Aggregation Transformation of XML Schemas to Object-Relational Databases

  • Nathalia Devina Widjaya
  • David Taniar
  • Wenny Rahayu
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2877)


As XML has become an emerging standard for information exchange on the World Wide Web, it has gained attention in database communities to extract information from XML sees as a database model. Recently, many researchers have addressed mappings from XML structures onto database structures. In this paper, we present the way to transform the XML encoded format, which can be treated as a logical model, to the ORDB format. Firstly, the paper discusses the modelling of XML and why we need the transformation. Then, a number of transformation steps from the XML schema to the ORDB, with the emphasis on the transformations of aggregation relationships are presented. Two perspectives regarding this conceptual relationship (existence dependent aggregation which consists of homogeneous and ordered composition and independent aggregation) and their transformations are mainly discussed.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Bray, T., Paoli, J., Sperberg-McQueen, C.M. (eds.): Extensible Markup Language (XML) 1.0. W3C (1998),
  2. 2.
    Dillon, T., Tan, P.L.: Object Oriented Conceptual Models. Prentice Hall, Englewood Cliffs (1993)Google Scholar
  3. 3.
    Fong, J., Pang, F., Bloor, C.: Converting Relational Database into XML Document. In: Proc. 12th Intl. Workshop on Database and Expert Systems Appl., pp. 61–65 (2001)Google Scholar
  4. 4.
    Klettke, M., Meyer, H.: XML and Object Relational Database System. In: Suciu, D., Vossen, G. (eds.) WebDB 2000. LNCS, vol. 1997, pp. 151–170. Springer, Heidelberg (2001)CrossRefGoogle Scholar
  5. 5.
    Mani, M., Lee, D., Muntz, R.: Semantic Data Modelling Using XML Schemas. In: Kunii, H.S., Jajodia, S., Sølvberg, A. (eds.) ER 2001. LNCS, vol. 2224, pp. 149–163. Springer, Heidelberg (2001)CrossRefGoogle Scholar
  6. 6.
    Shanmugasundaram, J., et al.: Efficiently publishing relational data as XML documents. The VLDB Journal 10, 133–154Google Scholar
  7. 7.
    Stonebraker, M., Moore, D.: Object-relational DBMSs:the next great wave. Mogran Kaufmann Publishers, San Francisco (1996)zbMATHGoogle Scholar
  8. 8.
    Widjaya, N.D., Taniar, D., Rahayu, J.W., Pardede, E.: Association Relationship Transformation of XML Schemas to Object-Relational Databases. In: Proceedings of the 4th International Conference on Information Integration and Web-based Applications and Services (IIWAS 2002), pp. 135–142 (2002)Google Scholar
  9. 9.
    Widjaya, N.D., Taniar, D., Rahayu, J.W.: Inheritance Relationship Transformation of XML Schemas to Object-Relational Databases. In: Liu, J., Cheung, Y.-m., Yin, H. (eds.) IDEAL 2003. LNCS, vol. 2690, Springer, Heidelberg (2003)Google Scholar
  10. 10.
    Xiao, R., Dillon, T., Chang, E., Feng, L.: Modeling and Transformation of Object-Oriented Conceptual Models into XML Schema. In: Mayr, H.C., Lazanský, J., Quirchmayr, G., Vogel, P. (eds.) DEXA 2001. LNCS, vol. 2113, pp. 795–804. Springer, Heidelberg (2001)CrossRefGoogle Scholar
  11. 11.
    Yang, X., Wang, G.: Efficiently Mapping Referential Integrity Constraints from Relational Databases to XML. In: Caplinskas, A., Eder, J. (eds.) ADBIS 2001. LNCS, vol. 2151, pp. 338–351. Springer, Heidelberg (2001)CrossRefGoogle Scholar
  12. 12.
    Yang, X., Wang, G.: Mapping Referential Integrity Constraints from Relational Databases to XML. In: Wang, X.S., Yu, G., Lu, H. (eds.) WAIM 2001. LNCS, vol. 2118, pp. 329–340. Springer, Heidelberg (2001)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2003

Authors and Affiliations

  • Nathalia Devina Widjaya
    • 1
  • David Taniar
    • 1
  • Wenny Rahayu
    • 2
  1. 1.School of Business SystemsMonash UniversityAustralia
  2. 2.Department of Computer Science and EngineeringLa Trobe University 

Personalised recommendations