Buffer fix procedure supporting both detection-based and avoidance-based cache coherency control scheme in a multisystem shared disk environment

摘要

The present invention, each of the multiple system is used, especially a table, the characteristics of the block, a database managed by the concurrency control to occur in a record unit of the system (DBMS) relates to a cache coherence methods for the DBMS running on the environment sharing disk to select the most optimal procedure to form and by the respective procedures to coexist is one to obtain higher performance.; According to the present invention for this purpose it is provided with a cache coherence procedure, characterized in that for selecting the avoidance based consistency maintenance procedure optimized for locking of the detected based cache consistency maintenance procedure, the table and the block unit is optimized for the lock of the record unit. So the table and maintain two kinds of consistency for the same blocks to support the characteristics of the DBMS that the record lock coexist effective policies can be handled by a single buffer loading process can be two procedures coexist mutually in order to access the same table, and it can provide a better structure and performance.