Design and Analysis of Update Mechanisms of a Database Computer (DBC).

This report shows how the process of update is carried out in the database computer DBC which is a specialized back-end database machine capable of managing data of 10 to the 10 power bytes in size. Since DBC might often have to be used in an update-intensive environment that is, an environment where many update, delete and insert commands and only a few retrieve commands are issued, we have indicated throughout this report, the kind of architectural enhancements which will provide good performance in an update-intensive environment. Perhaps the most important enhancement that affects the performance of all the four types of requests in DBC retrieve, delete, insert and update is the incorporation of a track-size buffer with each TIP. The advantages that accrue as a result of the incorporation are clearly demonstrated in the various sections of the report.