Method of and system for committing a transaction to database

• US 8,782,020 B2
• Filed: 12/08/2003
• Issued: 07/15/2014
• Est. Priority Date: 11/18/2003
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Karimisetty, Srikanth, Akella, Ravindra, Durgada, Savita, Rastogi, Sanjay, Gupta, Manish, Danese, John
• Primary Examiner(s): Shmatov, Alexey
• Application Number:
  US10/731,655
• Publication Number:
  US 20050108295A1
• Time in Patent Office: 3,872 Days
• Field of Search: 713/179, 713/176, 707/9, 707/10, 707/703, 707/694
• US Class Current: 707/694
• CPC Class Codes: G06F 16/8373 Query execution

Abstract

A method of and system for committing a transaction to a database. In one embodiment the method comprises initiating a database transaction; creating an electronic record that includes transaction data from the database transaction; executing a rule associated with the record to determine whether an electronic signature is required to connote review and/or approval of the electronic record, and requesting the electronic signature prior to committing the transaction to the database if execution of the rule results in a determination that an electronic signature is required.

Claims

1. A method comprising:

detecting, at one or more computer systems, an occurrence of a predefined business event of a type associated with first electronic records to be created from database transaction data in response to initiation of database transactions, the first electronic records being different from second electronic records resulting from completion of the database transactions with the database transaction data;

intercepting, at one or more computer systems, database transaction data to be committed to a database resulting from a database transaction initiation between one or more database applications and a database using a framework engine in response to detection of the occurrence of the predefined event of the type associated with first electronic records;

generating, at one or more computer systems, an electronic record based on the database transaction data that is different from one or more electronic records resulting from completion of the initiated database transaction, an electronic record definition associated with the generated electronic record defining one or more fields to include in the generated electronic record, and information that maps data from underlying database tables to at least some of the one or more fields of the generated electronic record using the framework engine;

instantiating, at one or more computer systems, a workflow process to determine whether an electronic signature is required to connote approval of the generated electronic record using the framework engine; and

committing the database transaction data to the database to generate the one or more electronic records resulting from completion of the initiated database transaction, using the one or more computer systems, in response to receiving the electronic signature to connote approval of the generated electronic record.

2. The method of claim 1 wherein the generated electronic record comprises data generated from multiple tables of the database.

3. The method of claim 1 wherein the generated electronic record is stored in a common repository of electronic records that provides an audit trail that cannot be altered or disabled by users of the database.

4. The method of claim 1 wherein the generated electronic record is stored as data in a character large object (CLOB) format.

5. The method of claim 4 wherein the data comprises a well-formed XML document stored within a column of a database table.

6. The method of claim 5 wherein XML fields of the data are filled with the database transaction data based on a predefined mapping of a data type definition to multiple data sources.

7. The method of claim 1 further displaying at least some of the database transaction data in the generated electronic record on a computer display based on the determination that an electronic signature is required.

8. The method of claim 7 wherein the database transaction data in the generated electronic record is displayed according to a predefined layout set forth in an XSL style sheet associated with data comprising a copy of the generated electronic record as displayed, wherein the data is stored within a column of a database table.

9. The method of claim 1 further comprising obtaining and verifying the electronic signature.

10. The method of claim 9 wherein, if the electronic signature is rejected or otherwise cannot be obtained, the database transaction is rolled-back and not committed to the database.

11. The method of claim 1 wherein the instantiating the workflow process includes executing a rule to determine whether a plurality of electronic signatures are required prior to committing the database transaction data to the database.

12. A computer system comprising:

a processor; and

a computer-readable memory coupled to the processor, the computer-readable memory storing a set of instructions executable by the processor to;

detect an occurrence of a predefined business event of a type associated with first electronic records to be created from database transaction data in response to initiation of database transactions, the first electronic records being different from second electronic records resulting from completion of the database transactions with the database transaction data;

intercept database transaction data to be committed to a database resulting from a database transaction initiation between one or more database applications and a database using a framework engine in response to detection of the occurrence of the predefined event of the type associated with first electronic records;

generate an electronic record based on the database transaction data that is different from one or more electronic records resulting from completion of the initiated database transaction, an electronic record definition associated with the generated electronic record defining one or more fields to include in the generated electronic record, and information that maps data from underlying database tables to at least some of the one or more fields of the generated electronic record using the framework engine;

instantiate a workflow process to determine whether an electronic signature is required to connote approval of the generated electronic record using the framework engine; and

commit the database transaction data to the database to generate the one or more electronic records resulting from completion of the initiated database transaction in response to receiving the electronic signature to connote approval of the generated electronic record.

13. The computer system of claim 12 wherein the generated electronic record comprises data generated from multiple tables of the database.

