公开(公告)号：US07966493B2

公开(公告)日：2011-06-21

申请号：US10731623

申请日：2003-12-08

申请人： Srinivasulu Puri ,  Ravindra Akella ,  Savita Durgada ,  Mark Fisher ,  Hany Saleeb ,  Manish Gupta ,  William Stearns

发明人： Srinivasulu Puri ,  Ravindra Akella ,  Savita Durgada ,  Mark Fisher ,  Hany Saleeb ,  Manish Gupta ,  William Stearns

IPC分类号： H04L9/32

CPC分类号： G06F21/64 ,  G06F21/6227

摘要： A method of and system for intercepting a transaction instantiated by a database application to determine if an electronic signature is necessary to commit the transaction to the database is disclosed. In one embodiment the method comprises calling an application program interface to raise an event in response to a triggering action generated by the database application; initiating a workflow process that executes a rule to determine if an electronic signature is required to approve the transaction; and if execution of the rule results in a determination that an electronic signature is required for the transaction, instantiating a signature collection process. Some embodiments further comprise obtaining an electronic signature in response to the signature collection process and thereafter, verifying the electronic signature and updating a filed of the electronic record to indicate a valid signature was collected if the electronic signature is verified.

摘要翻译： 公开了一种用于截取由数据库应用程序实例化的事务以确定电子签名是否需要将事务提交到数据库的方法和系统。 在一个实施例中，该方法包括响应于由数据库应用产生的触发动作，调用应用程序接口来引发事件; 启动执行规则以确定电子签名是否需要批准交易的工作流程; 并且如果规则的执行导致对于交易需要电子签名的确定，则实例化签名收集处理。 一些实施例还包括响应于签名收集过程获得电子签名，此后，如果电子签名被验证，则验证电子签名并更新电子记录的文件以指示有效的签名被收集。

公开(公告)号：US20050108537A1

公开(公告)日：2005-05-19

申请号：US10731623

申请日：2003-12-08

申请人： Srinivasulu Puri ,  Ravindra Akella ,  Savita Durgada ,  Mark Fisher ,  Hany Saleeb ,  Manish Gupta

发明人： Srinivasulu Puri ,  Ravindra Akella ,  Savita Durgada ,  Mark Fisher ,  Hany Saleeb ,  Manish Gupta

IPC分类号： H04L9/00

CPC分类号： G06F21/64 ,  G06F21/6227

摘要： A method of and system for intercepting a transaction instantiated by a database application to determine if an electronic signature is necessary to commit the transaction to the database is disclosed. In one embodiment the method comprises calling an application program interface to raise an event in response to a triggering action generated by the database application; initiating a workflow process that executes a rule to determine if an electronic signature is required to approve the transaction; and if execution of the rule results in a determination that an electronic signature is required for the transaction, instantiating a signature collection process. Some embodiments further comprise obtaining an electronic signature in response to the signature collection process and thereafter, verifying the electronic signature and updating a filed of the electronic record to indicate a valid signature was collected if the electronic signature is verified.

摘要翻译： 公开了一种用于截取由数据库应用程序实例化的事务以确定电子签名是否需要将事务提交到数据库的方法和系统。 在一个实施例中，该方法包括响应于由数据库应用产生的触发动作，调用应用程序接口来引发事件; 启动执行规则以确定电子签名是否需要批准交易的工作流程; 并且如果规则的执行导致对于交易需要电子签名的确定，则实例化签名收集处理。 一些实施例还包括响应于签名收集过程获得电子签名，此后，如果电子签名被验证，则验证电子签名并更新电子记录的文件以指示有效的签名被收集。

公开(公告)号：US20050108536A1

公开(公告)日：2005-05-19

申请号：US10731299

申请日：2003-12-08

申请人： Srikanth Karimisetty ,  Srinivasulu Puri ,  Charanjeet Singh ,  Ravindra Akella ,  Savita Durgada

发明人： Srikanth Karimisetty ,  Srinivasulu Puri ,  Charanjeet Singh ,  Ravindra Akella ,  Savita Durgada

IPC分类号： H04L9/00

CPC分类号： G06F21/6227 ,  G06F2221/2101

