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

Multi-version management method for reducing index maintenance overhead

An index maintenance and management method technology, applied in the field of database management, can solve the problems of reducing system transaction throughput and spending time, and achieve the effect of improving transaction throughput and throughput

Active Publication Date: 2015-12-23
XUZHOU NORMAL UNIVERSITY +1
View PDF2 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] If a table has several indexes, these indexes need to be maintained when adding, deleting, or modifying data in the table, that is, to make corresponding modifications, which requires time overhead, thereby reducing the transaction throughput of the system

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
  • Multi-version management method for reducing index maintenance overhead
  • Multi-version management method for reducing index maintenance overhead

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0030] A multi-version management method that reduces index maintenance costs. Different versions of records are stored in a database table, and the database system extracts the physical ID of the stored record; more than one index is set in the database table, and each record is given a logical ID , the leaf node of the index stores the logical ID of the record; the index includes an index based on the user ID field and an index based on the date field. The index is in the form of a B+ tree; the order of the B+ tree is K (K>=3), and the internal nodes of the tree structure include split key values ​​and pointers to child nodes. Establish a mapping table from logical IDs to physical IDs, and maintain a mapping table from logical IDs to physical IDs. The mapping table records the logical ID, the physical ID of the latest submitted version, the physical ID of the latest uncommitted version, and the pointer to the next historical submitted version. The mapping table has an auxil...

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 multi-version management method for reducing index maintenance overhead. According to the multi-version management method, recorded different versions are stored in database tables and stored recorded physical IDs are extracted by a database system; one or more indexes are arranged in the database tables; each record is endowed with a logic ID; the recorded logic IDs are stored in the leaf nodes of the indexes; the logic IDs are built to a mapping table of the physical IDs and meanwhile, the logic IDs are maintained to the mapping table of the physical IDs. By adopting the multi-version management method for reducing the index maintenance overhead, the maintenance overhead of indexes is simplified and the transaction processing throughput is improved.

Description

technical field [0001] The invention relates to a multi-version management method for reducing index maintenance costs, and belongs to the technical field of database management. Background technique [0002] The purpose of database concurrency control is to coordinate these operations and ensure data consistency when multiple users access the same data object at the same time. For example, the balance of an account is 100, user a reads the balance, adds 10 yuan, and writes the new value to 110. After user a reads the account balance, user b also reads the balance, which is 100 yuan, and he adds 20 yuan. After user a writes 110 yuan, user b writes 120 yuan. The final balance is 120 yuan, which is a wrong value. The correct value should be 130 yuan. The purpose of concurrency control is to coordinate the operations of the above-mentioned users on data and ensure data consistency. [0003] There are two types of concurrency control methods, one is the locking mechanism, th...

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
CPCG06F16/2272G06F16/2308
Inventor 周晓云覃雄派
Owner XUZHOU NORMAL UNIVERSITY
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