A framework for data warehouse refresh policies

Authors:
Michael V. Mannino;Zhiping Walter
Affiliations:
The Business School, University of Colorado at Denver and Health Sciences, CO;The Business School, University of Colorado at Denver and Health Sciences, CO
Venue:
Decision Support Systems
Year:
2006

Citing 20
Cited 5

The case research strategy in studies of information systems

MIS Quarterly
Optimal update policies for distributed materialized views

Management Science
An overview of workflow management: from process modeling to workflow automation infrastructure

Distributed and Parallel Databases - Special issue on software support for work flow management
Applying update streams in a soft real-time database system

SIGMOD '95 Proceedings of the 1995 ACM SIGMOD international conference on Management of data
Consistency Algorithms for Multi-Source Warehouse View Maintenance

Distributed and Parallel Databases - Special issue on parallel and distributed information systems
Developing a multidimensional measure of system-use in an organizational context

Information and Management
Shrinking the warehouse update Window

SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
Analytical modeling of materialized view maintenance

Proceedings of the seventh ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
The benefits of data warehousing at Whirlpool

Success and pitfalls of information technology management
Making multiple views self-maintainable in a data warehouse

Data & Knowledge Engineering
The measurement of user information satisfaction

Communications of the ACM
Dimensions of information systems success

Communications of the AIS
Information quality benchmarks: product and service performance

Communications of the ACM - Supporting community and building social capital
Incremental maintenance of multi-source views

ADC '01 Proceedings of the 12th Australasian database conference
Fundamentals of Data Warehouses

Fundamentals of Data Warehouses
Building the Operational Data Store

Building the Operational Data Store
Modeling and Executing the Data Warehouse Refreshment Process

DANTE '99 Proceedings of the 1999 International Symposium on Database Applications in Non-Traditional Environments
Optimal Synchronization Policies for Data Warehouses

INFORMS Journal on Computing
The DeLone and McLean Model of Information Systems Success: A Ten-Year Update

Journal of Management Information Systems
An empirical investigation of the factors affecting data warehousing success

MIS Quarterly

Efficiency evaluation of data warehouse operations

Decision Support Systems
A Right-Time Refresh for XML Data Warehouses

DASFAA '09 Proceedings of the 14th International Conference on Database Systems for Advanced Applications
Key organizational factors in data warehouse architecture selection

Decision Support Systems
Evaluating a model for cost-effective data quality management in a real-world CRM setting

Decision Support Systems
First international workshop on usability and accessibility focused requirements engineering (UsARE 2012): summary report

ACM SIGSOFT Software Engineering Notes

Quantified Score

Hi-index	0.00

Visualization

Abstract

In a field study to explore influences on data warehouse refresh policies, we interviewed data warehouse administrators from 13 organizations about data warehouse details and organizational background. The dominant refresh strategy reported was daily refresh during nonbusiness hours with some deviations due to operational decision making and data source availability. As a result of the study, we developed a framework consisting of short-term and long-term influences of refresh policies along with traditional information system success variables influenced by refresh policies. The framework suggests the need for research about process design, data timeliness valuation, and optimal refresh policy design.