By Topic

A Novel Query Preprocessing Technique for Efficient Access to XML-Relational Databases

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$33 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

6 Author(s)
Pei-Lun Suei ; Dept. of Comput. Sci. & Inf. Eng., Nat. Taiwan Univ., Taipei, Taiwan ; Jun Wu ; Yung-Feng Lu ; Der-Nien Lee
more authors

Many researchers and vendors have proposed their XML storage approaches based on relational databases (RDB), which are called XML-relational databases (XRDB). To manipulate XML data in XRDB, many excellent model-mapping schemas were proposed to provide schema definitions to translate various XML documents with different structures into relational tables. Such an approach can support any sophisticated applications and well-formed XML documents. When XML data stored in an XRDB, the user query must be translated into the corresponding SQL commands, then executed in the relational database. However, most model-mapping-schema-based approaches have a potential performance problem for retrieving XML data from an XRDB, because a large number of join operations are needed. In this paper, a novel query preprocessing technique was proposed to reduce the number of join operations from the corresponding SQL commands. The rationale behind our approach is to replace join operations by predefined constant-mapping selection operations. By reducing the number of join operations, the performance of query processing can be greatly improved. The capability of our proposed approach was verified by experiments, for which we have some encouraging results.

Published in:

2009 First International Workshop on Database Technology and Applications

Date of Conference:

25-26 April 2009