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.

Active Publication Date: 2012-01-25
TAOBAO CHINA SOFTWARE
View PDF2 Cites 34 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] It can be seen that the existing database server caching method has poor flexibility. Even if only a small amount of hot data changes, the cached

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
  • Database cache management method and database server
  • Database cache management method and database server
  • Database cache management method and database server

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] In order to enable those skilled in the art to better understand the technical solutions in the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described The embodiments are only some of the embodiments of the present application, but not all of them. All other embodiments obtained by persons of ordinary skill in the art based on the embodiments in this application shall fall within the protection scope of this application.

[0024] First, a database cache management method in the embodiment of the present application is described, see figure 1 As shown, the method includes the following steps:

[0025] S101: Establish a record cache for the data table in the database in advance, and the record cache performs data reading and writing in units of data rows;

[0026] S102: When receiving ...

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

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.

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

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30
Inventor 张潇
Owner TAOBAO CHINA SOFTWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products