Scribd Logo
Upload

Welcome to Scribd!

  • 35 views

    Distributed Database

    Uploaded by

    Aye Sha
    Distributed Database: 1. A distributed database is a database that is spread over multiple computers or sites connected through a network. This allows for global access to the database. 2. It features logical interrelations between databases at different sites that represent a single logical database, with physical data storage across multiple independent sites connected through a network. 3. The key difference between client/server and distributed databases is that distributed databases spread data across sites rather than clients, allowing users to access data from any site simultaneously rather than being limited to one server.

    Copyright:

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

    Distributed Database

    Uploaded by

    Aye Sha
    35 views5 pages
    Distributed Database: 1. A distributed database is a database that is spread over multiple computers or sites connected through a network. This allows for global access to the database. 2. It features logical interrelations between databases at different sites that represent a single logical database, with physical data storage across multiple independent sites connected through a network. 3. The key difference between client/server and distributed databases is that distributed databases spread data across sites rather than clients, allowing users to access data from any site simultaneously rather than being limited to one server.

    Original Title

    DISTRIBUTED DATABASE

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Distributed Database: 1. A distributed database is a database that is spread over multiple computers or sites connected through a network. This allows for global access to the database. 2. It features logical interrelations between databases at different sites that represent a single logical database, with physical data storage across multiple independent sites connected through a network. 3. The key difference between client/server and distributed databases is that distributed databases spread data across sites rather than clients, allowing users to access data from any site simultaneously rather than being limited to one server.

    Copyright:

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

    Distributed Database

    Uploaded by

    Aye Sha
    Distributed Database: 1. A distributed database is a database that is spread over multiple computers or sites connected through a network. This allows for global access to the database. 2. It features logical interrelations between databases at different sites that represent a single logical database, with physical data storage across multiple independent sites connected through a network. 3. The key difference between client/server and distributed databases is that distributed databases spread data across sites rather than clients, allowing users to access data from any site simultaneously rather than being limited to one server.

    Copyright:

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

    DISTRIBUTED DATABASE

    COURSE;

    DISTRIBUTED DATABASE DESIGN

    SUBMITTED TO;

    Prof: Bilal Mazhar


    SUBMITTED BY;

    Ayesha Arshad

    ROLL NO: 23
    DEPT NAME;

    MCS (Semester 2)

    DATE: July 22, 2020.


    Best College Kharian

    Distributed Database System


    Distributed Database:

    A distributed database is basically a database that is not limited to one


    system, it is spread over different sites, i.e., on multiple computers or over a network of
    computers. A distributed database system is located on various sited that don’t share physical
    components. This may be required when a particular database needs to be accessed by
    various users globally. It needs to be managed such that for the users it looks like one single
    database.

    Features:

     Databases in the collection are logically interrelated with each other. Often they
    represent a single logical database.

     Data is physically stored across multiple sites. Data in each site can be managed by a
    DBMS independent of the other sites.
     The processors in the sites are connected via a network. They do not have any
    multiprocessor configuration.

     A distributed database is not a loosely connected file system.

     A distributed database incorporates transaction processing, but it is not synonymous


    with a transaction processing system.

    Difference between Client /Server and Distributed Database:

     Client/Server:
    Client/server is developed to deal with various computing environments that have a large
    number of computers and servers connected together via a network. In this architecture, a
    Client is a user machine which provides the user interface and local processing capabilities.
    When any client requires additional functionality like database access, it can connect to
    Server that is capable of providing the functionality needed by the client. Basically Server is a
    machine that provides services to the Client i.e. user machine.
    Distributed Database:

     In Distributed DBMS, data is distributed over the geographical site. Each site is a complete
    database system site on its end but the different sites have to work together because if any
    user wants to access the data it can easily access data anywhere in the network as the data is
    stored at the user’s own computer.

    S.NO
    . CLIENT/SERVER DISTRIBUTED DBMS
    Client can access only one server at User can access many sites
    1. a time. simultaneously.

    2. It is difficult to manage. It is easy to manage.

    In this data is distributed across In this data is distributed across


    3. clients. sites.

    Speed of accessing database is


    Speed of accessing database is poor much better than Client/Server
    4. as compared to Distributed DBMS. Architecture.
    S.NO
    . CLIENT/SERVER DISTRIBUTED DBMS
    If somehow server crashes, the The crash of one site does not stop
    5. whole system stops. the entire system.

    Accessing of data is difficult to


    6. Accessing of data is easy to control. control.

    It is less expensive as compared to


    7. Distributed DBMS. It is expensive.

    8. Maintenance cost is low. Maintenance cost is high.

    You might also like