利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

16 条记录 (耗时 0.024 秒)

    Query generator
    1.
    发明申请
    Query generator 有权
    查询生成器

    公开(公告)号：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）创建仅引用第二个视图的查询以及它所暴露的项目。

    Query generator
    2.
    发明授权
    Query generator 有权
    查询生成器

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

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

    Structured query language table merging
    6.
    发明授权
    Structured query language table merging 有权
    结构化查询语言表合并

    公开(公告)号：US07725457B2

    公开(公告)日：2010-05-25

    申请号：US10739338

    申请日：2003-12-19

    申请人： Christopher Evans ,  Paolo Fragapane ,  Stephen Cave ,  Andrew Osborn

    发明人： Christopher Evans ,  Paolo Fragapane ,  Stephen Cave ,  Andrew Osborn

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

    CPC分类号： G06F17/30454

    摘要： A method of modifying a Structured Query Language (SQL) statement in order to reduce the number of joins executed by a database is disclosed. The method includes presenting the SQL statement to the database and identifying joins in the SQL statement for removal in accordance with one or more predetermined criteria. For each identified join, the SQL statement may be modified so as to remove the identified join and to change references to a first instance of a table which is referred to by the identified join to a second instance of the table.

    摘要翻译： 公开了一种修改结构化查询语言（SQL）语句以减少数据库执行的连接数量的方法。 该方法包括将SQL语句呈现给数据库，并根据一个或多个预定标准识别SQL语句中的连接以进行删除。 对于每个已标识的连接，可以修改SQL语句，以便删除所标识的连接，并将对由标识的连接引用的表的第一个实例的引用更改为表的第二个实例。

    Structured query language table merging
    7.
    发明申请
    Structured query language table merging 有权
    结构化查询语言表合并

    公开(公告)号：US20050076007A1

    公开(公告)日：2005-04-07

    申请号：US10739338

    申请日：2003-12-19

    申请人： Christopher Evans ,  Paolo Fragapane ,  Stephen Cave ,  Andrew Osborn

    发明人： Christopher Evans ,  Paolo Fragapane ,  Stephen Cave ,  Andrew Osborn

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30454

    摘要： A method of modifying a Structured Query Language (SQL) statement in order to reduce the number of joins executed by a database is described. The method comprises: a) presenting the SQL statement to the database; b) identifying joins in the SQL statement for removal in accordance with one or more predetermined criteria; and c) for each identified join, modifying the SQL statement so as to remove the identified join and to change references to a first instance of a table which is referred to by the identified join to a second instance of the table.

    摘要翻译： 描述了一种修改结构化查询语言（SQL）语句以减少数据库执行的连接数量的方法。 该方法包括：a）将SQL语句呈现给数据库; b）根据一个或多个预定标准识别SQL语句中的连接以便移除; 和c）对于每个已标识的连接，修改SQL语句以便删除所标识的连接，并将对所标识的连接引用的表的第一个实例的引用更改为表的第二个实例。

    Query generator
    9.
    发明授权
    Query generator 有权
    查询生成器

    公开(公告)号：US07467152B2

    公开(公告)日：2008-12-16

    申请号：US09730826

    申请日：2000-12-07

    申请人： Natascha Kearsey ,  Stephen David Cave ,  Andrew Osborn ,  Robert Lloyd Lavender ,  Kathryn Nash ,  Paolo Fragapane

    发明人： Natascha Kearsey ,  Stephen David Cave ,  Andrew Osborn ,  Robert Lloyd Lavender ,  Kathryn Nash ,  Paolo Fragapane

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30398 ,  Y10S707/99932 ,  Y10S707/99942 ,  Y10S707/99943

    摘要： The present invention relates to a query generator for generating a query for obtaining selected data from a database. The query generator includes a processor which is adapted to receive an input indicating the selected data to be obtained. The processor then analyses the input to determine whether the input requires a joining of data in different tables, and an aggregation step. If so, the processor generates a query which causes the database to aggregate the data within each of the tables as required; and, join the aggregated data, the joined aggregated data representing the selected data.

    摘要翻译： 本发明涉及一种查询生成器，用于从数据库生成用于获取所选数据的查询。 查询生成器包括处理器，其适于接收指示要获取的所选数据的输入。 然后，处理器分析输入以确定输入是否需要在不同的表中加入数据，以及聚合步骤。 如果是这样，处理器会生成一个查询，导致数据库根据需要汇总每个表中的数据; 并加入聚合数据，表示所选数据的连接聚合数据。

    Query generator
    10.
    发明申请
    Query generator 审中-公开
    查询生成器

    公开(公告)号：US20070239659A1

    公开(公告)日：2007-10-11

    申请号：US11392777

    申请日：2006-03-30

    申请人： Paolo Fragapane ,  Natascha Kearsey ,  Christopher Evans ,  Martin Hogg

    发明人： Paolo Fragapane ,  Natascha Kearsey ,  Christopher Evans ,  Martin Hogg

    IPC分类号： G06F17/30

    CPC分类号： G06F16/24534

    摘要： A query generator for generating a query for retrieving a desired set of data from a relational database is disclosed. The query generator is adapted to: a) receive an input query adapted to retrieve a superset of the desired set of data from the database; b) analyse a default filters table comprising one or more filter application criteria, each associated with a default filter condition that refers to data contained in the superset of data; and c) for each filter application criterion that is satisfied, modify the input query in accordance with the associated default filter condition to produce an output query adapted to retrieve the desired set of data only.

    摘要翻译： 公开了一种用于从关系数据库生成用于检索所需数据集的查询的查询生成器。 所述查询生成器适于：a）接收适于从所述数据库检索期望的数据集的超集的输入查询; b）分析包括一个或多个过滤器应用准则的默认过滤器表，每个与过滤器条件相关联，该默认过滤条件涉及包含在数据超集中的数据; 以及c）对于满足的每个过滤器应用标准，根据相关联的默认过滤条件来修改输入查询以产生仅适于检索所需数据集的输出查询。