Automated integration of heterogeneous data warehouse schemas

International Journal of Data Warehousing and Mining

Volumn 4, Issue 4, 2008, Pages 1-21

  Banek, Marko ^a   Vrdoljak, Boris ^a   Tjoa, A Min ^b   Skočir, Zoran ^a  

^a UNIVERSITY OF ZAGREB   (Croatia)

^b VIENNA UNIVERSITY OF TECHNOLOGY   (Austria)

Author keywords

Bipartite graph; Data warehouse; Data warehouse federation; Data warehouse integration; Mapping; Multidimensional model; Schema matching; Semantic similarity

Indexed keywords

DATA WAREHOUSES; INTEGRATION; MAPPING; SEMANTICS;

BIPARTITE GRAPHS; EVIDENCE-BASED MEDICINE; HETEROGENEOUS DATA WAREHOUSE; LOGICAL INTEGRATION; MULTI-DIMENSIONAL MODEL; SCHEMA MATCHING; SEMANTIC SIMILARITY; STRUCTURAL COMPARISON;

DATA INTEGRATION;

EID: 47349084551     PISSN: 15483924     EISSN: 15483932     Source Type: Journal    
DOI: 10.4018/jdwm.2008100101     Document Type: Article

References (37)

1. Aumueller, D., Do, H.H., Massmann, S., & Rahm, E. (2005). Schema and Ontology Matching with COMA++. In F. Özcan (Ed.), Proc. ACM SIGMOD Int. Conf. on Management of Data (pp. 906-908). New York: ACM Press.
2. Banek, M., Tjoa, A. M., & Stolba, N. (2006). Integrating Different Grain Levels in a Medical Data Warehouse Federation. In A. M. Tjoa & J. Trujillo (Eds.), Proc. 8th Int. Conf. on Data Warehousing and Knowledge Discovery. Lecture Notes in Computer Science, 4081, 185-194.
3. Banek, M., Vrdoljak, B., Tjoa, A. M., & Skočir, Z. (2007). Automating the Schema Matching Process for Heterogeneous Data Warehouses. In I. Y. Song, J. Eder & T. Manh Nguyen (Eds.), Proc. 9th Int. Conf. on Data Warehousing and Knowledge Discovery. Lecture Notes in Computer Science, 4654, 45-54.
4. Beneventano D., Bergamaschi S., Guerra F., & Vincini M. (2003). Synthesizing an Integrated Ontology. IEEE Internet Computing Magazine, 7 (5), 42-51.
5. Beneventano D., & Bergamaschi S. (2006). Semantic Search Engines based on Data Integration Systems. In J. Cardoso (Ed.), Semantic Web: Theory, Tools and Applications (pp. 317-34 1). Hershey, PA, USA: IGI Publishing.
6. Bergamaschi, S., Castano, S., & Vincini, M. (1999). Semantic Integration of Semistructured and Structured Data Sources. SIGMOD Record 28 (1), 54-59.
7. Berger S., & Schrefl, M. (2006). Analysing Multidimensional Data accross Autonomous Data Ware-houses. In A. M. Tjoa & J. Trujillo (Eds.), Proc. 8th Int. Conf. on Data Warehousing and Knowledge Discovery. Lecture Notes in Computer Science, 4081, 120-133.
8. Cabibbo, L., & Torlone, R. (2005). Integrating Heterogeneous Multidimensional Databases. In J. Frew (Ed.), Proc. 17th Int. Conf. Scientific and Statistical Database Management (pp. 205-214).
9. Dhamankar, R., Lee, Y., Doan, A-H., Halevy, A. Y., & Domingos, P. (2004). iMAP: Discovering Complex Mappings between Database Schemas. In G. Weikum, A. C. König, S. DeBloch (Eds.), Proc. ACM SIGMOD Int. Conf. on Management of Data (pp. 383-394). New York: ACM Press.
10. Doan A., & Halevi, A. Y. (2005). Semantic integration research in the database community: A Brief Survey. AI Magazine, 26 (1), 83-94.
11. Doan, A., Lu, Y., Lee, Y., & Han, J. (2003). Profile-Based Object Matching for information Integration. IEEE Intelligent Systems, 18 (5), 54-59.
12. Euzenat, J., & Valtchev, P. (2004). Similarity-Based Ontology Alignment in OWL-Lite. In: R. López de Mántaras, L. Saitta (Eds.), Proc. 16th European Conf. on Artificial Intelligence, (pp. 333-337). Amsterdam: IOS Press.
13. Embley, D. W., Xu, L., & Ding Y. (2004). Automatic Direct and Indirect Schema Mapping: Experiences and Lessons Learned. SIGMOD Record 33 (4), 14-19.
14. Golfarelli, M., Maio, D. & Rizzi, S. (1998). The Dimensional Fact Model: a Conceptual Model for Data Warehouses. International Journal of Cooperative Information Systems, 7, 215-247.
15. Hackney, D. (1997). Understanding and Implementing Successful Data Marts. Reading, MA, USA: Addison-Wesley.
16. Halevy,A. Y. (200 1). Answering queries using views: A survey. VLDB J., 10, 270-294.
17. Health Level Seven - HL7 (2008). Retrieved February 25, 2008 from the World Wide Web: http://www.hl7.org
18. Inmon, W. H. (1996). Building the Data Warehouse (2nd ed.). New York: John Wiley & Sons.
19. Jindal, R. & Acharya, A. (2004). Federated Data Warehouse Architecture.Wipro Technologies-white paper. Retrieved October 10, 2007 from the World WideWeb: http://hosteddocs.ittoolbox.com/ Federated%20data%20Warehouse%20Architecture.pdf
20. Kim, W., & Seo, J. (1991). Classifying Semantic and Data Heterogeneity in Multidatabase Systems. IEEE Computer, 24 (12), 12-18.
21. Levenshtein, V. I. (1966). Binary Codes Capable of Correcting Deletions, Insertions, and Reversals. Cybernetics and Control Theory, 10 (8), 707-710.
22. Lovàsz, L. & Plummer, M. D. (1986). Matching Theory. Amsterdam: Ndrth-Holland.
23. Madhavan, J., Bernstein, P. A., & Rahm, E. (2001). Generic Schema Matching with Cupid. In P. M. G. Apers, P. Atzeni, S. Ceri, S. Paraboschi, K. Ramamohanarao, R. T. Snodgrass (Eds.) Proc. 27th Int. Conf. on Very Large Data Bases (pp. 49-58). San Francisco: Morgan Kaufmann.
24. Mansmann, S., & Scholl, M. H. (2006). Extending Visual OLAP for Handling Irregular Dimensional Hierarchies. In A. M. Tjoa & J. Trujillo (Eds.), Proc. 8th Int. Conf. on Data Warehousing and Knowledge Discovery. Lecture Notes in Computer Science, 4081, 95-105.
25. Melnik, S., Garcia-Molina, H., & Rahm, E. (2002). Similarity Flooding: A Versatile Graph Matching Algorithm and Its Application to Schema Matching. In Proc. 18th Int. Conf. on Data Engineering (pp. 117-128). IEEE Computer Society.
26. Palopoli, L., Saccà, D., Terracina, G., & Ursino, D. (2003). Uniform Techniques for Deriving Similarities of Objects and Subschemes in Heterogeneous Databases. IEEE Transactions on Knowledge and Data Engineering, 15, 271-294.
27. Rahm, E., & Bernstein, P. A. (2001). A survey of approaches to automatic schema matching. VLDB Journal, 10, 334-350.
28. Rahm, E., Do, H., & Massmann, S. (2004). Matching Large XML Schemas. SIGMOD Record, 33 (4), 26-31.
29. Resnik, P. (1999). Semantic Similarity in a Taxonomy: An Information-Based Measure and its Application to Problems of Ambiguity in Natural Language. J. Artificial. Intelligence Research, 11, 95-130.
30. Rodríguez, M. A., & Egenhofer, M.J. (2003). Determining Semantic Similarity among Entity Classes from Different Ontologies. IEEE Transactions on Knowledge and Data Engineering, 15, 442-456.
31. Sackett, D. L., Rosenberg, W. M. C., Muir Gray, J. A., Haynes, R. B., & Richardson, W. S. (1996). Evidence-Based Medicine: What It Is and What It Isn't. British Medical Journal, 312, 71-72.
32. Sheth, A. P., & Larson, J. A. (1990). Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases. ACM Computing Surveys, 22, 183-236.
33. Stolba, N., Banek, M., & Tjoa, A. M. (2006). The Security Issue of Federated Data Warehouses in the Area of Evidence-Based Medicine, In Proceedings of 1st Int. Conf. on Availability, Reliability and Security (pp. 329-339). Los Alamitos, CA, USA: IEEE Computer Society.
34. Sturnme, G., & Maedche, A. (2001). FCA-Merge: Bottom-up Merging of Ontologies. In B. Nebel (Ed.), Proc. 7th Int. Conf. on Artificial Intelligence, (pp. 225-230). San Francisco: Morgan Kaufmann.
35. Ullman, J.D. (1997). Information Integration Using Logical Views, In F. N. Afrati, P. G. Kolaitis (Eds.), Proc. 6th Int. Conf. on Data Database Theory. Lecture Notes in Computer Science, 1186, 19-40.
36. WordNet, a lexical database for English Language (2007). Retrieved October 10, 2007 from http://wordnet.princeton.edu/5papers.pdf
37. Yang, D., Powers, D. M. W. (2005). Measuring Semantic Similarity in the Taxonomy of WordNet. In V. Estivill-Castro (Ed.), Proc. 28th Australasian Computer Science Conference (pp. 315-322). Australian Computer Society.