Generation of electronic pedigree

    公开(公告)号:US09116969B2

    公开(公告)日:2015-08-25

    申请号:US13460338

    申请日:2012-04-30

    IPC分类号: G06F17/30 G06Q10/08 G06Q30/00

    摘要: A pedigree data processing system receives a first item from an upstream partner and generates a receive native event for the first item. The mechanism receives pedigree data for the first item from the upstream partner, generates at least one synthetic event based on the pedigree data and stores the receive native event and the at least one synthetic event in a pedigree data repository. The pedigree data processing system determines whether to send electronic pedigree information for the first item to downstream partners using push data exchange or pull data exchange. The pedigree data processing system generates an electronic pedigree for the first item using pull data exchange based on the receive native event and the at least one synthetic event and provides the electronic pedigree to a first downstream partner pedigree system.

    Relational Query Planning for Non-Relational Data Sources
    2.
    发明申请
    Relational Query Planning for Non-Relational Data Sources 审中-公开
    非关系数据源的关系查询计划

    公开(公告)号:US20130006966A1

    公开(公告)日:2013-01-03

    申请号:US13549681

    申请日:2012-07-16

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30445 G06F17/30448

    摘要: A query plan for executing a query within a relational database system including at least one non-relational data source is generated by analyzing expressions that reference a non-relational data source within a query for the database system via an interface for that non-relational data source, determining for each analyzed expression at least one of the database system and interface capable of processing that analyzed expression for executing the query, providing an indicator for each of the analyzed expressions that indicates at least one of the database system and interface determined to process that analyzed expression, and generating the query plan for execution of the query, via the database system, based on the indicators for the expressions of the query.

    摘要翻译: 在关系数据库系统中执行包括至少一个非关系数据源的查询的查询计划通过分析通过用于该非关系数据的接口为数据库系统引用非关系数据源的表达来生成查询计划 源,为每个被分析的表达确定能够处理用于执行查询的分析表达式的数据库系统和接口中的至少一个,为所分析的表达中的每一个提供指示数据库系统和确定要处理的界面中的至少一个的指示符 分析表达式,并通过数据库系统基于查询表达式的指标生成查询执行查询计划。

    Generation of Electronic Pedigree
    3.
    发明申请
    Generation of Electronic Pedigree 有权
    电子谱系的生成

    公开(公告)号:US20130290357A1

    公开(公告)日:2013-10-31

    申请号:US13460338

    申请日:2012-04-30

    IPC分类号: G06F17/30

    摘要: A pedigree data processing system receives a first item from an upstream partner and generates a receive native event for the first item. The mechanism receives pedigree data for the first item from the upstream partner, generates at least one synthetic event based on the pedigree data and stores the receive native event and the at least one synthetic event in a pedigree data repository. The pedigree data processing system determines whether to send electronic pedigree information for the first item to downstream partners using push data exchange or pull data exchange. The pedigree data processing system generates an electronic pedigree for the first item using pull data exchange based on the receive native event and the at least one synthetic event and provides the electronic pedigree to a first downstream partner pedigree system.

    摘要翻译: 血统数据处理系统从上游伙伴接收第一个物品,并为第一个物品生成接收本机事件。 该机制从上游伙伴接收第一项目的谱系数据,基于谱系数据生成至少一个合成事件,并将接收本机事件和至少一个合成事件存储​​在谱系数据库中。 谱系数据处理系统确定是否使用推送数据交换或拉数据交换向下游合作伙伴发送第一个项目的电子血统信息。 系谱数据处理系统使用基于接收本机事件和至少一个合成事件的拉数据交换来生成第一项目的电子血统,并将电子谱系提供给第​​一下游伴侣血统系统。

    Relational query planning for non-relational data sources
    5.
    发明授权
    Relational query planning for non-relational data sources 有权
    非关系数据源的关系查询规划

    公开(公告)号:US09558239B2

    公开(公告)日:2017-01-31

    申请号:US13549681

    申请日:2012-07-16

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30445 G06F17/30448

    摘要: A query plan for executing a query within a relational database system including at least one non-relational data source is generated by analyzing expressions that reference a non-relational data source within a query for the database system via an interface for that non-relational data source, determining for each analyzed expression at least one of the database system and interface capable of processing that analyzed expression for executing the query, providing an indicator for each of the analyzed expressions that indicates at least one of the database system and interface determined to process that analyzed expression, and generating the query plan for execution of the query, via the database system, based on the indicators for the expressions of the query.

    摘要翻译: 在关系数据库系统中执行包括至少一个非关系数据源的查询的查询计划通过分析通过用于该非关系数据的接口为数据库系统引用非关系数据源的表达来生成查询计划 源,为每个被分析的表达确定能够处理用于执行查询的分析表达式的数据库系统和接口中的至少一个,为所分析的表达中的每一个提供指示数据库系统和确定要处理的界面中的至少一个的指示符 分析表达式,并通过数据库系统基于查询表达式的指标生成查询执行查询计划。

    Method and apparatus for managing shared data using a data surrogate and
