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

Shared memory buffer pool processing method of database, storage medium and equipment

A shared memory and processing method technology, which is applied in the field of shared memory buffer pool processing, can solve problems such as interference and impact on memory buffer replacement, and achieve the effects of performance improvement, convenient cache operation, and flexible configuration

Pending Publication Date: 2022-07-26
北京人大金仓信息技术股份有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, not updating these page control structures can cause other disturbances, such as affecting memory buffer replacement

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
  • Shared memory buffer pool processing method of database, storage medium and equipment
  • Shared memory buffer pool processing method of database, storage medium and equipment
  • Shared memory buffer pool processing method of database, storage medium and equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0052] figure 1 is a schematic flowchart of a method for processing a shared memory buffer pool of a B-tree index database according to an embodiment of the present invention, figure 2 A schematic diagram of a database shared memory in a method for processing a shared memory buffer pool of a B-tree index database according to an embodiment of the present invention. The processing method of the database shared memory buffer pool can generally include:

[0053] Step S102, obtaining a buffer pool setting instruction;

[0054] Step S104, according to the buffer pool setting instruction, determine the designated B-tree index and the node to be fixed of the designated B-tree index;

[0055] Step S106, setting the fixed buffer pool mark of the B-tree index to a fixed state;

[0056] Step S108, after receiving the access to the designated B-tree index, execute the process of moving the node page of the node to be fixed into the fixed buffer pool, wherein the fixed buffer pool is ope...

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 invention provides a shared memory buffer pool processing method of a database, a storage medium and equipment. The method comprises the following steps: acquiring a buffer pool setting instruction; determining a specified B-tree index and a to-be-fixed node of the specified B-tree index according to the buffer pool setting instruction; setting a fixed buffer pool mark of the B-tree index as a fixed state; and after access to the specified B-tree index is received, the process of moving the node page of the node to be fixed into a fixed buffer pool is executed, and the fixed buffer pool is a buffer pool which is developed in advance in the memory cache space of the database and is independent of the common buffer pool. According to the scheme, the overhead rise caused by concurrent updating of the page control structure of the B-tree index is avoided, and the performance of database index query in a high-concurrency scene is greatly improved.

Description

technical field [0001] The invention relates to database technology, in particular to a shared memory buffer pool processing method, storage medium and device for a B-tree index database. Background technique [0002] The B-tree index is the most commonly used index in the database, which can support processing equivalence and range queries on sortable data, and greatly increase the query speed using this index. A B-tree index sorts the data and builds a B-tree so that the actions of finding data, accessing sequentially, inserting data, and deleting data can be done in logarithmic time. [0003] A B-tree is generally a generalized self-balancing n-ary search tree. Different from the self-balancing binary search tree, the B-tree is optimized for the read and write operations of large blocks of data in the system. The B-tree reduces the intermediate process experienced when locating records, thereby increasing the access speed. [0004] In a B-tree, internal (non-leaf) nodes...

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 Applications(China)
IPC IPC(8): G06F16/22G06F16/2455
CPCG06F16/2246G06F16/24552
Inventor 冷建全孙文奇
Owner 北京人大金仓信息技术股份有限公司