Ontological On-line Analytical Processing for Integrating Energy Sensor Data

Abstract In this paper we propose an ontological OLAP (on-line analytical processing) framework to integrate distributed energy sensor data. The OLAP data cube in the framework annotated with semantics with other supporting mechanisms can deal with the issues of the schema inconsistency that may result from integration of heterogeneous data sources. The proposed approach provides a way of storing, reusing and composing OLAP cubes in order to increase system usability. A prototype of the proposed framework based on a number of existing tools such as protégé, Jess, and Fuzzy J has been developed to demonstrate its feasibility.

[1]  V. Ganesh,et al.  HBase and Hypertable for large scale distributed storage systems A Performance evaluation for Open Source BigTable Implementations , 2008 .

[2]  R. A. Moeller,et al.  Distributed data warehousing using Web technology , 2001 .

[3]  Laura Maruster,et al.  Encyclopedia of data warehousing and mining , 2008 .

[4]  Huajun Chen,et al.  The Semantic Web , 2011, Lecture Notes in Computer Science.

[5]  Raja Chiky,et al.  Summarizing Distributed Data Streams for Storage in Data Warehouses , 2008, DaWaK.

[6]  Mukesh K. Mohania,et al.  Physical Data Warehousing Design , 2009, Encyclopedia of Data Warehousing and Mining.

[7]  Il-Yeol Song,et al.  Applying UML and XML for designing and interchanging information for data warehouses and OLAP applications , 2004, J. Database Manag..

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

[9]  Stephen R. Gardner.  Building the data warehouse , 1998, CACM.

[10]  Kevin Wilkinson,et al.  Data integration flows for business intelligence , 2009, EDBT '09.

[11]  Peter Thanisch,et al.  Applying Grid Technologies to XML Based OLAP Cube Construction , 2003, DMDW.

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

[13]  A Min Tjoa,et al.  A framework for a multidimensional OLAP model using Topic Maps , 2001, Proceedings of the Second International Conference on Web Information Systems Engineering.

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

[15]  Yuan Ji.  Towards Framework for The Virtual Data Warehouse , 2003 .

[16]  E. F. Codd,et al.  Providing OLAP to User-Analysts: An IT Mandate , 1998 .

[17]  Yu Hong,et al.  Data Warehouse Performance , 2009, Encyclopedia of Data Warehousing and Mining.

[18]  Iuliana Botha,et al.  Improving query performance in virtual data warehouses , 2008 .

[19]  Dan Brickley,et al.  Rdf vocabulary description language 1.0 : Rdf schema , 2004 .

[20]  Thomas R. Gruber,et al.  A translation approach to portable ontology specifications , 1993, Knowl. Acquis..

[21]  Wilson C. Hsieh,et al.  Bigtable: A Distributed Storage System for Structured Data , 2006, TOCS.

[22]  Pascal Richard,et al.  Data Partitioning in Data Warehouses: Hardness Study, Heuristics and ORACLE Validation , 2008, DaWaK.

[23]  L. Stein,et al.  OWL Web Ontology Language - Reference , 2004 .

[24]  Les Pang.  Best Practices in Data Warehousing , 2009, Encyclopedia of Data Warehousing and Mining.

[25]  Larry Kerschberg,et al.  Knowledge Management in Heterogeneous Data Warehouse Environments , 2001, DaWaK.

[26]  Dieter Fensel,et al.  Knowledge Engineering: Principles and Methods , 1998, Data Knowl. Eng..

[27]  Jane Zhao.  Designing Distributed Data Warehouses and OLAP Systems , 2005, ISTA.

[28]  Patrick Valduriez,et al.  Principles of Distributed Database Systems , 1990 .

[29]  Jorge Bernardino,et al.  Efficient Data Distribution for DWS , 2008, DaWaK.

[30]  Klaus-Dieter Schewe,et al.  Balancing Redundancy and Query Costs in Distributed Data Warehouses , 2005, APCCM.

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

[32]  Peter Thanisch,et al.  Constructing an OLAP cube from distributed XML data , 2002, DOLAP '02.

[33]  Dimitrios Skoutas,et al.  Ontology-Based Conceptual Design of ETL Processes for Both Structured and Semi-Structured Data , 2007, Int. J. Semantic Web Inf. Syst..

[34]  Oscar Mangisengi,et al.  A Framework for Supporting Interoperability of Data Warehouse Islands Using XML , 2001, DaWaK.

[35]  Geneviève Jomier,et al.  Design and Analysis of Index Structures in MultiVersion Data Warehouses , 2009 .

[36]  Witold Litwin,et al.  Architecture and Interface of Scalable Distributed Database System SD-SQL Server , 2006, Databases and Applications.

[37]  Dimitrios Skoutas,et al.  Designing ETL processes using semantic web technologies , 2006, DOLAP '06.

[38]  Carlo Combi,et al.  Modeling and Querying Temporal Semistructured Data , 2009, New Trends in Data Warehousing and Data Analysis.

[39]  Torben Bach Pedersen.  Warehousing The World: A Vision for Data Warehouse Research , 2009, New Trends in Data Warehousing and Data Analysis.

[40]  Torben Bach Pedersen,et al.  Integrating Data Warehouses with Web Data: A Survey , 2008, IEEE Transactions on Knowledge and Data Engineering.

[41]  Esteban Zimányi,et al.  Conceptual Modeling for Data Warehouse and OLAP Applications , 2009, Encyclopedia of Data Warehousing and Mining.

[42]  Jeremy J. Carroll,et al.  Resource description framework (rdf) concepts and abstract syntax , 2003 .

[43]  Harvey B. Newman,et al.  Distributed Heterogeneous Relational Data Warehouse In A Grid Environment , 2003, ArXiv.

[44]  Alberto Abelló,et al.  Research in data warehouse modeling and design: dead or alive? , 2006, DOLAP '06.

[45]  A Min Tjoa,et al.  Meta Cube-X: An XML Metadata Foundation for Interoperability Search among Web Data Warehouses , 2001, DMDW.

[46]  Alberto Salguero,et al.  Ontology based framework for data integration , 2008 .