Method and apparatus for ensuring cache coherency for spawned dependent transactions in a multi-system environment with shared data storage devices

An article of manufacture comprising a computer program carrier readable by a computer and embodying one or more instructions executable by the computer for ensuring cache coherency in a database containing data stored in a data storage system connected to a plurality of computers including a computer having a group buffer pool, said article of manufacture comprising:

• program instructions for generating a first transaction for updating data in a local buffer pool of the first computer;
• and
• program instructions for immediately writing the data in the local buffer pool of the first computer to the group buffer pool, when an immediate write option is set.

A method of ensuring cache coherency in a shared database containing data stored on a data storage device, the data contained in the shared database being shared by a plurality of computers, the method comprising:

• writing updated data in a first local buffer pool, wherein the updated data is updated with a first transaction;
• and
• immediately writing the updated data in the first local buffer pool to a group buffer in the data storage device in response to updating the data in the first local buffer pool.

An apparatus for ensuring cache coherency in a database computing system having a plurality of computers coupled together wherein at least one of said plurality of computers executes application logic, the apparatus being part of a first computer among the plurality of computers and comprising:

• a local buffer pool;
• and
• a cache coherency unit coupled to the local buffer pool controlled according to an immediate write option and, if the immediate write option is set, configured to control a database to immediately write to a group buffer pool data within the local buffer pool modified by a first transaction issued by the application logic, prior to returning control to the application logic.