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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Bækgaard, L., Mark, L.: Incremental Computation of Time-Varying Query Expressions. IEEE Trans. knowledge and Data Eng. 7(4), 583–590 (1995)
Bhargava, G., Gadia, S.K.: Relational Database Systems with Zero Information Loss. IEEE Trans. knowledge and Data Eng. 5(1), 76–87 (1993)
Chiueh, T., Pilania, D.: Design, Implementation, and Evaluation of a Repairable Database Management System. In: Proc. 21st International Conference on Data Engineering, pp. 1024–1035 (2005)
Jensen, C.S., Mark, L., Roussopoulos, N.: Incremental Implementation Model for Relational Database with Transaction Time. IEEE Trans. knowledge and Data Eng. 3(4), 461–473 (1991)
Jensen, C.S., Snodgass, R.T.: Temporal Data Management. IEEE Trans. knowledge and Data Eng. 11(1), 36–44 (1999)
Park, H.-J., Yoo, S.I.: Implementation of Checkout/Checkin Mechanism on object-Oriented Database System. In: Proc. 7th International workshop on Database and Expert System Applications, pp. 298–303 (1996)
Shrira, L., Xu, H.: SNAP: Efficient Snapshots for Back-in-Time Execution. In: Proc. 21st International Conference on Data Engineering, pp. 434–445 (2005)
Stantic, B., Thornton, J., Sattar, A.: A Novel Approach to Model NOW in Temporal Databases. In: Proc. 10th International Symposium on Temporal Representation and Reasoning and Fourth International Conference on Temporal Logic, pp. 174–180 (2003)
Srinivasan, J., Das, S., Freiwald, C., et al.: Oracle8i Index-Organized Table and its Application to New Domains. In: Proc. 26th International Conference on Very Large Data Bases, pp. 285–296 (2000)
Terenziani, P.: Symbolic User-Defined Periodicity in Temporal Relational Databases. IEEE Trans. Knowledge and Data Eng. 15(2), 489–509 (2003)
Gray, J., Reuter, A.: Transaction Processing: Concept and Techniques. Morgan Kaufmann, San Francisco (1992)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2007 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Kudou, T., Kataoka, N., Mizuno, T. (2007). Integrity Maintenance System of Database Query Under Updating. In: Apolloni, B., Howlett, R.J., Jain, L. (eds) Knowledge-Based Intelligent Information and Engineering Systems. KES 2007. Lecture Notes in Computer Science(), vol 4694. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-74829-8_61
Download citation
DOI: https://doi.org/10.1007/978-3-540-74829-8_61
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-74828-1
Online ISBN: 978-3-540-74829-8
eBook Packages: Computer ScienceComputer Science (R0)