03-07-2013 дата публикации
Номер: CN103186566A
Принадлежит:
The invention discloses data classification storage method, device and system, wherein the method comprises the steps: acquiring the use frequency of a data table from an ETL (Extraction Transformation Loading) schedule table, and acquiring the appearance frequency of the data table from a buffer pool; according to the usage frequency and appearance frequency of the data table, calculating the heat of the data table; and according to the level of the data table, performing classification storage on the data table. The heat of the data table is calculated according to the usage frequency of the data table, acquired from the ETL schedule table, and the occurrence frequency in the buffer pool, so that the evaluation on the data table is more accurate, the classification storage is more precise to meet the practical condition of the data table, and the system performance can be improved. Different from the traditional method of carrying out data partitioning according to time slices, data in ...
Подробнее