dido:public:ra:xapend:xapend.a_glossary:d:dist_db
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
dido:public:ra:xapend:xapend.a_glossary:d:dist_db [2022/04/25 15:12] nick created |
dido:public:ra:xapend:xapend.a_glossary:d:dist_db [2022/04/25 15:16] (current) nick |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| [[dido:public:ra:xapend:xapend.a_glossary:start| Return to Glossary ]] | [[dido:public:ra:xapend:xapend.a_glossary:start| Return to Glossary ]] | ||
| - | A **Distributed Database** is a database that consists of two or more files located on different sites either on the same network or on entirely different networks. Portions of the database are stored in multiple physical locations and processing is distributed among multiple database nodes. | + | A **Distributed Database** is basically a [[dido:public:ra:xapend:xapend.a_glossary:d: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 sites 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. |
| - | A centralized distributed database management system (DDBMS) integrates data logically so it can be managed as if it were all stored in the same location. The DDBMS synchronizes all the data periodically and ensures that data updates and deletes performed at one location will be automatically reflected in the data stored elsewhere. | + | Types: |
| - | By contrast, a centralized database consists of a single database file located at one site using a single network. | + | - **Homogeneous Database:** In a homogeneous database, all different sites store database identically. The operating system, database management system, and the data structures used – all are the same at all sites. Hence, they’re easy to manage. |
| + | - **Heterogeneous Database:** In a heterogeneous distributed database, different sites can use different schema and software that can lead to problems in query processing and transactions. Also, a particular site might be completely unaware of the other sites. Different computers may use different operating systems and different database applications. They may even use different data models for the database. Hence, translations are required for different sites to communicate. | ||
| - | Source: [[https://www.techtarget.com/searchoracle/definition/distributed-database ]] | + | Source: [[https://www.geeksforgeeks.org/distributed-database-system/ ]] |
dido/public/ra/xapend/xapend.a_glossary/d/dist_db.1650913926.txt.gz · Last modified: 2022/04/25 15:12 by nick
