Patent ID: 7096319

Claim:
A computer system comprising: computers on which database management systems operate respectively; storage subsystems connected to said computers and provided for storing data of databases managed by said database management systems, each storage subsystem having a plurality of logical units; and a management device connected to said computers and said storage subsystems, wherein each of said computers includes a first cache memory, wherein each of said storage subsystems includes a second cache memory, and wherein said management device acquires information concerning partitioning of said first cache memory from each of said database management systems, acquires information concerning mapping of data from corresponding one of said computers and corresponding one of said storage subsystems respectively, decides a partitioning of said second cache memory in corresponding one of said storage subsystems by using said information concerning partitioning of said first cache memory and said information concerning mapping of said data and instructs corresponding one of said storage subsystems to set partitioning of said second cache memory in accordance with said decided partitioning, wherein partitioned regions of said first cache memory have one-to-one correspondence with partitioned regions of said second cache memory, and wherein each one-to-one corresponding partitioned region of said first cache memory and partitioned region of said second cache memory correspond to the same one or more logical units.