Identifying Data Sources for Data Warehouses

  • Christian Koncilia
  • Heinz Pozewaunig
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2412)


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.


Data Warehouses Data Source Identification Multiple Sequence Analysis 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 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. 2.
    Kurz, A.: Data Warehousing-Enabling Technology, MITP-Verlag, Bonn (1999)Google Scholar
  3. 3.
    Kachur, R.: The Data Warehouse Diary: Source System Assessment for Data Warehouse, DM Review Online, (2000)
  4. 4.
    Paton, N., Diaz, O.: Active Database Systems, ACM Computing, Survey, vol. 31, No 1 (1999)Google Scholar
  5. 5.
    Pozewaunig, H.: Mining Component Behavior to Support Reuse, University Klagenfurt, Austria (2001)Google Scholar
  6. 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. 7.
    Sun, R., Giles, C.L.: Sequence Learning — Paradigms, Algorithms, and Applications, Lecture Notes in Computer Science 1828, Springer Verlag, (2001)Google Scholar
  8. 8.
    Nevill-Manning, C.G.: Inferring Sequential Structure, University of Waikato (1996)Google Scholar
  9. 9.
    Williams, J.: Tools for Traveling Data, DBMS Magazine,, Miller Freeman Inc. (1997)
  10. 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

Copyright information

© Springer-Verlag Berlin Heidelberg 2002

Authors and Affiliations

  • Christian Koncilia
    • 1
  • Heinz Pozewaunig
    • 2
  1. 1.Dep. of Informatics-SystemsUniversity of KlagenfurtAustria
  2. 2.SEZ AGVillachAustria

Personalised recommendations