摘要： 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.

摘要翻译： 用于收集存储在数据库中的电子记录的电子签名的方法和系统。 在一个实施例中，该方法包括：响应于预定事件的发生，从存储在多个不同数据库表中的数据自动创建电子记录; 将电子记录的实例存储在提供不能由系统的用户改变或禁用的审计跟踪的电子记录的公共存储库中; 执行与电子记录相关联的规则以确定电子签名是否需要意味着电子记录的审查和/或批准; 并且如果执行规则导致需要电子签名的确定，则将电子记录的实例标记为无符号并发起收集所需电子签名的请求。 在一些实施例中，电子记录以非结构化数据存储在字符大对象（CLOB）格式中，并且非结构化数据包括存储在数据库中存储的表的列内的格式良好的XML文档。

公开(公告)号：US07600124B2

公开(公告)日：2009-10-06

申请号：US10731657

申请日：2003-12-08

申请人： Srikanth Karimisetty ,  Srinivasulu Puri ,  Charanjeet Singh ,  Ravindra Akella ,  Savita Durgada

发明人： Srikanth Karimisetty ,  Srinivasulu Puri ,  Charanjeet Singh ,  Ravindra Akella ,  Savita Durgada

IPC分类号： H04L9/32

CPC分类号： G06F17/30911

摘要： 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 the fields stored in the electronic record; allowing a user to generate a map that maps data from underlying database tables to at least some of the fields defined for the electronic record; allowing a user to define a layout for displaying data in the electronic record on a computer display when an electronic signature for the data record is collected; allowing a user to identify a signatory approver for the electronic record; generating the electronic record and displaying the electronic record to the signatory approver according to the defined layout in response to the occurrence of the event; receiving an electronic signature from the signatory approver; and associating the electronic signature with the electronic record. Some embodiments further comprise verifying the electronic signature prior to associating the signature with the electronic record.

摘要翻译： 一种用于将电子签名与计算机系统中的电子记录相关联的方法和系统。 在一个实施例中，该方法包括允许用户定义在发生时产生需要电子签名的电子记录的事件; 允许用户定义存储在电子记录中的字段; 允许用户生成将数据从基础数据库表映射到为电子记录定义的至少一些字段的映射; 允许用户在收集数据记录的电子签名时定义用于在计算机显示器上的电子记录中显示数据的布局; 允许用户识别电子记录的签署者批准人; 生成电子记录，并根据事件的发生，根据定义的布局将电子记录显示给签字者批准人; 从签署方批准人处收到电子签名; 并将电子签名与电子记录相关联。 一些实施例还包括在将签名与电子记录相关联之前验证电子签名。

公开(公告)号：US20050108212A1

公开(公告)日：2005-05-19

申请号：US10731673

申请日：2003-12-08

申请人： Srikanth Karimisetty ,  Srinivasulu Puri ,  Charanjeet Singh ,  Ravindra Akella ,  Savita Durgada

发明人： Srikanth Karimisetty ,  Srinivasulu Puri ,  Charanjeet Singh ,  Ravindra Akella ,  Savita Durgada

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F21/6227 ,  G06F17/30525 ,  G06F2221/2101

摘要： A method of and system for searching unstructured data stored in a database. In one embodiment the method comprises storing a plurality of electronic records in a common repository of electronic records in the database that provides an audit trail that cannot be altered or disabled by users of the system where each electronic record comprises unstructured data stored in a character large-object (CLOB) format in a column of a table of the database; creating a security protocol that protects the electronic records against unauthorized access; and creating a query designed to identify electronic records in the database that meet criteria designated in the query. The method further comprises modifying the query in accordance with the security protocol to create a modified query prior to executing the query and running the modified query against the unstructured data. In one particular implementation, the unstructured data comprises a well-formed XML document stored within a column of a table stored in the database.

