Exploring Strategic Indexes by Semantic OLAP Operators
At strategic and decision levels of information systems, information models are defined by a set of high-level measurable performance indexes, calculated by composition of more basic pieces of information, and aggregated along a number of different dimensions. Although the multidimensional model is able to effectively capture the aggregative characteristics of strategic information, it fails to represent its compound nature. Hence, index semantics is not completely specified and OLAP operators allow only to analyze indexes through the different aggregation dimensions. In this paper we discuss a novel set of OLAP operators resulting from a previously defined model for the semantic annotation of a Data Warehouse (DW) schema. These operators perform the analogous of drill down operators on index components instead of dimensions, both at intensional and extensional level. This means that both the definition of an index in terms of components and compositions operators and the actual values of the components can be hierarchically explored on-line, giving final users better ways to understand the meaning of the complex information encoded in a DW, its correctness, and more powerful tools to analyze it. A prototype implementing the proposal is presented.
KeywordsComposition Operator Semantic Annotation Semantic Enrichment Extensional Index Extensional Engine
Unable to display preview. Download preview PDF.
- 1.Lakshmanan LVS, Pei J, Zhao Y (2003) Efficacious data cube exploration by semantic summarization and compression. In Proceedings of the 29th international conference on very large data bases (pp. 1125–1128), BerlinGoogle Scholar
- 2.Diamantini C, Potena D (2008) Semantic enrichment of strategic datacubes. In Proceedings of the 11th ACM international workshop on data warehousing and OLAP, Napa Valley, pp 81–88Google Scholar
- 4.Xie GT, Yang Y, Liu S, Qiu Z, Pan Y, Zhou X (2007) EIAW: towards a business-friendly data warehouse using semantic web technologies. In Proceedings of the 6th international semantic web conference (pp. 857–870), BusanGoogle Scholar
- 5.Niinimäki M, Niemi T, Toivonen S, Nummenmaa J (2007) Ontologies with semantic web/grid in data integration for OLAP. Int J Semant Web Inf Syst 3(4):25–49Google Scholar
- 6.Skoutas D, Simitsis A (2006) Designing ETL processes using semantic web technologies. In Proceedings of the 9th ACM international workshop on data warehousing and OLAP (pp. 67–74), New OrleansGoogle Scholar
- 7.Priebe T, Pernul G (2003) Ontology-based integration of OLAP and information retrieval. In Proceedings of DEXA workshops (pp. 610–614), PragueGoogle Scholar
- 8.W3C Math Working Group. Mathematical markup language (MathML) Version 2.0, 2nd edn. http://www.w3.org/Math/. Accessed 18 Sept 2009
- 9.OpenMath Society. The OpenMath Standard Ver. 2.0. http://www.openmath.org/. Accessed 18 Sept 2009
- 10.Pentaho Analysis Services: Mondrian Project site. http://mondrian.pentaho.org/. Accessed 18 Sept 2009
- 11.JPivot Project site. http://jpivot.sourceforge.net/. Accessed 18 Sept 2009