Implementation of Integrity Maintenance System of Database Query under Updating

††† ††† 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 the processing of both can be executed at the same time for the efficient operation. The integrity of the querying result can be maintained by using a bitemporal database even while data are being updated. However, in actual operations of mission-critical systems, various kinds of problems occur, such as the incorrect input of the data or being behind in the data entry. Then, it is necessary that the bitemporal database can support those problems. In this paper, we show the case to have applied the bitemporal database to a mission-critical system, as an implementation of the method to maintain the integrity of the querying result under data being updated. By this case, we confirmed that the integrity of the querying result was maintained under data being updated, and that various corrections done by the actual operations of the system were reflected to the result. Furthermore, we confirmed that it is effective for the data corrections not only of a short term but also for a long term, and that the correction of the data could be managed from the both sides of the correction by the internal process and the correction of the business.