skip to main content
10.1145/502187.502203acmconferencesArticle/Chapter ViewAbstractPublication PagesdocengConference Proceedingsconference-collections
Article

Bridging XML-schema and relational databases: a system for generating and manipulating relational databases using valid XML documents

Published:09 November 2001Publication History

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.

References

  1. 1."XML Schema Part 0: Primer," W3C Working Draft, Sept. 2000 (http://www.w3.org/TR/xmlschema-0)Google ScholarGoogle Scholar
  2. 2.M. Fernandez, W.C. Tan, D. Suciu, SilkRoute: Trading between Relations and XML, WWW9 / Computer Networks 33(1-6): 723-745 (2000) Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. 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 ScholarGoogle Scholar
  4. 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 ScholarGoogle Scholar
  5. 5.ISO/IEC JTC1/SC29/WG11, "MPEG-7 Overview (v. 1.0)," Doc. N3158, Dec. 1999.Google ScholarGoogle Scholar
  6. 6.S. Abiteboul, J. Widom, T. Lahiri, A Unified Approach for Querying Structured Data and XML. The Query Languages Workshop, QL'98.Google ScholarGoogle Scholar
  7. 7.G. Arocena, A. Mendelzon, WebOQL: Restructuring Documents, Databases, and Webs, Proc. ICDE'98, Orlando, February 1998. Google ScholarGoogle ScholarDigital LibraryDigital Library
  8. 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 ScholarGoogle Scholar
  9. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  10. 10.IBM's DB2 extender for XML (http://www-4.ibm.com/software/data/db2/ extenders/xmlext.html)Google ScholarGoogle Scholar
  11. 11.Microsoft SQL Server XML support, (http://msdn.microsoft.com/msdnmag/issues/ 0300/sql/sql.asp)Google ScholarGoogle Scholar
  12. 12.Informix and XML, (http://www.informix.com/xml/)Google ScholarGoogle Scholar
  13. 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 ScholarGoogle Scholar
  14. 14.Sybase SQL server, (http://www.sybase.com/products/ databaseservers/ase/whitepapers/L01041.pdf)Google ScholarGoogle Scholar
  15. 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 ScholarGoogle Scholar
  16. 16.R. Bourret, Mapping W3C Schemas to Object Schemas to Relational Schemas, http://www.rpbourret.com/xml/SchemaMap.html (March 2001)Google ScholarGoogle Scholar

Index Terms

  1. Bridging XML-schema and relational databases: a system for generating and manipulating relational databases using valid XML documents

          Recommendations

          Comments

          Login options

          Check if you have access through your login credentials or your institution to get full access on this article.

          Sign in
          • Published in

            cover image ACM Conferences
            DocEng '01: Proceedings of the 2001 ACM Symposium on Document engineering
            November 2001
            174 pages
            ISBN:1581134320
            DOI:10.1145/502187

            Copyright © 2001 ACM

            Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

            Publisher

            Association for Computing Machinery

            New York, NY, United States

            Publication History

            • Published: 9 November 2001

            Permissions

            Request permissions about this article.

            Request Permissions

            Check for updates

            Qualifiers

            • Article

            Acceptance Rates

            DocEng '01 Paper Acceptance Rate18of55submissions,33%Overall Acceptance Rate178of537submissions,33%

          PDF Format

          View or Download as a PDF file.

          PDF

          eReader

          View online with eReader.

          eReader