公开(公告)号：US07797307B2

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

申请号：US11340599

申请日：2006-01-27

申请人： Joel Turkel ,  Raghuram Venkatasubramanian

发明人： Joel Turkel ,  Raghuram Venkatasubramanian

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

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

摘要： A query generator for generating a query which retrieves a desired set of data from a relational database and performs one or more aggregation functions on the set of data is disclosed. The query generator is adapted to: a) receive user input indicating the desired set of data and the aggregation functions to be performed; b) identify each join subgraph for the desired set of data; c) for each join subgraph identified in step (b), generate an inline view which, on execution, performs all of the aggregation functions that refer only to data within that join subgraph; and d) generate an output query comprising the inline views generated in step (c) as arguments of a join.

摘要翻译： 一种查询生成器，用于生成从关系数据库检索所需数据集并且对数据集合执行一个或多个聚合函数的查询。 查询生成器适于：a）接收指示所需数据集合和要执行的聚合函数的用户输入; b）识别所需数据集合的每个连接子图; c）对于在步骤（b）中标识的每个连接子图，生成一个内联视图，其在执行时执行仅引用该连接子图中的数据的所有聚合函数; 以及d）生成包括在步骤（c）中生成的内联视图作为连接的参数的输出查询。

公开(公告)号：US20070185833A1

公开(公告)日：2007-08-09

申请号：US11340599

申请日：2006-01-27

申请人： Joel Turkel ,  Raghuram Venkatasubramanian

发明人： Joel Turkel ,  Raghuram Venkatasubramanian

IPC分类号： G06F17/30

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

摘要： A query generator for generating a query which retrieves a desired set of data from a relational database and performs one or more aggregation functions on the set of data is disclosed. The query generator is adapted to: a) receive user input indicating the desired set of data and the aggregation functions to be performed; b) identify each join subgraph for the desired set of data; c) for each join subgraph identified in step (b), generate an inline view which, on execution, performs all of the aggregation functions that refer only to data within that join subgraph; and d) generate an output query comprising the inline views generated in step (c) as arguments of a join.

摘要翻译： 一种查询生成器，用于生成从关系数据库检索所需数据集并且对数据集合执行一个或多个聚合函数的查询。 查询生成器适于：a）接收指示所需数据集合和要执行的聚合函数的用户输入; b）识别所需数据集合的每个连接子图; c）对于在步骤（b）中标识的每个连接子图，生成一个内联视图，其在执行时执行仅引用该连接子图中的数据的所有聚合函数; 以及d）生成包括在步骤（c）中生成的内联视图作为连接的参数的输出查询。

公开(公告)号：US08166020B2

公开(公告)日：2012-04-24

申请号：US11314343

申请日：2005-12-22

申请人： Joel Turkel ,  Raghuram Venkatasubramanian

发明人： Joel Turkel ,  Raghuram Venkatasubramanian

IPC分类号： G06F17/30

CPC分类号： G06F17/30427

摘要： A query generator for generating a query that returns a result set comprising data retrieved from a database and data returned by an analytic function that operates on at least a portion of the retrieved data is disclosed. The result set is arranged as a table having a plurality of rows, and the query generator is adapted to: a) receive an input query indicating the data to be retrieved from the database, which of these data are to be operated on by the analytic function and the identity of the analytic function; b) analyse the input query to ascertain whether it retrieves a data item or calculates an aggregation result from a plurality of data items that will be repeated across one or more rows of the result set and that is to be operated on by the analytic function; and c) if it does, modify the input query to cause the database to split the retrieved data into a number of partitions such that the data value or aggregation result is present only once in each partition; before operating on the retrieved data with the analytic function.

