Method of and system for collecting an electronic signature for an electronic record stored in a database

• US 7,694,143 B2
• Filed: 12/08/2003
• Issued: 04/06/2010
• Est. Priority Date: 11/18/2003
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Puri, Srinivasulu, Durgada, Savita, Akella, Ravindra, Karimisetty, Srikanth, Singh, Charanjeet
• Primary Examiner(s): Vu; Kimyen
• Assistant Examiner(s): PATEL, NIRAV B
• Application Number:
  US10/731,299
• Publication Number:
  US 20050108536A1
• Time in Patent Office: 2,311 Days
• Field of Search: 713/156, 713/176, 713/180, 713/193, 707/1, 707/9, 707/10, 707/100, 707/102, 707/200, 707/3, 705/50, 705/1, 709/201, 709/229, 709/246, 726 26- 30, 726/1, 726/2
• US Class Current: 713/176
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries
• CPC Class Codes: G06F 2221/2101 Auditing as a secondary aspect

Abstract

A method of and system for collecting an electronic signature for an electronic record stored in a database. In one embodiment the method comprises automatically creating an electronic record from data stored in a plurality of different database tables in response to the occurrence of a predetermined event; storing an instance of the electronic record in a common repository of electronic records that provides an audit trail that cannot be altered or disabled by users of the system; executing a rule associated with the electronic record to determine whether an electronic signature is required to connote review and/or approval of the electronic record; and if execution of the rule results in a determination that an electronic signature is required, marking the instance of the electronic record as unsigned and initiating a request to collect the required electronic signature. In some embodiments the electronic record is stored as unstructured data in a character large object (CLOB) format and the unstructured data comprises a well-formed XML document stored within a column of a table stored in the database.

Claims

1. A method of collecting an electronic signature for an electronic record stored in a database, the method comprising:

receiving, at a processor of a computer system, information provided by a user via a graphical user interface configured to enable users of the computer system to define operations by one or more database applications as triggering conditions for predetermined events monitored by the computer system and processing that occurs when the predetermined events are triggered, the information defining a predetermined event that, upon occurrence, causes the computer system to intercept a database transaction instantiated by one of the database applications with a database management system of a database and generate from data identified in the database transaction an electronic record that requires an electronic signature;

receiving, at the processor of the computer system, information provided by the user via the graphical interface that maps data from underlying database tables associated with execution of one or more operations to be performed by a database application in response to the occurrence of the predetermined event to an electronic record;

receiving, at a processor of a computer system, information indicative of an occurrence of a predetermined event, the predetermined event defined to represent a set of operations to be performed by a database application to accomplish a task;

automatically creating, using the processor of the computer system, an electronic record from data stored in a plurality of different database tables associated with execution of one or more operations in the set of operations based on a mapping in response to the occurrence of the predetermined event;

storing, using the processor of the computer system, an instance of the electronic record in a common repository of electronic records that provides an audit trail that cannot be altered or disabled by users associated with the database;

executing, using the processor of the computer system, a rule associated with the electronic record to determine whether an electronic signature is required to connote review and/or approval of the electronic record; and

if execution of the rule results in a determination that an electronic signature is required, marking, using the processor of the computer system, the instance of the electronic record as unsigned and initiating a request to collect the required electronic signature.

2. The method of claim 1 further comprising receiving an electronic signature from the user;

verifying the electronic signature; and

in response to a positive verification of the electronic signature, marking the electronic record as signed.

3. The method of claim 2 wherein the 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 electronic record comprises unstructured data in a character large object (CLOB) format.

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

6. The method of claim 4 wherein fields of the electronic record are filled with XML data based on a predefined mapping to multiple data sources.

7. The method of claim 1 further comprising the step of, if execution of the rule results in a determination that an electronic signature is required, displaying data from the electronic record on a computer display.

8. The method of claim 7 wherein data from the electronic record is display according to a predefined layout set forth in an XSL style sheet.

9. The method of claim 1 wherein the rule requires a plurality of different electronic signatures and wherein, if execution of the rule results in a determination that a plurality of electronic signatures are required, requesting the plurality of electronic signatures.

10. The method of claim 1 wherein the electronic record is initially marked as unsigned by setting an appropriate attribute associated with a database table in which at least part of the record is stored.

11. A computer system that manages electronic records stored in a database, the computer system comprising:

a processor;

a database; and

a computer-readable memory coupled to the processor, the computer readable memory configured to store a computer program;

wherein the processor is operative with the computer program to;

receive information defining operations by one or more database applications as triggering conditions for predetermined events and processing that occurs when the predetermined events are triggered, the information defining a predetermined event that, upon occurrence, causes the processor to intercept a database transaction instantiated by one of the database applications with a database management system of a database and generate from data identified in the database transaction an electronic record that requires an electronic signature;

receive information that maps data from underlying database tables associated with execution of one or more operations to be performed by a database application in response to the occurrence of the predetermined event to an electronic record;

receive information indicative of an occurrence of a predetermined event, the predetermined event defined to represent a set of operations to be performed by a database application to accomplish a task

