公开(公告)号：WO2010120751A3

公开(公告)日：2011-01-06

申请号：PCT/US2010030856

申请日：2010-04-13

Applicant: IBM

Inventor： BHATTACHARJEE BISHWARANJAN ,  CANIM MUSTAFA ,  MIHAILA GEORGE ANDRE

IPC: G06F7/00

CPC classification number: G06F17/30312 ,  G06F17/30424 ,  G06F17/30864

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

Abstract translation: 一种方法，信息处理系统和计算机程序存储产品优化数据库对象在多个存储设备上的放置。 一组数据库对象被放置在多个存储设备中的第一存储设备上。 每个存储设备包括不同的特征。 在已经放置在第一个存储设备上的数据库对象集上运行查询工作负载。 收集与正在运行的查询工作负载相关联的分析信息。 从要存储在第二存储设备上的数据库对象的集合中选择数据库对象的子集。 第二存储设备是与第一存储设备不同的并且执行得比第一存储设备更快的单独的物理设备。 数据库对象的子集存储在第二存储设备上，并且存储在第一存储设备上的数据库对象集合中的所有剩余的数据库对象。