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 second storage device is a separate physical device from, and performs faster than, the first 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; determining, based on collecting the profiling information, a number of pages read and written for each database object in the set of database objects, and a total time spent through sequential and random access for each database object in the set of database objects; collecting profiling information associated with the query workload that is running; selecting, based on the number pages read and written and the total time spent through sequential and random access for each database object, 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, wherein the second storage device is a separate physical device from, and performs faster than, the first storage device; 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, where each database object in the set of database objects is a randomly accessed database object, and where each remaining database object is a sequentially accessed database object.