A method and system for accessing database records
A database and record technology, applied in the field of data processing, can solve the problem of low record update efficiency, achieve the effect of improving efficiency, avoiding unnecessary waiting, and meeting query requirements
Active Publication Date: 2021-09-28
北京思特奇信息技术股份有限公司
View PDF12 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
The process of locking and unlocking the database avoids abnormal phenomena such as dirty reads. However, for the process program that is updated later, it is necessary to wait for the update of the process program before the update to update the record. Therefore, Unnecessarily waiting for a long time, resulting in low efficiency of record update
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0019] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.
[0020] like figure 1 As shown, a method for accessing database records provided by an embodiment of the present invention includes:
[0021] Step 110, determining the program number of the update program on the record to be updated in the database, creating a preset number of temporary records according to the program number, and initializing the temporary record;
[0022] Specifically, the update program may include: an update process program or an update thread program.
[0023] The record to be updated in the database is any record in the database, as long as the record has a concurrent update problem, the method provided in this embodiment can be used to solve it.
[0024] The larger the value of the preset nu...
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
Login to View More Abstract
The present invention relates to a method and system for accessing database records. The method includes: determining the program quantity of the update program on the record to be updated in the database, creating a preset number of temporary records according to the program quantity, and initializing the temporary record; mapping all the update programs to On the preset number of temporary records, and update the temporary records to obtain the temporary data of each temporary record; when there is a query program on the records to be updated in the database, query according to the temporary data of all temporary records and the original data of the records to be updated in the database data and send it to the query program. The invention enables multiple updating programs to be updated at the same time, avoids unnecessary waiting of the updating programs, improves the efficiency of record updating, and satisfies the query requirement.
Description
technical field [0001] The invention belongs to the technical field of data processing, in particular to a method and system for accessing database records. Background technique [0002] In the prior art, concurrent updates often occur when updating records in a database, that is, a multi-process program or a multi-thread program simultaneously updates a record in the database. The following uses a multi-process program as an example to illustrate the concurrent update process: the database locks the record, and a process program in the multi-process program updates the record, and the database unlocks the record after the update; Then lock the record, another process program in the multi-process program will update the record, and after the update, the database will unlock the record... In this way, each process in the multi-process program is completed The program updates this one record. The process of locking and unlocking the database avoids abnormal phenomena such as...
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
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/2453
CPCG06F16/24549
Inventor 张奇伟
Owner 北京思特奇信息技术股份有限公司