Heterogeneous Distributed Database System
Jump to navigation
Jump to search
A Heterogeneous Distributed Database System is a distributed database system that is a heterogeneous database system.
- AKA: Heterogeneous DDBMS.
- …
- Example(s):
- a Data Lake.
- a Federated Database System.
- …
- Counter-Example(s):
- See: Distributed Database.
References
2016
- (Wikipedia, 2016) ⇒ http://wikipedia.org/wiki/Distributed_database#Heterogeneous_DDBMS Retrieved:2016-2-8.
- In a heterogeneous distributed database, different sites may use different schema and software. Difference in schema is a major problem for query processing and transaction processing. Sites may not be aware of each other and may provide only limited facilities for cooperation in transaction processing. In heterogeneous systems, different nodes may have different hardware & software and data structures at various nodes or locations are also incompatible. Different computers and operating systems, database applications or data models may be used at each of the locations. For example, one location may have the latest relational database management technology, while another location may store data using conventional files or old version of database management system. Similarly, one location may have the Windows NT operating system, while another may have UNIX. Heterogeneous systems are usually used when individual sites use their own hardware and software. On heterogeneous system, translations are required to allow communication between different sites (or DBMS). In this system, the users must be able to make requests in a database language at their local sites. Usually the SQL database language is used for this purpose. If the hardware is different, then the translation is straightforward, in which computer codes and word-length is changed. The heterogeneous system is often not technically or economically feasible. In this system, a user at one location may be able to read but not update the data at another location.