A data processing method and device

Abstract

The invention provides a method and a device for processing data based on a single-table both-diagram mechanism. The method comprises distributing a first identifier for all records of a data table before end-of-day batch job, when updating the records during the end-of-day batch job, copying the records before update, updating the identifier corresponding to the copied records before update into a second identifier from the first identifier, performing the operation of updating the records and updating the identifier corresponding to the updated records into a third identifier from the first identifier, when inserting a record, performing the operation of inserting the record and distributing a third identifier to the inserted record, when deleting a record, copying the record before deletion, updating the identifier corresponding to the coped record before deletion into the second identifier from the first identifier and performing the operation of deleting the record, and creating a first diagram and a second diagram based on the data table, wherein the first diagram comprises the records corresponding to the first identifier and the second identifier, while the second diagram comprises the records corresponding to the first identifier and the third identifier.

Description

technical field [0001] The invention relates to data processing technology, in particular to a data processing method and device. Background technique [0002] The bank's 7x24 mechanism refers to maintaining uninterrupted online operation transactions during the end-of-day batch operation process, so as to provide users with 7x24 hours of continuous service. Among them, how to distinguish day1 data and day2 data during the end-of-day batch operation process is a part of the bank's 7x24 mechanism key issues. [0003] At present, the solutions of the 7x24 mechanism of domestic banks mostly adopt the dual-table storage mechanism, such as the data processing method and system for realizing uninterrupted bank service in Industrial Bank Co., Ltd. (Chinese patent application: 200310116036.8), and the industrial and commercial bank of China Co., Ltd. (Chinese patent application: 200510132633.9) provides a data processing method and system for continuous service. The above two schem...

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present invention provides a data processing method and device of a single-table dual-view mechanism, which can solve the high consumption of the dual-table storage mechanism and the problem of "breakpoints" in the process of data merging, and can avoid the single-table storage and double-record storage mechanism Complex business logic design in

Images