Please enable JavaScript.

Coggle requires JavaScript to display documents.

Distributed databases - Coggle Diagram

- - - - Using this tactic, a distributed database can avoid excessive traffic because identical data can be accessed locally.
        
        This type of data facilitates the provision of data from any section to any other section of the larger database if the data in the last section is compromised by any type of error.
    - - The primary keys are used again. However, in this case, copies of the primary key are available within each section of the database (accessible for each branch).
        
        This type of format works well for situations where a company branch and central location interact with the same accounts, but perhaps in different ways (such as changes in customer contact information versus changes in financial figures).
    - - This involves the use of primary keys (each of which refers to a record in the database).
        
        Horizontal fragmentation is commonly used for situations where specific company locations generally only need access to the database for their specific branch.
    - - It means that the data has been adjusted in one way or another, as is typical in decision support databases. In some cases, there are two different systems that handle transactions and decision support.
        
        Decision support systems may be more technically difficult to maintain, Online Transaction Processing (OLTP) often requires reconfiguration to allow large numbers of requests.
    - - This category of data divides the database and the software used to access different departments and situations.
        
        For example, user data versus product data. Usually, there is an overlap between the various databases within this type of distribution.