Abstract
This paper presents a new framework for users to select relevant data from an xml document and store it in an existing relational database, as opposed to previous approaches that shred the entire xml document into a newly created database of a newly designed schema. The framework is based on a notion of xml2db mappings. An xml2db mapping extends a (possibly recursive) dtd by associating element types with semantic attributes and rules. It extracts either part or all of the data from an xml document, and generates sql updates to increment an existing database using the xml data. We also provide an efficient technique to evaluate xml2db mappings in parallel with sax parsing. These yield a systematic method to store xml data selectively in an existing database.
This is a preview of subscription content, log in via an institution to check access.
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
Abiteboul, S., Cluet, S., Milo, T.: Querying and updating the file. In: VLDB (1993)
Benedikt, M., Chan, C.Y., Fan, W., Freire, J., Rastogi, R.: Capturing both types and constraints in data integration. In: SIGMOD (2003)
Bohannon, P., Freire, J., Haritsa, J., Ramanath, M., Roy, P., Siméon, J.: Bridging the XML relational divide with LegoDB. In: ICDE (2003)
Choi, B.: What are real DTDs like. In: WebDB (2002)
Deransart, P., Jourdan, M., Lorho, B.: Attribute Grammars. LNCS. Springer, Heidelberg (1988)
Florescu, D., Kossmann, D.: Storing and querying XML data using an RDMBS. IEEE Data Eng. Bull. (1999)
IBM. DB2 XML Extender, http://www-3.ibm.com/software/data/db2/extended/xmlext/
Krishnamurthy, R., Kaushik, R., Naughton, J.F.: XML-to-SQL Query Translation Literature: The State of the Art and Open Problems. In: Bellahsène, Z., Chaudhri, A.B., Rahm, E., Rys, M., Unland, R. (eds.) XSym 2003. LNCS, vol. 2824, pp. 1–18. Springer, Heidelberg (2003)
Megginson, D.: SAX: A simple API for XML, http://www.megginson.com/SAX/
Microsoft. XML support in Microsoft SQL server 2005 (December 2005), http://msdn.microsoft.com/library/en-us/dnsql90/html/sql2k5xml.asp/
Neven, F.: Extensions of attribute grammars for structured document queries. In: Connor, R.C.H., Mendelzon, A.O. (eds.) DBPL 1999. LNCS, vol. 1949, p. 99. Springer, Heidelberg (2000)
Nicola, M., Linden, B.: Native XML support in DB2 universal database. In: VLDB (2005)
Oracle. Oracle database 10g release 2 XML DB technical whitepaper
Schmidt, A., Kersten, M.L., Windhouwer, M., Waas, F.: Efficient Relational Storage and Retrieval of XML Documents. In: Suciu, D., Vossen, G. (eds.) WebDB 2000. LNCS, vol. 1997, p. 137. Springer, Heidelberg (2001)
Shanmugasundaram, J., Tufte, K., He, G., Zhang, C., DeWitt, D., Naughton, J.: Relational databases for querying XML documents: Limitations and opportunities. In: VLDB (1999)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Fan, W., Ma, L. (2006). Selectively Storing XML Data in Relations. In: Bressan, S., Küng, J., Wagner, R. (eds) Database and Expert Systems Applications. DEXA 2006. Lecture Notes in Computer Science, vol 4080. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11827405_3
Download citation
DOI: https://doi.org/10.1007/11827405_3
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-37871-6
Online ISBN: 978-3-540-37872-3
eBook Packages: Computer ScienceComputer Science (R0)