Patent ID: 9165021
Filing Date: 2015-10-20
Classification: G06F

Abstract:
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.