Huawei Technologies Co., Limited

Kun Dai

Wenlong Huang

Huaizhou Li

Jiao Song

Haibin Wei

Shishi Shan

Embodiments of the present invention disclose a method and an apparatus for data preheating, which relate to database technologies, so as to increase a responding speed of a database system, reduce frequent IO on a magnetic disk, and improve overall performance of the database system. The method includes: when a database is started, reading hit ratio information from a flash memory device and reading user configuration information from a hard disk; obtaining a union set of a preset hot data table in the user configuration information and a hot data table in the hit ratio information; determining the total number of to-be-loaded hot data blocks from the union set; according to the storage proportions, determining the to-be-loaded hot data block to be stored into a shared buffer and the flash memory device; and separately storing the to-be-loaded hot data block into the shared buffer and the flash memory device.

Method and apparatus for data preheating

The present invention provides a method and a system for configuring a storage device in a hybrid storage environment. The method includes: acquiring a plurality of attribute parameters of each storage device; performing calculation according to the attribute parameters to obtain a priority of each storage device; acquiring a storage priority of each data object; and performing matching according to the storage priority of each data object and the priority of each storage device, so as to store each data object into a storage device with a priority corresponding to the storage priority of the data object. Accordingly, configuration of a plurality of storage devices and a plurality of data objects in a hybrid storage environment can be implemented, which avoids manual involvement, thereby reducing security risks, improving performance of the system, and reducing energy consumption of the system.

Growing community of inventors

Shenzhen, China

Kun Dai