Database management system for controlling setting of cache partition area in storage system
OwnerNobuo KAWAMURAinventor
Life of this patent
Estimating the term…
Abstract
A database management system comprises a setting processor and an instruction sending unit. The setting processor determines the size related to each cache partition area associated with each database buffer on the basis of the size related to the each database buffer. The setting processor also produces a partition setting instruction, more specifically an instruction to perform setting related to each of the cache partition areas at the determined size. The instruction sending unit sends the produced partition setting instruction.
Claims19
A database management system operated by a host computer connected to a storage system that executes, in response to a partition setting instruction from an external device, allocation of each of a plurality of cache partition areas obtained by logically partitioning a cache memory, to each of a plurality of storage devices, said database management system comprising:
- a setting processor that determines a size related to each cache partition area associated with each database buffer on the basis of a size related to each database buffer, and produces a partition setting instruction to perform setting related to each of the cache partition areas at the determined size;
- and
- an instruction sending unit that sends the produced partition setting instruction.
A computer system comprising a storage system and a host computer,
- wherein the storage system has a plurality of storage devices, a cache memory, and a controller, and the controller is constituted such that when a plurality of cache partition areas obtained by logically partitioning the cache memory have been prepared, if an access command designating a certain storage device out of the plurality of storage devices is received from the host computer, the controller temporarily stores data to be accessed by this access command in the cache partition area to which the certain storage device has been allocated out of the plurality of cache partition areas,
- the host computer has a database management system,
- the database management system comprises:
- a setting processor that determines a size related to each cache partition area associated with each database buffer on the basis of a size related to each database buffer, and produces a partition setting instruction to perform setting related to each of the cache partition areas at the determined size;
- and
- an instruction sending unit that sends the produced partition setting instruction, and
- the controller of the storage system receives the partition setting instruction sent from the instruction sending unit, prepares a plurality of cache partition areas by logically partitioning the cache memory according this partition setting instruction, and allocates any of the plurality of storage devices to each of the plurality of cache partition areas.
A cache logical partitioning method,
- wherein a database management system determines a size related to each cache partition area associated with each database buffer on the basis of a size related to each database buffer,
- the database management system produces a partition setting instruction to perform setting related to each of the cache partition areas in the determined size,
- the database management system sends the produced partition setting instruction, and
- a storage system receives the partition setting instruction, prepares a plurality of cache partition areas by logically partitioning the cache memory according to the partition setting instruction, and allocates any of a plurality of storage devices each of the plurality of cache partition areas.
Dependencies are inferred from the claim text.