摘要翻译： 用于搜索存储在数据库中的非结构化数据的方法和系统。 在一个实施例中，该方法包括将多个电子记录存储在数据库中的电子记录的公共存储库中，该电子记录提供不能由系统的用户改变或禁用的审计跟踪，其中每个电子记录包括存储在字符大小中的非结构化数据 - 对象（CLOB）格式在数据库的表的列中; 创建一个安全协议，保护电子记录免受未经授权的访问; 并创建一个查询，用于识别数据库中符合查询中指定条件的电子记录。 所述方法还包括根据所述安全协议来修改所述查询以在执行所述查询之前创建修改的查询，并针对非结构化数据运行所述经修改的查询。 在一个特定实现中，非结构化数据包括存储在数据库中存储的表的列内的格式良好的XML文档。

公开(公告)号：US07694143B2

公开(公告)日：2010-04-06

申请号：US10731299

申请日：2003-12-08

申请人： Srikanth Karimisetty ,  Srinivasulu Puri ,  Charanjeet Singh ,  Ravindra Akella ,  Savita Durgada

发明人： Srikanth Karimisetty ,  Srinivasulu Puri ,  Charanjeet Singh ,  Ravindra Akella ,  Savita Durgada

IPC分类号： H04L9/32

CPC分类号： G06F21/6227 ,  G06F2221/2101

摘要： 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.

摘要翻译： 用于收集存储在数据库中的电子记录的电子签名的方法和系统。 在一个实施例中，该方法包括：响应于预定事件的发生，从存储在多个不同数据库表中的数据自动创建电子记录; 将电子记录的实例存储在提供不能由系统的用户改变或禁用的审计跟踪的电子记录的公共存储库中; 执行与电子记录相关联的规则以确定电子签名是否需要意味着电子记录的审查和/或批准; 并且如果执行规则导致需要电子签名的确定，则将电子记录的实例标记为无符号并发起收集所需电子签名的请求。 在一些实施例中，电子记录以非结构化数据存储在字符大对象（CLOB）格式中，并且非结构化数据包括存储在数据库中存储的表的列内的格式良好的XML文档。

公开(公告)号：US07650512B2

公开(公告)日：2010-01-19

申请号：US10731673

申请日：2003-12-08

申请人： Srikanth Karimisetty ,  Srinivasulu Puri ,  Charanjeet Singh ,  Ravindra Akella ,  Savita Durgada

发明人： Srikanth Karimisetty ,  Srinivasulu Puri ,  Charanjeet Singh ,  Ravindra Akella ,  Savita Durgada

IPC分类号： G06F12/14

CPC分类号： G06F21/6227 ,  G06F17/30525 ,  G06F2221/2101

摘要： A method of and system for searching unstructured data stored in a database. In one embodiment the method comprises storing a plurality of electronic records in a common repository of electronic records in the database that provides an audit trail that cannot be altered or disabled by users of the system where each electronic record comprises unstructured data stored in a character large-object (CLOB) format in a column of a table of the database; creating a security protocol that protects the electronic records against unauthorized access; and creating a query designed to identify electronic records in the database that meet criteria designated in the query. The method further comprises modifying the query in accordance with the security protocol to create a modified query prior to executing the query and running the modified query against the unstructured data. In one particular implementation, the unstructured data comprises a well-formed XML document stored within a column of a table stored in the database.

摘要翻译： 用于搜索存储在数据库中的非结构化数据的方法和系统。 在一个实施例中，该方法包括将多个电子记录存储在数据库中的电子记录的公共存储库中，该电子记录提供不能由系统的用户改变或禁用的审计跟踪，其中每个电子记录包括存储在字符大小中的非结构化数据 - 对象（CLOB）格式在数据库的表的列中; 创建一个安全协议，保护电子记录免受未经授权的访问; 并创建一个查询，用于识别数据库中符合查询中指定条件的电子记录。 所述方法还包括根据所述安全协议来修改所述查询以在执行所述查询之前创建修改的查询，并针对非结构化数据运行所述经修改的查询。 在一个特定实现中，非结构化数据包括存储在数据库中存储的表的列内的格式良好的XML文档。

公开(公告)号：US20050108283A1

公开(公告)日：2005-05-19

申请号：US10731657

申请日：2003-12-08

申请人： Srikanth Karimisetty ,  Srinivasulu Puri ,  Charanjeet Singh ,  Ravindra Akella ,  Savita Durgada

