Efficient Storage and Retrieval of XML Documents Using XQuery

Abstract:

XML has already been the standard of data interchange on the Internet. Nowadays, a large amount of data is represented in XML format. However, most of the critical data in businesses are still stored in relational database management systems. It is difficult to query XML databases because of its textual format. This research intends to tackle this problem, and we proposed a system to manage XML documents that could be queried by the query language XQuery. XML documents are stored in relational format and the XQuery expressions are translated into appropriate SQL queries. The results of the SQL queries are transformed into XML documents. Comparing with LegoDB System, our system reduces processing time to search a relation configuration and proposes a better translating and executing technique which is more efficiently.

• Periodical: Advanced Materials Research (Volumes 779-780)
• Pages: 1685-1688
• DOI: https://doi.org/10.4028/www.scientific.net/AMR.779-780.1685
• Online since: September 2013
• Authors: Yu Bin Chiu, Huei Huang Chen, Chu Yen Liu, Shih Chih Chen, Chung Wen Hung
• Keywords: RDBMS, XML, XQuery

References

[1] Cook, James H., XML Sets Stage for Efficient Knowledge Management, IT Professional. 2000(May-June), 55-57.

[2] Schmidt, A., M. Kersten, M. Windhouwer, and F. Waas, Efficient Relational Storage and Retrieval of XML Documents, Proceedings of the Third International. Workshop on the Web and Databases (WebDB 2000). 2000, 47-52.

DOI: 10.1007/3-540-45271-0_9

[3] Information onhttp: /www. w3. org/XML.

[4] Zheng, H. L., Zhong, H., and Yan, S. A., XML schema normalization design, Applied Mechanics and Materials. 2011(58-60), 2345-2350.

DOI: 10.4028/www.scientific.net/amm.58-60.2345

[5] Schmidt, A., S. Manegold, and M. Kersten, Integrated querying of XML data in RDBMSs, Proceedings of the 2003 ACM symposium on Applied computing. 2003, 509-514.

DOI: 10.1145/952532.952634

[6] Information on http: /www. w3. org/TR/xpath.

[7] Bohannon, P., J. Freire, J. R. Haritsa, M. Ramanath, P. Roy, and J. Simeon, LegoDB: Customizing Relational Storage for XML Documents, Proceedings of the 28th VLDB Conference. 2002, 1091-1094.

DOI: 10.1016/b978-155860869-6/50116-5

[8] Roy, P., J. Simeon, P. Bohannon, and J. Freire, From XML schema to relations: A cost-based approach to XML storage, Proceedings of the 18th International Conference on Data Engineering. 2002, 64-75.

DOI: 10.1109/icde.2002.994698

[9] Fernandez, Mary, Wang-Chiew Tan, and Suciu Dan, SilkRoute: Trading between Relations and XML, Proceedings of the Ninth International World-wide Web Conference. 2000, 723-745.

DOI: 10.1016/s1389-1286(00)00061-x