Eighth ACIS International Conference on Software Engineering, Artificial Intelligence, Networking, and Parallel/Distributed Computing (SNPD 2007) Efficient XML query using Relational Data Model Haier International Training Center, Qingdao, China July 30-August 01 ISBN: 0-7695-2909-7
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/SNPD.2007.540
XML files are effective for data store, search and query when used as a single entity. However, when it comes search and query to multiple XML files, performance and efficiency are the ones that are to be degradated. To cope with such degradation, we are proposing an efficient way of merging XML files into a relational database for permanent storage and take advantage of relational database management system?s search and query features to locate certain record. Once the resulting record - used to be an XML file - is located, it will be converted back to an XML file for further use. Upon completion on further use, the XML is merged back to the database. To accommodate such need, multiple tables are created according to the XML file?s tag structure. In our approach, there are two data transformation functions -- one is to conver XML to relational data model and the other is relational data model to XML. We have developed a prototype conversion system for the technical feasibility analysis. For the sake of our experiment, we have used a virtual collaboration system called VCEI where for each discussion session, all the discussion or conference content are stored in a single XML file. Over the times, the number of discussions grows big and so is the number of XML files. The prototype also demonstrates the functional extension of the existing remote conferencing system.
Index Terms:
XML, XML query, relational database
Citation:
Sungchul Hong, Yeong-Tae Song, "Efficient XML query using Relational Data Model," snpd, vol. 3, pp.1095-1100, Eighth ACIS International Conference on Software Engineering, Artificial Intelligence, Networking, and Parallel/Distributed Computing (SNPD 2007), 2007 Usage of this product signifies your acceptance of the Terms of Use. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||