System for heterogeneous distributed transaction management in database systems
AssigneeInternational Busniess Machines Corporation
InventorRaghupathi Keshava Murthy
Life of this patent
Estimating the term…
Abstract
Disclosed is a mechanism that can be implemented in database systems to support distributed transactions in heterogeneous systems. Once the transaction manager of a database system implements this mechanism, application developers and vendors can integrate new datasources into the transaction manager of the database system. This would simplify the application design and ensure the integrity of data and interactions. The interface and interactions between the transaction manager and external datasources (both structured and non-structured) conform to X/Open XA standards. Also disclosed is a technique to design the system catalogs for organizing the datasources and instances of the new datasources.
Claims19
A database engine comprising:
- a transactional mechanism supporting heterogeneous distributed transactions, said transactional mechanism having:
- means for recognizing data sources conforming to an industry standard interface for interaction between a transaction manager and resource manager, said data sources including structured and non-structured external data sources;
- and
- means for managing transactions in which said data sources participate by:
- generating a global transaction identifier for each distributed transaction;
- accessing support functions for data source types for data sources registered to participate in the transaction identified by the global transaction identifier;
- and
- maintaining a list of all of the recognized heterogeneous data sources that participated in the global transaction identified by the global transaction ID.
A database server comprising:
- a database engine comprising:
- a transactional mechanism supporting heterogeneous distributed transactions, said transactional mechanism having:
- means for recognizing data sources conforming to an industry standard interface for interaction between a transaction manager and resource manager said data sources including structured and non-structured external data sources;
- means for managing transactions in which said data sources participate:
- generating a global transaction identifier for each distributed transaction;
- accessing support functions for data source types for data sources registered to participate in the transaction identified by the global transaction identifier;
- and
- maintaining a list of all of the recognized heterogeneous data sources that participated in the global transaction identified by the global transaction ID.
A method of integrating a database system to support heterogeneous distributed transactions, comprising:
- recognizing data sources conforming to an industry standard interface for interaction between a transaction manager and resource manager, said data sources including structured and non-structured data sources external to said database system;
- and
- configuring a database engine with a transactional mechanism, said transactional mechanism managing said heterogeneous distributed transactions in which said data sources participate, wherein said transactional mechanism is capable of managing transactions in which said data sources participate by:
- generating a global transaction identifier for each distributed transaction;
- accessing support functions for data source types for data sources registered to participate in the transaction identified by the global transaction identifier;
- and
- maintaining a list of all of the recognized heterogeneous data sources that participated in the global transaction identified by the global transaction ID.
Dependencies are inferred from the claim text.