Real-time data warehouse loading methodology

ACM International Conference Proceeding Series

Volumn 299, Issue , 2008, Pages 49-58

  Santos, Ricardo Jorge ^a   Bernardino, Jorge ^b  

^a UNIVERSITY OF COIMBRA   (Portugal)

^b POLYTECHNIC INSTITUTE OF COIMBRA   (Portugal)

Author keywords

continuous data integration for data warehousing; data warehouse refreshment loading process; real time and active data warehousing

Indexed keywords

ACTIVE DATA WAREHOUSING; CONTINUOUS DATA; DATA WAREHOUSE SYSTEMS; DATA WAREHOUSING; DATA-MINING TOOLS; DECISION SUPPORTS; LOADING DATA; LOADING PROCESS; OLAP QUERIES; QUERY EXECUTION TIME; QUERY PERFORMANCE; QUERY PREDICATES; REAL-TIME DATA; SCHEMAS; STATIC STRUCTURES; TABLE STRUCTURE; TIME-RATE; TRANSACTIONAL DATA;

DATA HANDLING; DECISION MAKING; DECISION SUPPORT SYSTEMS; LOADING;

DATA WAREHOUSES;

EID: 77954432381     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1451940.1451949     Document Type: Conference Paper

References (28)

1. D. J. Abadi, D. Carney, et al., 2003. "Aurora: A New Model and Architecture for Data Stream Management", The VLDB Journal, 12(2), pp. 120-139.
2. S. Babu, and J. Widom, 2001. "Continuous Queries Over Data Streams", SIGMOD Record 30(3), pp. 109-120.
3. T. Binder, 2003. Gong User Manual, Tecco Software Entwicklung AG.
4. M. Bouzeghoub, F. Fabret, and M. Matulovic, 1999. "Modeling Data Warehouse Refreshment Process as a Workflow Application", Intern. Workshop on Design and Management of Data Warehouses (DMDW).
5. R. M. Bruckner, B. List, and J. Schiefer, 2002. "Striving Towards Near Real-Time Data Integration for Data Warehouses", International Conference on Data Warehousing and Knowledge Discovery (DAWAK).
6. R. M. Bruckner, and A. M. Tjoa, 2002. "Capturing Delays and Valid Times in Data Warehouses - Towards Timely Consistent Analyses". Journal of Intelligent Information Systems (JIIS), 19:2, pp. 169-190.
7. S. Chaudhuri, and U. Dayal, 1997. "An Overview of Data Warehousing and OLAP Technology", SIGMOD Record, Volume 26, Number 1, pp. 65-74.
8. W. H. Inmon, R. H. Terdeman, J. Norris-Montanari, and D. Meers, 2001. Data Warehousing for E-Business, J. Wiley & Sons.
9. I. C. Italiano, and J. E. Ferreira, 2006. "Synchronization Options for Data Warehouse Designs", IEEE Computer Magazine.
10. A. Karakasidis, P. Vassiliadis, and E. Pitoura, 2005. "ETL Queues for Active Data Warehousing", IQIS'05.
11. R. Kimball, L. Reeves, M. Ross, and W. Thornthwaite, 1998. The Data Warehouse Lifecycle Toolkit - Expert Methods for Designing, Developing and Deploying Data Warehouses, Wiley Computer Publishing.
12. R. Kimball, and J. Caserta, 2004. The Data Warehouse ETL Toolkit, Wiley Computer Publishing.
13. E. Kuhn, 2003. "The Zero-Delay Data Warehouse: Mobilizing Heterogeneous Databases", International Conference on Very Large Data Bases (VLDB).
14. W. Labio, J. Yang, Y. Cui, H. Garcia-Molina, and J. Widom, 2000. "Performance Issues in Incremental Warehouse Maintenance", International Conference on Very Large Data Bases (VLDB).
15. D. Lomet, and J. Gehrke, 2003. Special Issue on Data Stream Processing, IEEE Data Eng. Bulletin, 26(1).
16. Oracle Corporation, 2005. www.oracle.com
17. T. B. Pedersen, 2004. "How is BI Used in Industry?", Int. Conf. on Data Warehousing and Knowledge Discovery (DAWAK).
18. th ADC.
19. A. Simitsis, P. Vassiliadis and T. Sellis, 2005. "Optimizing ETL Processes in Data Warehouses", Inte. Conference on Data Engineering (ICDE).
20. U. Srivastava, and J. Widom, 2004. "Flexible Time Management in Data Stream Systems", PODS.
21. D. Theodoratus, and M. Bouzeghoub, 1999. "Data Currency Quality Factors in Data Warehouse Design", International Workshop on the Design and Management of Data Warehouses (DMDW).
22. TPC-H decision support benchmark, Transaction Processing Council, www.tpc.com.
23. P. Vassiliadis, Z. Vagena, S. Skiadopoulos, N. Karayannidis, and T. Sellis, 2001. "ARKTOS: Towards the Modelling, Design, Control and Execution of ETL Processes", Information Systems, Vol. 26(8).
24. C. White, 2002. "Intelligent Business Strategies: Real-Time Data Warehousing Heats Up", DM Preview, www.dmreview.com/article-sub-cfm? articleId=5570.
25. J. Yang, 2001. "Temporal Data Warehousing", Ph.D. Thesis, Dpt. Computer Science, Stanford University.
26. th Intern. Conference on Data Engineering (ICDE).
27. th Int. Conf. Extending Database Technology (EDBT).
28. th International Conference on Data Engineering (ICDE).