公开(公告)号：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.

公开(公告)号：EP1890260A1

公开(公告)日：2008-02-20

申请号：EP07397026.1

申请日：2007-07-30

申请人： Aprimo, Incorporated

发明人： Lawrence, John A. ,  Burrous, Paul J. ,  Kelsey, Matthew J. ,  Knapp, Curtis A. ,  Sublette, Tim A.

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

CPC分类号： G06Q30/02 ,  G06Q30/0201 ,  G06Q30/0204

摘要： The present invention involves a computer system and method which implements a marketing management system. The computer comprises a processor, at least one database containing marketing information, and a database segmentation manager the segmentation manager is coupled to the processor and database. The database segmentation manager includes a node organizer for maintaining concatenated nodes defining a subset of data from the database. The node organizer includes a dataset node for creating a subset of said database according to query criteria and creating a temp table storing a portion of the fields and rows obtained by the query criteria. The segmentation manager further includes universe display software enabling an external user to view the database and nodes. The computer further has a graphic workflow manager capable of providing a visual representation with a plurality of items from the database and having a place and an order of a plurality of work tasks relating to the database.

摘要翻译： 本发明涉及一种实现营销管理系统的计算机系统和方法。 计算机包括处理器，至少一个包含营销信息的数据库，以及数据库分段管理器，该分段管理器耦合到处理器和数据库。 数据库分段管理器包括用于维护从数据库定义数据子集的级联节点的节点管理器。 节点管理器包括用于根据查询条件创建所述数据库的子集的数据集节点，并创建存储通过查询条件获得的一部分字段和行的临时表。 分段管理器还包括使外部用户能够查看数据库和节点的宇宙显示软件。 计算机还具有图形工作流程管理器，其能够从数据库提供具有多个项目的可视表示，并具有与数据库相关的多个工作任务的位置和顺序。