Container-based virtualization for testing database system

A computer program product comprising:

• a computer readable storage medium readable by one or more processor and storing instructions for execution by the one or more processor for performing a method comprising:
• receiving a request for a lock on a page from a virtual database amongst two or more virtual databases, the virtual database comprising a number of containers respectively corresponding to the same number of database components of the virtual database;
• refreshing a copy of the page with a latest copy of the page in an overall cache that is commonly accessed by the two or more virtual databases, in order for the virtual database to fetch the latest copy of the page from the overall cache, based on ascertaining that the page is not locked by any other virtual database;
• and
• granting the lock on the page to the virtual database for an exclusive access to the page.

A system comprising:

• a memory;
• one or more processor in communication with the memory;
• and program instructions executable by the one or more processor via the memory to perform a method comprising:
• receiving a request for a lock on a page from a virtual database amongst two or more virtual databases;
• refreshing a copy of the page with a latest copy of the page in an overall cache that is commonly accessed by the two or more virtual databases, in order for the virtual database to fetch the latest copy of the page from the overall cache, based on ascertaining that the page is not locked by any other virtual database;
• updating a local cache of the virtual database with the latest copy of the page;
• and
• granting the lock on the page to the virtual database for an exclusive access to the page, wherein the updating is performed prior to the granting.