Title
Integrity maintenance system of database query under updating
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.
Year
DOI
Venue
2007
10.1007/978-3-540-74829-8_61
KES (3)
Keywords
Field
DocType
efficient operation,integrity maintenance system,mission-critical system,database query,querying result,error data,batch processing,past time,transaction processing,relational database,batch process,temporal database
Transaction processing,Data mining,Information retrieval,Relational database,Computer science,View,Database design,Temporal database,Online aggregation,Rollback,Snapshot (computer storage)
Conference
Volume
ISSN
Citations 
4694
0302-9743
0
PageRank 
References 
Authors
0.34
10
3
Name
Order
Citations
PageRank
Tsukasa Kudou111.41
Nobuhiro Kataoka244.56
Tadanori Mizuno325157.60