Heterogeneous Database System
- Heterogeneous Database System
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]
Problems of Heterogeneous Database Integration
This article does not contain details of Distributed database management systems (sometimes known as Federated database systems).
Technical Heterogeneity
Different file formats, access protocols, query languages etc. Often called syntactic heterogeneity from the point of view of data.
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.
emantic 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.
ee also
*Ontology
*Knowledge Base
*Expert System
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 managingdistributed, heterogeneous, and autonomous databases. ACM Comput Surv, 1990. 22(3): p. 183–236.
Wikimedia Foundation.
2010.
Look at other dictionaries:
Heterogeneous Database System — Bei einem Heterogenen Datenbank Verwaltungs System (kurz: HDBMS) handelt es sich um ein automatisiertes (oder teil automatisiertes) System zum Zusammenfassen heterogener, verschiedenartiger Datenbanken, um dem Benutzer ein einziges… … Deutsch Wikipedia
Database system — A database system is a term that is typically used to encapsulate the constructs of a data model, database Management system (DBMS) and database.[1] A database is an organised pool of logically related data. Data is stored within the data… … Wikipedia
Federated database system — A federated database system is a type of meta database management system (DBMS) which transparently integrates multiple autonomous database systems into a single federated database. The constituent databases are interconnected via a computer… … Wikipedia
Database — A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports… … Wikipedia
Distributed database management system — A distributed database management system ( DDBMS ) is a software system that permits the management of a distributed database and makes the distribution transparent to the users. A distributed database is a collection of multiple, logically… … Wikipedia
System Architecture Evolution — (aka SAE) is the core network architecture of 3GPP s LTE wireless communication standard. SAE is the evolution of the GPRS Core Network, with some differences: simplified architecture all IP Network (AIPN) support for higher throughput and lower… … Wikipedia
Thermodynamic system — A thermodynamic system is a precisely defined macroscopic region of the universe, often called a physical system, that is studied using the principles of thermodynamics. All space in the universe outside the thermodynamic system is known as the… … Wikipedia
Complex system — This article largely discusses complex systems as a subject of mathematics and the attempts to emulate physical complex systems with emergent properties. For other scientific and professional disciplines addressing complexity in their fields see… … Wikipedia
Open system (systems theory) — This article is about systems theory. For other uses, see Open system (disambiguation). Open System Model (basics) An open system is a system which continuously interacts with its environment. The interaction can take the form of information,… … Wikipedia
Executive information system — An Executive Information System (EIS) is a type of management information system intended to facilitate and support the information and decision making needs of senior executives by providing easy access to both internal and external information… … Wikipedia