Advertisement

Source Integration

  • Matthias Jarke
  • Maurizio Lenzerini
  • Yannis Vassiliou
  • Panos Vassiliadis

Abstract

According to [Inmo96], integration is the most important aspect of a data warehouse. When data passes from the application-oriented operational environment to the data warehouse, possible inconsistencies and redundancies should be resolved, so that the warehouse is able to provide an integrated and reconciled view of data of the organization.

Keywords

Source Model Schema Integration Data Integration Description Logic Data Warehouse 
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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. [Inmo96]
    W. H. Inmon: Building the Data Warehouse, 2nd edition. John Wiley and Sons, 1996.Google Scholar
  2. [Albe96]
    J. Albert: Data integration in the RODIN multidatabase system. Proceedings of the 4th International Conference on Cooperative Information Systems (CoopIS), Brussels, Belgium, pp. 48–57, IEEE Computer Society, 1996.Google Scholar
  3. [HuZh96]
    R. Hull, G. Zhou: A framework for supporting data integration using the materialized and virtual approaches.In: [SIGM96], pp. 481–492.Google Scholar
  4. [BaLN86]
    C. Batini, M. Lenzerini, S.B. Navathe: A comparative analysis of methodologies for database schema integration. ACM Computing Surveys, 18 (4), pp. 323–364, 1986.CrossRefGoogle Scholar
  5. [CaLe93]
    T. Catarci, M. Lenzerini: Representing and using interschema knowledge in cooperative information systems.Journal of Intelligent and Cooperative Information Systems, 2 (4), pp. 375–398, 1993.CrossRefGoogle Scholar
  6. [BaLN86]
    C. Batini, M. Lenzerini, S.B. Navathe: A comparative analysis of methodologies for database schema integration. ACM Computing Surveys, 18 (4), pp. 323–364, 1986.CrossRefGoogle Scholar
  7. [GaSC95]
    M. Garcia-Solaco, F. Saltor, M. Castellanos: A semantic-discrimi-nated approach to integration in federated databases. Proceedings of the 3rd International Conference on Cooperative Information Systems (CoopIS), Vienna, Austria, pp. 19–31, 1995.Google Scholar
  8. [GaSC95a]
    M. Garcia-Solaco, F. Saltor, M. Castellanos: A structure based schema integration methodology. Proceedings of the 11`h International Conference on Data Engineering (ICDE), Taipei, Taiwan, pp. 505–512, IEEE Computer Society, 1995.Google Scholar
  9. [RPRG94]
    M.P. Reddy, B.E. Prasad, P.G. Reddy, A. Gupta: A methodology for integration of heterogeneous databases. IEEE Transactions on Knowledge and Data Engineering, 6 (6), pp. 920–933, 1994.CrossRefGoogle Scholar
  10. [GaSC95]
    M. Garcia-Solaco, F. Saltor, M. Castellanos: A semantic-discrimi-nated approach to integration in federated databases. Proceedings of the 3rd International Conference on Cooperative Information Systems (CoopIS), Vienna, Austria, pp. 19–31, 1995.Google Scholar
  11. [GaSC95a]
    M. Garcia-Solaco, F. Saltor, M. Castellanos: A structure based schema integration methodology. Proceedings of the 11`h International Conference on Data Engineering (ICDE), Taipei, Taiwan, pp. 505–512, IEEE Computer Society, 1995.Google Scholar
  12. [ShGN93]
    A.P. Sheth, S.K. Gala, S.B. Navathe: On automatic reasoning for schema integration. Journal of Intelligent and Cooperative Information Systems, 2 (1), pp. 23–50, 1993.CrossRefGoogle Scholar
  13. [Joha94]
    P. Johanneson: Schema standardization as an aid in view integra-tion. Information Systems, 19 (3), pp.275–290, 1994.CrossRefGoogle Scholar
  14. [BoCo90]
    M. Bouzeghoub, I. Comyn-Wattiau: View integration by semantic unification and transformation of data structures. Proceedings of the 9h International Conference on the Entity-Relationship Approach (ER), pp. 413–430,North-Holland, 1990.Google Scholar
  15. [SpPD92]
    S. Spaccapietra, C. Parent, Y. Dupont: Model independent asser-tions for integration of heterogeneous schemas.VLDB Journal, 1 (1), pp. 81–126, 1992.CrossRefGoogle Scholar
  16. [OuNa94]
    A.M. Ouksel, C. F. Naiman: Coordinating context building in het-erogeneous information systems. Journal of Intelligent Information Systems, 3 (2), pp. 151–183, 1994.CrossRefGoogle Scholar
  17. [RPRG94]
    M.P. Reddy, B.E. Prasad, P.G. Reddy, A. Gupta: A methodology for integration of heterogeneous databases. IEEE Transactions on Knowledge and Data Engineering, 6 (6), pp. 920–933, 1994.CrossRefGoogle Scholar
  18. [GoLN92]
    W. Gotthard, P.C. Lockemann, A. Neufeld: System-guided view integration for object-oriented databases IEEE Transactions on Knowledge and Data Engineering, 4 (1), pp. 1–22, 1992.CrossRefGoogle Scholar
  19. [MiYR94]
    R.J. Miller, Y.E. Yoannidis, R. Ramakrishnan: Schema equivalence in heterogeneous systems: Bridging theory and practice. Information Systems, 19 (1), pp. 3–31, 1994.CrossRefGoogle Scholar
  20. [Qian96]
    X. Qian: Correct schema transformations. In: [EDBT98], pp. 114–128.Google Scholar
  21. [Hu1186]
    R. Hull: Relative information capacity of simple relational database schema. SIAM Journal of Computing,15 (3), pp. 856–886, 1986.MathSciNetMATHCrossRefGoogle Scholar
  22. [BuDK92]
    P. Buneman, S. Davidson, A. Kosky: Theoretical aspects of schema merging. Proceedings of the 3rd International Conference on Extending Database Technology (EDBT), Vienna, Austria, pp. 152167, Lecture Notes in Computer Science, Volume 580,Springer-Verlag, 1992.Google Scholar
  23. [SpPD92]
    S. Spaccapietra, C. Parent, Y. Dupont: Model independent asser-tions for integration of heterogeneous schemas.VLDB Journal, 1 (1), pp. 81–126, 1992.CrossRefGoogle Scholar
  24. [GPNS92]
    J. Geller, Y. Perl, E. Neuhold, A. Sheth: Structural schema integration with full and partial correspondence using the dual model. Information Systems, 17 (6), pp. 443–464, 1992.CrossRefGoogle Scholar
  25. [GPC*92]
    J. Geller, Y. Perl, P. Cannata, A.P. Sheth, E. Neuhold: A case study of structural integration. Proceedings of the 1St International Conference on Information and Knowledge Management (CIKM), Baltimore, MD, pp. 102–111, 1992.Google Scholar
  26. [CoHS91]
    C. Collet, M.N. Huhns, W. Shen: Resource integration using a large knowledge base in Carnot. IEEE Computer, 24 (12), pp. 55–62, 1991.CrossRefGoogle Scholar
  27. [LeSK95]
    A.Y. Levy, D. Srivastava, T. Kirk: Data model and query evaluation in global information systems. Journal of Intelligent Information Systems, 5 (2), pp. 121–143, 1995.CrossRefGoogle Scholar
  28. [KLSS95]
    T. Kirk, A.Y. Levy, Y. Sagiv, D. Srivastava: The Information Mani-fold. Proceedings of the AAAI 1995 Spring Symposium on Information Gathering from Heterogeneous, Distributed Environments, pp. 85–91, 1995.Google Scholar
  29. [LeRO96]
    A.Y. Levy, A. Rajaraman, J.J. Ordille: Query answering algorithms for information agents. Proceedings of the 13th National Conference on Artificial Intelligence (AAAI), Portland, OR, pp. 40–47, AAAI Press/MIT Press, 1996.Google Scholar
  30. [PMB*91]
    P.F. Patel-Schneider, D.L. McGuiness, R.J. Brachman, L. Alperin Resnick, A. Borgida: The CLASSIC knowledge representation system: Guiding principles and implementation rational. SIGART Bulletin, 2 (3), pp. 108–113, 1991.CrossRefGoogle Scholar
  31. [CGH*94]
    S. Chawathe, H. Garcia-Molina, J. Hammer, K. Ireland, Y. Papakonstantinou, J. Ullman, J. Widom: The TSIMMIS project: Integration of heterogeneous information sources. Proceedings of IPSJ Conference, Tokyo, Japan, pp. 7–18,1994.Google Scholar
  32. [U11m97]
    ] J.D. Ullman: Information integration using logical views. In: [ICDT97], pp. 19–40.Google Scholar
  33. [GuJM96]
    A. Gupta, H.V. Jagadish, I.S. Mumick: Data integration using self-maintainable views. In: [EDBT96], pp.140–144.Google Scholar
  34. [ZHKF95]
    G. Zhou, R. Hull, R. King, J. Franchitti: Data integration and warehousing using H20. IEEE Data Engineering Bulletin, Special Issue on Materialized Views and Data Warehousing, 18 (2), pp. 29–40, 1995.Google Scholar
  35. [ZHKF95a]
    G. Zhou, R. Hull, R. King, J. Franchitti: Using object matching and materialization to integrate heterogeneous databases. Proceedings of the 3rd International Conference on Cooperative Information Systems (CoopIS), Vienna, Austria, pp.4–18, 1995.Google Scholar
  36. [ZhHK96]
    G. Zhou, R. Hull, R. King: Generating data integration mediators that use materialization. Journal of Intelligent Information Systems, 6 (2), pp. 199–221, 1996.CrossRefGoogle Scholar
  37. [HuZh96]
    R. Hull, G. Zhou: A framework for supporting data integration using the materialized and virtual approaches.In: [SIGM96], pp. 481–492.Google Scholar
  38. [ZHKF95]
    G. Zhou, R. Hull, R. King, J. Franchitti: Data integration and warehousing using H20. IEEE Data Engineering Bulletin, Special Issue on Materialized Views and Data Warehousing, 18 (2), pp. 29–40, 1995.Google Scholar
  39. [ZhHK96]
    G. Zhou, R. Hull, R. King: Generating data integration mediators that use materialization. Journal of Intelligent Information Systems, 6 (2), pp. 199–221,1996.CrossRefGoogle Scholar
  40. [ZGHW95]
    Y. Zhuge, H. Garcia-Molina, J. Hammer, J. Widom: View maintenance in a warehousing environment. In: [SIGM95],pp. 316–327.Google Scholar
  41. [CDL*97]
    D. Calvanese, G. De Giacomo, M. Lenzerini, D.Nardi, R. Rosati: Source integration in data warehousing. DWQ Technical Report, October 1997.Google Scholar
  42. [CDL*98c]
    D. Calvanese, G. De Giacomo, M. Lenzerini, D. Nardi, R.Rosati: Experimentation with the incremental view integration. DWQ Technical Report, September 1998.Google Scholar
  43. [CDL*98d]
    D. Calvanese, G. De Giacomo, M. Lenzerini, D. Nardi, R. Rosati: Schema and data integration methodology for DWQ. DWQ Technical Report, September 1998.Google Scholar
  44. [CDL*98a]
    D. Calvanese, G. De Giacomo, M. Lenzerini, D. Nardi, R. Rosati: Description logic framework for information integration. Proceedings of the 6th International Conference on the Principles of Knowledge Representation and Reasoning (KR),pp. 2–13, Morgan Kaufmann, 1998.Google Scholar
  45. [CDL*98b]
    D. Calvanese, G. De Giacomo, M. Lenzerini, D. Nardi, R. Rosati: Source integration in data warehousing. In: [DEXA98], pp. 192197.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2000

Authors and Affiliations

  • Matthias Jarke
    • 1
  • Maurizio Lenzerini
    • 2
  • Yannis Vassiliou
    • 3
  • Panos Vassiliadis
    • 3
  1. 1.Dept. of Computer Science V (Information Systems)RWTH AachenAachenGermany
  2. 2.Dipartimento di Informatica e SistemisticaUniversità di Roma “La Sapienza”RomeItaly
  3. 3.Dept. of Electrical and Computer Engineering Computer Science DivisionNational Technical University of AthensZographou AthensGreece

Personalised recommendations