International Conference on Conceptual Modeling

Conceptual Modeling pp 302-316 | Cite as

Flexible Data Management across XML and Relational Models: A Semantic Approach

Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 9381)


Relational model and XML model have their own advantages and disadvantages in data maintenance and sharing. In this paper, we consider a framework that can be used in many applications that need to maintain their potentially large data in relational database and partially publish, exchange and/or utilize the data in different XML formats according to the applications’ preferences. The existing relational-to-XML data transformation relies on pre-defined XML view or transformation rules. Thus the output XML data or views are rigid and invariable, and cannot fulfill the requirement of format flexibility in our considered situations. In this paper, we propose a semantic approach that supports the framework under our consideration. We use conceptual models to design both relational data and XML views, and invent algorithms to transform data in one model to the other via conceptual model transformation. We also demonstrate how XPath queries issued to XML views can be translated and processed against a relational database through conceptual models.


ORASS XML Relational model Model transformation 


  1. 1.
    Chen, P.P.: The ER model: toward a unified view of data. ACM Trans. Database Syst. 1(1), 9–36 (1976)CrossRefGoogle Scholar
  2. 2.
    Chen, Y.B., Ling, T.W., Lee, M., Nakanishi, M., Dobbie, G.: A semantic approach to the design of valid and reversible semistructured views. JCSE 1(1), 95–123 (2007)Google Scholar
  3. 3.
    Bonifati, A., Chang, E.Q., Ho, T., Lakshmanan, L.V.S., Pottinger, R., Chung, Y.: Schema mapping and query translation in heterogeneous P2P XML databases. VLDB J. 19(2), 231–256 (2010)CrossRefGoogle Scholar
  4. 4.
    Chaudhuri, S., Kaushik, R., Naughton, J.F.: On relational support for XML publishing: beyond sorting and tagging. In: SIGMOD, pp. 611–622 (2003)Google Scholar
  5. 5.
    Chen, Y.B., Ling, T.W., Lee, M., Nakanishi, M., Dobbie, G.: A semantic approach to the design of valid and reversible semistructured views. JCSE 1(1), 95–123 (2007)Google Scholar
  6. 6.
    Difallah, D.E., Pavlo, A., Curino, C., Cudre-Mauroux, P.: OLTP-Bench: an extensible testbed for benchmarking relational databases. PVLDB 7(4), 277–288 (2013)Google Scholar
  7. 7.
    Fernandez, M., Kadiyska, Y., Suciu, D., Morishima, A., Tan, W.: SilkRoute: a framework for publishing relational data in XML. ACM Trans. Database Syst. 27(4), 438–493 (2002)CrossRefGoogle Scholar
  8. 8.
    Fletcher, G.H.L., Wyss, C.M.: Data mapping as search. In: Ioannidis, Y., Scholl, M.H., Schmidt, J.W., Matthes, F., Hatzopoulos, M., Böhm, K., Kemper, A., Grust, T., Böhm, C. (eds.) EDBT 2006. LNCS, vol. 3896, pp. 95–111. Springer, Heidelberg (2006) CrossRefGoogle Scholar
  9. 9.
    Gou, G., Chirkova, R.: Efficiently querying large XML data repositories: a survey. IEEE Trans. Knowl. Data Eng. 19(10), 1381–1403 (2007)CrossRefGoogle Scholar
  10. 10.
    Jumaa, H., Fayn, J., Rubel, P.: An automatic approach to generate XML schemas from relational models. In: UKSim, pp. 509–514 (2010)Google Scholar
  11. 11.
    Lee, D., Mani, M., Chiu, F., Chu, W.W.: NeT & CoT: translating relational schemas to XML schemas using semantic constraints. In: CIKM (2002)Google Scholar
  12. 12.
    Li, L., Le, T.N., Wu, H., Ling, T.W., Bressan, S.: Discovering semantics from data-centric XML. In: Decker, H., Lhotská, L., Link, S., Basl, J., Tjoa, A.M. (eds.) DEXA 2013, Part I. LNCS, vol. 8055, pp. 88–102. Springer, Heidelberg (2013) CrossRefGoogle Scholar
  13. 13.
    Ling, T.W., Lee, M.L., Dobbie, G.: Semistructured Database Design. Springer, US (2005) MATHGoogle Scholar
  14. 14.
    Liu, C., Vincent, M.W., Liu, J.: Constraint preserving transformation from relational schema to XML schema. World Wide Web 9(1), 93–110 (2006)CrossRefGoogle Scholar
  15. 15.
    Mecca, G., Rull, G., Santoro, D., Teniente, E.: Semantic-Based Mappings. In: ER (2013)Google Scholar
  16. 16.
    Melnik, S., Adya, A., Bernstein, P.A.: Compiling mapplings to bridge applications and databases. In: SIGMOD, pp. 461–472 (2007)Google Scholar
  17. 17.
    Shanmugasundaram, J., Shekita, E., Barr, R., Carey, M., Linday, B., Pirahesh, H., Reinwald, B.: Efficiently publishing relational data as XML documents. VLDB J. 10(2–3), 133–154 (2001)MATHGoogle Scholar
  18. 18.
    Wu, H., Bao, Z.: Object-oriented XML keyword search. In: ER (2011)Google Scholar
  19. 19.
    Zhou, R., Liu, C., Li, J.: Holistic constraint-preserving transformation from relational schema into XML schema. In: Haritsa, J.R., Kotagiri, R., Pudi, V. (eds.) DASFAA 2008. LNCS, vol. 4947, pp. 4–18. Springer, Heidelberg (2008) CrossRefGoogle Scholar

Copyright information

© Springer International Publishing Switzerland 2015

Authors and Affiliations

  1. 1.Institute for Infocomm Research, A*STARSingaporeSingapore
  2. 2.School of ComputingNational University of SingaporeSingaporeSingapore

Personalised recommendations