This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
dido:public:ra:xapend:xapend.a_glossary:d:dist_db [2022/04/25 15:15] nick |
dido:public:ra:xapend:xapend.a_glossary:d:dist_db [2022/04/25 15:16] (current) nick |
||
|---|---|---|---|
| Line 7: | Line 7: | ||
| - **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. | - **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. | - **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. | ||