Safe Update based on partial knowledge and available evidence
Original Publication Date: 2003-Nov-28
Included in the Prior Art Database: 2003-Nov-28
Generally databases must read data to be updated for validation and other reasons before performing the update. Unlike writing, which can be performed lazily, this reading must be completed before operation continues. This can severely limit throughput, particularly in serial use of the database. There may often be sufficient data already available in memory buffers to validate the update. This may for example be held in buffered indices or automated summary tables (materialized views). The database may use such data to avoid the need to read of the full data record before validating the update, and thus the read may be lazy and throughput improved.