利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

8 条记录 (耗时 0.025 秒)

    Query generator
    2.
    发明申请
    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）创建仅引用第二个视图的查询以及它所暴露的项目。

    Structured query language table merging
    3.
    发明授权
    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
    4.
    发明申请
    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
    5.
    发明授权
    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.

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

    Query generator
    6.
    发明授权
    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.

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

    Method of programming a processing system
    8.
    发明申请
    Method of programming a processing system 有权
    编程处理系统的方法

    公开(公告)号：US20050278059A1

    公开(公告)日：2005-12-15

    申请号：US11066687

    申请日：2005-02-25

    申请人： Andrew Osborn ,  Charles Cowham ,  Sarah Brown ,  Stephen Briers ,  Stephen Burgess ,  Alan Newson ,  Kyle Rhodes

    发明人： Andrew Osborn ,  Charles Cowham ,  Sarah Brown ,  Stephen Briers ,  Stephen Burgess ,  Alan Newson ,  Kyle Rhodes

    IPC分类号： G05B19/042 ,  G06F9/44 ,  G06F19/00

    CPC分类号： G05B19/0426 ,  G05B2219/23258 ,  G06F8/34

    摘要： Various methods of programming a processing system utilizing a computer having a configuration canvas, at least one processor, and a plurality of function objects is disclosed. A processing configuration is created by placing object icons associated with function objects onto the canvas. Execution paths are automatically routed between the object icons based on orientations of icons on the canvas. Data flow paths are created between object icons on the canvas separately from the routings of the execution paths. Execution paths can be re-routed to increase the versatility of the processing system. Also, visual instruments and instrument icons can be utilized to further graphically illustrate and control the processing configuration.

    摘要翻译： 公开了利用具有配置画布，至少一个处理器和多个功能对象的计算机对处理系统进行编程的各种方法。 通过将与功能对象相关联的对象图标放置在画布上来创建处理配置。 基于画布上的图标的方向，执行路径在对象图标之间自动路由。 在执行路径的路由上分别在画布上的对象图标之间创建数据流路径。 可以重新路由执行路径，以增加处理系统的多功能性。 此外，可以利用视觉仪器和仪器图标来进一步图形地说明和控制处理配置。