Database-based breakpoint resume method and related device

A technology of resuming data transfer and database, which is applied in the field of database and can solve problems such as time wasting

Pending Publication Date: 2021-11-26
INSPUR BUSINESS MACHINE CO LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This will bring about two problems. One is that the database may need to be rolled back to the state before the batch processing started, and the other is that the batch needs to be re-run from the beginning, which will cause a lot of waste of time.

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
  • Database-based breakpoint resume method and related device
  • Database-based breakpoint resume method and related device
  • Database-based breakpoint resume method and related device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0039] The core of the present invention is to provide a database-based breakpoint resume transmission method. In the prior art, if a problem occurs in the system during batch running and the batch processing is interrupted abnormally, the usual practice is to roll back the database transaction after restarting the application or database, and then resubmit the batch processing program to continue processing. This will bring about two problems. One is that the database may need to be rolled back to the state before the batch process started, and the other is that the batch needs to be re-run from the beginning, which will cause a lot of waste of time.

[0040] And a kind of database-based breakpoint continuation method provided by the present invention includes acquiring database transactions to be processed; after acquiring database transactions to be processed, reading breakpoint records; when valid breakpoint positions are stored in the breakpoint records When identifying, ...

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 database-based breakpoint resume method, which comprises the following steps: pre-establishing a breakpoint record, and storing a corresponding breakpoint position identifier in the breakpoint record. Since the processing position corresponding to the breakpoint position identifier is updated once when the submission operation is executed once in the process of executing the database transaction to be processed, the breakpoint position identifier can represent the processing progress of the database transaction to be processed. And when the to-be-processed database transaction is forced to be interrupted, the to-be-processed database transaction can be continuously processed according to the breakpoint position identifier, so that a breakpoint resuming function is realized. The invention further provides a database-based breakpoint resume device, database-based breakpoint resume equipment and a computer readable storage medium, which also have the above beneficial effects.

Description

technical field [0001] The present invention relates to the technical field of databases, in particular to a method for resumed data transfer based on a database, a device for resumed data transfer based on a database, a device for resumed data transfer based on a database, and a computer-readable storage medium . Background technique [0002] For large financial companies, database batch processing is required every trading day to process massive amounts of data. Due to the large size of the data, the processing time usually takes several hours or more. During batch running, once a problem occurs in the system and the batch processing is interrupted abnormally, the usual practice is to roll back the database transaction after restarting the application or database, and then resubmit the batch processing program to continue processing. This will bring about two problems. One is that the database may need to be rolled back to the state before the batch process started, and ...

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 Applications(China)
IPC IPC(8): G06F16/23G06F9/46G06F16/22G06F16/17
CPCG06F16/23G06F9/466G06F16/2282G06F16/1734
Inventor 方纬
Owner INSPUR BUSINESS MACHINE CO LTD
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