A framework for data warehouse refresh policies

Decision Support Systems

Volumn 42, Issue 1, 2006, Pages 121-143

  Mannino, Michael V ^a   Walter, Zhiping ^a  

^a UNIVERSITY OF COLORADO   (United States)

Author keywords

Data source; Data warehouse; Refresh policy; Refresh process

Indexed keywords

DATA REDUCTION; DATA STRUCTURES; DECISION MAKING; INFORMATION MANAGEMENT; SOCIETIES AND INSTITUTIONS; STRATEGIC PLANNING; SUPERVISORY PERSONNEL;

DATA SOURCE; INFORMATION SYSTEM; REFRESH POLICY; REFRESH PROCESS;

DATA WAREHOUSES;

EID: 33747792003     PISSN: 01679236     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.dss.2004.11.002     Document Type: Article

References (42)

1. B. Adelberg, H. Garcia-Molina, B. Kao, Applying Update Streams in a Soft Real-Time Database System, ACM SIGMOD Record 24, No. 2, Proceedings of the 1995 ACM SIGMOD International Conference on Management of Data, (May 1995), 245-256.
2. L. Agosta, Data Warehousing Lessons Learned: Data Warehousing Refresh Rates, DM Review, June 2003, online at http://www.dmreview.com/article_sub.cfm?articleId=6834, last accessed on Oct. 25th, 2004.
3. Bailey J., and Pearson S. Development of a tool for measuring and analyzing computer user satisfaction. Management Science 29 5 (1983 (May)) 530-545
4. Baragoin C., Marini M., Morgan C., Mueller O., Perkins A., Kiho Y., and Persaud M. Building the Operational Data Store on DB2 UDB Using IBM Data Replication, WebSphere MQ Family, and DB2 Warehouse Manager, IBM Redbook (2001), IBM, San Jose, CA. http://www.redbooks.ibm.com/redbooks/pdfs/sg246513.pdf http://www.redbooks.ibm.com/redbooks/pdfs/sg246513.pdf, last accessed on Oct. 24th, 2004
5. Benbasat I., Goldstein D., and Mead M. The case research strategy in studies of information systems. MIS Quarterly 11 3 (1987 (Sep.)) 368-386
6. Berndt D., and Fisher J. Understanding dimension volatility in data warehouses. Proceedings Sixth INFORMS Conference on Information Systems and Technology (CIST- 2001), (Miami, Florida, Nov. 2001). (2001)
7. M. Bouzeghoub, F. Fabret, M. Matulovic-Broque, Modeling data warehouse refreshment process as a workflow application, in: S. Gatziu, M. Jeusfeld, M. Staudt, Y. Vassiliou, (eds.). CEUR-WS, Proceedings on the International Workshop on Design and Management of Data Warehouses (DMDW'99 at CAiSE*99), (Heidelberg, Germany, June 1999) 6.1-6.12, online at http://sunsite.informatik.rwth-aachen.de/Publications/CEUR-WS/Vol-19/paper6.pdf, last accessed on Oct. 24th, 2004.
8. Connor M. A practical view of real-time warehousing. Business Intelligence Journal 8 2 (2003 (Spring)) 10-18
9. Cybenko G., and Brewington B. The foundations of information push and pull. In: O'Leary D. (Ed). Mathematics of Information, Institute for Mathematics and Applications Proceedings (1998), Springer-Verlag. http://actcomm.dartmouth.edu/papers/cybenko:push.pdf http://actcomm.dartmouth.edu/papers/cybenko:push.pdf, last accessed on Oct. 24th, 2004.
10. Delone W., and McLean E. Information systems success: the quest for the dependent variable. Information Systems Research 3 1 (1992 (Mar.)) 65-90
11. Delone W., and McLean E. The Delone and McLean model of information systems success: a ten-year update. Journal of Management Information Systems 19 4 (2003 (Spring)) 9-30
12. Dey D., and Zhang Z. An optimal policy for data warehouse synchronization. Proceedings of the Eleventh Workshop on Technologies and Systems (WITS 2001), (New Orleans, Dec. 2001) (2001)
13. D. Dey, Z. Zhang, P. De, Optimal Synchronization Policies for Data Warehouses, INFORMS Journal on Computing (in press).
14. Doll W., and Torkzadeh G. Developing a multidimensional measure of systems use in an organizational context. Information and Management 33 4 (1998 (Mar.)) 171-185
15. Eisenhardt K. Building theories from case study research. Academy of Management Review 14 4 (1989 (Oct.)) 532-550
16. Fisher J., and Berndt D. Creating false memories: temporal reconstruction errors in data warehouses. Proceedings of the Eleventh Workshop on Technologies and Systems (WITS 2001), (New Orleans, Dec. 2001) (2001)
17. Georgakopoulos D., Hornrick M., and Sheth A. An overview of workflow management: from process modeling to workflow automation infrastructure. Distributed and Parallel Databases 3 2 (1995 (Apr.)) 119-153
18. Gupta A., and Mumick I. Maintenance of materialized views: problems, techniques, and applications. IEEE Data Engineering Bulletin 18 2 (1995 (Jun.)) 3-18
19. Haley B., Watson H., and Goodhue D. The benefits of data warehousing at whirlpool. In: Khosrow-Pour M. (Ed). Annals of Cases on Information Technology Applications and Management in Organizations vol. 1 (1999), Idea Group Publishing, Hershey, PA 14-25
20. Hamilton S., and Scott N. Evaluating information system effectiveness-Part I. Comparing evaluation approaches. MIS Quarterly 5 3 (1981 (Sep.)) 55-70
21. Holland P. Virtues of a Virtual Data Warehouse, Datamation (2000 (March 22)). http://itmanagement.earthweb.com/datbus/article.php/621401 http://itmanagement.earthweb.com/datbus/article.php/621401, last accessed on Oct. 24th, 2004.
22. Inmon W. Building the Operational Data Store. 2nd ed. (1999), Wiley, New York
23. Ives B., Olson M.H., and Baroudi J.J. The measurement of user information satisfaction. Communications of the ACM 26 10 (1983 (Oct.)) 785-793
24. Jarke M., Lenzerini M., Vassiliou Y., and Vassiliadis P. Fundamentals of Data Warehouse (2000), Springer, Berlin
25. Kahn B., Strong D., and Wang R. Information quality benchmarks: product and service performance. Communications of the ACM 45 4 (2002 (Apr.)) 184-192
26. Kennedy D. The Reality of Real-Time OLAP, MSDN, Microsoft (2003 (February)). http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_real-timeolap.asp http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_real-timeolap.asp, last accessed on Oct. 24th, 2004.
27. Kriebel C., and Raviv A. An economics approach to modeling the productivity of computer systems. Management Science 26 3 (1980 (Mar.)) 297-311
28. W.J. Labio, R. Yerneni, H. Garcia-Molina, Shrinking the Warehouse Update Window, ACM SIGMOD Record, 28, No. 2, Proceedings of the 1999 ACM SIGMOD International Conference on Management of Data, (Phildelphia, PA, Jun. 1999), 383-394.
29. Liang L., Wang N., and Orlowska W. Making multiple views self-maintainable in a data warehouse. Data and Knowledge Engineering 30 2 (1999 (Jun.)) 121-134
30. Moro G., and Sartori C. Incremental maintenance of multi-source views. Proceedings 12th Australian Database Conference (ADC 2001) (2001), IEEE 13-20
31. Rummel J., Walter Z., Dewan R., and Seidmann A. Activity consolidation to improve responsiveness. European Journal of Operational Research 161 3 (2005 (Mar.)) 683-703
32. Seddon P. A respecification and extension of the Delone and Mclean model of is success. Information Systems Research 8 3 (1997 (Sep.)) 240-253
33. Seddon P., Staples D., Patnayakoni R., and Bowtell M. The dimensions of information systems success. Communications of the Association for Information Systems 2, Article 20 (1999 (Nov.)) 1-40
34. Segev A., and Fang F. Optimal update policies for distributed materialized views. Management Science 37 7 (1991 (Jul.)) 851-870
35. Shin B. An exploratory investigation of system success factors in data warehousing. Journal of the Association for Information Systems 4, Article 6 (2003 (Aug.)) 141-170
36. Srivastava J., and Roten D. Analytical modeling of materialized view maintenance. Proceedings of the Seventh ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (Austin, TX) (1988 (Mar.)) 126-134
37. Swanson B. Management information systems: appreciation and involvement. Management Science 21 2 (1974 (Oct.)) 178-188
38. Theodoratos D., and Bouzeghoub M. Data currency quality satisfaction in the design of a data warehouse. International Journal of Cooperative Information Systems 10 3 (2001 (Sep.)) 299-326
39. Vavouras A., Gatziu S., and Dittrich K. Modeling and executing the data warehouse refreshment process. Proceedings of 1999 International Symposium on Database Applications in Non-Traditional Environments (DANTE '1999) (Kyoto, Japan) (1999 (Nov.)) 66-73
40. Wixom B., and Watson H. An empirical investigation of the factors affecting data warehousing success. MIS Quarterly 28 1 (2001 (Mar.)) 17-41
41. Zhang X., and Rundensteiner E. Integrating the maintenance and synchronization of data warehouses using a cooperative framework. Information Systems 27 4 (2002 (Jun.)) 219-243
42. Zhuge Y., Garcia-Molina H., and Wiener J. Consistency algorithms for multi-source warehouse view maintenance. Journal of Distributed and Parallel Databases 6 1 (1998 (Jan.)) 7-40