Bufferpool coherency for identifying and retrieving versions of workfile data using a producing DBMS and a consuming DBMS

摘要

There are one or more DBMSs and one or more production DBMSs that consume to produce workfiles DBMSs generations for consuming DBMSs for a kind of system and method, computer based system. It includes workfile that a kind of production DBMS, which uniquely identifies the bufferpool pages, uniquely identifies workfile, only empties the corresponding page workfile storage devices of bufferpool. Production DBMS further notify consumption this workfile of DBMS is available to receive to reply that this indicates the data that retrieve of customer from storage device from consumption DBMS. Consumer device reception notice retrieves workfile from production DBMS, and is returned to production DBMS with following retrieval workfile.