Ontological Approach to Data Warehouse Source Integration

  • Francesco Di TriaEmail author
  • Ezio Lefons
  • Filippo Tangorra
Conference paper
Part of the Lecture Notes in Electrical Engineering book series (LNEE, volume 264)


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. 1.
    Ballard C, Herreman D, Schau D, Bell R, Kim E, Valencic A (1998) Data modeling technique for data warehousing. IBM CorporationGoogle Scholar
  2. 2.
    Romero O, Abelló A (2009) A survey of multidimensional modeling methodologies. Int J Data Warehouse Min 5:1–23CrossRefGoogle Scholar
  3. 3.
    Di Tria F, Lefons E, Tangorra F (2012) Hybrid methodology for data warehouse conceptual design by uml schemas. Inf Software Technol 54(4):360–379CrossRefGoogle Scholar
  4. 4.
    Euzenat J, Shvaiko P (2007) Ontology matching. SpringerGoogle Scholar
  5. 5.
    Di Tria F, Lefons E, Tangorra F (2011) GrHyMM: a graph-oriented hybrid multidimensional model. In: Proceedings of the 30th international conference on ER 2011, Brussels, Belgium, LNCS 6999. Springer, pp 86–97Google Scholar
  6. 6.
    Chen Z (2001) Intelligent data warehousing: from data preparation to data mining. CRC PressGoogle Scholar
  7. 7.
    Sure Y, Erdmann M, Angele J, Staab S, Studer R, Wenke D (2002) OntoEdit: collaborative ontology development for the semantic web. In: Proceedings of the 1st international semantic web conference, Sardinia, Italy, LNCS 2342. Springer Verlag, pp 221–235Google Scholar
  8. 8.
    Hakimpour F, Geppert A (2002) Global schema generation using formal ontologies. In: Proceedings of the 21st international conference on conceptual modeling, Tampere, Finland, LNCS 2503. Springer, pp 307–321Google Scholar
  9. 9.
    Romero O, Abelló A (2010) A framework for multidimensional design of data warehouses from ontologies. Data Knowl Eng 69:1138–1157CrossRefGoogle Scholar
  10. 10.
    Bakhtouchi A, Bellatreche L, Ait-Ameur Y (2011) Ontologies and functional dependencies for data integration and reconciliation. In: Proceedings of the 30th international conference on ER 2011, Brussels, Belgium, LNCS 6999. Springer, pp 98–107Google Scholar
  11. 11.
    Mazón JN, Trujillo J, Serrano M, Piattini M et al (2005) Designing data warehouses: from business requirement analysis to multidimensional modeling. In: Cox K (ed) Requirements engineering for business need and it alignment. University of New South, Wales Press, pp 44–53Google Scholar
  12. 12.
    dell’Aquila C, Di Tria F, Lefons E, Tangorra F (2009) Dimensional fact model extension via predicate calculus. In: Proceedings of the 24th international symposium on computer and information sciences. IEEE Press, North Cyprus, pp 211–217Google Scholar
  13. 13.
    dell’Aquila C, Di Tria F, Lefons E, Tangorra F (2010) Logic programming for data warehouse conceptual schema validation. In: Proceedings of the 12th international conference on data warehousing and knowledge discovery, Bilbao, Spain, LNCS 6263. Springer, pp 1–12Google Scholar
  14. 14.
    Lenat DB (1995) Cyc: a large-scale investment in knowledge infrastructure. Commun ACM 38(11):32–38Google Scholar
  15. 15.
    Reed S, Lenat DB (2002) Mapping ontologies in Cyc. AAAI 2002 Conference workshop on ontologies for the semantic web. Edmonton, CanadaGoogle Scholar
  16. 16.
    Ferilli S, Basile TMA, Biba M, Di Mauro N, Esposito F (2009) A general similarity framework for Horn clause logic. Fundam Inf 90(1–2):43–66zbMATHGoogle Scholar

Copyright information

© Springer International Publishing Switzerland 2013

Authors and Affiliations

  • Francesco Di Tria
    • 1
    Email author
  • Ezio Lefons
    • 1
  • Filippo Tangorra
    • 1
  1. 1.Dipartimento di InformaticaUniversità degli Studi di Bari “Aldo Moro”BariItaly

Personalised recommendations