Abstract
Integrating XML documents in data warehouse is a major issue for decisional data processing and business intelligence. Indeed this type of data is increasingly being used in organisations’ information system. But the current warehousing systems do not manage documents as they do for extracted data from relational databases. We have therefore developed a multidimensional model based on the Unified Modeling Language (UML), to describe an XML Document Warehouse (XDW). The warehouse diagram obtained is a Star schema ( StarCD) which fact represents the documents class to be analyzed, and the dimensions correspond to analysis criteria extracted from the structure of the documents. The standard XQuery language can express queries on XML documents, but it is not suitable for analyzing a warehouse as its syntax is too complex for a non IT specialist. This paper presents a new language aimed at decision-makers and allows applying OLAP queries on a XDW described by a StarCD.
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
Barry, D.K., Cattell, R.G.G.: The Obkect Database Standard. Morgan Kaufmann publisher (1997)
Golfarelli, M., Maio, D., Rizzi, S.: The dimensional fact model: a conceptual model for data warehouses. International Journal of Cooperative Information Systems 07 (1998)
Nassis, V., Rajagopalapillai, R., Dillon, T.S., Rahayu, W.: Conceptual and systematic design approach for xml document warehouses (2005)
Object Management Group (OMG): Unified Modelling Language (UML), http://www.uml.org/
Park, B.-K., Han, H., Song, I.-Y.: XML-OLAP: A multidimensional analysis framework for XML warehouses. In: Tjoa, A.M., Trujillo, J. (eds.) DaWaK 2005. LNCS, vol. 3589, pp. 32–42. Springer, Heidelberg (2005)
Pérez, J.M., Llavori, R.B., Aramburu, M.J., Pedersen, T.B.: Integrating data warehouses with web data: A survey. IEEE Trans. Knowl. Data Eng. 20(7), 940–955 (2008)
Ravat, F., Teste, O., Tournier, R., Zurfluh, G.: A conceptual model for multidimensional analysis of documents (2007)
Ravat, F., Teste, O., Zufluh, G.: Algèbre OLAP et langage graphique (2006)
W3C-Consortium: Extensible Markup Language (XML), http://www.w3.org/XML/
W3C-Consortium: W3C XML Query (XQuery), http://www.w3.org/XML/Query/
W3C-Consortium: XML Schema Part 0: Structures, 2nd edn., http://www.w3.org/TR/2004/REC-xmlschema-1-20041028/
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
Abdelhedi, F., Ntsama, L., Zurfluh, G. (2014). XML Warehouse Modelling and Querying. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds) Beyond Databases, Architectures, and Structures. BDAS 2014. Communications in Computer and Information Science, vol 424. Springer, Cham. https://doi.org/10.1007/978-3-319-06932-6_8
Download citation
DOI: https://doi.org/10.1007/978-3-319-06932-6_8
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-06931-9
Online ISBN: 978-3-319-06932-6
eBook Packages: Computer ScienceComputer Science (R0)