Source: http://www.google.com/patents/US7600124?dq=5815142
Timestamp: 2017-11-20 18:26:03
Document Index: 473204785

Matched Legal Cases: ['Application No. 60', 'art 11', 'art 11', 'art11', 'art 11', 'art 11', 'art 11', 'art 11', 'art 11']

Patent US7600124 - Method of and system for associating an electronic signature with an ... - Google Patents
A method of and system for associating an electronic signature with an electronic record in a computer system. In one embodiment the method comprises allowing a user to define an event that, upon occurrence, generates an electronic record that requires an electronic signature; allowing a user to define...http://www.google.com/patents/US7600124?utm_source=gb-gplus-sharePatent US7600124 - Method of and system for associating an electronic signature with an electronic record
Publication number US7600124 B2
Application number US 10/731,657
Also published as US20050108283
Publication number 10731657, 731657, US 7600124 B2, US 7600124B2, US-B2-7600124, US7600124 B2, US7600124B2
Inventors Srikanth Karimisetty, Srinivasulu Puri, Charanjeet Singh, Ravindra Akella, Savita Durgada
Patent Citations (71), Non-Patent Citations (18), Referenced by (6), Classifications (4), Legal Events (4)
US 7600124 B2
1. A computer-implemented method of associating an electronic signature with an electronic record, the method comprising:
receiving, at a computer system configured to manage a database of electronic records, first 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 application events monitored by the computer system and processing that occurs when the application events are triggered, the first information defining an application 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 computer system, second information provided by the user via the graphical user interface, the second information defining one or more fields for data to be stored in the electronic record;
receiving, at the computer system, third information provided by the user via the graphical user interface, the third information providing a mapping between data from underlying database tables associated with the database transaction to at least some of the fields defined for data to be stored in the electronic record;
receiving, at the computer system, fourth information provided by the user via the graphical user interface, the fourth information defining a layout that is applicable when an electronic signature is collected for the electronic record for displaying data stored in the electronic record on a computer display;
receiving, at the computer system, fifth information provided by the user via the graphical user interface, the fifth information identifying a signatory approver for the electronic record;
in response to detecting the occurrence of the application event at the computer system when the one of the database applications instantiates the database transaction associated with the application event with the database management system of a database, automatically generating the electronic record with the computer system from data intercepted from the database transaction according to the mapping between the data from the underlying database tables associated with the database transaction to the at least some of the fields in the electronic record;
displaying the electronic record using the computer system to the signatory approver according to the defined layout in order to collect an electronic signature for the electronic record;
receiving, at the computer system, an electronic signature from the signatory approver for the electronic record; and
generating, by the computer system, sixth information associating the electronic signature from the signatory approver with the electronic record prior to performing an action with the computer system that results in committing the database transaction to the database associated with the database management system.
2. The method of claim 1 further comprising verifying the electronic signature at the computer system prior to associating the electronic signature with the electronic record.
3. The method of claim 2 wherein associating the electronic signature with the electronic record comprise associating by the computer system the electronic signature with the electronic record in response to a positive verification of the electronic signature.
5. The method of claim 1 further comprising verifying the electronic signature by the computer system and storing the electronic record with the computer system in a common repository of electronic records that are generated from multiple data sources.
receiving, at the computer system, seventh information provided by the user via the graphical user interface, the seventh information specifying a set of business rules associated with the application event;
determining, with the computer system, a business rule from the set of business rules associated with the application event; and
executing the business rule with the computer system to determine whether an electronic signature is required to connote review or approval of the electronic record.
9. A computer system that manages a database of electronic records, the computer system comprising:
(i) receive first information provided by a user via a graphical user interface configured to enable users of the graphical user interface to define operations by one or more database applications as triggering conditions for application events and processing that occurs when the application events are triggered, the first information defining an application 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;
(ii) receive second information provided by the user via the graphical user interface, the second information defining one or more fields for data to be stored in the electronic record;
(iii) receive third information provided by the user via the graphical user interface, the third information providing a mapping between data from underlying database tables associated with the database transaction to at least some of the fields defined for the electronic record;
(iv) receive fourth information provided by the user via the user interface, the fourth information defining a layout that is applicable when an electronic signature is collected for the electronic record for displaying data stored in the electronic record on a computer display;
(v) receive fifth information provided by the user via the graphical user interface, the fifth information identifying a signatory approver for the electronic record;
(vi) intercept data from the database transaction instantiated by the one of the database applications with the database management system of a database to generate the electronic record in response to detecting the occurrence of the application event, the electronic record generated by the processor according to the mapping between the data from the underlying database tables associated with the database transaction to the at least some of the fields in the electronic record;
(vii) receive an electronic signature from the signatory approver for the electronic record; and
(viii) generate sixth information that associates the electronic signature from the signature approver with the electronic record prior to performing an action committing the database transaction instantiated by the one of the database applications with the database management system of a database to the database associated with the database management system.
11. The computer system of claim 10 wherein processor is operative to associate the electronic signature with the electronic record in response to a positive verification of the electronic signature.
16. The computer system of claim 9 wherein the processor is further operative to:
determine a business rule from a set of business rules associated with the application event; and
execute the business rule to determine whether an electronic signature is required to connote review or approval of the electronic record.
17. A computer program product embodied on a computer-readable storage medium configured to store a set of code modules which when executed by a processor of a computer system cause the processor to manage a database of electronic records, the computer program product comprising:
code for displaying a graphical user interface configured to enable users of the graphical user interface to define operations in one or more database applications as triggering conditions for application events and processing that occurs when the application events are triggered;
code for receiving first information provided by a user via the graphical user interface, the first information defining an application event that, upon occurrence, causes a database transaction instantiated by one of the database applications with a database management system of a database to be intercepted and an electronic record that requires an electronic signature to be generated from data identified in the database transaction;
code for receiving second information provided by the user via the graphical user interface, the second information defining one or more fields for data to be stored in the electronic record;
code for receiving third information provided by the user via the graphical user interface, the third information providing a mapping between data from underlying database tables associated with the database transaction to at least some of the fields defined for data to be stored in the electronic record;
code for receiving fourth information provided by the user via the graphical user interface, the fourth information defining a layout that is applicable when an electronic signature is collected for the electronic record for displaying data stored in the electronic record on a computer display;
code for receiving fifth information provided by the user via the user interface, the fifth information identifying a signatory approver for the electronic record;
code for, in response to detecting the occurrence of the application event when the one of the database applications instantiates the database transaction with the database management system of a database, generating the electronic record from data intercepted from the database transaction according to the mapping between the data from the underlying database tables associated with the database transaction to the at least some of the fields in the electronic record;
code for displaying the electronic record to the signatory approver according to the defined layout in order to collect an electronic signature;
code for receiving an electronic signature from the signatory approver for the electronic record; and
code for generating sixth information associating the electronic signature from the signatory approver with the electronic record prior to performing an action that results in committing the database transaction to the database associated with the database management system.
18. The computer program product of claim 17 further comprising code for verifying the electronic signature.
19. The computer program product of claim 18 wherein the electronic signature comprises a user id and a password.
20. The computer program product of claim 18 further comprising code for storing the electronic record in a common repository of electronic records that are generated from multiple data sources.
21. The computer program product of claim 20 wherein the electronic record comprises unstructured data in a character large object (CLOB) format.
22. The computer program product of claim 21 wherein the common repository is a database and wherein the unstructured data is a well-formed XML document stored within a column of a table stored in the database.
This application claims the benefit of U.S. Provisional Application No. 60/523,221, entitled eSIGNATURES AND eRECORDS SYSTEM, by Srikanth Karimisetty et al., filed Nov. 18, 2003, the disclosure of which is incorporated herein by reference. This application is also being filed concurrently with U.S. application Ser. No. 10/731,673, entitled METHOD OF AN SYSTEM FOR SEARCHING UNSTRUCTURED DATA STORED IN A DATABASE, by Srikanth Karimisetty et al.; and with U.S. application Ser. No. 10/731,604, entitled METHOD OF AND SYSTEM FOR CREATING QUERIES THAT OPERATE ON UNSTRUCTURED DATA STORED IN A DATABASE, by Srikanth Karimisetty et al. and with U.S. application Ser. No. 10/731,655, entitled METHOD OF AND SYSTEM FOR COMMITTING A TRANSACTION TO A DATABASE, by Srikanth Karimisetty et al.; and with U.S. application Ser. No. 10/731,299, entitled METHOD OF AND SYSTEM FOR COLLECTING AN ELECTRONIC SIGNATURE FOR AN ELECTRONIC RECORD STORED IN A DATABASE, by Srikanth Karimisetty et al.; and with U.S. application Ser. No. 10/731,623, entitled METHOD OF AND SYSTEM FOR DETERMINING IF AN ELECTRONIC SIGNATURE IS NECESSARY IN ORDER TO COMMIT A TRANSACTION TO A DATABASE, by Srinivasulu Puri et al. the disclosures of which are incorporated herein by reference.
US5434917 * Oct 13, 1993 Jul 18, 1995 Thomson Consumer Electronics S.A. Unforgeable identification device, identification device reader and method of identification
US5884321 Oct 10, 1997 Mar 16, 1999 Meffert; Gregory John Document image and query management system for application databases
US6456955 Dec 5, 2000 Sep 24, 2002 Waters Investments Limited Automated test protocol
US6947945 Mar 21, 2000 Sep 20, 2005 International Business Machines Corporation Using an XML query language to publish relational data as XML
US7039807 * Jan 23, 2001 May 2, 2006 Computer Associates Think, Inc. Method and system for obtaining digital signatures
US7089235 Apr 17, 2003 Aug 8, 2006 International Business Machines Corporation Method for restricting queryable data in an abstract database
US7093133 Dec 20, 2001 Aug 15, 2006 Hewlett-Packard Development Company, L.P. Group signature generation system using multiple primes
US7093207 Nov 17, 2003 Aug 15, 2006 Kla-Tencor Technologies Corporation Data analysis flow engine
US7143103 Jun 15, 2000 Nov 28, 2006 University College London Method and apparatus for monitoring and maintaining the consistency of distributed documents
US7146500 Nov 14, 2001 Dec 5, 2006 Compass Technology Management, Inc. System for obtaining signatures on a single authoritative copy of an electronic record
US7165179 Oct 29, 2001 Jan 16, 2007 International Business Machines Corporation Digital signature verification and program transmission
US7210037 Dec 15, 2000 Apr 24, 2007 Oracle International Corp. Method and apparatus for delegating digital signatures to a signature server
US7337950 Jul 28, 2004 Mar 4, 2008 Devault Ricky W Transaction workflow and data collection system
US20010039545 Mar 20, 2001 Nov 8, 2001 Hidekazu Nishizawa Method of managing an electronic file and a computer program product
US20020023083 Apr 17, 2001 Feb 21, 2002 Durkalski Wesley Paul Systems and methods for enabling an untrained or novice end-user to rapidly build clinical trials data management systems compliant with all appropriate regulatory guidances
US20020040431 Sep 17, 2001 Apr 4, 2002 Takehisa Kato Computer program product and method for exchanging XML signature
US20020107652 Dec 5, 2000 Aug 8, 2002 Andrews Richard Wayne Automated test protocol
US20020143726 Mar 14, 2001 Oct 3, 2002 Planalp John Eugene System and method for managing product development
US20020157006 Apr 16, 2002 Oct 24, 2002 Hitachi, Ltd. Signature verifying method and its apparatus
US20030061158 Sep 24, 2002 Mar 27, 2003 Guy Tami L. Method of credit approval
US20030069795 Sep 23, 2002 Apr 10, 2003 Boyd Amy Hancock Supplier data management system
US20030069894 Sep 17, 2001 Apr 10, 2003 Darlene Cotter Computer-based system for assessing compliance with governmental regulations
US20030078880 Nov 19, 2002 Apr 24, 2003 Nancy Alley Method and system for electronically signing and processing digital documents
US20030088776 Oct 2, 2002 May 8, 2003 Along Lin Method and apparatus for evidence generation
US20030131241 Oct 21, 2002 Jul 10, 2003 Gladney Henry M. Trustworthy digital document interchange and preservation
US20030177041 Mar 15, 2002 Sep 18, 2003 Millican Hansel Brady Systems and methods for creating and online viewing of pathology reports
US20040039706 Jun 19, 2003 Feb 26, 2004 Skowron John M. System and method for digitally authenticating facility management reports
US20040068757 Sep 9, 2003 Apr 8, 2004 Heredia Edwin Arturo Digital signatures for digital television applications
US20040123108 Sep 12, 2003 Jun 24, 2004 Winkler Kay Hans-Peter Signature validation and generation
US20040187127 Feb 24, 2004 Sep 23, 2004 Albert Gondi Systems and methods for transaction chaining
US20040236660 May 19, 2003 Nov 25, 2004 Thomas T. Randal Multiparty transaction system
US20050044369 Oct 15, 2001 Feb 24, 2005 Lakshminarayanan Anantharaman Electronic document management system
US20050132201 Sep 23, 2004 Jun 16, 2005 Pitman Andrew J. Server-based digital signature
US20050240770 Jun 22, 2004 Oct 27, 2005 Kathleen Lane System, method and computer-readable medium to issue an electronic signature in association with a checksum of a document
1 "21CFR Part 11 Opportunity or Challenge? With an Analysis of Oracle's OPM," Life Science CIO Forum, www.lifesciencesCIOforum.com, pp. 1-14 (2002).
2 "FDA 21 CFR Part 11," Document Resources, http://www.documentresources.com/document/21cfrpart11.html, pp. 1-2, printed Jun. 23, 2003.
3 "The Role of Technology Solutions in the Pharmaceutical and Biotechnology Industries' Search for 21 CFR Part 11 Compliance," Life Science CIO Forum, www.lifesciencesCIOforum.com, pp. 1-7 (2002).
4 * Aversano et al., "Integrating Document and Workflow Management Tools using XML and Web Technologies: a Case Study", IEEE, 2002, Proceedings of the Sixth European Conference on Software Maintenance and Reengineering.
5 Bertino et al. "Integrating XML and Databases" IEEE Internet Computing Jul.-Aug. 2001.
6 Chueh et al., "An XML Portable Chart Format," 1998, Proc AMIA Symp., pp. 730-734.
7 FDA, Guidance for Industry Part 11, Electronic Records; Electronic Signatures-Scope and Application, Aug. 2003.
8 Mathieson, "Implementing Oracle Workflow," European Oracle User Group 1999 Presentation pp. 1-11.
9 Meehan, "Deploying Hummingbird Document and Records Management Products to Comply with 21 CFR Part 11: Electronic Records; Electronic Signatures," Apr. 2003, Hummingbird.
10 Muirhead, "Impact of 21 CFR Part 11 on clinical laboratories: An overview," Aug. 2001, American Clinical Laboratory, pp. 33-34.
11 Noferi et al. "Information Age Audits" BioPharm Jan. 2002 pp. 35-39 and 50.
12 Oracle, "Question & Answer Document for Oracle Appsworld" Jan. 19-22, 2003, pp. 1-81.
13 Oracle, Oracle Life Sciences Platform Feature Summary, Feb. 2003, Oracle Corp.
14 Oracle, Oracle Workflow Release 2.6.2 Business Event System and PL/SQL Development Guidelines Oct. 2001 26 pages.
15 Papazoglou, "The World of e-Business: Web-Services, Workflows, and Business Transactions" WES 2002, LNCS 2512, pp. 153-173,2002.
16 SmarTeam, SmarTeam(TM) FDA Compliance Technical Paper Functional Compliance With FDA Rule 21 CFR Part 11, Jul. 2002, SmarTeam Corp.
17 SmarTeam, SMARTEAM-FDA Compliance Configuration (SFA), IBM/SmarTeam, Sep. 2003.
18 Stember, LABTrack: Introducing a legal electronic lab notebook, 221st National Meeting, American Chemical Society, Division of Chemical Information.
US20110055221 * Aug 26, 2009 Mar 3, 2011 Sovio Sampo Juhani Method and apparatus for obtaining decision diagrams from unknown hash identifiers
International Classification G06F7/00, H04L9/32