Patent ID: 6928450

Claim:
A storage apparatus comprising: connection means for connecting to a computer in which a database management system operates; and information acquiring means for acquiring information of data structures including tables, indexes, and logs defined by schema in said database management system, and information of recording positions of data of a database in said storage apparatus that are managed by said database management system and grouped under each of said data structures defined by said schema; at least one physical storage device for storing data; logical-to-physical position conversion means by which logical storage positions used when said computer makes access to said storage apparatus are converted to physical storage positions at which data can be actually stored within said physical storage device; data allocation changing means for changing said physical storage positions within said at least one physical storage device corresponding to said logical storage positions; and allocation changing plan generation means for generating a plan for changing the physical storage positions of data corresponding to said logical storage positions by using said information acquired by said information acquiring means.