Transaction data updating method and device

A technology of transaction data and update method, applied in the field of data processing, can solve problems such as update failure

Pending Publication Date: 2020-12-04
BANK OF CHINA
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present invention proposes a transaction data update method to solve the prob...

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
  • Transaction data updating method and device
  • Transaction data updating method and device
  • Transaction data updating method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention more clear, the embodiments of the present invention will be further described in detail below in conjunction with the accompanying drawings. Here, the exemplary embodiments and descriptions of the present invention are used to explain the present invention, but not to limit the present invention.

[0021] In the description of this specification, the words "comprising", "comprising", "having", "containing" and so on are all open terms, meaning including but not limited to. A description referring to the terms "one embodiment," "a particular embodiment," "some embodiments," "for example," etc., means that a particular feature, structure, or characteristic described in connection with the embodiment or example is included in at least one of the present application. Examples or examples. In this specification, schematic representations of the above terms do not ne...

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 provides a transaction data updating method and device, and the method comprises the steps: querying a first transaction information table after a transaction happens online, judging that the transaction is an effective transaction, and writing the transaction flow information of the transaction into a transaction flow information table when the transaction is the effective transaction; scanning a plurality of pieces of transaction flow information of which the final modification state is a first state in the transaction flow information table every a first set duration, temporarily storing the transaction flow information in a first list, and arranging the transaction flow information according to a preset sorting mode; according to the sequence of the transaction flow information in the first list, calling the amount updating transaction, updating the amount information table one by one, and after each piece of transaction flow information is successfully updated, changing the final modification state of the piece of transaction flow information in the transaction flow information table into a second state, and writing the serial number of the transaction flow information into the last updated serial number in the amount information table. According to the invention, the problem of updating failure caused by optimistic locks in transaction data updating affairscan be solved.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method and device for updating transaction data. Background technique [0002] In a transaction that includes record flow and amount update, when the amount is updated, a large number of update failures often occur due to optimistic locks. This is reflected in the fact that to ensure consistency, the flow records and amount updates are synchronized in one transaction. When the amount is updated, an optimistic lock (generally using the version number) will be used instead of a pessimistic lock (directly lock the database) to resolve high concurrency conflicts. But this only applies to the case where the database "write" operation is relatively small. Once the database is accessed frequently, optimistic locking will cause resource conflicts under multi-threading, making the database connection pool unable to be released, and only one of the multiple updates is allowed to...

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): G06F16/23G06Q40/04
CPCG06F16/2365G06Q40/04
Inventor 邓惠月韩天阳李国威叶蓉
Owner BANK OF CHINA
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap