Semantic enrichment of strategic datacubes

In the information system view, the reference architecture for strategic and decision support is based on the Data Warehouse architecture, that enables flexible and multidimensional analysis of strategic indexes by means of OLAP tools and reports. In this paper we propose a novel model for semantic annotation of Data Warehouse schema that takes into account domain ontologies as well as a mathematical ontology. Such an ontology describes mathematical formulas underlying elements of the datacube schema, including the semantics of operands and operators. In particular, we discuss and apply the proposed model for the semantic annotation of the schema of a datacube, that is the basis for OLAP analysis and contains information derived from Data Warehouse schema. In the paper, an illustrative case study together with some examples of analysis based on this kind of annotation are provided.

[1]  Shengping Liu,et al.  EIAW: Towards a Business-Friendly Data Warehouse Using Semantic Web Technologies , 2007, ISWC/ASWC.

[2]  Jia-Lang Seng,et al.  Data warehouse enhancement: A semantic cube model approach , 2007, Inf. Sci..

[3]  Veronika Stefanov,et al.  Business Metadata for the DataWarehouse , 2006, 2006 10th IEEE International Enterprise Distributed Object Computing Conference Workshops (EDOCW'06).

[4]  Tadeusz Pankowski,et al.  Modeling Analytical Indicators Using DataWarehouse Metamodel , 2006, 17th International Workshop on Database and Expert Systems Applications (DEXA'06).

[5]  Claudia Diamantini,et al.  About Semantic Enrichment of Strategic Data Models as Part of Enterprise Models , 2006, Business Process Management Workshops.

[6]  Peter Rowlett.  The W3C MathML software list , 2006 .

[7]  K. Emam.  Calculating Return-On-Investment , 2005 .

[8]  Frank S. C. Tseng,et al.  Integrating heterogeneous data warehouses using XML technologies , 2005, J. Inf. Sci..

[9]  Patricia Pulliam Phillips,et al.  Calculating the Return on Investment , 2004 .

[10]  Günther Pernul,et al.  Ontology-based integration of OLAP and information retrieval , 2003, 14th International Workshop on Database and Expert Systems Applications, 2003. Proceedings..

[11]  Robert L. Grossman,et al.  Data mining standards initiatives , 2002, CACM.

[12]  Ramasamy Uthurusamy,et al.  EVOLVING DATA MINING INTO SOLUTIONS FOR INSIGHTS , 2002 .

[13]  Klaus R. Dittrich,et al.  Metadata management for data warehousing: between vision and reality , 2001, Proceedings 2001 International Database Engineering and Applications Symposium.

[14]  Stephen M. Watt,et al.  Mathematical Markup Language (MathML) Version 3.0 , 2001, WWW 2001.

[15]  Alton L. Taylor,et al.  Strategic Change in Colleges and Universities , 2000 .

[16]  Diego Calvanese,et al.  Source integration in data warehousing , 1998, Proceedings Ninth International Workshop on Database and Expert Systems Applications (Cat. No.98EX130).

[17]  Michael Uschold,et al.  The Enterprise Ontology , 1998, The Knowledge Engineering Review.

[18]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[19]  Michael Uschold,et al.  Ontologies: principles, methods and applications , 1996, The Knowledge Engineering Review.

[20]  Tapio Niemi,et al.  Describing Data Sources Semantically for Facilitating Efficient Creation of OLAP Cubes , .