Patent ID: 7054893

Claim:
A data relocation method in a computer system comprising: at least one computer for operating a database management system; at least one storage apparatus for storing database data to be managed by said database management system, said storage apparatus including a plurality of physical storage devices; storage control means connected between said computer and said storage apparatus, for controlling transfer of database data between said computer and said storage apparatus; and a data position management server for managing positions of database data in said computer system, said method comprising the steps of: acquiring, by said data position management server, information a database to be managed by said database management system through said computer, said information on the database including table data and index data to said table data, with said index data having a tree-structure; determining, by said data position management server, relocation of database data in said computer system on the basis of the information on the database thus acquired; instructing, from said data position management server, said storage control means to migrate database data so as to prevent said storage control means from accessing said table data and said index data simultaneously in a same physical storage device; and changing, by said storage control means, allocation of database data so that said table data and said index data are stored in different physical storage devices, respectively, according to instruction from said data position management server.