Abstract
In this paper, we propose a holistic scheme of transforming a relational schema into an XML Schema with integrity constraints preserved. This scheme facilitates constructing a schema for the published XML views of relational data. With this schema, users are able to issue qualified queries against XML views, and discover update anomalies in advance before propagating the view updates into relational database. Compared to the previous work which splits the transformation process into two steps, we establish a holistic solution to directly transform a relational schema into an XML Schema without building a reference graph. We achieve this by classifying the underlying relations in a more concise and effective way, and applying the converting rules wisely. The rules are also devised to be more compact and less complicated in contrast to those in our previous work. Finally, we manage to crack another hard nut which was seldom touched before, i.e. converting circularly referenced relations into recursive XML Schema.
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.
Similar content being viewed by others
References
Fernandez, M.F., Kadiyska, Y., Suciu, D., Morishima, A., Tan, W.C.: Silkroute: A framework for publishing relational data in XML. ACM Trans. Database Syst. 27(4), 438–493 (2002)
Liu, C., Vincent, M.W., Liu, J., Guo, M.: A virtual XML database engine for relational databases. In: Bellahsène, Z., Chaudhri, A.B., Rahm, E., Rys, M., Unland, R. (eds.) XSym 2003. LNCS, vol. 2824, pp. 37–51. Springer, Heidelberg (2003)
Lee, D., Mani, M., Chu, W.W.: Schema conversion methods between XML and relational models. In: Knowledge Transformation for the Semantic Web, pp. 1–17 (2003)
Shanmugasundaram, J., Shekita, E.J., Barr, R., Carey, M.J., Lindsay, B.G., Pirahesh, H., Reinwald, B.: Efficiently publishing relational data as XML documents. VLDB J. 10(2-3), 133–154 (2001)
Wang, L., Rundensteiner, E.A., Mani, M.: Updating XML views published over relational databases: Towards the existence of a correct update mapping. Data Knowl. Eng. 58(3), 263–298 (2006)
Braganholo, V.P., Davidson, S.B., Heuser, C.A.: Pataxo: A framework to allow updates through XMLviews. ACM Trans. Database Syst. 31(3), 839–886 (2006)
Lee, D., Mani, M., Chiu, F., Chu, W.W.: Net & cot: translating relational schemas to XML schemas using semantic constraints. In: CIKM, pp. 282–291. ACM, New York (2002)
Liu, C., Vincent, M.W., Liu, J.: Constraint preserving transformation from relational schema to XML schema. World Wide Web 9(1), 93–110 (2006)
Consortium, W.W.W.: Xml schema part 0, 1, 2. In: W3C Candidate Recommendation, http://www.w3.org/XML/schema/
Liu, C., Li, J.: Designing quality xml schemas from e-r diagrams. In: Yu, J.X., Kitsuregawa, M., Leong, H.-V. (eds.) WAIM 2006. LNCS, vol. 4016, pp. 508–519. Springer, Heidelberg (2006)
Chamberlin, D., Florescu, D., Robie, J.: Xquery update. In: W3C working draft (July 2006), http://www.w3.org/TR/xqupdate/
Fan, W., Cong, G., Bohannon, P.: Querying xml with update syntax. In: Chan, C.Y., Ooi, B.C., Zhou, A. (eds.) SIGMOD Conference, pp. 293–304. ACM, New York (2007)
Benedikt, M., Chan, C.Y., Fan, W., Rastogi, R., Zheng, S., Zhou, A.: Dtd-directed publishing with attribute translation grammars. In: VLDB, pp. 838–849. Morgan Kaufmann, San Francisco (2002)
Turau, V.: Making Legacy Data Accessible for XML Applications (1999), http://www.informatik.fh-wiesbaden.de/~turau/veroeff.html
Deutsch, A., Fernández, M.F., Suciu, D.: Storing semistructured data with stored. In: Delis, A., Faloutsos, C., Ghandeharizadeh, S. (eds.) SIGMOD 1999, Proceedings ACM SIGMOD International Conference on Management of Data, June 1-3, 1999, pp. 431–442. ACM Press, USA (1999)
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 2002: Proceedings of the 2002 ACM SIGMOD international conference on Management of data, pp. 204–215. ACM Press, New York (2002)
Baru, C.K.: XViews: XML views of relational schemas. In: DEXA Workshop, pp. 700–705 (1999)
Kappel, G., Kapsammer, E., Retschitzegger, W.: Integrating XML and relational database systems. World Wide Web 7(4), 343–384 (2004)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2008 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Zhou, R., Liu, C., Li, J. (2008). Holistic Constraint-Preserving Transformation from Relational Schema into XML Schema. In: Haritsa, J.R., Kotagiri, R., Pudi, V. (eds) Database Systems for Advanced Applications. DASFAA 2008. Lecture Notes in Computer Science, vol 4947. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-78568-2_4
Download citation
DOI: https://doi.org/10.1007/978-3-540-78568-2_4
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-78567-5
Online ISBN: 978-3-540-78568-2
eBook Packages: Computer ScienceComputer Science (R0)