Paper Info
Title
Optimal Synchronization Policies for Data Warehouses
Abstract
The notion of a data warehouse for integrating operational data into a single repository is rapidly becoming popular in modern organizations. An important issue in this context is how often one should synchronize the data warehouse to reflect the changes in the constituent operational data sources. If the synchronization is performed very frequently, the associated cost might be quite high, although the data warehouse would only have a small amount of stale data. On the other hand, if the data warehouse is synchronized infrequently, it might result in costly errors in business decisions arising from the stale data. This paper examines the trade-off between the synchronization and staleness costs and derives the optimal synchronization frequency.
Year
DOI
Venue
2006
10.1287/ijoc.1040.0094
INFORMS Journal on Computing
Keywords
Field
DocType
important issue,stale data,optimal synchronization policies,data warehouses,associated cost,data warehouse,modern organization,costly error,constituent operational data source,business decision,optimal synchronization frequency,operational data,synchronization
Data warehouse,Data science,Mathematical optimization,Synchronization,Computer science,Database
Journal
Volume
Issue
ISSN
18
2
1091-9856
Citations 
PageRank 
References 
13
0.61
34
Authors
3
Name
Order
Citations
PageRank
Debabrata Dey1456206.82
Zhongju Zhang237421.01
Prabuddha De350784.53