An Ontology-Based Data Exploration Tool for Key Performance Indicators

This paper describes the main functionalities of an ontology-based data explorer for Key Performance Indicators (KPI), aimed to support users in the extraction of KPI values from a shared repository. Data produced by partners of a Virtual Enterprise are semantically annotated through a domain ontology in which KPIs are described together with their mathematical formulas. Based on this model and on reasoning capabilities, the tool provides functionalities for dynamic aggregation of data and computation of KPI values through the formula. In this way, besides the usual drill-down, a novel mode of data exploration is enabled, based on the expansion of a KPI into its components.

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

[2]  Hongjun Lu,et al.  An aspect of query optimization in multidatabase systems , 1995, SGMD.

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

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

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

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

[7]  Leon Sterling,et al.  Solving Symbolic Equations with PRESS , 1982, J. Symb. Comput..

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

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

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

[11]  Claudia Diamantini,et al.  Data Mart Reconciliation in Virtual Innovation Factories , 2014, CAiSE Workshops.

[12]  Manuel Resinas,et al.  On the definition and design-time analysis of process performance indicators , 2013, Inf. Syst..

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

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

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

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

[17]  Claudia Diamantini,et al.  Extending Drill-Down through Semantic Reasoning on Indicator Formulas , 2014, DaWaK.

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

[19]  Maurizio Lenzerini,et al.  Data integration: a theoretical perspective , 2002, PODS.

[20]  Christof Schulte.  10.2 Supply Chain Operations Reference-Modell , 2012 .

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

[22]  J. Ayers.  Supply-Chain Council , 2000 .

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

[24]  J. Marshall.  Open Innovation: The New Imperative for Creating and Profiting from Technology , 2004 .

[25]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling , 1996 .

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

[27]  Riccardo Torlone,et al.  Two approaches to the integration of heterogeneous data warehouses , 2008, Distributed and Parallel Databases.

[28]  Isabel F. Cruz,et al.  The role of ontologies in data integration , 2005 .

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