Integration of Weakly Heterogeneous Semistructured Data

  • George Feuerlicht
  • Jaroslav Pokorný
  • Karel Richta
  • Narongdech Ruttananontsatean


While most business applications typically operate on structured data that can be effectively managed using relational databases, some applications use more complex semistructured data that lacks a stable schema. XML techniques are available for the management of semistructured data, but such techniques tend to be ineffective when applied to large amounts of heterogeneous data, in particular in applications with complex query requirements. We describe an approach that relies on the mapping of multiple semistructured data sets to object-relational structures and uses an object-relational database to support complex query requirements. As an example we use weakly heterogeneous oceanographic data.


Weakly heterogeneous data Semistructured data Data integration 



This research has been partially supported by the National Program of Research, Information Society Project No. 1ET100300419 and also by the grants of GACR No. GA201/09/0990, GA201/06/0175, and GA201/06/0648.


  1. 1.
    Amornsinlaphachai, P., Rossiter, N. and Ali, M.A. (2006) Storing Linked XML Documents in Object-Relational DBMS. Journal of Computing and Information Technology (CIT) 14(3), 225–241.Google Scholar
  2. 2.
    Beyer, K., Cochrane, R.J., Josifovski, V., Kleewein, J., Lapis, G., Lohman, G., Lyle, B., Ozcan, F., Pirahesh, H., Seemann, N., Truong, T., Van der Linden, B., Vickery, B. and Zhang1, Ch. (2005): System RX: One Part Relational, One Part XML. In Proc. of the 2005 ACM SIGMOD Int. Conf. on Management of Data, Baltimore, Maryland, USA, ACM Press, pp. 347–358.Google Scholar
  3. 3.
    Boag, S., Chamberlin, D., Fernández, M.F., Florescu, D., Robie, J. and Siméon, J. (2005) XQuery 1.0: An XML Query Language, W3C Working Draft, 04 April 2005. Retrieved July 4, 2008 from:
  4. 4.
    Bourret, R. (2007) XML Database Products. Retrieved July 4, 2008 from:
  5. 5.
    Buneman, P. (1997) Semistructured Data. In Proc. of 1997 Symposium on Principles of Database Systems (PODS97), Tucson, Arizona, pp.117–121.Google Scholar
  6. 6.
    Clark, J. (1999): XSL Transformations (XSLT) Version 1.0. W3C Recomm. Nov 16, 1999.Google Scholar
  7. 7.
    Fiebig, T., Helmer, S., Kanne, C.-C., Moerkotte, G., Neumann, J., Schiele, R. and Westmann, T. (2002): Anatomy of a native XML base management system. VLDB Journal, 11(4), 292–314.zbMATHCrossRefGoogle Scholar
  8. 8.
    Harold, E.R. (2005) Managing XML data: Native XML databases. Retrieved July 4, 2008 from:
  9. 9.
    Isenor, A.W. and Keeley, J.R (2005) Modeling Generic Oceanographic Data Objects in XML. Computing in Science and Engineering, July/August, 58–65.Google Scholar
  10. 10.
    ISO/IEC 9075:2003 (2003) Information Technology, Database Languages, SQL. Part 2: Foundations.Google Scholar
  11. 11.
    Liu, Z.H., Krishnaprasad, M. and Arora, V. (2005): Native XQuery Processing in Oracle XMLDB. In Proc. of the ACM SIGMOD Int. Conf. on Management of Data. Baltimore, MD, pp. 828–833.Google Scholar
  12. 12.
    Mlýnková, I. and Pokorný, J. (2005) XML in the World of (Object-)Relational Database Systems. In Vasilecas, O., et al. (Eds.), Information Systems Development Advances in Theory, Practice, and Education 2004. Springer Science+Business Media, Inc., pp. 63–76.Google Scholar
  13. 13.
    OCG (2008) Geography Markup Language. Retrieved July 4, 2008 from:
  14. 14.
    Rahayu, J.W., Pardede, E. and Taniar, D. (2007) XML Databases: Trends, Issues, and Future Research. In The 9th Int. Conf. on Information Integration and Web-based Applications and Services (iiWAS 2007), ACS, 229, 9–10, Jakarta, Indonesia.
  15. 15.
    Runapongsa, K. and Patel, J.M. (2002) Storing and Querying XML Data in Object-Relational DBMSs. In XML-Based Data Management and Multimedia Engineering. EDBT 2002 Workshops, LNCS 2490/2002.Google Scholar
  16. 16.
    Ruttananontsatean, N. (2007) An Investigation of Query Techniques for Semistructured Data, PhD Thesis, Faculty of Information Technology, University of Technology, Sydney, Australia, November 2007.Google Scholar
  17. 17.
    Shanmugasundaram, J., Shekita, E., Barr, R., Carey, M., Lindsay, B., Pirahesh H. and Reinwald B. (2001) Efficiently Publishing Relational Data as XML Documents. VLDB Journal 10(2–3), 133–154.zbMATHGoogle Scholar
  18. 18.
    Suresh, R., Shukla, P. and Schwenke G. (2000) XML-Based Data Systems for Earth Science Applications. In Proc. of Geoscience and Remote Sensing Symposiun (IGARSS), IEEE 2000 Int., 3, 1214–1216.Google Scholar
  19. 19.
    W3C (2004): Extensible Markup Language (XML) 1.1. (Second Edition), W3C Recommendation 16 August 2004. Retrieved July 4, 2008 from:

Copyright information

© Springer Science+Business Media, LLC 2009

Authors and Affiliations

  • George Feuerlicht
    • 1
    • 2
  • Jaroslav Pokorný
    • 3
  • Karel Richta
    • 3
  • Narongdech Ruttananontsatean
    • 4
  1. 1.University of TechnologySydneyAustralia
  2. 2.University of EconomicsPragueCzech Republic
  3. 3.Charles University of PraguePragueCzech Republic
  4. 4.Kanchanaburi Rajabhat UniversityKanchanaburiThailand

Personalised recommendations