摘要翻译： 公开了一种查询生成器，用于生成返回包括从数据库检索的数据的结果集的查询，以及由至少部分所检索的数据进行操作的分析函数返回的数据。 结果集被排列为具有多行的表，并且查询生成器适于：a）从数据库接收指示要检索的数据的输入查询，这些数据中的哪一个将被分析 功能和分析功能的身份; b）分析输入查询以确定其是否检索数据项，或者从将在结果集的一行或多行上重复并将由分析函数进行操作的多个数据项计算聚合结果; 和c）如果是，则修改输入查询以使数据库将检索的数据拆分成多个分区，使得数据值或聚合结果在每个分区中只存在一次; 在使用分析功能对检索到的数据进行操作之前。

公开(公告)号：US20070150436A1

公开(公告)日：2007-06-28

申请号：US11314343

申请日：2005-12-22

申请人： Joel Turkel ,  Raghuram Venkatasubramanian

发明人： Joel Turkel ,  Raghuram Venkatasubramanian

IPC分类号： G06F17/30

CPC分类号： G06F17/30427

摘要： A query generator for generating a query that returns a result set comprising data retrieved from a database and data returned by an analytic function that operates on at least a portion of the retrieved data is disclosed. The result set is arranged as a table having a plurality of rows, and the query generator is adapted to: a) receive an input query indicating the data to be retrieved from the database, which of these data are to be operated on by the analytic function and the identity of the analytic function; b) analyse the input query to ascertain whether it retrieves a data item or calculates an aggregation result from a plurality of data items that will be repeated across one or more rows of the result set and that is to be operated on by the analytic function; and c) if it does, modify the input query to cause the database to split the retrieved data into a number of partitions such that the data value or aggregation result is present only once in each partition; before operating on the retrieved data with the analytic function.

摘要翻译： 公开了一种查询生成器，用于生成返回包括从数据库检索的数据的结果集的查询，以及由至少部分所检索的数据进行操作的分析函数返回的数据。 结果集被排列为具有多行的表，并且查询生成器适于：a）从数据库接收指示要检索的数据的输入查询，这些数据中的哪一个将被分析 功能和分析功能的身份; b）分析输入查询以确定其是否检索数据项，或者从将在结果集的一行或多行上重复并将由分析函数进行操作的多个数据项计算聚合结果; 和c）如果是，则修改输入查询以使数据库将检索的数据拆分成多个分区，使得数据值或聚合结果在每个分区中仅存在一次; 在使用分析功能对检索到的数据进行操作之前。

公开(公告)号：US07110997B1

公开(公告)日：2006-09-19

申请号：US10440064

申请日：2003-05-15

申请人： Joel Turkel ,  Kathryn Nash ,  Raghuram Venkatasubramanian ,  Steve Cave

发明人： Joel Turkel ,  Kathryn Nash ,  Raghuram Venkatasubramanian ,  Steve Cave

IPC分类号： G06F17/30

CPC分类号： G06F17/30539 ,  Y10S707/954 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935

摘要： Embodiments of the present invention provide an ad-hoc query engine. The ad-hoc query engine comprises a query management module, a metadata module, a data cache module and a viewer module. The query management module receives a query request from a client device. The query request is specified in terms of a plurality of business objects. The query management module utilizes the metadata module to translate the business objects into a structured query language statement as a function of the content of the data cache module. The SQL statement comprises a plurality of aggregation. The query management module dynamically causes each aggregation to be re-directed to execute against the content of the data cache module, when the aggregation is locally or linearly computable from said content of said data cache module. The query management utilizes the viewer module to generate a report as a function of the results of the executed SQL statement.

摘要翻译： 本发明的实施例提供了一种即席查询引擎。 该自组织查询引擎包括查询管理模块，元数据模块，数据高速缓存模块和观看者模块。 查询管理模块从客户端设备接收查询请求。 查询请求是根据多个业务对象来指定的。 查询管理模块利用元数据模块根据数据缓存模块的内容将业务对象转换为结构化查询语言语句。 SQL语句包括多个聚合。 当聚合从所述数据高速缓存模块的所述内容进行本地或线性计算时，所述查询管理模块动态地使得每个聚合被重定向以对数据高速缓存模块的内容执行。 查询管理利用查看器模块根据执行的SQL语句的结果生成报告。