Skip to main content
SpringerLink
Log in

Source Integration

  • Chapter
Fundamentals of Data Warehouses

  • 120 Accesses

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 74.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. W. H. Inmon: Building the Data Warehouse, 2nd edition. John Wiley and Sons, 1996.

    Google Scholar 

  2. 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. R. Hull, G. Zhou: A framework for supporting data integration using the materialized and virtual approaches.In: [SIGM96], pp. 481–492.

    Google Scholar 

  4. 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.

    Article  Google Scholar 

  5. 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.

    Article  Google Scholar 

  6. 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.

    Article  Google Scholar 

  7. 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. 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. 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.

    Article  Google Scholar 

  10. 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. 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. 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.

    Article  Google Scholar 

  13. P. Johanneson: Schema standardization as an aid in view integra-tion. Information Systems, 19 (3), pp.275–290, 1994.

    Article  Google Scholar 

  14. 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. S. Spaccapietra, C. Parent, Y. Dupont: Model independent asser-tions for integration of heterogeneous schemas.VLDB Journal, 1 (1), pp. 81–126, 1992.

    Article  Google Scholar 

  16. 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.

    Article  Google Scholar 

  17. 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.

    Article  Google Scholar 

  18. 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.

    Article  Google Scholar 

  19. 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.

    Article  Google Scholar 

  20. X. Qian: Correct schema transformations. In: [EDBT98], pp. 114–128.

    Google Scholar 

  21. R. Hull: Relative information capacity of simple relational database schema. SIAM Journal of Computing,15 (3), pp. 856–886, 1986.

    Article  MathSciNet  MATH  Google Scholar 

  22. 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. S. Spaccapietra, C. Parent, Y. Dupont: Model independent asser-tions for integration of heterogeneous schemas.VLDB Journal, 1 (1), pp. 81–126, 1992.

    Article  Google Scholar 

  24. 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.

    Article  Google Scholar 

  25. 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. C. Collet, M.N. Huhns, W. Shen: Resource integration using a large knowledge base in Carnot. IEEE Computer, 24 (12), pp. 55–62, 1991.

    Article  Google Scholar 

  27. 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.

    Article  Google Scholar 

  28. 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. 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. 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.

    Article  Google Scholar 

  31. 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. ] J.D. Ullman: Information integration using logical views. In: [ICDT97], pp. 19–40.

    Google Scholar 

  33. A. Gupta, H.V. Jagadish, I.S. Mumick: Data integration using self-maintainable views. In: [EDBT96], pp.140–144.

    Google Scholar 

  34. 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. 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. G. Zhou, R. Hull, R. King: Generating data integration mediators that use materialization. Journal of Intelligent Information Systems, 6 (2), pp. 199–221, 1996.

    Article  Google Scholar 

  37. R. Hull, G. Zhou: A framework for supporting data integration using the materialized and virtual approaches.In: [SIGM96], pp. 481–492.

    Google Scholar 

  38. 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. G. Zhou, R. Hull, R. King: Generating data integration mediators that use materialization. Journal of Intelligent Information Systems, 6 (2), pp. 199–221,1996.

    Article  Google Scholar 

  40. Y. Zhuge, H. Garcia-Molina, J. Hammer, J. Widom: View maintenance in a warehousing environment. In: [SIGM95],pp. 316–327.

    Google Scholar 

  41. D. Calvanese, G. De Giacomo, M. Lenzerini, D.Nardi, R. Rosati: Source integration in data warehousing. DWQ Technical Report, October 1997.

    Google Scholar 

  42. 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. 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. 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. D. Calvanese, G. De Giacomo, M. Lenzerini, D. Nardi, R. Rosati: Source integration in data warehousing. In: [DEXA98], pp. 192197.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Dept. of Computer Science V (Information Systems), RWTH Aachen, Ahornstr. 55, D-52056, Aachen, Germany

    Matthias Jarke

  2. Dipartimento di Informatica e Sistemistica, Università di Roma “La Sapienza”, Via Salaria 113, 00198, Rome, Italy

    Maurizio Lenzerini

  3. Dept. of Electrical and Computer Engineering Computer Science Division, National Technical University of Athens, 15773, Zographou Athens, Greece

    Yannis Vassiliou & Panos Vassiliadis

Authors
  1. Matthias Jarke
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Maurizio Lenzerini
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Yannis Vassiliou
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Panos Vassiliadis
    View author publications

    You can also search for this author in PubMed Google Scholar

Rights and permissions

Reprints and permissions

Copyright information

© 2000 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Jarke, M., Lenzerini, M., Vassiliou, Y., Vassiliadis, P. (2000). Source Integration. In: Fundamentals of Data Warehouses. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-662-04138-3_3

Download citation

  • DOI: https://doi.org/10.1007/978-3-662-04138-3_3

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-662-04140-6

  • Online ISBN: 978-3-662-04138-3

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation