Skip to main content

XML Data Warehouse: Modelling And Querying

  • Chapter
Databases and Information Systems II

Abstract

A large amount of heterogeneous information is now available in enterprises. Some their data sources are repositories of XML data or they are viewed as XML data independently on their inner implementation. In this paper, we study the foundations of XML data warehouses. We adapt the traditional star schema with explicit dimension hierarchies for XML environment. We propose the notion of XML-referential integrity for handling XML-dimension hierarchies. For querying XML data warehouses, we introduce a semijoin operation based on approximate matching XML data and discuss its effective evaluation.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 129.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 169.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 169.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Bourret, R.: XML and Databases. http://www.rpbourret.com/xml/XMLAndDatabases.htm.

  2. Buneman, P., Davidson, S., Fan,W., Hara, C., Tan, W.-Ch.: Keys for XML. Proc. of WWW10, May 1–5, Hong-Kong, ACM Press, 2001, pp. 201–210.

    Google Scholar 

  3. Deutsch, D., Fernandez M.F., Florescu D., Levy M. A., Suciu D.: A Query Language for XML. WWW8/Computer Networks 31, 1999, (11–16): 1155–1169.

    Article  Google Scholar 

  4. Fan, W., Libkin, L.: On XML Integrity Constraints in the Presence of DTDs. Proc. ACM SIGACT-SIGMOD-SIGART Symp. on Principles of Database Systems, 2001, pp. 114125.

    Google Scholar 

  5. Golfarelli, M., Rizzi S., Vrdoljak, B.: Data warehouse design from XML sources. Proc. of ACM Fourth International Workshop on Data Warehousing and OLAP (DOLAP 2001), J. Hammer Ed., ACM Press, 2001, Atlanta, pp. 40–47.

    Google Scholar 

  6. ISO/IEC 9075:1999: Information Technology - Database Languages-SQL. Part 2: Foundations. 1999.

    Google Scholar 

  7. Lee, D., Chu, W.W.: Constraint-preserving transformation from XML Document Type Definition to Relational Schema. Proc. of 20th E-R Conf., Salt Lake City, 2000, pp. 323338.

    Google Scholar 

  8. Mani, M., Lee, D., Munz, R.: Semantic Data Modelling using XML Schemes. In: Proc. of E-R Conf., Yokohama, 2001, pp. 149–163.

    Google Scholar 

  9. Pokorny, J. “Data Warehouses: a Modelling Perspective.” In Evolution and Challenges in System Development (Eds. W.G.Wojtkowski, S. Wrycza, J. Zupancic ), Kluwer Academic/Plenum Press Publ., 1999, pp. 59–71.

    Chapter  Google Scholar 

  10. Pokorny, J.: Modelling Stars Using XML. Proc. of ACM Fourth International Workshop on Data Warehousing and OLAP (DOLAP 2001), J. Hammer Ed., ACM Press, 2001, Atlanta, pp. 24–31.

    Google Scholar 

  11. Papakonstantinou, Y., Vianu, V.: DTD Inference for Views of XML Data. Proc. ACM SIGACT-SIGMOD-SIGART Symp. on Principles of Database Systems 2000, pp. 35–46.

    Google Scholar 

  12. Schlieder, T.: Schema-Driven Evaluation of Approximate Tree-Pattern Queries. Proc. of EDBT 2002, C.S. Jensen et al. (Eds), LNCS 2287, Springer Verlag, 2002, pp. 514–532.

    Google Scholar 

  13. XML: Extensible Markup Language 1.0. http://www.w3.org/www.w3.org/TR/REC-xml,1998.

  14. XQuery 1.0: An XML Query Language. W3C Working Draft 20 December 2001 http://www.w3.org/TR/2001/WD-xquery-20011220/.

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2002 Springer Science+Business Media Dordrecht

About this chapter

Cite this chapter

Pokorny, J. (2002). XML Data Warehouse: Modelling And Querying. In: Haav, HM., Kalja, A. (eds) Databases and Information Systems II. Springer, Dordrecht. https://doi.org/10.1007/978-94-015-9978-8_6

Download citation

  • DOI: https://doi.org/10.1007/978-94-015-9978-8_6

  • Publisher Name: Springer, Dordrecht

  • Print ISBN: 978-90-481-6182-9

  • Online ISBN: 978-94-015-9978-8

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics