Dealing with semantic annotation for manipulating and mapping relational and XML sources

The schemas currently implemented as weIl XML documents available from the web hardly reflect the semantics of the data very little at aIl. As a result of this situation, it is still difficult to understand, question, modify, integrate, interconnect a relational data base or an XML document. Consequently we propose to annotate a relational schema or an XML document with semantic features in order to automatically recover a conceptual view. The annotation which we propose can be directly implemented with an RDBMS or described into a DTD. Such annotation can significantly facilitate the management and use of relational sources and XML documents. We give then the mapping rules to publish relational data in an XML document and to store an XML document into a relational data base. These rules preserve the annotation.

[1]  Serge Abiteboul,et al.  Correspondence and translation for heterogeneous data , 1997, Theor. Comput. Sci..

[2]  Dennis McLeod,et al.  An Approach to Resolving Semantic Heterogenity in a Federation of Autonomous, Heterogeneous Database Systems , 1993, Int. J. Cooperative Inf. Syst..

[3]  Wesley W. Chu,et al.  Effective Schema Conversions between XML and Relational Models , 2002 .

[4]  Martin Gogolla,et al.  Conceptual modelling of database applications using extended ER model , 1992, Data Knowl. Eng..

[5]  Robert A. Maksimchuk,et al.  UML for Database Design , 2001 .

[6]  Venkataraman Ramesh,et al.  A Blackboard-Based Cooperative System for Schema Integration , 1995, IEEE Expert.

[7]  Stéphane Bressan,et al.  Introduction to Database Systems , 2005 .

[8]  Diego Calvanese,et al.  Information integration: conceptual modeling and reasoning support , 1998, Proceedings. 3rd IFCIS International Conference on Cooperative Information Systems (Cat. No.98EX122).

[9]  Fèlix Saltor,et al.  A structure based schema integration methodology , 1995, Proceedings of the Eleventh International Conference on Data Engineering.

[10]  Henderik Alex Proper,et al.  A unifying object role modelling theory , 1995, Inf. Syst..

[11]  Todd D. Millstein,et al.  Query containment for data integration systems , 2000, PODS '00.

[12]  Martin Andersson,et al.  Extracting an Entity Relationship Schema From a Relational Database Through Reverse Engineering , 1994, Int. J. Cooperative Inf. Syst..

[13]  Heikki Mannila,et al.  Design of Relational Databases , 1992 .

[14]  Laura M. Haas,et al.  Capabilities-Based Query Rewriting in Mediator Systems , 2004, Distributed and Parallel Databases.