Eureka AIR delivers breakthrough ideas for toughest innovation challenges, trusted by R&D personnel around the world.

A Distributed Buffer Management Method Based on Dynamic Index

A technology of dynamic indexing and management methods, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems that are not suitable for database cluster systems, reduce disk I/O, improve overall performance, and reduce data loss Effect

Active Publication Date: 2015-09-09
北京人大金仓信息技术股份有限公司
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this method is not suitable for use in database cluster systems

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
  • A Distributed Buffer Management Method Based on Dynamic Index
  • A Distributed Buffer Management Method Based on Dynamic Index

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] The specific implementation steps of the present invention will be further described below in conjunction with the accompanying drawings and specific examples, but the examples should not be construed as limiting the present invention.

[0024] In a database cluster system based on a shared disk, there are 4 database nodes and 1 global resource management node. Wherein, the database node refers to a server that provides database services, and is used to accept a user's database query request and return a result. It is an integral part of the database cluster system, and there can be one or more. The global resource management node refers to the node that provides the shared resource management service of the database cluster system. It is a core component of the database cluster system, which includes a global buffer manager for managing buffers. The global buffer manager can implement functions such as content indexing, version management and attribute modification o...

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 discloses a distributed buffer management method based on a dynamic index, applied in a database cluster system, wherein each node of the database cluster system is provided with an independent buffer; when a data block is firstly loaded to the buffer of the node by the certain node, information of the data block is firstly loaded in a dynamic index table of a global buffer manager, the attribute of the buffer is set to be a local resource, and is held by the node; when the other nodes need to access the data block, the nodes firstly search in the global buffer manager, and under the condition that the data block is loaded and held by the certain node is acquired through the dynamic index table, the nodes modify the attribute of the buffer to be a global resource, and apply to the node which holds the data block for transferring the data block for accessing. The invention realizes multi-version assess control of the data block through a dynamic index mechanism, reduces disk I / O (Input / Output), and improves overall performance of the database cluster system.

Description

technical field [0001] The invention relates to a method for managing distributed buffers in a database cluster system, in particular to a method for managing distributed buffers based on a dynamic index mechanism, and belongs to the technical field of database cluster systems. Background technique [0002] With the rapid development of the economy, the number of users and the amount of data show explosive growth. In the application environment where user demands are constantly increasing, a severe test is put forward for database technology. For all databases, in addition to recording correct processing results, there are also challenges in the following aspects: how to improve processing speed and achieve database load balancing; how to ensure database availability, data security, and how to implement data collection. scalability. [0003] In order to deal with the technical challenges mentioned above, people draw on the technical concept of computer clusters (connecting...

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/30
Inventor 白广超李祥凯冯玉李卫冷建全
Owner 北京人大金仓信息技术股份有限公司
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
Eureka Blog
Learn More
PatSnap group products