Method of and system for collecting an electronic signature for an electronic record stored in a database
First Claim
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.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
25 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
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. - View Dependent Claims (12, 13, 14, 15, 16, 17)
-
-
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. - View Dependent Claims (19, 20, 21, 22, 23)
-
-
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.
-
Specification