Towards Analytics Aware Ontology Based Access to Static and Streaming Data

Real-time analytics that requires integration and aggregation of heterogeneous and distributed streaming and static data is a typical task in many industrial scenarios such as diagnostics of turbines in Siemens. OBDA approach has a great potential to facilitate such tasks; however, it has a number of limitations in dealing with analytics that restrict its use in important industrial applications. Based on our experience with Siemens, we argue that in order to overcome those limitations OBDA should be extended and become analytics, source, and cost aware. In this work we propose such an extension. In particular, we propose an ontology, mapping, and query language for OBDA, where aggregate and other analytical functions are first class citizens. Moreover, we develop query optimisation techniques that allow to efficiently process analytical tasks over static and streaming data. We implement our approach in a system and evaluate our system with Siemens turbine data.

[1]  Michael Zakharyaschev,et al.  Ontology-Based Data Access: Ontop of Databases , 2013, SEMWEB.

[2]  Daniel P. Miranker,et al.  Ultrawrap: SPARQL execution on relational data , 2013, J. Web Semant..

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

[4]  Ian Horrocks,et al.  Ontology-Based Integration of Streaming and Static Relational Data with Optique , 2016, SIGMOD Conference.

[5]  Diego Calvanese,et al.  High Performance Query Answering over DL-Lite Ontologies , 2012, KR.

[6]  Jennifer Widom,et al.  STREAM: the stanford stream data manager (demonstration description) , 2003, SIGMOD '03.

[7]  Dimitrios Gunopulos,et al.  Elastic Processing of Analytical Query Workloads on IaaS Clouds , 2015, ArXiv.

[8]  Diego Calvanese,et al.  The MASTRO system for ontology-based data access , 2011, Semantic Web.

[9]  Ian Horrocks,et al.  Optique: Towards OBDA Systems for Industry , 2013, ESWC.

[10]  Nick Roussopoulos,et al.  DynaMat: a dynamic view management system for data warehouses , 1999, SIGMOD '99.

[11]  Jennifer Widom,et al.  STREAM: The Stanford Stream Data Manager , 2003, IEEE Data Eng. Bull..

[12]  Óscar Corcho,et al.  RSP-QL Semantics: A Unifying Query Model to Explain Heterogeneity of RDF Stream Processing Systems , 2014, Int. J. Semantic Web Inf. Syst..

[13]  Danh Le Phuoc,et al.  A Native and Adaptive Approach for Unified Processing of Linked Streams and Linked Data , 2011, SEMWEB.

[14]  Ralf Möller,et al.  A Stream-Temporal Query Language for Ontology Based Data Access , 2014, Description Logics.

[15]  Ian Horrocks,et al.  Optique: Ontology-Based Data Access Platform , 2015, SEMWEB.

[16]  Yannis E. Ioannidis,et al.  Dataflow Processing and Optimization on Grid and Cloud Infrastructures , 2009, IEEE Data Eng. Bull..

[17]  Diego Calvanese,et al.  Capturing model-based ontology evolution at the instance level: The case of DL-Lite , 2013, J. Comput. Syst. Sci..

[18]  Alasdair J. G. Gray,et al.  Enabling Ontology-Based Access to Streaming Data Sources , 2010, SEMWEB.

[19]  Richard McClatchey,et al.  Ontology-driven relational query formulation using the semantic and assertional capabilities of OWL-DL , 2012, Knowl. Based Syst..

[20]  Frederick Reiss,et al.  TelegraphCQ: continuous dataflow processing , 2003, SIGMOD '03.

[21]  Radoslaw Oldakowski D2RQ Platform – Treating Non-RDF Databases as Virtual RDF Graphs , 2011 .

[22]  Diego Calvanese,et al.  Ontologies and Databases: The DL-Lite Approach , 2009, Reasoning Web.

[23]  Diego Calvanese,et al.  Aggregate queries over ontologies , 2008, ONISW '08.

[24]  S. Lamparter,et al.  Demo : Enabling Semantic Access to Static and Streaming Distributed Data with Optique ∗ , 2016 .

[25]  Carsten Lutz,et al.  Mixing Open and Closed World Assumptionin Ontology-Based Data Access: Non-Uniform Data Complexity , 2012, Description Logics.

[26]  Franz Baader,et al.  Description Logics with Aggregates and Concrete Domains , 1997, Description Logics.

[27]  Ian Horrocks,et al.  Enabling semantic access to static and streaming distributed data with optique: demo , 2016, DEBS.

[28]  Jennifer Widom,et al.  The CQL continuous query language: semantic foundations and query execution , 2006, The VLDB Journal.

[29]  Diego Calvanese,et al.  Ontology-based data integration in EPNet: Production and distribution of food during the Roman Empire , 2016, Eng. Appl. Artif. Intell..

[30]  Thomas Eiter,et al.  Linked Stream Data Processing Engines: Facts and Figures , 2012, SEMWEB.

[31]  Alessandro Artale,et al.  DL-Lite with Attributes and Datatypes , 2012, ECAI.

[32]  Maurizio Lenzerini,et al.  MASTRO STUDIO: Managing Ontology-Based Data Access applications , 2013, Proc. VLDB Endow..

[33]  Egor V. Kostylev,et al.  Complexity of Answering Counting Aggregate Queries over DL-Lite , 2013, Description Logics.

[34]  Michael Stonebraker,et al.  Aurora: a data stream management system , 2003, SIGMOD '03.

[35]  Diego Calvanese,et al.  Evolution of DL-Lite Knowledge Bases , 2010, SEMWEB.

[36]  Daniele Braga,et al.  C-SPARQL: a Continuous Query Language for RDF Data Streams , 2010, Int. J. Semantic Comput..

[37]  Freddy Priyatna,et al.  Formalisation and experiences of R2RML-based SPARQL to SQL query translation using morph , 2014, WWW.

[38]  Evgeny Kharlamov,et al.  How Semantic Technologies Can Enhance Data Access at Siemens Energy , 2014, SEMWEB.

[39]  Abraham Bernstein,et al.  Scalable Linked Data Stream Processing via Network-Aware Workload Scheduling , 2013, SSWS@ISWC.

[40]  Ian Horrocks,et al.  Semantic Access to Siemens Streaming Data: the Optique Way , 2015, International Semantic Web Conference.

[41]  Ian Horrocks,et al.  Optique 1.0: Semantic Access to Big Data: The Case of Norwegian Petroleum Directorate's FactPages , 2013, International Semantic Web Conference.

[42]  Ralf Möller,et al.  OBDA for Temporal Querying and Streams , 2015, HiDeSt@KI.