-
1.发明申请公开(公告)号：US20150261822A1
公开(公告)日：2015-09-17
申请号：US14205007
申请日：2014-03-11
IPC分类号： G06F17/30
CPC分类号： G06F17/30477
摘要： A query is received by a database server from a remote application server. The query is associated with a calculation scenario that defines a data flow model that includes one or more calculation nodes. The calculation nodes each define one or more operations to execute by a calculation engine on the database server. Thereafter, the database server instantiates a runtime model of the calculation scenario by accessing a local settings object stored with the calculation scenario that specifies local settings for the calculation scenario. Subsequently, the database server executes the operations defined by the calculation nodes of the instantiated calculation scenario to result in a responsive data set. The data set can then be provided by the database server to the application server.
摘要翻译： 数据库服务器从远程应用程序服务器接收到查询。 该查询与定义包含一个或多个计算节点的数据流模型的计算方案相关联。 计算节点各自定义一个或多个由数据库服务器上的计算引擎执行的操作。 此后，数据库服务器通过访问使用指定计算方案的本地设置的计算方案存储的本地设置对象来实例化计算方案的运行时模型。 随后，数据库服务器执行由实例计算场景的计算节点定义的操作以产生响应数据集。 数据集可以由数据库服务器提供给应用程序服务器。
-
公开(公告)号：US09116953B2
公开(公告)日：2015-08-25
申请号：US13896984
申请日：2013-05-17
IPC分类号： G06F17/30
CPC分类号： G06F17/30445
摘要： A query is received by a database server from a remote application server. The query is associated with a calculation model that defines a data flow model that includes a plurality of calculation nodes that each define one or more operations to execute on the database server. Thereafter, the database server dynamically determine, using at least one attribute of at least one dataset responsive to the query, that intermediate results provided by at least one of the operations specified by at least one of the nodes of the calculation model require partitioning. The database server then modifies the calculation model to partition operations on the at least one dataset based on the dynamic determination. The database server subsequently instantiates the modified calculation model so that it can be executed to generate at least one result set.
摘要翻译： 数据库服务器从远程应用程序服务器接收到查询。 该查询与定义包括多个计算节点的数据流模型的计算模型相关联，每个计算节点定义在数据库服务器上执行的一个或多个操作。 此后，数据库服务器使用响应于查询的至少一个数据集的至少一个属性来动态地确定由计算模型的至少一个节点指定的至少一个操作提供的中间结果需要分区。 然后，数据库服务器基于动态确定将计算模型修改为对至少一个数据集进行分区操作。 数据库服务器随后实例化修改的计算模型，使得其可被执行以产生至少一个结果集。
-
公开(公告)号：US20150142777A1
公开(公告)日：2015-05-21
申请号：US14084292
申请日：2013-11-19
IPC分类号： G06F17/30
CPC分类号： G06F17/30424
摘要： A query is received by a database server from a remote application server. The query is associated with a calculation scenario that defines a data flow model that includes one or more calculation nodes and that includes a pre-defined aggregation property. Each calculation node defines one or more operations to execute on the database server. The database server can include a column-oriented database. Thereafter, the database server instantiates the calculation scenario such that, based on the aggregation property, at least one non-aggregating operation specified by a calculation node is transformed into a aggregating operation based on a root node aggregation of the calculation scenario. Subsequently, the database server executes the operations defined by the calculation nodes of the optimized calculation scenario to result in a responsive data set. The database server then provides the data set to the application server.
摘要翻译： 数据库服务器从远程应用程序服务器接收到查询。 该查询与定义包含一个或多个计算节点并包含预定义聚合属性的数据流模型的计算方案相关联。 每个计算节点定义在数据库服务器上执行的一个或多个操作。 数据库服务器可以包括一个面向列的数据库。 此后，数据库服务器实例化计算场景，使得基于聚合属性，由计算节点指定的至少一个非聚合操作被转换为基于计算场景的根节点聚合的聚合操作。 随后，数据库服务器执行由优化的计算场景的计算节点定义的操作，以产生响应数据集。 然后，数据库服务器将数据集提供给应用程序服务器。
-
公开(公告)号：US20150142773A1
公开(公告)日：2015-05-21
申请号：US14083247
申请日：2013-11-18
IPC分类号： G06F17/30
CPC分类号： G06F17/30466
摘要： A query is received by a database server from a remote application server. The query is associated with a calculation scenario that defines a data flow model that includes one or more calculation nodes and that includes at least one hierarchy filter. Each hierarchy filter is a filter of at least one hierarchy table. Each calculation node defines one or more operations to execute on the database server. Thereafter, the database server instantiates the calculation scenario. The instantiating includes optimizing the calculation scenario by transforming at least one hierarchy filter and pushing down the at least one transformed hierarchy filter to a lower calculation node. The database server then executes the operations defined by the calculation nodes of the optimized calculation scenario to result in a responsive data set. The database server can subsequently provide the data set to the application server.
摘要翻译： 数据库服务器从远程应用程序服务器接收到查询。 该查询与定义包含一个或多个计算节点并且包括至少一个层次过滤器的数据流模型的计算方案相关联。 每个层次过滤器是至少一个层次表的过滤器。 每个计算节点定义在数据库服务器上执行的一个或多个操作。 此后，数据库服务器实例化计算方案。 实例化包括通过转换至少一个层次过滤器并将至少一个变换的层级过滤器推下到较低的计算节点来优化计算场景。 然后，数据库服务器执行由优化的计算场景的计算节点定义的操作以产生响应数据集。 数据库服务器可以随后将数据集提供给应用服务器。
-
5.发明授权公开(公告)号：US09037570B2
公开(公告)日：2015-05-19
申请号：US13914357
申请日：2013-06-10
IPC分类号： G06F17/30
CPC分类号： G06F17/30699 , G06F17/30424 , G06F17/30592
摘要： A query associated with a calculation scenario comprising a plurality of calculation nodes can be received by a calculation engine. The calculation scenario is instantiated and the query is transformed into a convex hull filter based on the at least one multiple selection condition that can be executed at any of the calculation nodes. The instantiated calculation scenario and the convex hull filter are executed to provide a result set. Related apparatus, systems, methods, and articles are also described.
摘要翻译： 可以由计算引擎接收与包括多个计算节点的计算场景相关联的查询。 计算场景被实例化，并且基于可以在任何计算节点处执行的至少一个多选择条件将查询转换成凸包过滤器。 执行实例计算场景和凸包过滤器以提供结果集。 还描述了相关装置，系统，方法和制品。
-
公开(公告)号：US20140344245A1
公开(公告)日：2014-11-20
申请号：US13897006
申请日：2013-05-17
IPC分类号： G06F17/30
CPC分类号： G06F17/30489
摘要： A database server receives a multi-part query from a remote application server. The multi-part query specifies a calculation scenario defining a data flow model that includes a plurality of calculation nodes that include a main section of nodes and two or more branches of nodes. Each calculation node defines one or more operations to execute on the database server. Thereafter, the database server instantiates the specified calculation scenario and additionally executes the operations defined by the calculation nodes of the main section of the instantiated calculation scenario a single time and executes the operations defined by the calculation nodes of the branches to result in respective responsive data sets corresponding to each branch. The responsive data sets are then provided by the database server to the application server. Related apparatus, systems, techniques and articles are also described.
摘要翻译： 数据库服务器从远程应用程序服务器接收多部分查询。 多部分查询指定定义包括多个计算节点的数据流模型的计算方案，所述计算节点包括节点的主要部分和节点的两个或多个分支。 每个计算节点定义在数据库服务器上执行的一个或多个操作。 此后，数据库服务器实例化指定的计算方案，并且另外执行由实例计算场景的主要部分的计算节点定义的操作，并执行由分支的计算节点定义的操作，以产生相应的响应数据 对应于每个分支的集合。 响应数据集然后由数据库服务器提供给应用程序服务器。 还描述了相关设备，系统，技术和物品。
-
公开(公告)号：US08838579B2
公开(公告)日：2014-09-16
申请号：US13457354
申请日：2012-04-26
IPC分类号： G06F17/30
CPC分类号： G06F17/30442 , G06F17/30463
摘要： A query is received and an initial data flow graph comprising a plurality of nodes is generated for executing the query. The initial data flow graph is optimized using a model optimizer that accesses at least one of a plurality of patterns to identify a matching pattern and executes at least one optimization rule associated with a matching pattern. Execution of the query is then initiated using the optimized data flow graph. Related apparatus, systems, techniques and articles are also described.
摘要翻译： 接收到查询，并且生成包括多个节点的初始数据流图，以执行查询。 使用模型优化器来优化初始数据流图，该模型优化器访问多个模式中的至少一个以识别匹配模式并且执行与匹配模式相关联的至少一个优化规则。 然后使用优化的数据流图来启动查询的执行。 还描述了相关设备，系统，技术和物品。
-
公开(公告)号：US20140222828A1
公开(公告)日：2014-08-07
申请号：US14248099
申请日：2014-04-08
IPC分类号： G06F17/30
CPC分类号： G06F17/30321 , G06F17/30241 , G06F17/30315 , G06F17/30445 , G06F17/30486
摘要： A database query of point data among two or more axes of a database is received. The database stores point data in distinct integer vectors with a shared dictionary. Thereafter, the dictionary is scanned to determine boundaries for each axis specified by the query. In response, results characterizing data responsive to the query within the determined boundaries for each axis are returned. Related apparatus, systems, techniques and articles are also described.
摘要翻译： 接收到数据库的两个或多个轴之间的点数据的数据库查询。 数据库使用共享字典将点数据存储在不同的整数向量中。 此后，扫描字典以确定查询指定的每个轴的边界。 作为响应，返回表征响应于针对每个轴的确定的边界内的查询的数据的结果。 还描述了相关设备，系统，技术和物品。
-
公开(公告)号：US20140108331A1
公开(公告)日：2014-04-17
申请号：US14109698
申请日：2013-12-17
IPC分类号： G06F17/30
CPC分类号： G06F16/254 , G06F16/24526 , G06F16/283
摘要： In one embodiment the present invention includes an OLAP execution model using relational operations. In one embodiment, the present invention includes, a method comprising receiving a first query in an online analytic processor (OLAP) executing on one or more computers, the OLAP generating and comprising a model specifying a graph defining a plurality of nodes and a plurality of tiers, each node corresponding to a different operation on data. A second query is generated by the OLAP. The second query includes a plurality of layered subqueries each corresponding to one of the nodes in the graph for specifying the different operations on data. The second query is received in a relational engine coupled to the datastore. The relational engine executes the second query, and in accordance therewith, retrieves data.
摘要翻译： 在一个实施例中，本发明包括使用关系操作的OLAP执行模型。 在一个实施例中，本发明包括一种方法，包括在一个或多个计算机上执行的在线分析处理器（OLAP）中接收第一查询，所述OLAP生成并包括指定限定多个节点的图形的模型和多个 每个节点对应于数据的不同操作。 第二个查询由OLAP生成。 第二查询包括多个分层子查询，每个子查询对应于图中的一个节点，用于指定关于数据的不同操作。 在耦合到数据存储的关系引擎中接收到第二个查询。 关系引擎执行第二个查询，并根据此查询数据。
-
公开(公告)号：US08650181B2
公开(公告)日：2014-02-11
申请号：US12951948
申请日：2010-11-22
IPC分类号： G06F7/00
CPC分类号： G06F17/30563 , G06F17/30436 , G06F17/30592
摘要： In one embodiment the present invention includes an OLAP execution model using relational operations. In one embodiment, the present invention includes, a method comprising receiving a first query in an online analytic processor (OLAP) executing on one or more computers, the OLAP generating and comprising a model specifying a graph defining a plurality of nodes and a plurality of tiers, each node corresponding to a different operation on data. A second query is generated by the OLAP. The second query includes a plurality of layered subqueries each corresponding to one of the nodes in the graph for specifying the different operations on data. The second query is received in a relational engine coupled to the datastore. The relational engine executes the second query, and in accordance therewith, retrieves data.
摘要翻译： 在一个实施例中，本发明包括使用关系操作的OLAP执行模型。 在一个实施例中，本发明包括一种方法，包括在一个或多个计算机上执行的在线分析处理器（OLAP）中接收第一查询，所述OLAP生成并包括指定限定多个节点的图形的模型和多个 每个节点对应于数据的不同操作。 第二个查询由OLAP生成。 第二查询包括多个分层子查询，每个子查询对应于图中的一个节点，用于指定关于数据的不同操作。 在耦合到数据存储的关系引擎中接收到第二个查询。 关系引擎执行第二个查询，并根据此查询数据。
-
-
-
-
-
-
-
-
-
搜索结果
69 条记录 (耗时 0.02 秒)
