Abstract
The schema integration technique offers the possibility to unify the representation of several schemas into one global schema. In this work, we present two contributions. The first one is about automating this technique to reduce human intervention. The second one is about applying this technique to generate data warehouse schema from data mart schemas. To response to our goals, we propose a new methodology that is composed by schema matching and schema mapping. The first technique compares the elements of the two schemas using a new semantic measure to generate the mapping rules. The second one transforms the mapping rules into queries and applies them to ensure the automatic merging of the schemas.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Barbançon, F., Miranker, D.P.: Interactive schema integration with sphinx. In: Christiansen, H., Hacid, M.-S., Andreasen, T., Larsen, H.L. (eds.) FQAS 2004. LNCS (LNAI), vol. 3055, pp. 175–190. Springer, Heidelberg (2004)
Batini, C., Lenzerini, M.: A methodology for data schema integration in the entity relationship model. IEEE Transactions on Software Engineering 6, 650–664 (1984)
Batini, C., Lenzerini, M., Navathe, S.B.: A comparative analysis of methodologies for database schema integration. ACM Computing Surveys (CSUR) 18(4), 323–364 (1986)
Battaglia, A., Golfarelli, M., Rizzi, S.: Qbx: A case tool for data mart design. In: De Troyer, O., Bauzer Medeiros, C., Billen, R., Hallot, P., Simitsis, A., Van Mingroot, H. (eds.) ER Workshops 2011. LNCS, vol. 6999, pp. 358–363. Springer, Heidelberg (2011)
Bellström, P.: Bridging the gap between comparison and conforming the views in view integration. In: 10th East-European Conference on Advances in Databases and Information Systems, pp. 184–199 (2006)
Bernstein, P.A., Melnik, S.: Meta data management. In: 2013 IEEE 29th International Conference on Data Engineering (ICDE), pp. 875–875. IEEE Computer Society (2004)
Casanova, M.A., Vidal, V.M.P.: Towards a sound view integration methodology. In: Proceedings of the 2nd ACM SIGACT-SIGMOD Symposium on Principles of Database Systems, pp. 36–47. ACM (1983)
Chiticariu, L., Hernández, M.A., Kolaitis, P.G., Popa, L.: Semi-automatic schema integration in clio. In: Proceedings of the 33rd International Conference on Very Large Data Bases, pp. 1326–1329. VLDB Endowment (2007)
Dang, L.H., Feldmann, D.I.M.: A Guideline for the Conduction of Data Integration for Heterogeneous Information Systems. Ph.D. thesis, Diploma Thesis (2010)
Hakimpour, F., Geppert, A.: Resolving semantic heterogeneity in schema integration. In: Proceedings of the International Conference on Formal Ontology in Information Systems, vol. 2001, pp. 297–308. ACM (2001)
Inmon, W.H.: Building the data warehouse. John Wiley & Sons (2005)
Kimball, R., Ross, M.: The data warehouse toolkit: the complete guide to dimensional modeling. John Wiley & Sons (2011)
Lawrence, R., Barker, K.: Integrating data sources using a standardized global dictionary. In: Knowledge Discovery for Business Information Systems, pp. 153–172. Springer (2002)
Lee, M.L., Ling, T.W.: Resolving structural conflicts in the integration of entity-relationship schemas. In: Papazoglou, M.P. (ed.) ER 1995 and OOER 1995. LNCS, vol. 1021, pp. 424–433. Springer, Heidelberg (1995)
Lee, M.L., Ling, T.W.: Resolving constraint conflicts in the integration of entity-relationship schemas. In: Embley, D.W., Goldstein, R.C. (eds.) ER 1997. LNCS, vol. 1331, pp. 394–407. Springer, Heidelberg (1997)
Lenzerini, M.: Data integration: A theoretical perspective. In: Proceedings of the Twenty-First ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, pp. 233–246. ACM (2002)
Levene, M., Loizou, G.: Why is the snowflake schema a good data warehouse design? Information Systems 28(3), 225–240 (2003)
Naiman, C.F., Ouksel, A.M.: A classification of semantic conflicts in heterogeneous database systems. Journal of Organizational Computing and Electronic Commerce 5(2), 167–193 (1995)
Navathe, S.B., Gadgil, S.G.: A methodology for view inegration in logical database design. In: Proceedings of the 8th International Conference on Very Large Data Bases, pp. 142–164. Morgan Kaufmann Publishers Inc. (1982)
Parent, C., Spaccapietra, S.: Integration de bases de donnees: Panorama desproblemes et des approches. In: Ingenierie des Systemes dInformation 4(LBD-ARTICLE-1996-002), pp. 333–359 (1996)
Schwarz, K., Schmitt, I., Türker, C., Höding, M., Hildebrandt, E., Balko, S., Conrad, S.: Design support for database federations. In: Akoka, J., Bouzeghoub, M., Comyn-Wattiau, I., Métais, E. (eds.) ER 1999. LNCS, vol. 1728, pp. 445–460. Springer, Heidelberg (1999)
Vermeer, M.W.W., Apers, P.M.G.: On the applicability of schema integration techniques to database interoperation. In: Thalheim, B. (ed.) ER 1996. LNCS, vol. 1157, pp. 179–194. Springer, Heidelberg (1996)
Yao, S.B., Waddle, V.E., Housel, B.C.: View modeling and integration using the functional data model. IEEE Transactions on Software Engineering 8(6), 544–553 (1982)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this paper
Cite this paper
Arfaoui, N., Akaichi, J. (2015). Automating Schema Integration Technique Case Study: Generating Data Warehouse Schema from Data Mart Schemas. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds) Beyond Databases, Architectures and Structures. BDAS 2015. Communications in Computer and Information Science, vol 521. Springer, Cham. https://doi.org/10.1007/978-3-319-18422-7_18
Download citation
DOI: https://doi.org/10.1007/978-3-319-18422-7_18
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-18421-0
Online ISBN: 978-3-319-18422-7
eBook Packages: Computer ScienceComputer Science (R0)