Integrity maintenance system of database query under updating

Authors:
Tsukasa Kudou;Nobuhiro Kataoka;Tadanori Mizuno
Affiliations:
Mitsubishi Electric Information Systems Corp., Kamakura-shi, Kanagawa Japan;School of Information Science and Technology, Tokai University, Hiratsuka-shi, Kanagawa Japan;Faculty of Information, Shizuoka University, Hamamatsu-shi, Shizuoka Japan
Venue:
KES'07/WIRN'07 Proceedings of the 11th international conference, KES 2007 and XVII Italian workshop on neural networks conference on Knowledge-based intelligent information and engineering systems: Part III
Year:
2007

Citing 10
Cited 0

Transaction Processing: Concepts and Techniques

Transaction Processing: Concepts and Techniques
Incremental Implementation Model for Relational Databases with Transaction Time

IEEE Transactions on Knowledge and Data Engineering
Incremental Computation of Time-Varying Query Expressions

IEEE Transactions on Knowledge and Data Engineering
Temporal Data Management

IEEE Transactions on Knowledge and Data Engineering
Relational Database Systems with Zero Information Loss

IEEE Transactions on Knowledge and Data Engineering
Symbolic User-Defined Periodicity in Temporal Relational Databases

IEEE Transactions on Knowledge and Data Engineering
Oracle8i Index-Organized Table and Its Application to New Domains

VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Implementation of checkout/checkin mechanism on object-oriented database systems

DEXA '96 Proceedings of the 7th International Workshop on Database and Expert Systems Applications
SNAP: Efficient Snapshots for Back-in-Time Execution

ICDE '05 Proceedings of the 21st International Conference on Data Engineering
Design, Implementation, and Evaluation of a Repairable Database Management System

ICDE '05 Proceedings of the 21st International Conference on Data Engineering

Quantified Score

Hi-index	0.00

Visualization

Abstract

In many mission-critical systems, databases are updated by transaction processing, and are queried by batch processing to make statistics and so on. It is necessary that both processing can be executed at the same time for the efficient operation. The method, which manages the history of the data and queries a snapshot of the past time to avoid the influence of the present updating, was proposed. However, there is a problem that even if the error data had been corrected just before querying, it is not reflected in the snapshot. In this paper, we propose a method, by which the correction of the data done after the time of the snapshot is reflected in it, and show the integrity of the querying result maintained even while data are being updated. Moreover, we applied this method to a mission-critical system, and confirmed that it was effective.