发明人： Srikanth Karimisetty ,  Srinivasulu Puri ,  Charanjeet Singh ,  Ravindra Akella ,  Savita Durgada

IPC分类号： G06F7/00

CPC分类号： G06F17/30911

摘要： 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 the fields stored in the electronic record; allowing a user to generate a map that maps data from underlying database tables to at least some of the fields defined for the electronic record; allowing a user to define a layout for displaying data in the electronic record on a computer display when an electronic signature for the data record is collected; allowing a user to identify a signatory approver for the electronic record; generating the electronic record and displaying the electronic record to the signatory approver according to the defined layout in response to the occurrence of the event; receiving an electronic signature from the signatory approver; and associating the electronic signature with the electronic record. Some embodiments further comprise verifying the electronic signature prior to associating the signature with the electronic record.

摘要翻译： 一种用于将电子签名与计算机系统中的电子记录相关联的方法和系统。 在一个实施例中，该方法包括允许用户定义在发生时产生需要电子签名的电子记录的事件; 允许用户定义存储在电子记录中的字段; 允许用户生成将数据从基础数据库表映射到为电子记录定义的至少一些字段的映射; 允许用户在收集数据记录的电子签名时定义用于在计算机显示器上的电子记录中显示数据的布局; 允许用户识别电子记录的签署者批准人; 生成电子记录，并根据事件的发生，根据定义的布局将电子记录显示给签字者批准人; 从签署方批准人处收到电子签名; 并将电子签名与电子记录相关联。 一些实施例还包括在将签名与电子记录相关联之前验证电子签名。

公开(公告)号：US20050108211A1

公开(公告)日：2005-05-19

申请号：US10731604

申请日：2003-12-08

申请人： Srikanth Karimisetty ,  Srinivasulu Puri ,  Charanjeet Singh ,  Ravindra Akella ,  Savita Durgada

发明人： Srikanth Karimisetty ,  Srinivasulu Puri ,  Charanjeet Singh ,  Ravindra Akella ,  Savita Durgada

IPC分类号： G06F17/30

CPC分类号： G06F16/81

摘要： A method of and system for searching unstructured data stored in a database. In one embodiment the method comprises storing unstructured data in a column of a database table; allowing a user to identify elements in the unstructured data as indexed elements; creating an intermediate index into the unstructured data from the identified elements; and allowing a user to create queries on the unstructured data using the indexed elements. In some implementations of this embodiment the unstructured data comprises a well-formed XML document stored within a column of a database table. Also, in some implementations the unstructured data is part of an electronic record stored in a common repository of electronic records that provides an audit trail that cannot be altered or disabled by users of the database.

摘要翻译： 用于搜索存储在数据库中的非结构化数据的方法和系统。 在一个实施例中，该方法包括将非结构化数据存储在数据库表的列中; 允许用户将非结构化数据中的元素标识为索引元素; 从所识别的元素创建到非结构化数据的中间索引; 并允许用户使用索引元素创建关于非结构化数据的查询。 在该实施例的一些实现中，非结构化数据包括存储在数据库表的列内的格式良好的XML文档。 此外，在一些实现中，非结构化数据是存储在电子记录的公共存储库中的电子记录的一部分，其提供不能由数据库的用户改变或禁用的审计跟踪。

公开(公告)号：US20050108295A1

公开(公告)日：2005-05-19

申请号：US10731655

申请日：2003-12-08

申请人： Srikanth Karimisetty ,  Ravindra Akella ,  Savita Durgada ,  John Danese ,  Sanjay Rastogi ,  Manish Gupta

发明人： Srikanth Karimisetty ,  Ravindra Akella ,  Savita Durgada ,  John Danese ,  Sanjay Rastogi ,  Manish Gupta

IPC分类号： G06F7/00

CPC分类号： G06F17/30938

摘要： 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.

摘要翻译： 将事务提交到数据库的方法和系统。 在一个实施例中，该方法包括启动数据库事务; 创建一个电子记录，其中包括来自数据库事务的交易数据; 执行与记录相关联的规则以确定电子签名是否需要意味着电子记录的审查和/或批准，并且如果执行规则导致了规则的执行，则在将事务提交到数据库之前请求电子签名，导致确定 需要电子签名。