CN111708790A - Transaction processing method and device - Google Patents
Transaction processing method and device Download PDFInfo
- Publication number
- CN111708790A CN111708790A CN202010463937.8A CN202010463937A CN111708790A CN 111708790 A CN111708790 A CN 111708790A CN 202010463937 A CN202010463937 A CN 202010463937A CN 111708790 A CN111708790 A CN 111708790A
- Authority
- CN
- China
- Prior art keywords
- transaction
- fragment
- complete
- executed
- module
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Withdrawn
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 20
- 239000012634 fragment Substances 0.000 claims abstract description 149
- 238000000034 method Methods 0.000 claims abstract description 22
- 238000000638 solvent extraction Methods 0.000 claims abstract description 13
- 230000004044 response Effects 0.000 claims abstract description 7
- 238000005192 partition Methods 0.000 claims description 8
- 238000012795 verification Methods 0.000 claims description 6
- 230000002085 persistent effect Effects 0.000 claims description 3
- 238000011084 recovery Methods 0.000 abstract description 6
- 230000008569 process Effects 0.000 description 9
- 238000004590 computer program Methods 0.000 description 5
- 238000013467 fragmentation Methods 0.000 description 4
- 238000006062 fragmentation reaction Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000002688 persistence Effects 0.000 description 2
- 239000002699 waste material Substances 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- FFBHFFJDDLITSX-UHFFFAOYSA-N benzyl N-[2-hydroxy-4-(3-oxomorpholin-4-yl)phenyl]carbamate Chemical compound OC1=C(NC(=O)OCC2=CC=CC=C2)C=CC(=C1)N1CCOCC1=O FFBHFFJDDLITSX-UHFFFAOYSA-N 0.000 description 1
- 230000014509 gene expression Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/466—Transaction processing
- G06F9/467—Transactional memory
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computer Security & Cryptography (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a transaction processing method and a device, wherein the method comprises the following steps: passively partitioning an executed first transaction fragment from a complete transaction according to an interrupt in response to the occurrence of the interrupt in the complete transaction being executed; forcibly submitting the first transaction fragment by using an executed fragment submitting module to generate first result data for saving the first transaction fragment; reinitiating the complete transaction, and checking the data consistency of the complete transaction by using a checking module so as to actively divide the unexecuted second transaction fragment from the complete transaction; executing the second transaction fragment, and using an unexecuted fragment submitting module to forcibly submit the second transaction fragment to generate second result data for storing the second transaction fragment; and summarizing the first result data and the second result data by using a data summarizing module to form a result set obtained by completely executing the complete transaction. The invention can keep the breakpoint affairs of the database when interruption occurs, thereby saving the recovery time.
Description
Technical Field
The present invention relates to the field of databases, and more particularly, to a transaction processing method and apparatus.
Background
When the existing stage database carries out transaction operation, after a transaction interruption occurs, a data result set before the interruption cannot be stored. If the transaction is executed again, the transaction also needs to start from scratch. If a large transaction is encountered, a large amount of time may be required to generate an operation with a large result set in the middle, and the previous actions are performed again when the transaction is executed again, which wastes time.
Aiming at the problem of time waste caused by transaction interruption rollback in the prior art, no effective solution is available at present.
Disclosure of Invention
In view of this, an object of the embodiments of the present invention is to provide a transaction processing method and apparatus, which can maintain breakpoint transactions of a database when an interrupt occurs, so as to save recovery time.
In view of the above object, a first aspect of the embodiments of the present invention provides a transaction processing method, including the following steps:
passively partitioning an executed first transaction fragment from a complete transaction according to an interrupt in response to the occurrence of the interrupt in the complete transaction being executed;
forcibly submitting the first transaction fragment by using an executed fragment submitting module to generate first result data for saving the first transaction fragment;
reinitiating the complete transaction, and checking the data consistency of the complete transaction by using a checking module so as to actively divide the unexecuted second transaction fragment from the complete transaction;
executing the second transaction fragment, and using an unexecuted fragment submitting module to forcibly submit the second transaction fragment to generate second result data for storing the second transaction fragment;
and summarizing the first result data and the second result data by using a data summarizing module to form a result set obtained by completely executing the complete transaction.
In some embodiments, the second transaction fragment is retired while the first transaction fragment is forced to be committed using the executed fragment commit module to generate first result data that preserves the first transaction fragment.
In some embodiments, passively partitioning an executed first transaction fragment from a complete transaction according to an interrupt comprises: and determining the position of the interruption transaction execution failure in the complete transaction, and determining the transaction before the position as a first transaction fragment.
In some embodiments, checking the data consistency of the complete transaction using the checking module to proactively partition the unexecuted second transaction fragment from the complete transaction comprises: the database is scanned using a verification module to determine potential transactions that are the same as the complete transaction, and a second transaction fragment is determined based on a difference between the complete transaction and the potential transactions.
In some embodiments, the result set is also persisted to memory and the first result data and the second result data are deleted.
A second aspect of an embodiment of the present invention provides a transaction processing apparatus, including:
a processor; and
a memory storing program code executable by the processor, the program code when executed performing the steps of:
passively partitioning an executed first transaction fragment from a complete transaction according to an interrupt in response to the occurrence of the interrupt in the complete transaction being executed;
forcibly submitting the first transaction fragment by using an executed fragment submitting module to generate first result data for saving the first transaction fragment;
reinitiating the complete transaction, and checking the data consistency of the complete transaction by using a checking module so as to actively divide the unexecuted second transaction fragment from the complete transaction;
executing the second transaction fragment, and using an unexecuted fragment submitting module to forcibly submit the second transaction fragment to generate second result data for storing the second transaction fragment;
and summarizing the first result data and the second result data by using a data summarizing module to form a result set obtained by completely executing the complete transaction.
In some embodiments, the second transaction fragment is retired while the first transaction fragment is forced to be committed using the executed fragment commit module to generate first result data that preserves the first transaction fragment.
In some embodiments, passively partitioning an executed first transaction fragment from a complete transaction according to an interrupt comprises: and determining the position of the interruption transaction execution failure in the complete transaction, and determining the transaction before the position as a first transaction fragment.
In some embodiments, checking the data consistency of the complete transaction using the checking module to proactively partition the unexecuted second transaction fragment from the complete transaction comprises: the database is scanned using a verification module to determine potential transactions that are the same as the complete transaction, and a second transaction fragment is determined based on a difference between the complete transaction and the potential transactions.
In some embodiments, the result set is also persisted to memory and the first result data and the second result data are deleted.
The invention has the following beneficial technical effects: according to the transaction processing method and device provided by the embodiment of the invention, the executed first transaction fragment is passively divided from the complete transaction according to the interruption by responding to the interruption of the complete transaction which is being executed; forcibly submitting the first transaction fragment by using an executed fragment submitting module to generate first result data for saving the first transaction fragment; reinitiating the complete transaction, and checking the data consistency of the complete transaction by using a checking module so as to actively divide the unexecuted second transaction fragment from the complete transaction; executing the second transaction fragment, and using an unexecuted fragment submitting module to forcibly submit the second transaction fragment to generate second result data for storing the second transaction fragment; the technical scheme that the first result data and the second result data are summarized by using the data summarizing module to form a result set obtained by completely executing the complete transaction can keep the breakpoint transaction of the database when interruption occurs, so that the recovery time is saved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flow chart illustrating a transaction processing method according to the present invention;
FIG. 2 is a block diagram of a transaction processing method provided by the present invention;
fig. 3 is a schematic block diagram of a transaction processing method according to the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the following embodiments of the present invention are described in further detail with reference to the accompanying drawings.
It should be noted that all expressions using "first" and "second" in the embodiments of the present invention are used for distinguishing two entities with the same name but different names or different parameters, and it should be noted that "first" and "second" are merely for convenience of description and should not be construed as limitations of the embodiments of the present invention, and they are not described in any more detail in the following embodiments.
In view of the above object, a first aspect of the embodiments of the present invention provides an embodiment of a transaction processing method capable of maintaining breakpoint transactions of a database when an interrupt occurs. Fig. 1 is a flow chart illustrating a transaction processing method provided by the present invention.
The transaction processing method, as shown in fig. 1, includes the following steps:
step S101: passively partitioning an executed first transaction fragment from a complete transaction according to an interrupt in response to the occurrence of the interrupt in the complete transaction being executed;
step S103: forcibly submitting the first transaction fragment by using an executed fragment submitting module to generate first result data for saving the first transaction fragment;
step S105: reinitiating the complete transaction, and checking the data consistency of the complete transaction by using a checking module so as to actively divide the unexecuted second transaction fragment from the complete transaction;
step S107: executing the second transaction fragment, and using an unexecuted fragment submitting module to forcibly submit the second transaction fragment to generate second result data for storing the second transaction fragment;
step S109: and summarizing the first result data and the second result data by using a data summarizing module to form a result set obtained by completely executing the complete transaction.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program to instruct relevant hardware to perform the processes, and the processes can be stored in a computer readable storage medium, and when executed, the processes can include the processes of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a read-only memory (ROM), a Random Access Memory (RAM), or the like. Embodiments of the computer program may achieve the same or similar effects as any of the preceding method embodiments to which it corresponds.
In some embodiments, the second transaction fragment is retired while the first transaction fragment is forced to be committed using the executed fragment commit module to generate first result data that preserves the first transaction fragment.
In some embodiments, passively partitioning an executed first transaction fragment from a complete transaction according to an interrupt comprises: and determining the position of the interruption transaction execution failure in the complete transaction, and determining the transaction before the position as a first transaction fragment.
In some embodiments, checking the data consistency of the complete transaction using the checking module to proactively partition the unexecuted second transaction fragment from the complete transaction comprises: the database is scanned using a verification module to determine potential transactions that are the same as the complete transaction, and a second transaction fragment is determined based on a difference between the complete transaction and the potential transactions.
In some embodiments, the result set is also persisted to memory and the first result data and the second result data are deleted.
The method disclosed according to an embodiment of the present invention may also be implemented as a computer program executed by a CPU, which may be stored in a computer-readable storage medium. The computer program, when executed by the CPU, performs the above-described functions defined in the method disclosed in the embodiments of the present invention. The above-described method steps and system elements may also be implemented using a controller and a computer-readable storage medium for storing a computer program for causing the controller to implement the functions of the above-described steps or elements.
The following further illustrates embodiments of the invention in terms of specific examples as shown in fig. 2 and 3.
The transaction is executed first, and the transaction is stopped when the transaction is interrupted after a period of time. For a database, generally, when a transaction is interrupted without being executed, the transaction will all rollback, that is, all SQL (referring to the basic unit of the database transaction fragment) executed in the transaction will rollback, if partial SQL does not rollback, and partial SQL rolls back, the transaction will generate dirty data, resulting in a problem of transaction consistency. However, in the executed fragment commit module (storage process 1 in fig. 3) in the present invention, first, all SQL in the transaction is searched according to the transaction ID, the executed SQL is found through the database view, the executed SQL is subjected to a forced commit operation, and a data result set of the executed SQL is stored in the permanent data table 1 by creating a permanent storage table 1. And backing the SQL which is not executed. Such a complete transaction (SQL set) is divided into two pieces (two small SQL sets) into two small transactions, thus shielding the problem of so-called transaction inconsistency and dirty data. Meanwhile, the related information of the two transaction fragments is stored in a transaction view, and the SQL set of the submitted fragments and the metadata information of the corresponding result set data table 1 are recorded in the view, so that the association relationship is established.
It should be noted that there are two types of transaction fragmentation modules in embodiments of the invention: the system comprises an executed fragment submitting module and an unexecuted fragment submitting module, wherein the executed fragment submitting module implements passive fragmentation, and the unexecuted fragment submitting module implements active fragmentation. The forced submission in the invention can effectively reduce the workload brought by rollback to save recovery time, and simultaneously solves the problem that the dirty data is caused by the conventional forced submission in the database.
When the transaction is reinitiated, the check module (storage process 2 in fig. 3) determines whether there is the same transaction in the database by scanning the transaction view in the database. The judging method is that the SQL set in the transaction is used for judging, the SQL consistency is compared, if the SQL of the transaction is consistent with the SQL of the transaction in the view and the execution sequence is consistent, the checking module considers that the transaction is executed before. And simultaneously confirming the last breakpoint of the transaction: and the last executed SQL and the first unexecuted SQL are used as a cutting point, and the transaction is cut into fragments and divided into two small transactions. While the relevant information of both transaction fragments is stored in the transaction view.
The uncommitted fragmentation module (storage process 3 in fig. 3) executes SQL before the cut point and generates the persistent data table 2, and stores the executed SQL result set to the persistent data table 2. And simultaneously establishing an association relation between the SQL set of the just submitted fragment and the metadata information of the corresponding result set data table 2.
The data summarization module (storage process 4 of fig. 3) scans the transaction view, confirming that two fragmented transactions of the transaction have been executed and committed. And meanwhile, a permanent data table 3 is established, and the contents of the data table 1 and the data table 2 are imported into the data table 3. And establishing an association relationship between the transaction ID and the permanent data table 3ID, and storing the association relationship into a view of a database transaction result set. Meanwhile, a cache table space is opened up in a database shared memory area, the data table 3 is placed in the cache space, memory persistence is carried out, and query efficiency is improved. When the same transaction is executed again or breakpoints are executed again, the data summarization module will look up the permanent data table 3 corresponding to the transaction from the transaction result set view. And rapidly inquiring the data table 3 for result display through memory persistence.
As can be seen from the foregoing embodiments, the transaction processing method provided in the embodiments of the present invention passively partitions an executed first transaction fragment from a complete transaction according to an interrupt by responding to the occurrence of the interrupt in the complete transaction being executed; forcibly submitting the first transaction fragment by using an executed fragment submitting module to generate first result data for saving the first transaction fragment; reinitiating the complete transaction, and checking the data consistency of the complete transaction by using a checking module so as to actively divide the unexecuted second transaction fragment from the complete transaction; executing the second transaction fragment, and using an unexecuted fragment submitting module to forcibly submit the second transaction fragment to generate second result data for storing the second transaction fragment; the technical scheme that the first result data and the second result data are summarized by using the data summarizing module to form a result set obtained by completely executing the complete transaction can keep the breakpoint transaction of the database when interruption occurs, so that the recovery time is saved.
It should be particularly noted that, the steps in the embodiments of the transaction processing method described above can be mutually intersected, replaced, added, or deleted, and therefore, the reasonable permutation and combination transformation of the transaction processing method shall also belong to the scope of the present invention, and shall not limit the scope of the present invention to the described embodiments.
In view of the above object, a second aspect of the embodiments of the present invention provides an embodiment of a transaction processing apparatus capable of maintaining breakpoint transactions of a database when an interrupt occurs. The transaction processing device includes:
a processor; and
a memory storing program code executable by the processor, the program code when executed performing the steps of:
passively partitioning an executed first transaction fragment from a complete transaction according to an interrupt in response to the occurrence of the interrupt in the complete transaction being executed;
forcibly submitting the first transaction fragment by using an executed fragment submitting module to generate first result data for saving the first transaction fragment;
reinitiating the complete transaction, and checking the data consistency of the complete transaction by using a checking module so as to actively divide the unexecuted second transaction fragment from the complete transaction;
executing the second transaction fragment, and using an unexecuted fragment submitting module to forcibly submit the second transaction fragment to generate second result data for storing the second transaction fragment;
and summarizing the first result data and the second result data by using a data summarizing module to form a result set obtained by completely executing the complete transaction.
In some embodiments, the second transaction fragment is retired while the first transaction fragment is forced to be committed using the executed fragment commit module to generate first result data that preserves the first transaction fragment.
In some embodiments, passively partitioning an executed first transaction fragment from a complete transaction according to an interrupt comprises: and determining the position of the interruption transaction execution failure in the complete transaction, and determining the transaction before the position as a first transaction fragment.
In some embodiments, checking the data consistency of the complete transaction using the checking module to proactively partition the unexecuted second transaction fragment from the complete transaction comprises: the database is scanned using a verification module to determine potential transactions that are the same as the complete transaction, and a second transaction fragment is determined based on a difference between the complete transaction and the potential transactions.
In some embodiments, the result set is also persisted to memory and the first result data and the second result data are deleted.
As can be seen from the foregoing embodiments, the transaction processing apparatus provided in the embodiments of the present invention passively partitions an executed first transaction fragment from a complete transaction according to an interrupt by responding to the occurrence of the interrupt in the complete transaction being executed; forcibly submitting the first transaction fragment by using an executed fragment submitting module to generate first result data for saving the first transaction fragment; reinitiating the complete transaction, and checking the data consistency of the complete transaction by using a checking module so as to actively divide the unexecuted second transaction fragment from the complete transaction; executing the second transaction fragment, and using an unexecuted fragment submitting module to forcibly submit the second transaction fragment to generate second result data for storing the second transaction fragment; the technical scheme that the first result data and the second result data are summarized by using the data summarizing module to form a result set obtained by completely executing the complete transaction can keep the breakpoint transaction of the database when interruption occurs, so that the recovery time is saved.
It should be particularly noted that the above embodiment of the transaction processing apparatus adopts the embodiment of the transaction processing method to specifically describe the working process of each module, and those skilled in the art can easily think that these modules are applied to other embodiments of the transaction processing method. Of course, since the steps in the embodiment of the transaction processing method can be mutually intersected, replaced, added, and deleted, these reasonable permutations and combinations should also fall within the scope of the present invention for the transaction processing apparatus, and should not limit the scope of the present invention to the embodiment.
The foregoing is an exemplary embodiment of the present disclosure, but it should be noted that various changes and modifications could be made herein without departing from the scope of the present disclosure as defined by the appended claims. The functions, steps and/or actions of the method claims in accordance with the disclosed embodiments described herein need not be performed in any particular order. Furthermore, although elements of the disclosed embodiments of the invention may be described or claimed in the singular, the plural is contemplated unless limitation to the singular is explicitly stated.
It should be understood that, as used herein, the singular forms "a", "an" and "the" are intended to include the plural forms as well, unless the context clearly supports the exception. It should also be understood that "and/or" as used herein is meant to include any and all possible combinations of one or more of the associated listed items. The numbers of the embodiments disclosed in the embodiments of the present invention are merely for description, and do not represent the merits of the embodiments.
It will be understood by those skilled in the art that all or part of the steps for implementing the above embodiments may be implemented by hardware, or may be implemented by a program instructing relevant hardware, where the program may be stored in a computer-readable storage medium, and the above-mentioned storage medium may be a read-only memory, a magnetic disk or an optical disk, etc.
Those of ordinary skill in the art will understand that: the discussion of any embodiment above is meant to be exemplary only, and is not intended to intimate that the scope of the disclosure, including the claims, of embodiments of the invention is limited to these examples; within the idea of an embodiment of the invention, also technical features in the above embodiment or in different embodiments may be combined and there are many other variations of the different aspects of an embodiment of the invention as described above, which are not provided in detail for the sake of brevity. Therefore, any omissions, modifications, substitutions, improvements, and the like that may be made without departing from the spirit and principles of the embodiments of the present invention are intended to be included within the scope of the embodiments of the present invention.
Claims (10)
1. A transaction processing method, comprising performing the steps of:
passively partitioning an executed first transaction fragment from a complete transaction in response to an interrupt occurring in the complete transaction being executed, in accordance with the interrupt;
forcibly submitting the first transaction fragment by using an executed fragment submitting module to generate first result data for saving the first transaction fragment;
reinitiating the complete transaction, and checking the data consistency of the complete transaction by using a checking module so as to actively divide an unexecuted second transaction fragment from the complete transaction;
executing the second transaction fragment, and using an unexecuted fragment submission module to forcibly submit the second transaction fragment to generate second result data for storing the second transaction fragment;
and summarizing the first result data and the second result data by using a data summarizing module to form a result set obtained by completely executing the complete transaction.
2. The method of claim 1, wherein the second transaction fragment is retired while the first transaction fragment is forced to be committed using an executed fragment commit module to generate first result data that preserves the first transaction fragment.
3. The method of claim 1, wherein passively partitioning an executed first transaction fragment from the complete transaction based on the interrupt comprises: and determining the position of the interruption transaction execution failure in the complete transaction, and determining the transaction before the position as the first transaction fragment.
4. The method of claim 1, wherein checking the complete transaction for data consistency using a check module to proactively partition an unexecuted second transaction fragment from the complete transaction comprises: scanning a database using the verification module to determine potential transactions that are the same as the complete transaction, and determining the second transaction fragment based on a difference between the complete transaction and the potential transactions.
5. The method of claim 1, further persisting the result set to memory and deleting the first result data and the second result data.
6. A transaction processing apparatus, comprising:
a processor; and
a memory storing program code executable by the processor, the program code when executed performing the steps of:
passively partitioning an executed first transaction fragment from a complete transaction in response to an interrupt occurring in the complete transaction being executed, in accordance with the interrupt;
forcibly submitting the first transaction fragment by using an executed fragment submitting module to generate first result data for saving the first transaction fragment;
reinitiating the complete transaction, and checking the data consistency of the complete transaction by using a checking module so as to actively divide an unexecuted second transaction fragment from the complete transaction;
executing the second transaction fragment, and using an unexecuted fragment submission module to forcibly submit the second transaction fragment to generate second result data for storing the second transaction fragment;
and summarizing the first result data and the second result data by using a data summarizing module to form a result set obtained by completely executing the complete transaction.
7. The apparatus of claim 6, wherein the second transaction fragment is retired while the first transaction fragment is forced to be committed using an executed fragment commit module to generate first result data that preserves the first transaction fragment.
8. The apparatus of claim 6, wherein passively partitioning the executed first transaction fragment from the complete transaction according to the interrupt comprises: and determining the position of the interruption transaction execution failure in the complete transaction, and determining the transaction before the position as the first transaction fragment.
9. The apparatus of claim 6, wherein checking the complete transaction for data consistency using a check module to proactively partition an unexecuted second transaction fragment from the complete transaction comprises: scanning a database using the verification module to determine potential transactions that are the same as the complete transaction, and determining the second transaction fragment based on a difference between the complete transaction and the potential transactions.
10. The apparatus of claim 6, wherein the result set is further persisted to memory and the first result data and the second result data are deleted.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010463937.8A CN111708790A (en) | 2020-05-27 | 2020-05-27 | Transaction processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010463937.8A CN111708790A (en) | 2020-05-27 | 2020-05-27 | Transaction processing method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111708790A true CN111708790A (en) | 2020-09-25 |
Family
ID=72538595
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010463937.8A Withdrawn CN111708790A (en) | 2020-05-27 | 2020-05-27 | Transaction processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111708790A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114443652A (en) * | 2022-01-07 | 2022-05-06 | 苏州浪潮智能科技有限公司 | Method, system and device for operating breakpoint SQL |
-
2020
- 2020-05-27 CN CN202010463937.8A patent/CN111708790A/en not_active Withdrawn
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114443652A (en) * | 2022-01-07 | 2022-05-06 | 苏州浪潮智能科技有限公司 | Method, system and device for operating breakpoint SQL |
| CN114443652B (en) * | 2022-01-07 | 2024-01-19 | 苏州浪潮智能科技有限公司 | Breakpoint SQL operation method, system and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11681684B2 (en) | Client-driven commit of distributed write transactions in a database environment | |
| EP3968175B1 (en) | Data replication method and apparatus, and computer device and storage medium | |
| WO2016180164A1 (en) | Method and apparatus for rolling back distributed transaction | |
| US9652519B2 (en) | Replicating data across multiple copies of a table in a database system | |
| EP3111347B1 (en) | Efficient methods and systems for consistent read in record-based multi-version concurrency control | |
| Kemme et al. | Don't be lazy, be consistent: Postgres-R, a new way to implement database replication | |
| US10572508B2 (en) | Consistent query execution in hybrid DBMS | |
| EP2797013B1 (en) | Database update execution according to power management schemes | |
| CN111522631B (en) | Distributed transaction processing method, device, server and medium | |
| US20100274768A1 (en) | De-duplication and completeness in multi-log based replication | |
| US20030217055A1 (en) | Efficient incremental method for data mining of a database | |
| Labio et al. | Efficient resumption of interrupted warehouse loads | |
| CN105608086A (en) | Transaction processing method and device of distributed database system | |
| CN109086382B (en) | Data synchronization method, device, equipment and storage medium | |
| TW201514734A (en) | Database managing method, database managing system, and database tree structure | |
| CN111708790A (en) | Transaction processing method and device | |
| US9384100B2 (en) | Tracking redo completion at a page level | |
| CN117234670B (en) | Distributed transaction processing method, system, computer equipment and storage medium | |
| CN111858504B (en) | Operation merging execution method based on log analysis synchronization and data synchronization system | |
| US7051051B1 (en) | Recovering from failed operations in a database system | |
| CN102193987B (en) | Method and system for increasing node data relationship based on OLTP (online transaction processing) | |
| CN112765126B (en) | Database transaction management method, device, computer equipment and storage medium | |
| CN112612647B (en) | Log parallel replay method, device, equipment and storage medium | |
| CN113190281B (en) | ROWID interval-based initialization loading method and device | |
| US12050586B2 (en) | Rollback-free referential integrity update processing |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WW01 | Invention patent application withdrawn after publication | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20200925 |