| 发明名称 |
PREDICTIVE PLACEMENT OF COLUMNS DURING CREATION OF A LARGE DATABASE |
| 摘要 |
Methods and arrangements for predictively placing columns of a large database in a multi-tier storage system. Aspects include receiving a database to be stored in the multi-tier storage system, wherein the database comprises a plurality of columns and the multi-tier storage system comprises at least two storage devices and evaluating one or more attributes of each of the plurality of columns of the database. Aspects also include storing each of the plurality of columns of the database on one of the at least two storage devices, wherein a determination of which of the at least two storage devices to store each of the plurality of columns is based on the one or more attributes of each of the columns, a predictive model based on the weighted columnar relationship graph, and the characteristics of the storage devices. |
| 申请公布号 |
US2015363443(A1) |
申请公布日期 |
2015.12.17 |
| 申请号 |
US201414305061 |
申请日期 |
2014.06.16 |
| 申请人 |
International Business Machines Corporation |
发明人 |
Kaushik Rini |
| 分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
| 代理机构 |
|
代理人 |
|
| 主权项 |
1. A method for predictively placing columns of a database in a multi-tier storage system, the method comprising:
receiving, by a processor, a database to be stored in the multi-tier storage system, wherein the database comprises a plurality of columns and the multi-tier storage system comprises at least two storage devices; evaluating one or more attributes of each of the plurality of columns of the database; and storing each of the plurality of columns of the database on one of the at least two storage devices, where a determination of which of the at least two storage devices to store each of the plurality of columns is based on the evaluation of the one or more attributes of each of the columns. |
| 地址 |
Armonk NY US |