automatically create an electronic record from data stored in a plurality of different database tables associated with execution of one or more operations in the set of operations based on a mapping in response to the occurrence of the predetermined event;

store an instance of the electronic record in a common repository of electronic records that provides an audit trail that cannot be altered or disabled by users associated with the database;

execute a rule associated with the electronic record to determine whether an electronic signature is required to connote review and/or approval of the electronic record; and

mark the instance of the electronic record as unsigned and initiate a request to collect the required electronic signature if execution of the rule results in a determination that an electronic signature is required.

12. The computer system of claim 11 wherein the 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.

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

14. The computer system of claim 13 wherein the unstructured data comprises a well formed XML document stored within a column of a table stored in the database.

15. The computer system of claim 14 wherein fields of the electronic record are filled with XML data based on a predefined mapping to multiple data sources.

16. The computer system of claim 11 wherein the processor and computer program are further operative to obtain and verify the electronic signature, and thereafter, mark the electronic record as signed.

17. The computer system of claim 16 wherein the processor and computer program are further operative to initially mark the electronic record as unsigned by setting an appropriate attribute associated with a database table in which at least part of the record is stored.

18. A computer program product having a computer-readable memory medium storing a set of code modules which when executed by a processor of a computer system cause the processor to manage electronic records stored in a database, the computer program product comprising:

code for receiving information provided by a user via a graphical user interface configured to enable users to define operations by one or more database applications as triggering conditions for predetermined events and processing that occurs when the predetermined events are triggered, the information defining a predetermined event that, upon occurrence, causes a computer system to intercept a database transaction instantiated by one of the database applications with a database management system of a database and generate from data identified in the database transaction an electronic record that requires an electronic signature;

code for receiving information provided by the user via the graphical from a user interface that maps data from underlying database tables associated with execution of one or more operations to be performed by a database application in response to the occurrence of the predetermined event to an electronic record;

code for receiving information indicative of an occurrence of a predetermined event, the predetermined event defined to represent a set of operations to be performed by a database application to accomplish a task;

code for automatically creating an electronic record from data stored in a plurality of different database tables associated with execution of one or more operations in the set of operations based on a mapping in response to the occurrence of the predetermined event;

code for storing an instance of the electronic record in a common repository of electronic records that provides an audit trail that cannot be altered or disabled by users associated with the database;

code for executing a rule associated with the electronic record to determine whether an electronic signature is required to connote review and/or approval of the electronic record; and

code for marking the instance of the electronic record as unsigned and initiating a request to collect the required electronic signature if execution of the rule results in a determination that an electronic signature is required.

19. The computer program product of claim 18 wherein the 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.

20. The computer program product of claim 19 wherein the electronic record comprises unstructured data in a character large object (CLOB) format.

21. The computer program product of claim 20 wherein the unstructured data comprises a well-formed XML document stored within a column of a table stored in the database.

22. The computer program product of claim 21 wherein fields of the electronic record are filled with XML data based on a predefined mapping to multiple data sources.

23. The computer program product of claim 18 further comprising code for obtaining and verifying the electronic signature, and thereafter, marking the electronic record as signed.

24. The computer program product of program 23 further comprising code for initially marking the electronic record as unsigned by setting an appropriate attribute associated with a database table in which at least part of the record is stored.

25. A computer-implemented method of collecting an electronic signature for an electronic record stored in a database, the method comprising:

receiving, at a processor of a computer system, information provided by a user via a graphical user interface configured to enable users to define operations by one or more database applications as triggering conditions for events associated with industrial processes monitored by the computer system and processing that occurs when the events are triggered, the information defining an event associated with an industrial process that, upon occurrence, causes the computer system to intercept a database transaction instantiated by one of the database applications with a database management system of a database and generate from data identified in the database transaction an electronic record that requires an electronic signature;

receiving, at the processor of the computer system, information provided by the user via the graphical user interface that maps data from underlying database tables associated with execution of one or more operations to be performed by a database application in response to the occurrence of the event to an electronic record;

receiving, at a processor of a computer system, information indicative of occurrence of one or more events associated with an industrial process, each event in the one or more events indicative of a set of one or more operations to be performed by a database application to accomplish a task in the industrial process;

storing data in the database in a plurality of different database tables using the processor of the computer system in response to execution of one or more operations associated with the one or more events, the data related to the execution of the one or more operations;

generating, using the processor of the computer system, an electronic record in response to an occurrence of a predetermined event in the one or more events from at least a portion of the data stored in the plurality of different database tables;

storing, using the processor of the computer system, an instance of the electronic record as a well-formed XML document that tracks the predetermined event in a common repository of electronic records that provides an audit trail that cannot be altered or disabled by users associated with the database;

executing, using the processor of the computer system, a rule associated with the electronic record to determine whether an electronic signature is required to connote review and/or approval of the electronic record; and

if execution of the rule results in a determination that an electronic signature is required, marking the instance of the electronic record as unsigned;

requesting, using the processor of the computer system, an electronic signature for the electronic record;

after obtaining the electronic signature, verifying its authenticity using the processor of the computer system; and

if the electronic signature is verified as authentic, marking the electronic record as signed using the processor of the computer system prior to committing the database transaction to the database.