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.

主权项

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 to assign a score to each of the plurality of columns, wherein the score assigned to each of the plurality of columns is a function of a cardinality of the column and a size of a data stored in the column; 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 score assigned to each of the plurality of columns.