公开(公告)号：EP2207106A2

公开(公告)日：2010-07-14

申请号：EP09179833.0

申请日：2009-12-18

申请人： Aprimo, Incorporated

发明人： Reynolds, Michael J. ,  Coriell, Michael L. ,  Rardin, Richard A. ,  Lawrence, John A. ,  Mcdole, Michael D. ,  Lothamer, Jason H. ,  Sublette, Tim A.

IPC分类号： G06F17/30

CPC分类号： G06F17/30392 ,  G06F17/30398 ,  G06F17/30592

摘要： The present invention involves a computer for implementing a complex database management system (100). A processor (110) has at least one complex database with extraction software (108). The database extraction software is capable of creating a perspective based data model from a user selected data table (104) of the database. A query is specified by user selection of attributes from a data table of the database. A perspective based data model is created from the user selected data base table of the database and related tables. The extraction software creates a query structure defining a plurality of paths providing a selected portion of the information in the database, which is presented to the user based on the perspective based data model. The query structure defines a plurality of paths and having a plurality of nodes, each of the nodes having a corresponding operand. A downward evaluation of the query structure is performed, proceeding from a starting object down downwardly through the paths. An upward evaluation of the query structure is performed, proceeding upwardly from the bottom of each path. The operands are resolved according to predetermined rules so that the number of evaluations of the nodes is less than the number of instances of each operand in the query structure.

摘要翻译： 本发明涉及用于实现一个复杂的数据库管理系统（100）的计算机。 处理器（110）具有与复杂提取软件（108）的至少一个数据库。 数据库提取软件能够创建从数据库的用户选择的数据表（104）在基于立体数据模型。 查询是通过从数据库中的数据表的属性的用户选择指定。 透视基于数据模型是从数据库和相关表的用户选择数据的基础上表中创建。 提取软件创建的查询结构限定的提供的在数据库中的信息的选定部分的路径复数，所有这一切都被呈现给基于所述立体基于数据模型中的用户。 查询结构定义的路径的多元性和具有节点的复数，每一个都具有对应的操作数中的节点。 查询结构的向下评价进行，通过路径从起始对象继续向下向下。 查询结构的向上的评估进行，从每个路径的底部向上进行。操作数都解决了雅鼎预定规则，所以做了节点的定期评估的数量少于每个操作数的情况下，在查询结构的数量 ，

公开(公告)号：EP2207106A3

公开(公告)日：2011-03-02

申请号：EP09179833.0

申请日：2009-12-18

申请人： Aprimo, Incorporated

发明人： Reynolds, Michael J. ,  Coriell, Michael L. ,  Rardin, Richard A. ,  Lawrence, John A. ,  Mcdole, Michael D. ,  Lothamer, Jason H. ,  Sublette, Tim A.

IPC分类号： G06F17/30

CPC分类号： G06F17/30392 ,  G06F17/30398 ,  G06F17/30592

摘要： The present invention involves a computer for implementing a complex database management system (100). A processor (110) has at least one complex database with extraction software (108). The database extraction software is capable of creating a perspective based data model from a user selected data table (104) of the database. A query is specified by user selection of attributes from a data table of the database. A perspective based data model is created from the user selected data base table of the database and related tables. The extraction software creates a query structure defining a plurality of paths providing a selected portion of the information in the database, which is presented to the user based on the perspective based data model. The query structure defines a plurality of paths and having a plurality of nodes, each of the nodes having a corresponding operand. A downward evaluation of the query structure is performed, proceeding from a starting object down downwardly through the paths. An upward evaluation of the query structure is performed, proceeding upwardly from the bottom of each path. The operands are resolved according to predetermined rules so that the number of evaluations of the nodes is less than the number of instances of each operand in the query structure.