Storing Linked XML Documents in Object-Relational DBMS

Amornsinlaphachai, Pensri; Rossiter, Nick; Ali, M. Akhtar
September 2006
Journal of Computing & Information Technology;Sep2006, Vol. 14 Issue 3, p225
Academic Journal
Currently, several researchers have proposed mapping both structure and constraints of XML documents to an object-relational database (ORDB). However, these researches cannot be conducted because of the limited range of constraints in available object-relational DBMSs. We therefore propose mapping rules that are practicable in available technologies. Normally, an XML document is treated as a database, so much data redundancy occurs. To solve this problem, we keep non-redundant data in several separate XML documents, link the data dispersed in these documents together by a mechanism called 'rlink' and then map this mechanism to ORDB. Finally we perform a case study in Oracle9i to illustrate the mapping of XML to ORDB according to our rules. Our contribution is that we find that mapping linked XML documents to traditional databases such as (O)RDB makes it easier to join several documents and to update several documents in one update command.


Related Articles

  • XML: The Talk of the tech industry. Lundquist, Eric // eWeek;8/5/2002, Vol. 19 Issue 31, p5 

    Discusses the issues tackled in the August 5, 2002 issue of the journal 'eWeek.' Importance of XML in the information technology infrastructure; Application of XML in the latest version of Oracle9i database; Integration of XML improvements in IBM's DB2.

  • XML DATABASE DOUBTS. Dyck, Timothy // eWeek;12/3/2001, Vol. 18 Issue 47, p67 

    Focuses on XML databases. Problem with standard in database space; Ease in storing documents of various format; Difficulty in integrating with non-XML data.

  • Where's the XML? Leon, Mark // InfoWorld;04/02/2001, Vol. 23 Issue 14, p36 

    Focuses on Extensible Markup Language (XML) databases. Problems faced by users of XML databases; Reason for the slow adoption of object database at some specialized markets; Advantages of XML; Companies adding XML features to their applications.

  • XMS Management System.  // IT Professional;Sep/Oct2001, Vol. 3 Issue 5, p54 

    Features NeoCore XML Management System 2.0 extensible markup language database. Support for rapid development of adaptive business applications; Price.

  • FileMaker 6 extends reach, ease of use. Dyck, Timothy // eWeek;7/15/2002, Vol. 19 Issue 28, p46 

    Focuses on the improvement of filemaker database via XML support. Advantages of the FileMaker database installations; Features of the database; Price cost of FileMaker Pro 6.

  • Beware proprietary data formats. Schofield, Jack // Computer Weekly;5/30/2002, p34 

    Focuses on the ways to avoid putting data into the propriety file format. Use of published, open and not protected data formats; Idea of open file formats; Plan of suppliers of using XML format.

  • Making a namespace for yourself. Gibbs, Mark // Network World;4/1/2002, Vol. 19 Issue 13, p38 

    Focuses on the use of Document Type Definition in creating a definition of the tags in XML. Classification of the element libraryitem; URL for the namespace definition; Reference of multiple namespaces with different names.

  • XML-style PKI. Udell, Jon // InfoWorld;9/16/2002, Vol. 24 Issue 37, p16 

    Presents information on the extensible mark-up language (XML) Key Management Specification (XKMS) Web service, which pushes the logic of finding and validating certificates out of the client. Test center perspective; Main parts; Problems with using XKMS; Functions.

  • Working out the bugs in XML databases. Cox, John; Hanson, Larry // Network World;1/7/2002, Vol. 19 Issue 1, p24 

    Reports the industrial applications of XML database in the United States. Definition of an XML database; Integration between XML and corporate data stores; Development of TextML Server for XML documents.


Read the Article


Sorry, but this item is not currently available from your library.

Try another library?
Sign out of this library

Other Topics