ABSTRACT
Many organizations and enterprises establish distributed working environments, where different users need to exchange information based on a common model. XML is widely used to facilitate this information exchange. The extensibility of XML allows the creation of generic models that integrate data from different sources. For these tasks, several applications are used to import and export information in XML format from the data repositories. In order to support this process for relational repositories we developed the X-Database system. The base of this system is an XML-Schema file that describes the logical model of interchanged information. Initially, the system analyses the syntax of the XML-Schema file and generates the relational database. Then it handles the decomposition of valid XML files according to that Schema and the composition of XML documents from the information in the database. Finally the system offers a flexible mechanism for modifying and querying database contents using only valid XML documents, which are validated over the XML-Schema file's rules.
- 1."XML Schema Part 0: Primer," W3C Working Draft, Sept. 2000 (http://www.w3.org/TR/xmlschema-0)Google Scholar
- 2.M. Fernandez, W.C. Tan, D. Suciu, SilkRoute: Trading between Relations and XML, WWW9 / Computer Networks 33(1-6): 723-745 (2000) Google ScholarDigital Library
- 3.G. Akrivas, S. Ioannoy, E. Karakoulakis, K. Karpouzis, Y. Avrithis, A. Delopoulos, S. Kollias, I. Varlamis, M. Vazirgiannis. An Intelligent System for Archiving and Retrieval of Audiovisual Material Based on the MPEG-7 Description Schemes, 5th WSES Multiconference on Circuits, Systems, Communications & Computers (CSCC 2001)Google Scholar
- 4.I Varlamis, M. Vazirgiannis, P. Poulos, G. Akrivas, S. Ioannoy. X-Database: A middleware for collaborative video annotation, storage and retrieval, to appear in the 8 th Panhellenic Conference in Informatics (2001).Google Scholar
- 5.ISO/IEC JTC1/SC29/WG11, "MPEG-7 Overview (v. 1.0)," Doc. N3158, Dec. 1999.Google Scholar
- 6.S. Abiteboul, J. Widom, T. Lahiri, A Unified Approach for Querying Structured Data and XML. The Query Languages Workshop, QL'98.Google Scholar
- 7.G. Arocena, A. Mendelzon, WebOQL: Restructuring Documents, Databases, and Webs, Proc. ICDE'98, Orlando, February 1998. Google ScholarDigital Library
- 8.D. Chamberlin, J. Clark, D. Florescu, J. Robie, J. Simeon, M. Stefanescu. XQuery 1.0: An XML Query Language. W3C working draft, June 2001.http://www.w3.org/TR/xquery.Google Scholar
- 9.Y. Alp Aslandogan and Clement T. Yu, "Techniques and Systems for Image and Video Retrieval", IEEE Transactions on Knowledge and Data Engineering, vol. 11, no. 1, Jan.-Feb. 1999. Google ScholarDigital Library
- 10.IBM's DB2 extender for XML (http://www-4.ibm.com/software/data/db2/ extenders/xmlext.html)Google Scholar
- 11.Microsoft SQL Server XML support, (http://msdn.microsoft.com/msdnmag/issues/ 0300/sql/sql.asp)Google Scholar
- 12.Informix and XML, (http://www.informix.com/xml/)Google Scholar
- 13.Steve Muench, Using XML and Relational Databases for Internet Applications, Oracle Corporation (http://technet.oracle.com/tech/xml/info/htdocs/ relational/index.htm#ID795)Google Scholar
- 14.Sybase SQL server, (http://www.sybase.com/products/ databaseservers/ase/whitepapers/L01041.pdf)Google Scholar
- 15.D. Florescu, D. Kossmann. Storing and querying XML Data using an RDBMS. Bulletin of the IEEE Computer Society Technical Committee on Data Engineering. (1999)Google Scholar
- 16.R. Bourret, Mapping W3C Schemas to Object Schemas to Relational Schemas, http://www.rpbourret.com/xml/SchemaMap.html (March 2001)Google Scholar
Index Terms
Bridging XML-schema and relational databases: a system for generating and manipulating relational databases using valid XML documents
Recommendations
Constraint Preserving Transformation from Relational Schema to XML Schema
XML has become the standard for publishing and exchanging data on the Web. However, most business data is managed and will remain to be managed by relational database management systems. As such, there is an increasing need to efficiently and accurately ...
An Efficient Schema-Based Technique for Querying XML Data
As data integration over the Web has become an increasing demand, there is a growing desire to use XML as a standard format for data exchange. For sharing their grammars efficiently, most of the XML documents in use are associated with a document ...
XML-based XML schema access
WWW '07: Proceedings of the 16th international conference on World Wide WebXML Schema's abstract data model consists of components, which are the structures that eventually define a schema as a whole. XML Schema's XML syntax, on the other hand, is not a direct representation of the schema components, and it proves to be ...
Comments