Unlock instant, AI-driven research and patent intelligence for your innovation.

A kind of database business data consistency processing method and system

A business data and database technology, applied in the database field, can solve problems such as no data inconsistency, and achieve the effect of maintaining consistency

Active Publication Date: 2022-07-08
BEIJING ANHUA JINHE TECH
View PDF33 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present application provides a database business operation continuity processing method and system to at least solve the problem in the prior art that there is no monitoring of whether the business request of the database will lead to data inconsistency

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 kind of database business data consistency processing method and system

Examples

Experimental program
Comparison scheme
Effect test

example 1

[0029] Example 1, the trigger condition may include: judging whether the database operation corresponding to the service request is in a session, and if not in a session and the database operation includes a data change operation, triggering sending of the alarm information.

example 2

[0030] Example 2, the trigger condition may include: if automatic commit is set in the connection and there are multiple data change operations, triggering the sending of the alarm information, wherein each time an automatic commit is performed, the corresponding The database operation is completed in one transaction; if auto-commit is disabled in the connection, there are multiple explicit COMMIT requests submitted in the same business, and at least one of the COMMIT requests contains a change operation, the alarm information is triggered to be sent.

example 3

[0031] Example 3, the triggering condition includes: a database operation corresponding to the service request includes a change operation, and after the change operation fails, a rollback operation is not initiated, then triggering the sending of the alarm information.

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 present application discloses a method and system for processing database business data consistency. The method includes: receiving a business request for operating a database, wherein the business request corresponds to a database operation business, and the database operation business is used for Operate the database to complete the predetermined operation target; run the service request; in the process of running the service request, determine whether the service request is run within a transaction; in the case that the service request is within a transaction It is determined that if an exception occurs during the execution of the service request, data consistency can be maintained. This application solves the problem in the prior art caused by not monitoring whether the business request of the database will lead to data inconsistency, so that it is possible to monitor whether the database operation corresponding to a business request is within a transaction, and whether an abnormality occurs The data consistency can be maintained after the situation.

Description

technical field [0001] The present application relates to the field of databases, and in particular, to a method and system for processing database business data consistency. Background technique [0002] In the process of operating the database, a database operation business needs to be able to be rolled back. For example, in a database operation business, the database has been modified several times. When there is a problem with a certain modification, the database needs to be rolled back. to the state before this modification was made. [0003] In actual work, sometimes there is a situation where it cannot be rolled back. The inventor found that, for the situation that cannot be rolled back, it is generally because the database operation business is distributed in different transactions, which leads to the failure of rollback, which leads to data inconsistency. However, the prior art does not monitor this situation. SUMMARY OF THE INVENTION [0004] Embodiments of th...

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/23G06F9/46
CPCG06F16/2365G06F9/466
Inventor 刘晓韬陈立
Owner BEIJING ANHUA JINHE TECH