Patent ID: 7171423

Claim:
A computer comprising, an input means arranged to receive an input of database design information, and a system definition means which generates, from said database design information, database definition information determining a volume to be used as a storage location for data of a plurality of tables constituting said database, and volume definition information determining a configuration required for said volume, and outputs said volume definition information as information to be given to a storage subsystem having a plurality of memory devices to be allocated to said volume based on said volume definition information, and said database definition information as information to be given to a database server which is a server to store, based on said database definition information, data of each of said plurality of tables in said volume of said storage subsystem, and to access said volume of said storage subsystem in response to a request from outside; wherein said system definition means generates said database definition information by obtaining grouping columns for each table defined in said database design information, generating a partitioning key of a logical OR of the grouping columns for each of said tables, grouping said tables into volumes so that all of said tables that are accessed simultaneously according to said database design information belong to different respective volumes, calculating the number of partitions for each of said tables from said database design information, dividing each of said volumes according to the calculated number of partitions to obtain a number of table spaces to be allocated to each of said tables, allocating table spaces equivalent to the number of table spaces thus obtained to each of said tables, calculating a volume performance required for each volume from said database design information, and obtaining configuration information for implementing the volume performance from said database design information.