Patent ID: 7730171

Claim:
An automated method of organizing data in a database management system, the automated method comprising: logically storing data in two or more logical data storage units; physically storing the data in two or more physical data storage units; maintaining a mapping of logical data storage units to physical data storage units, each logical data storage unit mapped to one physical data storage unit; measuring a current input/output workload of each logical data storage unit; measuring a data input/output rate of each physical data storage units; ranking the logical data storage units from the logical data storage unit with the highest workload to the logical data storage unit with the lowest workload; ranking the physical data storage units from the physical data storage unit with the fastest data input/output rate to the lowest input/output rate; building a data migration plan to match the logical data storage units with the highest workloads to the physical data storage units with the fastest data input/output rates; according to the data migration plan, migrating data of a logical data storage unit with a higher input/output workload from a first physical data storage unit to a second physical data storage unit having a faster input/output rate than the first physical data storage unit; and updating the mapping of the logical data unit of the migrated data from the first physical data storage unit to the second physical data storage unit.