Abstract
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.
Keywords
- Data Warehouse Design
- Ontological Approach
- Reconciliation Phase
- Semantic Inconsistencies
- Global Conceptual Schema
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Ballard C, Herreman D, Schau D, Bell R, Kim E, Valencic A (1998) Data modeling technique for data warehousing. IBM Corporation
Romero O, Abelló A (2009) A survey of multidimensional modeling methodologies. Int J Data Warehouse Min 5:1–23
Di Tria F, Lefons E, Tangorra F (2012) Hybrid methodology for data warehouse conceptual design by uml schemas. Inf Software Technol 54(4):360–379
Euzenat J, Shvaiko P (2007) Ontology matching. Springer
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–97
Chen Z (2001) Intelligent data warehousing: from data preparation to data mining. CRC Press
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–235
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–321
Romero O, Abelló A (2010) A framework for multidimensional design of data warehouses from ontologies. Data Knowl Eng 69:1138–1157
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–107
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–53
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–217
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–12
Lenat DB (1995) Cyc: a large-scale investment in knowledge infrastructure. Commun ACM 38(11):32–38
Reed S, Lenat DB (2002) Mapping ontologies in Cyc. AAAI 2002 Conference workshop on ontologies for the semantic web. Edmonton, Canada
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–66
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer International Publishing Switzerland
About this paper
Cite this paper
Tria, F.D., Lefons, E., Tangorra, F. (2013). Ontological Approach to Data Warehouse Source Integration. In: Gelenbe, E., Lent, R. (eds) Information Sciences and Systems 2013. Lecture Notes in Electrical Engineering, vol 264. Springer, Cham. https://doi.org/10.1007/978-3-319-01604-7_25
Download citation
DOI: https://doi.org/10.1007/978-3-319-01604-7_25
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-01603-0
Online ISBN: 978-3-319-01604-7
eBook Packages: Computer ScienceComputer Science (R0)