Mapping data structures
    4.
    发明授权
    Mapping data structures 有权
    映射数据结构

    公开(公告)号:US07620642B2

    公开(公告)日:2009-11-17

    申请号:US11302855

    申请日:2005-12-13

    IPC分类号: G06F17/00

    摘要: A first data storage schema in which a characteristic in a first dimension table is mapped by a first table and a second table can be received and a second data storage schema can be received. The first table maps the characteristic to a first object that include attributes to which time information is irrelevant to data processing activities and the second maps the characteristic to a second object that includes attributes to which time information is relevant to data processing activities. The second data storage schema includes a fact table including at least some facts drawn from the first data storage schema and a second dimension table that includes at least some characteristics drawn from at least one of the first object and the second object.

    摘要翻译: 第一数据存储模式,其中第一维度表中的特征被第一表和第二表映射,并且可以接收第二数据存储模式。 第一表将特征映射到第一对象,其包括时间信息与数据处理活动无关的属性,第二表将特征映射到包括时间信息与数据处理活动相关的属性的第二对象。 第二数据存储模式包括包括从第一数据存储模式中提取的至少一些事实的事实表以及包括从第一对象和第二对象中的至少一个绘制的至少一些特征的第二维度表。

    Query plan execution by implementation of plan operations forming a join graph
    5.
    发明申请
    Query plan execution by implementation of plan operations forming a join graph 有权
    通过实现形成连接图的计划操作来查询计划执行

    公开(公告)号:US20070156701A1

    公开(公告)日:2007-07-05

    申请号:US11322626

    申请日:2005-12-30

    IPC分类号: G06F17/30 G06F7/00

    摘要: A system and method for executing a query plan are disclosed. In the system and method, a join graph is generated to represent the query plan. The join graph includes a set of plan operations that are to be executed for implementing the join graph. The query plan is received by a distributed network of a logical index server and one or more selected physical index servers. Each physical index server receives a portion of the plan operations, and determines what plan data is needed to execute the portion of the plan operations. A system and method includes a process for determining what plan data is needed from other physical index servers, or what plan data is needed by other physical index servers.

    摘要翻译: 公开了一种用于执行查询计划的系统和方法。 在系统和方法中,生成连接图以表示查询计划。 连接图包括要执行连接图的一组计划操作。 查询计划由逻辑索引服务器和一个或多个选定的物理索引服务器的分布式网络接收。 每个物理索引服务器接收计划操作的一部分,并确定执行计划操作的一部分所需的计划数据。 系统和方法包括用于从其他物理索引服务器确定需要什么计划数据的过程,或其他物理索引服务器需要哪些计划数据。

    Query plan execution by implementation of plan operations forming a join graph
    6.
    发明授权
    Query plan execution by implementation of plan operations forming a join graph 有权
    通过实现形成连接图的计划操作来查询计划执行

    公开(公告)号:US07461057B2

    公开(公告)日:2008-12-02

    申请号:US11322626

    申请日:2005-12-30

    IPC分类号: G06F7/00 G06F17/30

    摘要: A system and method for executing a query plan are disclosed. In the system and method, a join graph is generated to represent the query plan. The join graph includes a set of plan operations that are to be executed for implementing the join graph. The query plan is received by a distributed network of a logical index server and one or more selected physical index servers. Each physical index server receives a portion of the plan operations, and determines what plan data is needed to execute the portion of the plan operations. A system and method includes a process for determining what plan data is needed from other physical index servers, or what plan data is needed by other physical index servers.

    摘要翻译: 公开了一种用于执行查询计划的系统和方法。 在系统和方法中,生成连接图以表示查询计划。 连接图包括要执行连接图的一组计划操作。 查询计划由逻辑索引服务器和一个或多个选定的物理索引服务器的分布式网络接收。 每个物理索引服务器接收计划操作的一部分,并确定执行计划操作的一部分所需的计划数据。 系统和方法包括用于从其他物理索引服务器确定需要什么计划数据的过程,或其他物理索引服务器需要哪些计划数据。