Scribd Logo
Upload

Welcome to Scribd!

  • 886 views

    Difference Between Centralized and Distributed Database

    Uploaded by

    Saira Agha
    Centralized databases contain a single database located at one location, making data management and backups easier but increasing failure risk. Distributed databases contain multiple database files across different locations, reducing failure risk and improving access speeds while making data synchronization and consistency more challenging. Examples include major banks using centralized databases and Google using a distributed Bigtable database.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Difference Between Centralized and Distributed Database

    Uploaded by

    Saira Agha
    886 views2 pages
    Centralized databases contain a single database located at one location, making data management and backups easier but increasing failure risk. Distributed databases contain multiple database files across different locations, reducing failure risk and improving access speeds while making data synchronization and consistency more challenging. Examples include major banks using centralized databases and Google using a distributed Bigtable database.

    Original Title

    Assignment ict1

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Centralized databases contain a single database located at one location, making data management and backups easier but increasing failure risk. Distributed databases contain multiple database files across different locations, reducing failure risk and improving access speeds while making data synchronization and consistency more challenging. Examples include major banks using centralized databases and Google using a distributed Bigtable database.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    886 views2 pages

    Difference Between Centralized and Distributed Database

    Uploaded by

    Saira Agha
    Centralized databases contain a single database located at one location, making data management and backups easier but increasing failure risk. Distributed databases contain multiple database files across different locations, reducing failure risk and improving access speeds while making data synchronization and consistency more challenging. Examples include major banks using centralized databases and Google using a distributed Bigtable database.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 2

    Difference between Centralized and Distributed Database

    Centralized Database Distributed Database

    1
    Definition Definition
     A centralized database is a type  A distributed database is a type
    of database that contains a of database that contains two or
    single database located at one more database files located at
    location in the network. different locations in the
    network.
    Maintaining Data Maintaining Data
     Managing, updating and taking in  There are multiple database files
    backups of data is easier in a in a distributed database, it
    centralized database because requires time to synchronize
    there is only one database file. data.

    Assessing Data Assessing Data


     A centralized database requires  In a distributed database, the
    time for accessing data because speed in accessing the data is
    multiple users access the higher because the data is
    database file. It has a high usage. retrieved from the nearest
    database file.
    Failure Failure
     In a centralized database, if the  In a distributed database, if one
    database fails, the users do not database fails, the users can still
    have access to a database. access other database files.

    Data Consistency Data Consistency


     Centralized database has more  Distributed database can have
    data consistency. It provides the data replications. Therefore,
    complete view to the user. there can be some data
    inconsistency.

    Example Example
     Google: Use a DBMS called Bigtable.
     Some major banks do all their
    processing on a mainframe, in some
    cases in a different country.
     Clients may use several branches, and
    online banking for transaction.

    You might also like