-
公开(公告)号：US20090299827A1
公开(公告)日：2009-12-03
申请号：US12130037
申请日：2008-05-30
IPC分类号： G06Q10/00
CPC分类号： G06Q10/10 , G06Q10/06398
摘要： Systems and methods are disclosed herein for verifying the competence of an operator in a manufacturing facility. In one implementation, for example, an operator competence verifying system comprises one or more input/output (“I/O”) devices configured to receive information from a user and provide information to the user. The system also comprises a processing device, which is configured to enable the user to set up a competence profile of an operator in the manufacturing facility. The processing device is further configured to enable the user to define jobs related to handling sensitive material at multiple material handling stages in the manufacturing facility. Also, the processing device is configured to assign training to the operator as needed to meet industry guidelines. The processing device is also configured to enable the user to define competence levels required at each multiple material handling stage.
摘要翻译： 本文公开的系统和方法用于验证制造设施中的操作者的能力。 在一个实现中，例如，操作员能力验证系统包括被配置为从用户接收信息并向用户提供信息的一个或多个输入/输出（“I / O”）设备。 该系统还包括处理装置，其被配置为使得用户能够在制造设施中建立操作者的能力简档。 处理装置还被配置为使得用户能够在制造设施中的多个材料处理阶段定义与处理敏感材料相关的作业。 此外，处理装置被配置为根据需要向操作者分配训练以满足行业指导。 处理设备还被配置为使得用户能够定义在每个多个物料搬运阶段所需的能力等级。
-
公开(公告)号：US20090193054A1
公开(公告)日：2009-07-30
申请号：US12151942
申请日：2008-05-09
IPC分类号： G06F17/30
CPC分类号： G06F17/30917 , G06F17/30368
摘要： Systems, methods, and other embodiments associated with database auditing are described. One example method includes generating a first extensible markup language (XML) document using data from a database object. A database object may include data from multiple relational data tables. The method includes generating a second XML document in response to an event causing a change to the database object. The method also includes comparing the first and second XML documents to identify changed values. The method also includes displaying the identified changes.
摘要翻译： 描述了与数据库审计相关联的系统，方法和其他实施例。 一个示例性方法包括使用来自数据库对象的数据生成第一可扩展标记语言（XML）文档。 数据库对象可以包括来自多个关系数据表的数据。 该方法包括响应于引起对数据库对象的改变的事件而生成第二XML文档。 该方法还包括比较第一和第二XML文档以识别改变的值。 该方法还包括显示所识别的变化。
-
3.发明申请Method of and system for collecting an electronic signature for an electronic record stored in a database 有权收集数据库中存储的电子记录的电子签名的方法和系统公开(公告)号：US20050108536A1
公开(公告)日：2005-05-19
申请号：US10731299
申请日：2003-12-08
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文档。
-
公开(公告)号：US08234248B2
公开(公告)日：2012-07-31
申请号：US12151942
申请日：2008-05-09
IPC分类号： G06F7/00
CPC分类号： G06F17/30917 , G06F17/30368
摘要： Systems, methods, and other embodiments associated with database auditing are described. One example method includes generating a first extensible markup language (XML) document using data from a database object. A database object may include data from multiple relational data tables. The method includes generating a second XML document in response to an event causing a change to the database object. The method also includes comparing the first and second XML documents to identify changed values. The method also includes displaying the identified changes.
摘要翻译： 描述了与数据库审计相关联的系统，方法和其他实施例。 一个示例性方法包括使用来自数据库对象的数据生成第一可扩展标记语言（XML）文档。 数据库对象可以包括来自多个关系数据表的数据。 该方法包括响应于引起对数据库对象的改变的事件而生成第二XML文档。 该方法还包括比较第一和第二XML文档以识别改变的值。 该方法还包括显示所识别的变化。
-
5.发明授权Method of and system for associating an electronic signature with an electronic record 有权将电子签名与电子记录相关联的方法和系统公开(公告)号：US07600124B2
公开(公告)日：2009-10-06
申请号：US10731657
申请日：2003-12-08
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.
摘要翻译： 一种用于将电子签名与计算机系统中的电子记录相关联的方法和系统。 在一个实施例中，该方法包括允许用户定义在发生时产生需要电子签名的电子记录的事件; 允许用户定义存储在电子记录中的字段; 允许用户生成将数据从基础数据库表映射到为电子记录定义的至少一些字段的映射; 允许用户在收集数据记录的电子签名时定义用于在计算机显示器上的电子记录中显示数据的布局; 允许用户识别电子记录的签署者批准人; 生成电子记录，并根据事件的发生，根据定义的布局将电子记录显示给签字者批准人; 从签署方批准人处收到电子签名; 并将电子签名与电子记录相关联。 一些实施例还包括在将签名与电子记录相关联之前验证电子签名。
-
公开(公告)号：US08402065B2
公开(公告)日：2013-03-19
申请号：US12151943
申请日：2008-05-09
CPC分类号： G06Q10/06
摘要： Systems, methods, and other embodiments associated with batch process monitoring are described. One example method may include monitoring an external batch process (e.g. food manufacture, drug manufacture). The method may include collecting data (e.g. material usage, material yield, resource usage, quality results, process parameters, actions performed on batches) from the external batch process. The method may also include generating an XML document based, at least in part, on data collected from the external batch process. The contents of the XML document are to represent a required record that relates to a consumable product manufacturing event. In one example, the record may comply with Title 21 of the United States Code.
-
7.发明申请公开(公告)号：US20050108212A1
公开(公告)日：2005-05-19
申请号：US10731673
申请日：2003-12-08
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文档。
-
8.发明授权Method of and system for collecting an electronic signature for an electronic record stored in a database 有权收集数据库中存储的电子记录的电子签名的方法和系统公开(公告)号：US07694143B2
公开(公告)日：2010-04-06
申请号：US10731299
申请日：2003-12-08
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文档。
-
9.发明授权公开(公告)号：US07650512B2
公开(公告)日：2010-01-19
申请号：US10731673
申请日：2003-12-08
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文档。
-
公开(公告)号：US20090193049A1
公开(公告)日：2009-07-30
申请号：US12151943
申请日：2008-05-09
IPC分类号： G06F17/30
CPC分类号： G06Q10/06
摘要： Systems, methods, and other embodiments associated with batch process monitoring are described. One example method may include monitoring an external batch process (e.g. food manufacture, drug manufacture). The method may include collecting data (e.g. material usage, material yield, resource usage, quality results, process parameters, actions performed on batches) from the external batch process. The method may also include generating an XML document based, at least in part, on data collected from the external batch process. The contents of the XML document are to represent a required record that relates to a consumable product manufacturing event. In one example, the record may comply with Title 21 of the United States Code.
摘要翻译： 描述与批处理监视相关联的系统，方法和其他实施例。 一个示例性方法可以包括监测外部分批过程（例如食品制造，药物制造）。 该方法可以包括从外部批处理收集数据（例如材料使用，材料产量，资源使用，质量结果，过程参数，批次执行的动作）。 该方法还可以包括至少部分地基于从外部批处理收集的数据来生成XML文档。 XML文档的内容是表示与消耗品制造事件相关的所需记录。 在一个例子中，记录可能符合美国法典第21章。
-
-
-
-
-
-
-
-
-
搜索结果
14 条记录 (耗时 0.02 秒)