Campus Units

Supply Chain and Information Systems

Document Type

Article

Publication Version

Accepted Manuscript

Publication Date

2017

Journal or Book Title

IEEE Transactions on Engineering Management

Volume

64

Issue

3

First Page

287

Last Page

300

DOI

10.1109/TEM.2017.2648516

Abstract

In order to maximize the value of an organization's data assets, it is important to keep data in its databases up-to-date. In the era of big data, however, constantly changing data sources make it a challenging task to assure data timeliness in enterprise systems. For instance, due to the high frequency of purchase transactions, purchase data stored in an enterprise resource planning system can easily become outdated, affecting the accuracy of inventory data and the quality of inventory replenishment decisions. Despite the importance of data timeliness, updating a database as soon as new data arrives is typically not optimal because of high update cost. Therefore, a critical problem in this context is to determine the optimal update policy for database systems. In this study, we develop a Markov decision process model, solved via dynamic programming, to derive the optimal update policy that minimizes the sum of data staleness cost and update cost. Based on real-world enterprise data, we conduct experiments to evaluate the performance of the proposed update policy in relation to benchmark policies analyzed in the prior literature. The experimental results show that the proposed update policy outperforms fixed interval update policies and can lead to significant cost savings.

Comments

This is an accepted manuscript published as 2. Zong , W., F. Wu, Z. Jiang. “A Markov-based Update Policy for Constantly Changing Database Systems.” IEEE Transactions on Engineering Management, August 2017; 64(3);287-300. 10.1109/TEM.2017.2648516 . Posted with permission.

Rights

Personal use of this material is permitted. Permission from IEEE must be obtained for all other users, including reprinting/ republishing this material for advertising or promotional purposes, creating new collective works for resale or redistribution to servers or lists, or reuse of any copyrighted components of this work in other works

Copyright Owner

IEEE

Language

en

File Format

application/pdf