Ontological Approach to Data Warehouse Source Integration

In the early stages of data warehouse design, the integration of several source databases must be addressed. Data-oriented and hybrid methodologies need to consider a global schema coming from the integration of source databases, in order to start the conceptual design. Since each database relies on its own conceptual schema, in the integration process a reconciliation phase is necessary, in order to solve syntactical and/or semantic inconsistencies among concepts. In this paper, we present an ontology-based approach to perform the integration of different conceptual schemas automatically.

[1]  Alberto Abelló,et al.  A framework for multidimensional design of data warehouses from ontologies , 2010, Data Knowl. Eng..

[2]  Francesco Di Tria,et al.  Logic Programming for Data Warehouse Conceptual Schema Validation , 2010, DaWak.

[3]  Steffen Staab,et al.  OntoEdit: Collaborative Ontology Development for the Semantic Web , 2002, SEMWEB.

[4]  Cherri M. Pancake,et al.  The promise and the cost of object technology: a five-year forecast , 1995, CACM.

[5]  Francesco Di Tria,et al.  Dimensional fact model extension via predicate calculus , 2009, 2009 24th International Symposium on Computer and Information Sciences.

[6]  J. Euzenat,et al.  Ontology Matching , 2007, Springer Berlin Heidelberg.

[7]  Douglas B. Lenat,et al.  CYC: a large-scale investment in knowledge infrastructure , 1995, CACM.

[8]  Stefano Ferilli,et al.  A General Similarity Framework for Horn Clause Logic , 2009, Fundam. Informaticae.

[9]  Alberto Abelló,et al.  A Survey of Multidimensional Modeling Methodologies , 2009, Int. J. Data Warehous. Min..

[10]  Farshad Hakimpour,et al.  Global Schema Generation Using Formal Ontologies , 2002, ER.

[11]  Chuck Ballard,et al.  Data Modeling Techniques for Data Warehousing , 1999 .

[12]  Ladjel Bellatreche,et al.  Ontologies and Functional Dependencies for Data Integration and Reconciliation , 2011, ER Workshops.

[13]  Francesco Di Tria,et al.  Hybrid methodology for data warehouse conceptual design by UML schemas , 2012, Inf. Softw. Technol..

[14]  Zhengxin Chen.  Intelligent Data Warehousing: From Data Preparation to Data Mining , 2001 .

[15]  Francesco Di Tria,et al.  GrHyMM: A Graph-Oriented Hybrid Multidimensional Model , 2011, ER Workshops.