Optimal synchronization policies for data warehouses

Debabrata Dey, Zhongju Zhang, Prabuddha De

Research output: Contribution to journalArticle

15 Scopus citations

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.

Original languageEnglish (US)
Pages (from-to)229-242
Number of pages14
JournalINFORMS Journal on Computing
Volume18
Issue number2
DOIs
StatePublished - Jul 11 2006
Externally publishedYes

Keywords

  • Data warehouse
  • Stateness cost
  • Synchronization

ASJC Scopus subject areas

  • Software
  • Information Systems
  • Computer Science Applications
  • Management Science and Operations Research

Fingerprint Dive into the research topics of 'Optimal synchronization policies for data warehouses'. Together they form a unique fingerprint.

  • Cite this