XML-based Components for Federating Multiple Heterogeneous Data Sources

Several federated database systems have been built in the past using the relational or the object model as federating model. This paper gives an overview of the XMLMedia system, a federated database system mediator using XML as federating model, built in the Esprit Project MIRO-Web. The system is composed of four main components: a wrapper generator using rule-based scripting to produce XML data from various source formats, a mediator querying and integrating relational and XML sources, an XML DBMS extender supporting XML on top of relational DBMSs, and client tools including a Java API and an XML query browser. The results demonstrate the ability of XML with an associated query language (we use XML-QL) to federate various data sources on the Internet or on Intranets.

[1]  Serge Abiteboul,et al.  From structured documents to novel query facilities , 1994, SIGMOD '94.

[2]  Peter Buneman,et al.  Semistructured data , 1997, PODS.

[3]  Roy Goldman,et al.  Lore: a database management system for semistructured data , 1997, SGMD.

[4]  Peter Fankhauser,et al.  Experiences in Federated Databases: From IRO-DB to MIRO-Web , 1998, VLDB.

[5]  Roy Goldman,et al.  DataGuides: Enabling Query Formulation and Optimization in Semistructured Databases , 1997, VLDB.

[6]  Peter M. G. Apers,et al.  Implementing Semi Structured Data with Moa , 1999 .

[7]  Jennifer Widom,et al.  Object exchange across heterogeneous information sources , 1995, Proceedings of the Eleventh International Conference on Data Engineering.

[8]  Alin Deutsch,et al.  A Query Language for XML , 1999, Comput. Networks.

[9]  Dan Suciu,et al.  A query language for a Web-site management system , 1997, SGMD.

[10]  Jeffrey D. Ullman,et al.  Representative objects: concise representations of semistructured, hierarchical data , 1997, Proceedings 13th International Conference on Data Engineering.

[11]  Alin Deutsch,et al.  XML-QL: A Query Language for XML , 1998 .

[12]  Dan Suciu,et al.  Optimizing regular path expressions using graph schemas , 1998, Proceedings 14th International Conference on Data Engineering.

[13]  Alin Deutsch,et al.  Storing semistructured data with STORED , 1999, SIGMOD '99.

[14]  J. Widom,et al.  Interactive Query and Search in Semistructured Databases , 1998, WebDB.

[15]  Serge Abiteboul,et al.  Querying Semi-Structured Data , 1997, Encyclopedia of Database Systems.