Extending Drill-Down through Semantic Reasoning on Indicator Formulas

Performance indicators are calculated by composition of more basic pieces of information, and/or aggregated along a number of different dimensions. The multidimensional model is not able to take into account the compound nature of an indicator. In this work, we propose a semantic multidimensional model in which indicators are formally described together with the mathematical formulas needed for their computation. By exploiting the formal representation of formulas an extended drill-down operator is defined, which is capable to expand an indicator into its components, enabling a novel mode of data exploration. Effectiveness and efficiency are briefly discussed on a prototype introduced as a proof-of concept.

[1]  Bernd Neumayr,et al.  Multi-level Conceptual Modeling and OWL , 2009, ER Workshops.

[2]  R. Kaplan,et al.  The balanced scorecard--measures that drive performance. , 2015, Harvard business review.

[3]  Günther Pernul,et al.  Advances in Conceptual Modeling - Challenging Perspectives, ER 2009 Workshops CoMoL, ETheCoM, FP-UML, MOST-ONISW, QoIS, RIGiM, SeCoGIS, Gramado, Brazil, November 9-12, 2009. Proceedings , 2009, ER Workshops.

[4]  Hamid Pirahesh,et al.  Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals , 1996, Data Mining and Knowledge Discovery.

[5]  Matteo Golfarelli,et al.  OLAP query reformulation in peer-to-peer data warehousing , 2012, Inf. Syst..

[6]  Henry Chesbrough,et al.  Open Innovation: The New Imperative for Creating and Profiting from Technology , 2003 .

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

[8]  Manuel Resinas,et al.  Defining Process Performance Indicators: An Ontological Approach , 2010, OTM Conferences.

[9]  Michael H. Breitner,et al.  Ontology-Based Exchange and Immediate Application of Business Calculation Definitions for Online Analytical Processing , 2009, DaWaK.

[10]  Claudia Diamantini,et al.  Semantic enrichment of strategic datacubes , 2008, DOLAP '08.

[11]  Tharam S. Dillon,et al.  On the Move to Meaningful Internet Systems, OTM 2010 , 2010, Lecture Notes in Computer Science.

[12]  Bernd Neumayr,et al.  Towards ontology-based OLAP: datalog-based reasoning over multidimensional ontologies , 2012, DOLAP '12.

[13]  Jyrki Nummenmaa,et al.  Ontologies with Semantic Web/Grid in Data Integration for OLAP , 2007, Int. J. Semantic Web Inf. Syst..

[14]  Laks V. S. Lakshmanan,et al.  Efficacious Data Cube Exploration by Semantic Summarization and Compression , 2003, VLDB.

[15]  Zahir Tari,et al.  On the Move to Meaningful Internet Systems. OTM 2018 Conferences , 2018, Lecture Notes in Computer Science.

[16]  John Domingue,et al.  Ontology-based metrics computation for business process analysis , 2009, SBPM '09.

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

[18]  Viara Popova,et al.  Modeling organizational performance indicators , 2010, Inf. Syst..

[19]  Maurizio Proietti,et al.  A Semantic Framework for Knowledge Management in Virtual Innovation Factories , 2013, Int. J. Inf. Syst. Model. Des..

[20]  Btjbsell L. Ackoft,et al.  MANAGEMENT MISINFORMATION SYSTEMS* , 2007 .

[21]  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..

[22]  Martin Törngren,et al.  Tool Integration Beyond Wasserman , 2011, CAiSE 2011.

[23]  John Mylopoulos,et al.  Strategic business modeling: representation and reasoning , 2014, Software & Systems Modeling.

[24]  Claudia Diamantini,et al.  A Logic-Based Formalization of KPIs for Virtual Enterprises , 2013, CAiSE Workshops.