Heterogeneous Database System
From Wikipedia, the free encyclopedia
 |
This article is orphaned as few or no other articles link to it. Please help introduce links in articles on related topics. (September 2006) |
A Heterogeneous Database System is an automated (or semi-automated) system for the integration of heterogeneous, disparate database management systems to present a user with a single, unified query interface.
Heterogeneous database systems (HDBS) are computational models and software implementations that provide heterogeneous database integration [1,2]
Contents |
[edit] Problems of Heterogeneous Database Integration
This article does not contain details of Distributed database management systems (sometimes known as Federated database systems).
[edit] Technical Heterogeneity
Different file formats, access protocols, query languages etc. Often called syntactic heterogeneity from the point of view of data.
[edit] Data Model Heterogeneity
Different ways of representing and storing the same data. Table decompositions may vary, column names (data labels) may be different (but have the same semantics), data encoding schemes may vary (i.e. should a measurement scale be explicitly included in a field or should it be implied elsewhere). Also referred as schematic heterogeneity.
[edit] Semantic Heterogeneity
Data across constituent databases may be related but different. Perhaps a database system must be able to integrate genomic and proteomic data. They are related - a gene may have several protein products - but the data is different (nucleotide sequences and amino acid sequences, or hydrophilic/phobic amino acid sequence and positive/negatively charge amino acids). There may be many ways of looking at semantically similar, but distinct datasets.
The system may also be required to present 'new' knowledge to the user. Relationships may be inferred between data according to rules specified in domain ontologies.
[edit] See also
[edit] References
1. W, S., Heterogeneous database integration in biomedicine. Journal of Biomedical Informatics, 2001. 34(4): p. 285-98.
2. Sheth AP, L.J., Federated database systems for managing distributed, heterogeneous, and autonomous databases. ACM Comput Surv, 1990. 22(3): p. 183–236.
