ACQUIRING AND INTEGRATING EXTERNAL DATA INTO DATA WAREHOUSES - Are You Familiar With the Most Common Process?

Mattias Strand, Benkt Wangler, Carl-Fredrik Lauren

Abstract

Data warehouses (DWs) has become one of the major IT-investments during the last decades and in order to fully exploit the potential of data warehouses, more and more organizations are acquiring and integrating external data into their star-schemas. However, the literature covering external data acquisition and integration is limited. Therefore, in this paper the results of an interview study conducted among banking organizations are presented. The study aimed at identifying different approaches for acquiring and integrating external data into DWs. The results show that there are many different approaches for the acquisition and integration, depending on the purpose and structure of the data being acquired. In addition, the most common external data acquisition and integration process is presented and discussed.

References

  1. Adleman, S., 1997. Data Quality, Data Warehouse: practical advice from the experts, (Bischoff, Joyce and Ted Alexander, eds.), New Jersey: Prentice Hall, 122- 134.
  2. Connolly, T. and Begg, C., 2002. Database Systems: a practical approach to design, implementation and management). Harlow: Addison Wesley Longman, 3rd edition.
  3. Damato, G. M., 1999. Strategic information from external sources - a broader picture of business reality for the data warehouse, acquired from http://www.dwway.com, printed 2003.03.20.
  4. Devlin, B., 1997. Data warehouse: from architecture to implementation. Harlow: Addison Wesley Longman.
  5. Gleason, D., 1997. Data transformation, Data warehouse: practical advice from the experts, (Bischoff, Joyce and Ted Alexander, eds.) (p.). New Jersey: Prentice Hall, 160-173.
  6. Inmon, W. H., 1996. Buliding the data warehouse, New York: John Wiley and sons, 2nd edition.
  7. Inmon, W. H., 1999. Integrating internal and external data, The Bill Inmon.com library LLC, acquired from http://www.billinmon.com/library/articles/intext.asp., printed 2003.02.23.
  8. Inmon, W. H., Imhoff, C. and Sousa, R., 2001. Information corporation factory, New York: John Wiley & sons, 2nd edition.
  9. Kelly, S., 1996. Data Warehousing the route to customization - updated and expanded, New York: John Wiley & Sons.
  10. Kimball, R., 1998. The data warehouse lifecycle toolkit: expert methods for designing, developing, and deploying data warehouses, New York: John Wiley & sons.
  11. Marco, D., 2000. Building and managing the meat data repository: a full lifecycle guide, New York: Johan Wiley & sons.
  12. Oglesby, W. E., 1999. Using external data sources and warehouses to enhance your direct marketing effort, acquired from http://www.dmreview.com., printed 2003.02.22.
  13. Salmeron, J. L., 2001. EIS data: findings from an evolutionary study. Journal of systems and software, Vol.64, Issue 2, 87-172.
  14. Singh, H., 1998. Data Warehousing: Concepts, Technologies, Implementations, and Management, New Jersey: Prentice Hall.
  15. Strand, M., 2003. Incorporating external data into data data warehouses. In proceedings of the knowledge in organization (KIO) doctorial consortium, part 2, 5-6 February, Västerås, Sweden.
  16. Strand, M. and Olsson, M. (2003) “The Hamlet dilemma on external data in data warehouses” in Proceedings of the 5th International Conference on Enterprise Information Systems (ICEIS) - Part 1, Olivier Camp, Joaquim Filipe, Slimane Hammoudi and Mario Piattini. (Ed.), April 23-26, Angers, France, pp.570- 573.
  17. Strand, M. Wangler, B. and Olsson, M., 2003. Incorporating External Data into Data Warehouses: Characterizing and Categorizing Suppliers and Types of External Data". In AMCIS'03, Americas Conference on Information Systems. 2460- 2468, (CD-ROM).
  18. Tiwana, A., 2000. The Knowledge Management Toolkit: practical techniques for building a knowledge management system, New Jersey: Prentice Hall.
Download


Paper Citation


in Harvard Style

Strand M., Wangler B. and Lauren C. (2004). ACQUIRING AND INTEGRATING EXTERNAL DATA INTO DATA WAREHOUSES - Are You Familiar With the Most Common Process? . In Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-00-7, pages 508-513. DOI: 10.5220/0002601905080513


in EndNote Style

TY - CONF
JO - Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - ACQUIRING AND INTEGRATING EXTERNAL DATA INTO DATA WAREHOUSES - Are You Familiar With the Most Common Process?
SN - 972-8865-00-7
AU - Strand M.
AU - Wangler B.
AU - Lauren C.
PY - 2004
SP - 508
EP - 513
DO - 10.5220/0002601905080513


in Bibtex Style

@conference{iceis04,
author={Mattias Strand and Benkt Wangler and Carl-Fredrik Lauren},
title={ACQUIRING AND INTEGRATING EXTERNAL DATA INTO DATA WAREHOUSES - Are You Familiar With the Most Common Process?},
booktitle={Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2004},
pages={508-513},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002601905080513},
isbn={972-8865-00-7},
}