Database cache management method and database server

A cache management and database technology, applied in the database field, can solve the problems of low actual utilization of cached data and poor flexibility.
CN102331986AActive Publication Date: 2012-01-25TAOBAO CHINA SOFTWARE
2 Cites 34 Cited by

Patent Information

Authority / Receiving Office
CN · China
Current Assignee / Owner
TAOBAO CHINA SOFTWARE
Publication Date
2012-01-25

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The embodiment of the invention discloses a database cache management method and a database server. The method comprises the following steps of: pre-establishing a record cache for a data sheet in a database, and reading and writing data by the record cache by taking a data row as a unit; in the event of receiving a data inquiry request of a client, searching requested data in the record cache; if the searching process is failed, searching the requested data from a page cache of the database; and returning the data searched from the record cache or the page cache to the client. By utilizing the scheme, the two caches are included in the same database server, wherein the record cache is used for reading and writing data by taking the data row as the unit; the record cache can be only updated when only a small amount of hotspot data is changed, therefore, the cache utilization rate of the database server is increased; and the cache updating frequency is reduced.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The present application relates to the technical field of databases, in particular to a database management method and a server. Background technique

[0002] With the development of the Internet, the number of visits to the database is also increasing. If the access volume is large or the access time is relatively concentrated, the efficiency of the database response will be reduced. In order to improve the response efficiency, in the existing database server, a page buffer (page buffer) is generally set for the data, and the page buffer is used by each data table in the database to store frequently accessed hot data. Wherein, the page cache resource is divided into multiple pages of the same size, and the size of the page is set by the administrator, generally it can be 2K, 4K, 8K....

[0003] Generally, multiple data records are stored in one page unit (each data record corresponds to one row of the data table). In the page cache, the page size i...

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