公开(公告)号：US09569489B2

公开(公告)日：2017-02-14

申请号：US14278707

申请日：2014-05-15

Applicant: Huawei Technologies Co., Ltd.

Inventor： Kun Dai ,  Huaizhou Li ,  Jiao Song

IPC: G06F17/30 ,  G06F12/02 ,  G06F12/08

CPC classification number: G06F17/30442 ,  G06F12/0246 ,  G06F12/0862 ,  G06F17/30289

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

Abstract translation: 本发明的实施例公开了一种与数据库技术相关的用于数据预热的方法和装置，以便增加数据库系统的响应速度，减少磁盘上的频繁IO，并提高数据库系统的整体性能。 该方法包括：当数据库启动时，从闪存设备读取命中率信息并从硬盘读取用户配置信息; 获取用户配置信息中的预设热数据表的联合集合和命中率信息中的热数据表; 从联合集中确定要加载的热数据块的总数; 根据存储比例，确定要存储到共享缓冲器和闪速存储器件中的待加载热数据块; 并将待加载的热数据块分别存储到共享缓冲器和闪存器件中。

公开(公告)号：US20140250102A1

公开(公告)日：2014-09-04

申请号：US14278707

申请日：2014-05-15

Applicant: Huawei Technologies Co., Ltd.

Inventor： Kun Dai ,  Huaizhou Li ,  Jiao Song

IPC: G06F17/30

CPC classification number: G06F17/30442 ,  G06F12/0246 ,  G06F12/0862 ,  G06F17/30289

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

Abstract translation: 本发明的实施例公开了一种与数据库技术相关的用于数据预热的方法和装置，以便增加数据库系统的响应速度，减少磁盘上的频繁IO，并提高数据库系统的整体性能。 该方法包括：当数据库启动时，从闪存设备读取命中率信息并从硬盘读取用户配置信息; 获取用户配置信息中的预设热数据表的联合集合和命中率信息中的热数据表; 从联合集中确定要加载的热数据块的总数; 根据存储比例，确定要存储到共享缓冲器和闪速存储器件中的待加载热数据块; 并将待加载的热数据块分别存储到共享缓冲器和闪存器件中。