Abstract
In order to establish a useful data warehouse, it must be correct and consistent. Hence, when selecting the data sources for building the data warehouse, it is essential know exactly about the concept and structure of all possible data sources and the dependencies between them. In a perfect world, this knowledge stems from an integrated, enterprize-wide data model. However, the reality is different and often an explicit model is not available.
This paper proposes an approach for identifying data sources for a data warehouse, even without having detailed knowledge about interdependencies of data sources. Furthermore, we are able to confine the number of potential data sources. Hence, our approach reduces the time needed to build and maintain a data warehouse and it increases the data quality of the data warehouse.
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.
References
Eder, J., Koncilia, C.: Changes of Dimension Data in Temporal Data Warehouses, Proc. of the DaWak 2001 Conference, Munich, Germany (2001)
Kurz, A.: Data Warehousing-Enabling Technology, MITP-Verlag, Bonn (1999)
Kachur, R.: The Data Warehouse Diary: Source System Assessment for Data Warehouse, DM Review Online, http://www.dmreview.com/ (2000)
Paton, N., Diaz, O.: Active Database Systems, ACM Computing, Survey, vol. 31, No 1 (1999)
Pozewaunig, H.: Mining Component Behavior to Support Reuse, University Klagenfurt, Austria (2001)
Pinto, H., Han, J., Pei, J., Wang, K., Chen, Q. Dayal, U.: Multi-Dimensional Sequential Pattern Mining, Proc. of the 2001 Int. Conf. on Information and Knowledge Management (CIKM’01), Atlanta, GA, (2001)
Sun, R., Giles, C.L.: Sequence Learning — Paradigms, Algorithms, and Applications, Lecture Notes in Computer Science 1828, Springer Verlag, (2001)
Nevill-Manning, C.G.: Inferring Sequential Structure, University of Waikato (1996)
Williams, J.: Tools for Traveling Data, DBMS Magazine, http://www.dbmsmag.com/, Miller Freeman Inc. (1997)
Vassiliadis, P. Bouzeghoub, M., Quix, C.: Towards Quality-Oriented Data Warehouse Usage and Evolution, Proc. of the 1 1th Conference on Advanced Information Systems Engineering (CAiSE’ 99), Heidelberg (1999)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Koncilia, C., Pozewaunig, H. (2002). Identifying Data Sources for Data Warehouses. In: Yin, H., Allinson, N., Freeman, R., Keane, J., Hubbard, S. (eds) Intelligent Data Engineering and Automated Learning — IDEAL 2002. IDEAL 2002. Lecture Notes in Computer Science, vol 2412. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45675-9_35
Download citation
DOI: https://doi.org/10.1007/3-540-45675-9_35
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-44025-3
Online ISBN: 978-3-540-45675-9
eBook Packages: Springer Book Archive