Patent ID: 7770186
Filing Date: 2010-08-03
Classification: G06F

Abstract:
1. A system providing a framework for transaction integration, the system comprising: an external computing system which allows a connection to a local computing system database server processor; and the local computing system database server processor configured to perform the steps of: running a user code associated with a runtime environment that is hosted on a database system, wherein the user code is executable code that is not an intrinsic part of the database system, and wherein the user code was created and deployed into the database system for execution; detecting a transaction within the database system; responsive to the detecting of the database system transaction, introducing an ambient transaction to the user code, wherein the ambient transaction is presented via an application programming interface, wherein the application programming interface implements a distributed transaction without the user code delineating between the distributed and a local transaction; propagating the ambient transaction automatically to the external computing system upon a connection established by the user code with the external computing system, wherein the propagating of the ambient transaction to the external computing system comprises passing an identifier of the transaction associated with the database system to a resource manager of the external computing system, wherein the ambient transaction contains a list of tasks to perform, and wherein the propagating of the ambient transaction to the external computing system upon the connection established by the user code with the external computing system is performed without user interaction; and wherein the local computing system database server processor programmed to perform the steps further comprising coordinating of the transaction associated with the database system and the transaction associated with the external computing system resulting in a single coordinated transaction; wherein the coordinating of the transaction is managed by transaction coordinators, wherein there is a root database transaction coordinator which manages relationships between transaction coordinators on different computing systems.