Unlock instant, AI-driven research and patent intelligence for your innovation.

Data preheating method and device

A preheating device and data technology, applied in the database field, can solve problems affecting the performance of the database system, busyness, and reduced response efficiency of the database system, and achieve the effects of improving overall performance, slowing down frequent IO, and improving response speed

Active Publication Date: 2014-04-02
HUAWEI CLOUD COMPUTING TECH CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] In the prior art, at the initial stage after the database is started, when the client requests a large amount of data and the business is very busy, the response efficiency of the database system will be reduced, and the IO will be very busy, which will affect the overall performance of the database system.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data preheating method and device
  • Data preheating method and device
  • Data preheating method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0031] A data preheating method provided by an embodiment of the present invention, such as figure 1 shown, including:

[0032] 101. When the database is started, fetch the hit rate information and read the user configuration information respectively, wherein the hit rate information includes: a hotspot data table, and the user configuration information includes: a preset hotspot data table, and the hotspot data block to be loaded The storage ratio stored in the shared buffer and the flash device, the size of the shared buffer, the storage capacity of the flash device, and the deviation value of the total number of hot data blocks to be loaded;

[0033] 102. Obtain a union of a preset hotspot data table in the user configuration information and a hotspot data table in the hit rate information;

[0034] 103. Determine the total number of hot data blocks to be loaded from the union according to the storage ratio, the size of the shared buffer, the size of the flash memory devic...

Embodiment 2

[0078] A data preheating device 40 provided by an embodiment of the present invention, such as Figure 4 As shown, it includes a reading unit 401 , an acquiring unit 402 , a first processing unit 403 , a second processing unit 404 and a storage unit 405 .

[0079] Wherein, the reading unit 401 is used to fetch hit rate information and read user configuration information respectively when the database is started, wherein the hit rate information includes: a hotspot data table, and the user configuration information includes: a preset hotspot data table , store the hot data blocks to be loaded in the shared buffer and the storage ratio of the flash device, the size of the shared buffer, the storage capacity of the flash device, and the deviation value of the total number of hot data blocks to be loaded;

[0080] An acquisition unit 402, configured to acquire a union of a preset hotspot data table in the user configuration information and a hotspot data table in the hit rate info...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

Embodiments of the present invention disclose a method and an apparatus for data preheating, which relate to the field of 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, separately 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. The embodiments of the present invention are applicable to processing of data preheating.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a data preheating method and device. Background technique [0002] With the rapid development of database technology, database storage systems present the following characteristics: [0003] Solid-state drives (Solid-State Drive, SSD), new storage devices such as phase-change memory and traditional disk devices constitute a hybrid storage environment. Compared with traditional disks, flash-based SSDs have the advantages of high performance and low energy consumption, and their price and capacity are between those of memory and traditional disks. It is expected that for a long time to come, various types of hard disk devices will exist at the same time, and hybrid storage will become the mainstream storage configuration; with more and more applications, the amount of user data will increase, and the input and output (Input) caused by traditional data storage / Output, IO) bottl...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30G06F12/0862
CPCG06F12/0862G06F2209/5019G06F9/5011G06F17/30442G06F12/0246G06F17/30289G06F16/21G06F16/2453
Inventor 代坤李怀洲宋娇
Owner HUAWEI CLOUD COMPUTING TECH CO LTD