Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Distributed buffer management method based on dynamic index

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

Active Publication Date: 2012-01-11
北京人大金仓信息技术股份有限公司
View PDF4 Cites 12 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
  • Distributed buffer management method based on dynamic index
  • Distributed buffer management method based on dynamic index
  • 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
IPC IPC(8): G06F17/30
Inventor 白广超李祥凯冯玉李卫冷建全
Owner 北京人大金仓信息技术股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com