obtaining cost parameters from a data dictionary by evaluating a parse
tree object
    7.
    发明授权
    Method and apparatus for managing shared data using a data surrogate and obtaining cost parameters from a data dictionary by evaluating a parse tree object 失效
    用于使用数据代理管理共享数据并通过评估解析树对象从数据字典获得成本参数的方法和装置

    公开(公告)号:US5689698A

    公开(公告)日:1997-11-18

    申请号:US546283

    申请日:1995-10-20

    IPC分类号: G06F17/30

    摘要: A method and apparatus for providing access to object data stored in an object server in response to a database query. The method comprises the steps of receiving a database query comprising a relational operation with a data surrogate identifying object data stored in an object server, transforming the database query into relational database commands, transmitting the relational database commands to the relational database management system, receiving a response table from the relational database management system, compiling an answer set from the response table comprising an object locator responsive to the database query, and transmitting the answer set to the client.

    摘要翻译: 一种用于响应于数据库查询提供对存储在对象服务器中的对象数据的访问的方法和装置。 该方法包括以下步骤:接收包括关系操作的数据库查询,数据代理识别存储在对象服务器中的对象数据,将数据库查询转换为关系数据库命令,将关系数据库命令传送到关系数据库管理系统, 来自关系数据库管理系统的响应表,响应于数据库查询从包括对象定位器的响应表编译答案集,并将答案集发送给客户端。

    Relational query planning for non-relational data sources
    8.
    发明授权
    Relational query planning for non-relational data sources 有权
    非关系数据源的关系查询规划

    公开(公告)号:US09177021B2

    公开(公告)日:2015-11-03

    申请号:US13157130

    申请日:2011-06-09

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30445 G06F17/30448

    摘要: A query plan for executing a query within a relational database system including at least one non-relational data source is generated by analyzing expressions that reference a non-relational data source within a query for the database system via an interface for that non-relational data source, determining for each analyzed expression at least one of the database system and interface capable of processing that analyzed expression for executing the query, providing an indicator for each of the analyzed expressions that indicates at least one of the database system and interface determined to process that analyzed expression, and generating the query plan for execution of the query, via the database system, based on the indicators for the expressions of the query.

    摘要翻译: 在关系数据库系统中执行包括至少一个非关系数据源的查询的查询计划通过分析通过用于该非关系数据的接口为数据库系统引用非关系数据源的表达来生成查询计划 源,为每个被分析的表达确定能够处理用于执行查询的分析表达式的数据库系统和接口中的至少一个,为所分析的表达中的每一个提供指示数据库系统和确定要处理的界面中的至少一个的指示符 分析表达式,并通过数据库系统基于查询表达式的指标生成查询执行查询计划。

    Relational Query Planning for Non-Relational Data Sources
    9.
    发明申请
    Relational Query Planning for Non-Relational Data Sources 有权
    非关系数据源的关系查询计划

    公开(公告)号:US20120317096A1

    公开(公告)日:2012-12-13

    申请号:US13157130

    申请日:2011-06-09

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30445 G06F17/30448

    摘要: A query plan for executing a query within a relational database system including at least one non-relational data source is generated by analyzing expressions that reference a non-relational data source within a query for the database system via an interface for that non-relational data source, determining for each analyzed expression at least one of the database system and interface capable of processing that analyzed expression for executing the query, providing an indicator for each of the analyzed expressions that indicates at least one of the database system and interface determined to process that analyzed expression, and generating the query plan for execution of the query, via the database system, based on the indicators for the expressions of the query.

    摘要翻译: 在关系数据库系统中执行包括至少一个非关系数据源的查询的查询计划通过分析通过用于该非关系数据的接口为数据库系统引用非关系数据源的表达来生成查询计划 源,为每个被分析的表达确定能够处理用于执行查询的分析表达式的数据库系统和接口中的至少一个,为所分析的表达中的每一个提供指示数据库系统和确定要处理的界面中的至少一个的指示符 分析表达式,并通过数据库系统基于查询表达式的指标生成查询执行查询计划。

    Method and apparatus for extending a relational database management
system using a federated coordinator
    10.
    发明授权
    Method and apparatus for extending a relational database management system using a federated coordinator 失效
    使用联合协调器来扩展关系数据库管理系统的方法和装置

    公开(公告)号:US5873083A

    公开(公告)日:1999-02-16

    申请号:US943837

    申请日:1997-10-03

    IPC分类号: G06F17/30

    摘要: A method and apparatus for providing access to object data stored in an object server in response to a database query. The method comprises the steps of receiving a database query comprising a relational operation with a data surrogate identifying object data stored in an object server, transforming the database query into relational database commands, transmitting the relational database commands to the relational database management system, receiving a response table from the relational database management system, compiling an answer set from the response table comprising an object locator responsive to the database query, and transmitting the answer set to the client.

    摘要翻译: 一种用于响应于数据库查询提供对存储在对象服务器中的对象数据的访问的方法和装置。 该方法包括以下步骤:接收包括关系操作的数据库查询,数据代理识别存储在对象服务器中的对象数据,将数据库查询转换为关系数据库命令,将关系数据库命令传送到关系数据库管理系统, 来自关系数据库管理系统的响应表,响应于数据库查询从包括对象定位器的响应表编译答案集,并将答案集发送给客户端。