14. The computer system of claim 12 wherein the generated electronic record is stored in a common repository of electronic records that provides an audit trail that cannot be altered or disabled by users of the system.

15. The computer system of claim 12 wherein the generated electronic record comprises data in a character large object (CLOB) format.

16. The computer system of claim 15 wherein the data comprises a well-formed XML document stored within a column of a table stored in the database.

17. The computer system of claim 16 wherein fields of the electronic record are filled with the database transaction data based on a predefined mapping of a data type definition to multiple data sources.

18. The computer system of claim 12 wherein the processor is further operative with the computer program to obtain and verify the electronic signature.

19. A non-transitory computer-readable medium storing code executable by a process of a computer system, the non-transitory computer-readable storage medium comprising:

code for detecting an occurrence of a predefined business event of a type associated with first electronic records to be created from database transaction data in response to initiation of database transactions, the first electronic records being different from second electronic records resulting from completion of the database transactions with the database transaction data;

code for intercepting database transaction data to be committed to a database resulting from a database transaction initiation between one or more database applications and a database using a framework engine in response to detection of the occurrence of the predefined event of the type associated with first electronic records;

code for generating an electronic record based on the database transaction data that is different from one or more electronic records resulting from completion of the initiated database transaction, an electronic record definition associated with the generated electronic record defining one or more fields to include in the generated electronic record, and information that maps data from underlying database tables to at least some of the one or more fields of the generated electronic record using the framework engine;

code for instantiating a workflow process to determine whether an electronic signature is required to connote approval of the generated electronic record using the framework engine; and

code for the database transaction data to the database to generate the one or more electronic records resulting from completion of the initiated database transaction in response to receiving the electronic signature to connote approval of the generated electronic record.

20. The non-transitory computer-readable medium of claim 19 wherein the generated electronic record is stored in a common repository of electronic records that provides an audit trail that cannot be altered or disabled by users of the system.

21. The non-transitory computer-readable medium of claim 20 wherein the generated electronic record comprises data in a character large object (CLOB) format.

22. The non-transitory computer-readable medium of claim 21 wherein the data comprises a well-formed XML document stored within a column of a table stored in the database.

23. The non-transitory computer-readable medium of claim 22 wherein fields of the electronic record are filled with the database transaction data based on a predefined mapping of a DTD to multiple data sources.

24. The non-transitory computer-readable medium of claim 19 further comprising code for obtaining and verifying the electronic signature.

25. A computer-implemented method of committing a transaction to a database, the method comprising:

communicating, to one or more destination computer systems, information configured for generating one or more user interfaces enabling users at the one or more destination computer systems to define business events;

receiving, at one or more computer systems, a user-specified business event via the one or more user interfaces that, upon occurrence, causes a database management system to intercept database transactions before the database transactions are committed to databases provided by the database management system, the database transactions representative of the business event and instantiated between the one or more database applications and the database management system;

receiving, at the one or more computer systems, a user-specified data type definition (DTD) via the one or more user interfaces defining one or more fields to include in XML documents automatically generated from data in the database transactions representative of the business event, the electronic record definition requiring the electronic records to have at least one electronic signature;

receiving, at the one or more computer systems, a user-specified XSL style sheet via the one or more user interfaces that defines layout settings for formatting and presenting the automatically generated XML documents;

receiving, at the one or more computer systems, information via the one or more user interfaces that maps data from underlying database tables associated with the database transaction to at least some of the one or more fields defined in the DTD;

storing in a storage device associated with the one or more computer systems, the DTD and the XSL style sheet in association with the business event based on the information that maps data from underlying database tables associated with the database transactions to at least some of the one or more fields defined in the DTD;

determining, with one or more processor associated with the one or more computer systems, that a database transaction between a database application and the database management system satisfies an occurrence condition of the business event and intercepting transaction data from the database transaction prior to the database management system committing the database transaction to a database of the database management system;

creating, with the one or more processor associated with the one or more computer systems, an electronic record prior to the database management system committing the associated database transaction to the database, wherein the electronic record comprises the intercepted transaction data prepared by the computer system using a set of XML mappings associated with the user-created-event and storing the electronic record as a well-formed XML document in a character large-object (CLOB) format of a column of a database table;

executing a rule associated with the business event to determine whether an electronic signature is required to connote review of the XML document in order for the database management system to commit the database transaction to the database;

if execution of the rule results in a determination that an electronic signature is required, (i) displaying the transaction data in the XML document according to a predefined layout set forth in the XSL style sheet associated with the business event and storing a copy of the transaction data as displayed in a character large-object (CLOB) format of a second column of the database table and (ii) requesting, obtaining and verifying the electronic signature prior to the database management system committing the transaction into a database; and

committing the transaction to the database in response to verifying the electronic signature.