Integration of data from autonomous, distributed and heterogeneous data sources poses several technical challenges. This paper overviews the data integration system AMOS II based on the wrapper-mediator approach. AMOS II consists of: (i) a mediator database engine that can process and execute queries over data stored locally and in several external data sources, and (ii) object-oriented (OO) multi-database views for reconciliation of data and schema heterogeneities among sources with various capabilities. The data stored in different types of data sources is translated and integrated using OO mediation primitives, providing the user with a consistent view of the data in all the sources. Through its multi-database facilities many distributed AMOS II systems can interoperate in a federation. Since most data reside in the data sources, and to achieve high performance, the core of the system is a main-memory DBMS having a storage manager, query optimizer, transactions, client–server interface, disk backup, etc. The AMOS II data manager is optimized for main-memory access and is extensible so that new data types and query operators can be added or implemented in some external programming language. The extensibility is essential for providing seamless access to a variety of data sources. Copyright © 2001 John Wiley & Sons, Ltd. KEY WORDS: heterogeneous data integration; mediator systems; distributed databases; object-oriented databases
|
798
|
Mediators in the architecture of future information systems
– Wiederhold
- 1992
|
|
244
|
Objects and Views
– Abiteboul, Bonner
- 1991
|
|
243
|
The Functional Data Model and the Data Language DAPLEX
– Shipman
- 1981
|
|
229
|
Optimizing queries across diverse data sources
– Haas, Kossmann, et al.
- 1997
|
|
141
|
Main Memory Database Systems: An Overview
– Garcia-Molina, Salem
- 1992
|
|
133
|
View definition and generalization for database integration in a multidatabase system
– Dayal, Hwang
- 1984
|
|
127
|
A view mechanism for object-oriented databases
– Bertino
- 1992
|
|
107
|
Superviews: Virtual Integration of Multiple Databases, in
– Motro
- 1987
|
|
67
|
Object Views: Extending the Vision
– Heiler, Zdonik
- 1990
|
|
42
|
Main Memory Oriented Optimization of OO Queries using Typed Datalog with Foreign Predicates
– Litwin, Risch
- 1992
|
|
28
|
Query Processing over Object Views of Relational Data
– Fahl, Risch
- 1997
|
|
27
|
Integrating Heterogeneous Overlapping Databases through Object-Oriented Transformations
– Josifovski, Risch
- 1999
|
|
24
|
An adaptive objectoriented approach to integration and access of heterogeneous information sources
– Liu, Pu
- 1997
|
|
20
|
Functional query optimization over object-oriented views for data integration
– Josifovski, Risch
- 1999
|
|
20
|
Using partial differencing for efficient monitoring of deferred complex rule conditions
– SKOLD, RISCH
- 1995
|
|
19
|
An Architecture for Active Mediators
– Fahl, Risch, et al.
- 1993
|
|
18
|
The Design, Implementation, and Evaluation of an Object-Based Sharing Mechanism for Federated Database System
– Fang, Ghandeharizadeh, et al.
- 1993
|
|
17
|
OSQL: A language for object databases
– Lyngbaek
- 1991
|
|
17
|
Processing object-oriented queries with invertible late bound functions
– Flodin, Risch
- 1995
|
|
15
|
Optimizing queries in distributed and composable mediators
– Josifovski, Risch
- 1999
|
|
14
|
The MultiView project: object-oriented view technology and applications
– Rundensteiner, Kuno, et al.
- 1996
|
|
13
|
Query Decomposition for a Distributed ObjectOriented Mediator System
– Josifovski, Risch
|
|
13
|
The Object-Slicing Technique: A Flexible Object Representation and Its Evaluation
– Kuno, Ra, et al.
- 1995
|
|
12
|
Elmagarmid (eds.): Object-Oriented Multidatabase Systems
– Bukhres, A
- 1996
|
|
9
|
Valduriez: Scaling Access to Heterogeneous Data Sources with DISCO
– Tomasic, Raschid, et al.
- 1998
|
|
8
|
Applying next generation object-oriented DBMS to finite element analysis
– Orsborn
- 1994
|
|
8
|
Rothnie Jr. Query Processing in a System for Distributed Databases (SDD-1
– Bernstein, Goodman, et al.
- 1981
|
|
7
|
Myriad: Design and Implementation of a Federated Database System
– Lim, Hwang, et al.
- 1995
|
|
6
|
Laasch C, Tresch M. Updatable views in object-oriented databases
– Scholl, Laasch, et al.
- 1991
|
|
4
|
Object-oriented mediator queries to xml data
– Lin, Risch
- 2000
|
|
4
|
Implementation and Evaluation of a Distributed Mediator System for Data Integration
– Design
- 1999
|
|
4
|
Cost-Based Optimization of Decision Support Queries using Transient Views
– Subramananian, Venkataraman
- 1998
|
|
3
|
Multi-database access from Amos II using ODBC. Linköping Electronic
– Brandani
- 1998
|
|
3
|
Quass D, Rajaraman A, Sagiv Y
– Garcia-Molina, Papakonstantinou
- 1997
|
|
2
|
Query Processing
– Du, Shan
- 1996
|
|
2
|
Valduriez P. Principles of Distributed Database Systems
– MT
- 1999
|
|
1
|
An implementation of transaction logging and recovery in a main memory resident database system. MSc Thesis LiTH-IDA-Ex-94-04
– JS
- 1994
|
|
1
|
Principles of Database and
– JD
- 1988
|
|
1
|
Dogac A, Nural S, Ozcan F. Multidatabase query optimization
– Evrendilek
- 1997
|
|
1
|
dos Santos C, Abiteboul S, Delobel C. Virtual schemas and bases
– Souza
- 1994
|
|
1
|
Wilms PF. An introduction to distributed query compilation
– Daniels, Selinger, et al.
- 1982
|
