Identifying Data Sources for Data Warehouses
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.
KeywordsData Warehouses Data Source Identification Multiple Sequence Analysis
Unable to display preview. Download preview PDF.
- 1.Eder, J., Koncilia, C.: Changes of Dimension Data in Temporal Data Warehouses, Proc. of the DaWak 2001 Conference, Munich, Germany (2001)Google Scholar
- 2.Kurz, A.: Data Warehousing-Enabling Technology, MITP-Verlag, Bonn (1999)Google Scholar
- 3.Kachur, R.: The Data Warehouse Diary: Source System Assessment for Data Warehouse, DM Review Online, http://www.dmreview.com/ (2000)
- 4.Paton, N., Diaz, O.: Active Database Systems, ACM Computing, Survey, vol. 31, No 1 (1999)Google Scholar
- 5.Pozewaunig, H.: Mining Component Behavior to Support Reuse, University Klagenfurt, Austria (2001)Google Scholar
- 6.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)Google Scholar
- 7.Sun, R., Giles, C.L.: Sequence Learning — Paradigms, Algorithms, and Applications, Lecture Notes in Computer Science 1828, Springer Verlag, (2001)Google Scholar
- 8.Nevill-Manning, C.G.: Inferring Sequential Structure, University of Waikato (1996)Google Scholar
- 9.Williams, J.: Tools for Traveling Data, DBMS Magazine, http://www.dbmsmag.com/, Miller Freeman Inc. (1997)
- 10.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)Google Scholar