Abstract
There is a structural discrepancy between XML documents and relational databases. Hence, special data structures are required in order to represent the hierarchical structure of XML documents in storing the XML documents in relational databases. The structural information is required in querying XML documents and publishing the stored relational data in XML documents. In this paper, we propose a method for storing XML documents in relational databases, in which the structural information of XML DTD as well as the XML documents is stored. The structural information of XML documents is also stored. The XML DTD is restored by using the stored structural information and provided to users in creating queries against XML documents. XML documents can be also restored using the stored structural information. The XML queries written in XQuery are processed by exploiting the structural information of DTD that is represented in conjunction with the relational tables in which XML documents are stored.
This work was supported by Kyungnam University Research Fund.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Aguilera, V., Cluet, S., Veltri, P., Vodislav, D., Wattez, F.: Querying XML Documents in Xyleme. In: Proceedings of the ACM SIGIR 2000 Workshop on XML and Information Retrieval (2000)
Carey, D., Florescu, D., Ives, Z., Lu, Y., Shanmugasundaram, J., Shekita, E., Subramanion, S.: XPREANTO: Publishing Object-Relational Data as XML. In: Informal Proceedings of the International Workshop on the Web and Databases, pp. 105–110 (2000)
David, M.M.: ANSI SQL Hierarchical Processing Can Fully Integrate Native XML. SIGMOD Record 32(1), 41–46 (2003)
Fernandez, M., Kadiyska, Y., Morishima, A., Suciu, D., Tan, W.C.: SilkRoute: A Framework for Publishing Relational Data in XML. ACM Transactions on Database Systems, 438–493 (2002)
Florescu, D., Kossmann, D.: Storing and Querying XML Data Using an RDBMS. IEEE Data Engineering Bulletin 22(3), 27–34 (1999)
Funderburk, J.E., Kiernan, G., Shanmugasundaram, J., Shekita, E., Wei, C.: XTABLES: Bridging Relational Technology and XML. IBM Systems Journal, 616–641 (2002)
Kha, D.D., Yoshikawa, M., Uemura, S.: An XML Indexing Structure with Relative Region Coordinate. In: Proceedings of 17th International Conference on Data Engineering, pp. 313–320 (2001)
Li, Q., Moon, B.: Indexing and Querying XML Data for Regular Path Expressions. In: Proceedings of the 27th VLDB Conference, pp. 361–370 (2001)
Shanmugasundaram, J., Kiernan, J., Shekita, E., Fan, C., Funderburk, J.: Querying XML Views of Relational Data. In: Proceedings of the 27th VLDB Conference, pp. 261–270 (2001)
Shanmugasundaram, J., Shekita, E., Barr, R., Carey, M., Lindsay, B., Pirahesh, H., Reinwald, B.: Efficiently Publishing Relational Data as XML Documents. In: Proceedings of the 26th VLDB Conference, pp. 65–76 (2000)
Shanmugasundaram, J., Shekita, E., Kiernan, J., Krishnamurthy, R., Viglas, E., Naughton, J., Tatarinov, I.: A General Technique for Querying XML Documents Using a Relational Database System. SIGMOD Record 30(3), 20–26 (2001)
Shanmugasundaram, J., Tufte, K., He, G., Zhang, C., Dewitt, D., Naughton, J.: Relational Databases for Querying XML Documents: Limitations and Opportunities. In: Proceedings of the 25th VLDB Conference, pp. 302–314 (1999)
Shin, B.J., Jin, M.: Storing and Querying XML Documents Using a Path Table in Relational Databases. In: The 1st International Workshop on XML Schema and Data Management held in conjuction with ER 2003, pp. 285–296 (2003)
Srivastava, D., Al-Khalifa, S., Jagadish, H.V., Koudas, N., Patel, J.M., Wu, Y.: Structural Joins: A Primitive for Efficient XML Query Pattern Matching. In: Proceedings of ICDE, pp. 141–152 (2002)
Tatarinov, I., Viglas, S.D., Beyer, K., Shanmugasundaram, J., Shekita, E., Zhang, C.: Storing and Querying Ordered XML Using a Relational Database System. In: SIGMOD Conference 2002, pp. 204–215 (2002)
Williams, M., Brundage, M., Dengler, P., Gabriel, J., Hoskinson, A., Kay, M., Maxwell, T., Ochoa, M., Papa, J., Vanmane, M.: Professional XML Databases. Wrox Press (2000)
Yoshikawa, M., Amagasa, T.: XRel: A Path-Based Approach to Storage and Retrieval of XML Documents Using Relational Databases. ACM Transactions on Internet Technology 1(1), 110–141 (2001)
Zhang, C., Naughton, J.F., DeWitt, D., Luo, Q., Lohman, G.: On Supporting Containment Queries in Relational Database Management Systems. In: Proceedings of ACM SIGMOD Conference (2001)
Zhang, X., Pielech, B., Rundensteiner, E.A.: XML Algebra Optimization. Technical Report WPI-CS-TR-02-25, Worcester Polytechnic Institute (2002)
W3C Recommendation. XML Path Language (XPath) Version 1.0, In http://www.w3c.org/TR/xpath/ (1999)
W3C Recommendation. XQuery 1.0: An XML Query Language, In http://www.w3c.org/TR/xquery/ (2003)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Jin, M., Shin, BJ. (2004). Storing Together the Structural Information of XML Documents in Relational Databases. In: Laganá, A., Gavrilova, M.L., Kumar, V., Mun, Y., Tan, C.J.K., Gervasi, O. (eds) Computational Science and Its Applications – ICCSA 2004. ICCSA 2004. Lecture Notes in Computer Science, vol 3046. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-24768-5_82
Download citation
DOI: https://doi.org/10.1007/978-3-540-24768-5_82
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-22060-2
Online ISBN: 978-3-540-24768-5
eBook Packages: Springer Book Archive