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

Control method and device for updating database records

A technology for updating data and control methods, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as reducing concurrency efficiency and deadlock, and achieve the effect of improving concurrency efficiency

Active Publication Date: 2018-10-16
CHINA CONSTRUCTION BANK
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, this concurrency control method in the prior art is likely to cause deadlock, which will greatly reduce concurrency efficiency

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
  • Control method and device for updating database records
  • Control method and device for updating database records
  • Control method and device for updating database records

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0047] see figure 1 , figure 1 It is a flowchart of a control method for updating database records provided by an embodiment of the present invention. Such as figure 1 As shown, the method includes:

[0048] Step S101, obtaining a pre-updated database record;

[0049] Specifically, a pre-updated database record is obtained through a select statement, and no row-level lock is added to the select statement.

[0050] Step S102, using the primary key to locate the database record;

[0051] Specifically, the primary key is field information that uniquely identifies a record in the Constraint database.

[0052] Step S103, updating the first pre-update field, and adding 1 to the version number of the database record in the control memory;

[0053] Step S104, during the process of updating the first pre-update field, when an update request for the second pre-update field is obtained, use the primary key to locate the database record;

[0054] Specifically, the second pre-update...

Embodiment 2

[0061] see figure 2 , figure 2 It is a flow chart of another control method for updating database records provided by the embodiment of the present invention. Such as figure 2 As shown, the method includes:

[0062] Step S201, obtaining a pre-updated database record;

[0063] Step S202, using the primary key to locate the database record;

[0064] Step S203, searching for the first pre-update field, obtaining first update data input by the user corresponding to the first pre-update field, and updating the first pre-update field;

[0065] Specifically, the first pre-update field is located in the database record.

[0066] Step S204, read the version number of the database record in the database, store the version number of the database record in the memory, and control the version number of the database record in the memory to add 1;

[0067] Step S205, during the process of updating the first pre-update field, when an update request for the second pre-update field is ...

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 database record updating control method and device. The method includes the steps that a database record to be updated is obtained; the database record is positioned through a main key; a first field to be updated is updated, and the version number of the database record in a memory is controlled to add one to the version number; in the process of updating the first field to be updated, when an updating request for updating a second field to be updated is obtained, the database record is positioned through the main key; the second field to be updated is located in the database record; the version number of the database record in the memory and the version number of the database record in a database are obtained; when the difference value generated by subtracting the version number of the database record in the database from the version number of the database record in the memory is one, the second field to be updated is updated. By the adoption of the technical scheme, the problems that in the prior art, a concurrency control method is prone to causing deadlock and the concurrency efficiency can be lowered can be avoided.

Description

technical field [0001] The invention relates to the technical field of software, in particular to a control method and device for updating database records. Background technique [0002] Database is the core and foundation of information system. Now mainstream database management systems support multiple transactions to be executed at the same time, which can effectively improve the operating efficiency of the database management system. A transaction is an operation performed on a database. When developing multi-user database applications, it is often necessary to strive for the maximum concurrent access. However, when multiple users access the database concurrently, multiple transactions often update the same record at the same time. Since the processing time required by different transactions is different, the modification operation of the long transaction will overwrite the modification of the record by the short transaction. Condition. [0003] In order to avoid the...

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
CPCG06F16/2308G06F16/2315
Inventor 舒展陈炙聂砂刘海李拓曲麟智
Owner CHINA CONSTRUCTION BANK
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