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

Method for managing distributed savepoints across multiple DBMS's within a distributed transaction

A management system and savepoint technology, applied in the field of savepoint management, can solve problems such as unsuccessful notification of transactions, failure of venues or communication links, etc.

Inactive Publication Date: 2007-02-14
IBM CORP
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0021] 5. ROLLBACK (rollback) or ABORT (abort), notify the transaction that the transaction is unsuccessfully ended, and must be rolled back, that is, the modification to the database must be undone
Also, it must handle submission processes that access database fragments and replicas stored at multiple sites, where some sites or communication links may fail during the submission process

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 managing distributed savepoints across multiple DBMS's within a distributed transaction
  • Method for managing distributed savepoints across multiple DBMS's within a distributed transaction
  • Method for managing distributed savepoints across multiple DBMS's within a distributed transaction

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0139] The present invention is a method, system and program product for setting, rolling back and releasing save points across multiple database management systems (DBMS) in a distributed transaction spanning multiple DBMSs. Typically, the method, system and program product of the present invention are used in conjunction with a relational database management system (RDBMS), but the method, system and program product of the present invention can also be used with any DBMS that uses SQL (Structured Query Language) use. Using the SAVEPOINT SQL statement, you can distinguish the milestones within the transaction. Then, the data and schema modifications made since the save point can be undone according to the application logic, without affecting the overall result of the transaction. Rolling back to a savepoint can also be used to optionally close SQL cursors that have been opened since the savepoint was created.

[0140] The present invention provides a method to uniquely establish ...

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

System, method, and program product for managing transactions on a plurality of Database Management Systems residing on separate participant servers and a coordinator server. A single transaction proceeds by multiple steps across more then one of the plurality of Database Management Systems as participants. Savepoints are assigned to the participants across the Database Management System, with at least one savepoint within a multiple step transaction. The DBMS responds to application requests to rollback to savepoint by rolling back the transaction, across the Database Management System participants, to the savepoint Further disclosed is a program product that contains code, which, either as written on the medium, or as instantiated in RAM, or both, controls the operation of a distributed database management system.

Description

Technical field [0001] The invention relates to a distributed database management system and the management of save points in the distributed database management system. Background technique [0002] A database is a warehouse of collected, recorded, and related data. It has intrinsic value in terms of the concentration of data elements, the logical consistency of the data, the intrinsic meaning of the data, and the data can be used. In addition, due to the accessibility of database organization, records and files and the dynamic updateability of data, the value of the database far exceeds the value of the sum of the various elements of the database. Routine, repetitive and consistent adding data to the database and the ability to restore relevant, timely and correct data from the database are the functions of its database management system (DBMS). A DBMS is a set of computer applications that create a database organization (schema and metadata), and store, retrieve, and update fi...

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): G06F17/30G06F12/00G06F11/14
CPCG06F17/30575Y10S707/99952G06F17/30286G06F11/1474G06F17/30353Y10S707/99938G06F2201/80G06F16/27G06F16/2322
Inventor 柯蒂斯·库特纳詹姆斯·皮克尔朱利恩·瓦茨
Owner IBM CORP
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com