Query processing method for multiple databases with a different set of attributes

This paper discusses a schema integration and query processing method that enables integrated access to the multiple autonomous databases in the distributed environment with schemata restricted to a set of attributes. This method is based on the construction of a virtual database (VDB) formed over physically distributed component databases. Although user queries are issued to this VDB, these queries are decomposed to the subqueries using the virtual functional dependency (VFD), which is defined on the VDB and issued to each actual component database. The VDB-based method can obtain more answers that are logically valid than those gained from conventional query processing methods. When the VFD formed over a VDB is acyclic among the nodes to which the query refers, sound and complete answers can be efficiently calculated.

[1]  Raymond Reiter,et al.  Towards a Logical Reconstruction of Relational Database Theory , 1982, On Conceptual Modelling.

[2]  Raymond Reiter,et al.  A sound and sometimes complete query evaluation algorithm for relational databases with null values , 1986, JACM.

[3]  Jaideep Srivastava,et al.  Entity identification in database integration , 1993, Proceedings of IEEE 9th International Conference on Data Engineering.

[4]  Nick Roussopoulos,et al.  Interoperability of multiple autonomous databases , 1990, CSUR.

[5]  Hans-Peter Kriegel,et al.  Integration of relational databases in a multidatabase system based on schema enrichment , 1993, Proceedings RIDE-IMS `93: Third International Workshop on Research Issues in Data Engineering: Interoperability in Multidatabase Systems.

[6]  Ronald Fagin,et al.  Horn clauses and database dependencies , 1982, JACM.