Data warehouse refreshment

Data Warehouses and OLAP: Concepts, Architectures and Solutions

Volumn , Issue , 2006, Pages 111-134

  Simitisis, Alkis ^a   Vassiliadis, Panos ^b   Skiadopoulos, Spiros ^c   Sellis, Timos ^a  

^a NATIONAL TECHNICAL UNIVERSITY OF ATHENS   (Greece)

^b UNIVERSITY OF IOANNINA   (Greece)

^c UNIVERSITY OF PELOPONNESE   (Greece)

Author keywords

[No Author keywords available]

Indexed keywords

EID: 70549093151     PISSN: None     EISSN: None     Source Type: Book    
DOI: 10.4018/987-1-59904-364-7.ch005     Document Type: Chapter

References (51)

1. Adzic, J., & Fiore, V. (2003, September). Data warehouse population platform. In Proceedings of 5th International Workshop on the Design and Management of Data Warehouses (DMDW'03), Berlin, Germany.
2. Ascential. (2003). Data warehousing technology. Retrieved May 27, 2006, from http://www.ascentialsoftware.com/products/datastage.html
3. Booch, G., Rumbaugh, J., & Jacobson, I. (1998). The unified modeling language user guide. Addison-Wesley.
4. Borkar, V., Deshmuk, K., & Sarawagi, S. (2000). Automatically extracting structure from free text addresses. Bulletin of the Technical Committee on Data Engineering, 23(4).
5. Bouzeghoub, M., Fabret, F., & Matulovic, M. (1999). Modeling data warehouse refreshment process as a workflow application. In Proceedings of 1st International Workshop on the Design and Management of Data Warehouses (DMDW'99), Heidelberg, Germany.
6. Calì, A., Calvanese, D., De Giacomo, G., Lenzerini, M., Naggar, P., & Vernacotola, F. (2003). IBIS: Semantic data integration at work. In Proceedings of the 15th International Conference on Advanced Information Systems Engineering (CAiSE 2003), Klangefurt, Austria (pp. 79-94).
7. Cohen, W. (1999). Some practical observations on integration of Web information. In Proceedings of SIGMOD Workshop on the Web and Databases (WebDB'99), Philadelphia, Pennsylvania.
8. Dagstuhl Perspective Workshop. (2004). Data warehousing at the crossroads. Dagstuhl, Germany.
9. Demarest, M. (1999). The politics of data warehousing. Retrieved May 27, 2006, from http://www.hevanet.com/demarest/marc/dwpol.html
10. Eder, J., & Gruber, W. (2002). A meta model for structured workflows supporting workflow transformations. In Proceedings of the 6th East European Conference on Advances in Databases and Information Systems (ADBIS'02), Bratislava, Slovakia (pp. 326-339).
11. Friedman, T. (2002). Reducing the cost of ETL for the data warehouse (Tech. Rep. No. COM-16-8237). Gartner Group.
12. Friedman, T. (2002a). Security issues in ETL for the data warehouse (Tech. Rep. No. COM-17-8459). Gartner Group.
13. Galhardas, H., Florescu, D., Shasha, D., & Simon, E. (1999). An extensible framework for data cleaning (Tech. Rep. No. INRIA RR-3742).
14. Galhardas, H., Florescu, D., Shasha, D., & Simon, E. (2000). Ajax: An extensible data cleaning tool. In Proceedings of ACM International Conference on the Management of Data (SIGMOD'00), Dallas, Texas (p. 590).
15. Gartner. (2003). ETL Magic Quadrant update: Market pressure increases (Gartner's Strategic Data Management Research Note M-19-1108). Author.
16. Giga. (2002). Market overview update: ETL (Tech. Rep. No. RPA-032002-00021). Author.
17. IBM. (2003). IBM Data Warehouse Manager. Retrieved May 27, 2006, from http://www-3.ibm.com/software/data/db2/datawarehouse
18. Informatica. (2003). PowerCenter. Retrieved May 27, 2006, from http://www.informatica.com/products/data+integration/powercenter/default.htm
19. nd ed.). Germany: Springer-Verlag.
20. Jarke, M., List, T., & Koller, J. (2000). The challenge of process warehousing. In Proceedings of the 26th International Conference on Very Large Databases (VLDB'00), Cairo, Egypt.
21. Jarke, M., Quix, C., Blees, G., Lehmann, D., Michalk, G., & Stierl, S. (1999). Improving OLTP data quality using data warehouse mechanisms. In Proceedings of ACM International Conference on Management of Data (SIGMOD'99), Philadelphia (pp. 537-538).
22. Labio, W., & Garcia-Molina, H. (1996). Efficient snapshot differential algorithms for data warehousing. In Proceedings of the 22nd International Conference on Very Large Data Bases (VLDB'96), Bombay, India (pp. 63-74).
23. Kiepuszewski, B., Ter Hofstede, A. H. M., & Bussler, C. (2000). On structured workflow modeling. In Proceedings of the 12th International Conference on Advanced Information Systems Engineering (CAiSE'00), Stockholm, Sweden (pp. 431-445).
24. Lenzerini. (2002). Data integration: A theoretical perspective. In Proceedings of the 21st Symposium on Principles of Database Systems (PODS'02), Wisconsin (pp. 233-246).
25. Microsoft. (2003). Data transformation services. Retrieved May 27, 2006, from http://www.microsoft.com
26. Monge, A. (2000). Matching algorithms within a duplicate detection system. Bulletin of the Technical Committee on Data Engineering, 23(4).
27. Oracle. (2001). Oracle9i™ Warehouse Builder user's guide (Release 9.0.2). Retrieved May 27, 2006, from http://otn.oracle.com/products/warehouse/content.html
28. Oracle. (2002). Oracle9i™ SQL reference (Release 9.2, pp. 17.77-17.80). Author.
29. Rahm, E., & Hai Do, H. (2000). Data cleaning: Problems and current approaches. Bulletin of the Technical Committee on Data Engineering, 23(4).
30. Raman, V., & Hellerstein, J. (2001). Potter's Wheel: An interactive data cleaning system. In Proceedings of 27th International Conference on Very Large Data Bases (VLDB'01), Roma, Italy (pp. 381-390).
31. Rundensteiner, E. (Ed.). (1999). Special issue on data transformations. Bulletin of the Technical Committee on Data Engineering, 22(1).
32. Sadiq, W., & Orlowska, M. E. (2000). On business process model transformations. In Proceedings of the 19th International Conference on Conceptual Modeling (ER'00) (pp. 267-280), Salt Lake City, Utah.
33. Sarawagi, S. (2000, December). Special issue on data cleaning. Bulletin of the Technical Committee on Data Engineering, 23(4).
34. Scalzo, B. (2003). Oracle DBA guide to data warehousing and star schemas. Prentice Hall.
35. Schafer, E., Becker, J.-D., & Jarke, M. (2000). DB-Prism: Integrated data warehouses and knowledge networks for bank controlling. In Proceedings of the 26th International Conference on Very Large Databases (VLDB'00), Cairo, Egypt.
36. Shilakes, C., & Tylman, J. (1998). Enterprise information portals. Retrieved May 27, 2006, fromhttp://www.sagemaker.com/company/downloads/eip/indepth.pdf
37. Simitsis, A. (2004). Modeling and optimization of extraction-transformation-loading (ETL) processes in data warehouse environments. Doctoral Thesis, NTU Athens, Greece.
38. Simitsis, A. (2005). Mapping conceptual to logical models for ETL processes. In Proceedings of the 8th ACM International Workshop on Data Warehousing and OLAP (DOLAP '05), Bremen, Germany.
39. Simitsis, A., Vassiliadis, P., & Sellis, T. (2005). Optimizing ETL processes in data warehouse environments. In Proceedings of the 21st IEEE International Conference on Data Engineering (ICDE '05), Tokyo, Japan.
40. Simitsis, A., Vassiliadis, P., & Sellis, T. (2005a). State-space optimization of ETL workflows. IEEE Transactions on Knowledge and Data Engineering, 17(10), 1404-1419.
41. Strange, K. (2002). ETL was the key to this data warehouse's success (Tech. Rep. No. CS-15-3143). Gartner Group.
42. Strange, K. (2002a). Data warehouse TCO: Don't underestimate the cost of ETL (Tech. Rep. No. DF-15-2007). Gartner Group.
43. Theodoratos, D., Ligoudistianos, S., & Sellis, T. (2001). View selection for designing the global data warehouse. Data & Knowledge Engineering, 39(3), 219-240.
44. Trujillo, J., & Luján-Mora, S. (2003). A UML based approach for modeling ETL processes in data warehouses. In Proceedings of 22nd International Conference on Conceptual Modeling (ER 2003), Chicago (pp. 307-320). LNCS, 2813.
45. Van der Aalst, W. M. P., ter Hofstede, A. H. M., Kiepuszewski, B., & Barros, A. P. (2000). Workflow patterns (BETA Working Paper Series WP 47). Eindhoven University of Technology, Eindhoven.
46. Vassiliadis, P. (2000). Gulliver in the land of data warehousing: Practical experiences and observations of a researcher. In Proceedings of 2nd International Workshop on Design and Management of Data Warehouses (DMDW'00), Stockholm, Sweden.
47. Vassiliadis, P., Quix, C., Vassiliou, Y., & Jarke, M. (2001). Data warehouse process management. Information Systems, 26(3), 205-236.
48. Vassiliadis, P., Simitsis, A., Georgantas, P., Terrovitis, M., & Skiadopoulos, S. (2005). A generic and customizable framework for the design of ETL scenarios. Information Systems, 30(7), 492-525.
49. Vassiliadis, P., Simitsis, A., & Skiadopoulos, S. (2002). Conceptual modeling for ETL processes. In Proceedings of the 5th ACM International Workshop on Data Warehousing and OLAP (DOLAP '02), McLean, Virginia.
50. Vassiliadis, P., Simitsis, A., & Skiadopoulos, S. (2002a). Modeling ETL activities as graphs. In Proceedings of the 4th International Workshop on the Design and Management of Data Warehouses (DMDW '02), Toronto, Canada (pp. 52-61).
51. Workflow Management Coalition. (1998). Interface 1: Process definition interchange process model (Doc. No. WfMC TC-1016-P).