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

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

Active Publication Date: 2019-05-31
三六零数字安全科技集团有限公司
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When different users have operation authority on the same piece of data in the same database, database concurrency problems will arise

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
  • A method and device for preventing database concurrency
  • A method and device for preventing database concurrency

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0051] figure 1 A flow diagram showing a method for preventing database concurrency according to an embodiment of the present invention, as shown in figure 1 As shown, the method includes:

[0052] Step S110, receiving a database access request.

[0053] Step S120, query the corresponding data from the database according to the access data identification in the data access request and read the version number of the corresponding ...

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 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.

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

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/21
CPCG06F16/219
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