A Markov-Based Update Policy for Constantly Changing Database Systems

Thumbnail Image
Date
2017-01-01
Authors
Zong, Wei
Wu, Feng
Jiang, Zhengrui
Major Professor
Advisor
Committee Member
Journal Title
Journal ISSN
Volume Title
Publisher
Authors
Person
Jiang, Zhengrui
Thome Professor
Research Projects
Organizational Units
Organizational Unit
Supply Chain Management
Supply chain management is an integrated program of study concerned with the efficient flow of materials, products, and information within and among organizations. It involves the integration of business processes across organizations, from material sources and suppliers through manufacturing, and processing to the final customer. The program provides you with the core knowledge related to a wide variety of supply chain activities, including demand planning, purchasing, transportation management, warehouse management, inventory control, material handling, product and service support, information technology, and strategic supply chain management.
Journal Issue
Is Version Of
Versions
Series
Department
Supply Chain Management
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.

Description
Keywords
Citation
DOI
Copyright
Sun Jan 01 00:00:00 UTC 2017
Collections