Distributed heterogeneous databases consist of systems which differ physically and logically, containing different data models and data manipulation languages. Although these databases are independently created and administered they must cooperate and interoperate. Users need to access and manipulate data from several databases and applications may require data from a wide variety of independent databases. Therefore, a new system architecture is required to manipulate and manage distinct and multiple databases, in a transparent way, while preserving their autonomy. This report contains an extensive survey on heterogeneous databases, analysing and comparing the different aspects, concepts and approaches related to the topic. It introduces an architecture to support interoperability among heterogeneous database systems. The architecture avoids the use of a centralised structure to assist in the different phases of the interoperability process. It aims to support scalability, and to assure privacy and confidentiality of the data. The proposed architecture allows the databases to decide when to participate in the system, what type of data to share and with which other databases, thereby preserving their autonomy. The report also describes an approach to information discovery in the proposed architecture, without using any centralised structure as repositories and dictionaries, and broadcasting to all databases. It attempts to reduce the number of databases searched
|
845
|
Federated Database Systems for Managing Distributed, Heterogeneous and Autonomous Databases
– Larson
- 1990
|
|
444
|
A comparative analysis of methodologies for database schema integration
– Batini, Lenzerini, et al.
- 1986
|
|
392
|
An Introduction to Database Systems
– Date
- 2004
|
|
210
|
Semantic database modeling: Survey, applications and research issues
– Hull, King
- 1987
|
|
154
|
Resource integration using a large knowledge base in carnot
– Collet, Huhns, et al.
- 1991
|
|
130
|
A federated architecture for information management
– Heimbigner, McLeod
- 1985
|
|
125
|
Language features for Interoperability of Databases with Schematic Discrepancies
– Krishnamurthy, Litwin, et al.
|
|
123
|
A Theory of Attribute Equivalence in Databases with Application to Schema Integration
– Larson, Navathe, et al.
- 1989
|
|
107
|
Superviews: Virtual Integration of Multiple Databases, in
– Motro
- 1987
|
|
103
|
The Pegasus Heterogeneous Multidatabase System
– Ahmed, Du, et al.
- 1991
|
|
102
|
Database systems: Achievements and opportunities
– Silberschatz, Stonebraker, et al.
- 1991
|
|
84
|
A taxonomy and current issues in multidatabase systems
– Bright, Hurson, et al.
- 1992
|
|
82
|
View integration: A step forward in solving structural conflicts
– Spaccapietra, Parent
- 1994
|
|
79
|
So far (schematically), yet so near (semantically
– Sheth, Kashyap
- 1992
|
|
78
|
Multidatabase Interoperability
– Litwin, Abdellatif
- 1986
|
|
61
|
Suitability of Data Models as Canonical Models for Federated Databases
– Saltor, Castellanos, et al.
- 1991
|
|
58
|
reliable transaction management in a multidatabase system
– Breitbart, Silberschatz, et al.
- 1990
|
|
55
|
An organizational framework for Cooperating Intelligent Information Systems
– Papazoglou, Laufmann, et al.
|
|
55
|
Specifying Interdatabase Dependencies in a Multidatabase Environment
– Rusinkiewicz, Sheth, et al.
- 1991
|
|
50
|
A methodology for data schema integration in the entityrelationship model
– Batini, Lenzerini
|
|
48
|
Resolving database incompatibility: An approach to performing relational operations over mismatched domains
– DeMichiel
- 1989
|
|
40
|
Integrating user views in database design
– Navathe, Elmasri, et al.
- 1986
|
|
39
|
The Breakdown of the Information Model in Multi-Database Systems
– Kent
- 1991
|
|
37
|
Heterogeneous distributed database systems for production use
– Thomas, Thompson, et al.
- 1993
|
|
35
|
Database Integration in a Distributed Heterogeneous Database System
– Breitbart, Olson, et al.
- 1986
|
|
32
|
On automatic reasoning for schema integration
– Sheth, Gala, et al.
- 1993
|
|
28
|
Multibase – integrating heterogeneous distributed database systems
– Smith, Bernstein, et al.
- 1981
|
|
27
|
Report on the workshop on heterogeneous database systems
– Scheuermann, Yu, et al.
- 1990
|
|
27
|
Semantic issues in Multidatabase Systems
– Sheth
- 1991
|
|
26
|
Towards a Sound View Integration Methodology
– Casanova, Vidal
- 1983
|
|
26
|
Knowledge based integration of heterogeneous databases
– Fankhauser, Neuhold
- 1992
|
|
26
|
A method for transforming relational schemas into conceptual schemas
– Johannesson
- 1994
|
|
25
|
A distributed object-oriented database system supporting shared and private databases
– Kim, Ballou, et al.
- 1991
|
|
23
|
Multidatabase interoperability
– Breitbart
- 1993
|
|
21
|
Constructing Superviews
– Motro, Buneman
- 1981
|
|
20
|
Semantic enrichment of database schemas: An object oriented approach
– Castellanos, Saltor
- 1991
|
|
19
|
DATAPLEX: An access to heterogeneous distributed databases
– Chung
- 1990
|
|
19
|
View de nition and Generalization for Database Integration of a Multidatabase System
– Dayal, Hwang
- 1984
|
|
19
|
Interoperability and Object Identity
– Eliassen, Karlsen
- 1991
|
|
18
|
Introduction to a system for distributed databases (SDD-1
– Jr, Bernstein, et al.
- 1980
|
|
18
|
Determining relationships among attributes for Interoperability of Multidatabase Systems
– Yu, Sun, et al.
- 1991
|
|
17
|
Data Manipulation in Heterogeneous Databases
– Chatterjee, Segev
- 1991
|
|
15
|
Large multidatabases: Issues and directions
– Bouguettaya, King
- 1993
|
|
15
|
Schema Transformations as an Aid in View Integration
– Johannesson
- 1993
|
|
15
|
Overcoming schematic discrepancies in interoperable databases
– Saltor, Castellanos, et al.
- 1992
|
|
14
|
Traditional, Semantic and Hyper-Semantic Approaches to Data Modeling
– Potter, Trueblood
- 1988
|
|
13
|
A canonical model for the interoperability among object-oriented and relational databases
– Castellanos, Saltor, et al.
- 1994
|
|
12
|
Negotiating data access in federated database systems
– Alonso, Barbara
- 1989
|
|
12
|
From database systems to multidatabase systems: Why and how
– Litwin
- 1988
|
|
12
|
A survey of research and development in distributed database management
– ROTHNIE, GOODMAN
- 1977
|
