BACKUP POLICIES FOR A DATABASE SYSTEM WITH TEMPORARY LARGE UPDATE

Authors

  • Syouji Nakamura Kinjo Gakuin University
  • Xufeng Zhao Qatar University
  • Cunhua Qian Nanjing Tech University

DOI:

https://doi.org/10.23055/ijietap.2017.24.4.2739

Abstract

In the batch processing, the updated data in a database system sometimes occur with a large amount in a short time. We propose to make independent backup schedules, which copies the batch-processed data for safety, for the full backup schemes. We apply the cumulative damage process to model database backup schedule, by replacing shock by time for data update and damage by the amount of updated data. When the total rewritten data has exceeded a level K, a full back up is performed. However, the overhead for such a full backup might become sometimes very large in a mass database system. To lessen the overhead for backup actions, we make an independent backup, which copies batch-processed data. The overhead for independent backups increases in proportion to the total amount of updated data. We obtain optimum full backup intervals with independent backups to minimize the expected cost rates analytically.

Published

2017-12-21

How to Cite

Nakamura, S., Zhao, X., & Qian, C. (2017). BACKUP POLICIES FOR A DATABASE SYSTEM WITH TEMPORARY LARGE UPDATE. International Journal of Industrial Engineering: Theory, Applications and Practice, 24(4). https://doi.org/10.23055/ijietap.2017.24.4.2739

Issue

Section

Special Issue: 2015 East Asia Workshop on Industrial Engineering