公开(公告)号：US20060271529A1

公开(公告)日：2006-11-30

申请号：US11140201

申请日：2005-05-31

申请人： Jitendra Dhamija ,  Suresh Mali ,  Christopher Evans ,  Paolo Fragapane ,  James Steadman ,  Andrew Osborn

发明人： Jitendra Dhamija ,  Suresh Mali ,  Christopher Evans ,  Paolo Fragapane ,  James Steadman ,  Andrew Osborn

IPC分类号： G06F17/30

CPC分类号： G06F17/30451

摘要： A query generator for generating a query for retrieving data from a database comprising at least one table is disclosed. The query refers to one or more data items in a first view defined to expose a portion of the database and to one or more data items that are not exposed by the first view, at least one of which has an associated reach through flag set thereby defining it as a reach through item. The query generator is adapted to: a) receive user input indicating selected items to be retrieved from the database; b) ascertain whether any of the selected items that are not exposed by the first view are defined as reach through items; and, c) if so: i) create a second view that is a copy of the first view and add a copy of each reach through item to it; and ii) create a query that refers only to the second view and the items exposed by it.

摘要翻译： 公开了一种查询生成器，用于生成用于从包括至少一个表的数据库检索数据的查询。 该查询涉及第一视图中的一个或多个数据项，其定义为暴露数据库的一部分以及未被第一视图公开的一个或多个数据项，其中至少一个通过标志集具有相关联的到达 将其定义为通过项目的触及。 查询生成器适于：a）接收指示要从数据库检索的所选项目的用户输入; b）确定第一视野未曝光的任何选定项目是否被定义为通过项目达成; 和c）如果是这样的话：i）创建第二个视图，它是第一个视图的副本，并通过项目向每个视图添加一个副本; 和ii）创建仅引用第二个视图的查询以及它所暴露的项目。

公开(公告)号：US07814090B2

公开(公告)日：2010-10-12

申请号：US11140201

申请日：2005-05-31

申请人： Jitendra Dhamija ,  Suresh Mali ,  Christopher Evans ,  Paolo Fragapane ,  James Steadman ,  Andrew Osborn

发明人： Jitendra Dhamija ,  Suresh Mali ,  Christopher Evans ,  Paolo Fragapane ,  James Steadman ,  Andrew Osborn

IPC分类号： G06F7/00

CPC分类号： G06F17/30451

摘要： A query generator for generating a query for retrieving data from a database comprising at least one table is disclosed. The query refers to one or more data items in a first view defined to expose a portion of the database and to one or more data items that are not exposed by the first view, at least one of which has an associated reach through flag set thereby defining it as a reach through item. The query generator is adapted to: receive user input indicating selected items to be retrieved from the database; ascertain whether any of the selected items that are not exposed by the first view are defined as reach through items; and, if so: create a second view that is a copy of the first view and add a copy of each reach through item to it; and create a query that refers only to the second view and the items exposed by it.

摘要翻译： 公开了一种查询生成器，用于生成用于从包括至少一个表的数据库检索数据的查询。 该查询涉及第一视图中的一个或多个数据项，其定义为暴露数据库的一部分以及未被第一视图公开的一个或多个数据项，其中至少一个通过标志集具有相关联的到达 将其定义为通过项目的触及。 所述查询生成器适于：从所述数据库接收指示要检索的所选项的用户输入; 确定第一视图未暴露的任何选定项目是否被定义为通过项目达到; 如果是，则创建第二个视图，即第一个视图的副本，并通过项目向其添加每个触及的副本; 并创建一个仅引用第二个视图的查询及其公开的项目。