Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for integrating native transaction and logical transaction

A transaction and logic technology, applied in the field of cloud computing, can solve the problems of logical transactions having no practical use, unclear requirements, blocking, etc., to achieve the effect of easy promotion, strong practicability, and deadlock resolution

Inactive Publication Date: 2014-12-10
INSPUR COMMON SOFTWARE
View PDF4 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] 1. It may lead to deadlock or blocking. In the same logical transaction, the business code requires the resource to be locked before the write operation. If the lock fails, all locks under the same function sessionID need to be unlocked
[0005] 2. Transaction isolation level. In theory, the isolation level of logical transactions has no practical use. It is mainly used for database transactions. The current requirements are not very clear
[0006] 3. Transaction nesting, users need to care about the transaction isolation level, and need to understand the upper-level transactions

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
  • Method for integrating native transaction and logical transaction

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0031] Embodiment: The following content is the data access of an instance of this method, and this instance applies transaction nesting.

[0032] Its specific implementation process is:

[0033] 1. Define the external transaction execution mode and transaction boundary type, and create logical transactions.

[0034] var ltrans = new GSPTransactionScope(GSPTransactionScopeOption, ScopeType.

[0035] 2. Perform data operations, create database instance objects, store the Sql statements to be executed, function SessionIDs, and database object names in thread-safe collections, see the following code:

[0036] using (var db = GSPDatabaseFactory. GetDataBase())

[0037] {

[0038] db. ExecSqlStatement(sql);

[0039] }

[0040] public override int ExecSqlStatement(string sqlStatement)

[0041] {

[0042] CheckForNullReference(sqlStatement, "sqlStatement");

[0043] int result = 0;

[0044] ...

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 method for integrating a native transaction and a logical transaction. The method includes the steps of creating a transaction, starting the transaction, subjecting the transaction to transaction management, submitting the transaction, and rolling back the transaction. Compared with the prior art, the method has the advantages that a logical transaction type and a logical transaction boundary type are applied, a user can start the transaction or directly submit the transaction, execution of submission and rollback of the logical transaction is determined according to the current transaction boundary type, inter-transaction deadlock is solved, and practicality is high.

Description

technical field [0001] The invention relates to the technical field of cloud computing, in particular to a method with strong practicability and fusion of native transactions and logical transactions. Background technique [0002] A database transaction is a sequence of operations performed as a single logical unit of work that is either fully performed or not performed at all. Transactions ensure that data-oriented resources are not permanently updated unless all operations within the transactional unit complete successfully. By grouping a set of related operations into an all-or-nothing unit, error recovery is simplified and applications are made more reliable. However, the database transaction must ensure that the transaction is in the same application, which is not applicable to the use between multiple frameworks, and it cannot guarantee that the operations between multiple frameworks are managed by the same transaction. [0003] In addition, using the combination of ...

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): G06F17/30
CPCG06F16/2308
Inventor 周仑王震
Owner INSPUR COMMON SOFTWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products