Query translation for distributed heterogeneous structured and semi-structured databases

Authors:
Fahad M. Al-Wasil;N. J. Fiddian;W. A. Gray
Affiliations:
School of Computer Science, Cardiff University, Cardiff, Wales, UK;School of Computer Science, Cardiff University, Cardiff, Wales, UK;School of Computer Science, Cardiff University, Cardiff, Wales, UK
Venue:
BNCOD'06 Proceedings of the 23rd British National Conference on Databases, conference on Flexible and Efficient Information Handling
Year:
2006

Citing 19
Cited 0

Mediators in the Architecture of Future Information Systems

Computer
Data manipulation in heterogeneous databases

ACM SIGMOD Record
Answering queries using views (extended abstract)

PODS '95 Proceedings of the fourteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
XML-based information mediation with MIX

SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
On wrapping query languages and efficient XML integration

SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
SilkRoute: trading between relations and XML

Proceedings of the 9th international World Wide Web conference on Computer networks : the international journal of computer and telecommunications netowrking
Data integration: a theoretical perspective

Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Scaling Access to Heterogeneous Data Sources with DISCO

IEEE Transactions on Knowledge and Data Engineering
MedMaker: A Mediation System Based on Declarative Specifications

ICDE '96 Proceedings of the Twelfth International Conference on Data Engineering
Information Integration Using Logical Views

ICDT '97 Proceedings of the 6th International Conference on Database Theory
Efficiently Publishing Relational Data as XML Documents

VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Querying XML Views of Relational Data

Proceedings of the 27th International Conference on Very Large Data Bases
Answering XML Queries on Heterogeneous Data Sources

Proceedings of the 27th International Conference on Very Large Data Bases
A Metadata Integration Assistant Generator for Heterogeneous Distributed Databases

On the Move to Meaningful Internet Systems, 2002 - DOA/CoopIS/ODBASE 2002 Confederated International Conferences DOA, CoopIS and ODBASE 2002
XML-based Components for Federating Multiple Heterogeneous Data Sources

ER '99 Proceedings of the 18th International Conference on Conceptual Modeling
A Design and Implementation of XML-Based Mediation Framework (XMF) for Integration of Internet Information Resources

HICSS '02 Proceedings of the 35th Annual Hawaii International Conference on System Sciences (HICSS'02)-Volume 7 - Volume 7
Towards heterogeneous multimedia information systems: the Garlic approach

RIDE '95 Proceedings of the 5th International Workshop on Research Issues in Data Engineering-Distributed Object Management (RIDE-DOM'95)
XTABLES: Bridging relational technology and XML

IBM Systems Journal
Establishing an XML metadata klnowledge base to assist integration of structured and semi-structured databases

ADC '06 Proceedings of the 17th Australasian Database Conference - Volume 49

Quantified Score

Hi-index	0.00

Visualization

Abstract

The main purpose of building data integration systems is to facilitate access to a multitude of data sources. A data integration system must contain a module that uses source descriptions in order to reformulate user queries which are posed in terms of the composite global schema, into sub-queries that refer directly to the schemas of the component data sources. In this paper we propose a method for this user query translation task to target distributed heterogeneous structured data residing in relational databases and semi-structured data held in well-formed XML documents (XML documents which have no referenced DTD or XML schema) produced by Internet applications or human-coded. These XML documents can be XML files on local hard drives or remote documents on Web servers. Our method is based on mappings between the master (composite) view and the participating data source schema structures that are defined in a generated XML Metadata Knowledge Base (XMKB).