MANAGING DATABASE OBJECT PLACEMENT ON MULTIPLE STORAGE DEVICES

摘要

A method, information processing system, and computer program storage product optimize the placement of database objects on a multiplicity of storage devices. A set of database objects are placed on a first storage device in a multiplicity of storage devices. Each storage device comprises differing characteristics. A query workload is run on the set of database objects that have been placed on the first storage device. Profiling information associated with the query workload that is running is collected. A subset of database objects is selected from the set of the database objects to be stored on a second storage device. The subset of database objects is stored on the second storage device and all remaining database objects in the set of database objects on the first storage device.

主权项

1. A method for optimizing placement of database objects on a plurality of storage devices, the method comprising:
placing a set of database objects on a first storage device in a plurality of storage devices, wherein each storage device in the plurality of storage device comprises differing characteristics; running a query workload on the set of database objects that have been placed on the first storage device; collecting profiling information associated with the query workload that is running; selecting, based on the profiling information that has been collected, a subset of database objects from the set of the database objects to be stored on a second storage device in the plurality of storage devices; and storing the subset of database objects on the second storage device and all remaining database objects in the set of database objects on the first storage device.