A method and device for preventing database concurrency

A database and data technology, applied in the database field, can solve problems such as database concurrency, achieve the effect of solving concurrency problems and improving fluency
CN105653632BActive Publication Date: 2019-05-31三六零数字安全科技集团有限公司
3 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
三六零数字安全科技集团有限公司
Publication Date
2019-05-31

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
Patent Text Reader

Abstract

The invention discloses a method and an apparatus for preventing database concurrence. The method comprises the steps of receiving a database access request; according to an access data identifier in the data access request, querying corresponding data from a database and reading a version number of the corresponding data; before the corresponding data in the database is operated according to an operation instruction in the data access request, judging whether the version number of the corresponding data is the same as the read version number or not; and if the version number of the corresponding data is the same as the read version number, then performing corresponding operation on the corresponding data in the database according to the operation instruction and modifying the version number of the corresponding data. According to the technical scheme, through a method for adding the version number to the data in the database, the problem of database concurrence is effectively solved and the fluency of data access is improved.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention relates to the technical field of databases, in particular to a method and device for preventing database concurrency. Background technique

[0002] Depending on the data stored in the database, the objects that can be accessed and read and written to the database are also different. When different users have operation authority on the same piece of data in the same database, database concurrency problems will arise. For example, user A and user B wish to modify data a in the first database at the same time, and at this time the two modification operations cannot be performed at the same time. Therefore, a method for efficiently handling database concurrency is needed. Contents of the invention

[0003] In view of the above problems, the present invention is proposed to provide a method and device for preventing database concurrency that overcomes the above problems or at least partially solves the above problems.

[0004] According ...

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