-
公开(公告)号：US20200320082A1
公开(公告)日：2020-10-08
申请号：US16372951
申请日：2019-04-02
申请人： SAP SE
IPC分类号： G06F16/2455 , G06F16/22 , G06F16/21 , G06F16/25 , G06F16/2453
摘要： A calculation engine of a database management system is described that determines a multiprovider includes a first data source and a second data source that each require different approaches for operation optimization. The calculation engine can split the multiprovider into a first node corresponding to a first operation compatible with the first data source and a second node corresponding to a second operation compatible with the second data source. The calculation engine can perform the first operation at the first data source to produce a first result and perform the second operation at the second data source to produce a second result. The calculation engine can then merge the first result and the second result according to a third operation, and perform such third operation at the first data source.
-
公开(公告)号：US20170139989A1
公开(公告)日：2017-05-18
申请号：US14945207
申请日：2015-11-18
申请人： SAP SE
IPC分类号： G06F17/30
CPC分类号： G06F16/24537 , G06F16/24545 , G06F16/24554
摘要： A calculation engine of a database management system receives a calculation scenario. The calculation scenario comprises a query of a multiprovider that comprises a plurality of partitions. The calculation engine evaluates the query to identify a partition of the plurality of partitions that is not necessary for responding to the query. The calculation engine prunes the partition from the calculation scenario. The pruning comprises not loading or accessing the partition in the execution of the query and/or removing the filter constraint for the partition.
-
公开(公告)号：US20160371330A1
公开(公告)日：2016-12-22
申请号：US14741377
申请日：2015-06-16
申请人： SAP SE
IPC分类号： G06F17/30
CPC分类号： G06F17/30466 , G06F17/30451
摘要： A calculation engine is described that executes calculation scenarios comprising a plurality of calculation nodes that specify operations to be performed to execute the query. One of the nodes can be a semantic node that is used to modify the query for operations requiring special handling including handling of hierarchy views. Related apparatus, systems, methods, and articles are also described.
摘要翻译： 描述了执行包括指定要执行以执行查询的操作的多个计算节点的计算场景的计算引擎。 其中一个节点可以是一个语义节点，用于修改需要特殊处理的操作的查询，包括层次结构视图的处理。 还描述了相关装置，系统，方法和制品。
-
公开(公告)号：US10558652B2
公开(公告)日：2020-02-11
申请号：US15650800
申请日：2017-07-14
申请人： SAP SE
IPC分类号： G06F17/30 , G06F16/242 , G06F16/84 , G06F16/2453 , G06F16/2455 , G06F16/28
摘要： A method may include executing a calculation scenario at a database. The calculation scenario may include a parent multiprovider aggregating data from a child multiprovider. The calculation scenario may be executed by mapping a first count keyfigure of the child multiprovider to a first sum keyfigure of the parent multiprovider if the child multiprovider aggregates data from part providers but not from multiproviders. A second sum keyfigure of the child multiprovider may be mapped to the first sum keyfigure of the parent multiprovider if the child multiprovider aggregates data from multiproviders but not from any part providers. The first count keyfigure of the child multiprovider may be mapped to a second count keyfigure of the parent multiprovider and the second sum keyfigure of the child multiprovider may be mapped to the first sum keyfigure of the parent multiprovider if the child multiprovider aggregates data from part providers and multiproviders.
-
公开(公告)号：US10552388B2
公开(公告)日：2020-02-04
申请号：US15402779
申请日：2017-01-10
申请人： SAP SE
IPC分类号： G06F16/215 , G06F16/25
摘要： Described herein includes finding and replacing, including automatically, at least one null value in a table for allowing processing of the table with an ABAP-based application. In some implementations, the null values are replaced with replacement values that are compatible with further processing of the data in the table. For example, a replacement value can be a string providing information or a value, such as for performing a calculation.
-
公开(公告)号：US10452659B2
公开(公告)日：2019-10-22
申请号：US15412765
申请日：2017-01-23
申请人： SAP SE
IPC分类号： G06F17/30 , G06F16/2455 , G06F16/28
摘要： Described herein includes processing various instruction sets configured for online analytics processing (OLAP) using a calculation engine. This allows OLAP configured instruction sets or calculation scenarios to be efficiently and effectively processed with the calculation engine during run time thereby preventing delays and errors during processing.
-
公开(公告)号：US20180210921A1
公开(公告)日：2018-07-26
申请号：US15412765
申请日：2017-01-23
申请人： SAP SE
IPC分类号： G06F17/30
CPC分类号： G06F16/2456 , G06F16/283
摘要： Described herein includes processing various instruction sets configured for online analytics processing (OLAP) using a calculation engine. This allows OLAP configured instruction sets or calculation scenarios to be efficiently and effectively processed with the calculation engine during run time thereby preventing delays and errors during processing.
-
公开(公告)号：US20180196833A1
公开(公告)日：2018-07-12
申请号：US15402779
申请日：2017-01-10
申请人： SAP SE
IPC分类号： G06F17/30
摘要： Described herein includes finding and replacing, including automatically, at least one null value in a table for allowing processing of the table with an ABAP-based application. In some implementations, the null values are replaced with replacement values that are compatible with further processing of the data in the table. For example, a replacement value can be a string providing information or a value, such as for performing a calculation.
-
公开(公告)号：US11113285B2
公开(公告)日：2021-09-07
申请号：US15945022
申请日：2018-04-04
申请人： SAP SE
IPC分类号： G06F17/30 , G06F16/2455 , G06F16/22 , G06F16/2453
摘要： Described herein includes a calculation scenario of a calculation engine that efficiently partitions data for processing at separate hosts, including in parallel, and unions intermediate results from such separate processing when required for further processing. Such parallel processing of partitions can allow for faster processing times, and such unioning of data only when required for further processing can limit the transferring of data that results in slower processing.
-
公开(公告)号：US20210182299A1
公开(公告)日：2021-06-17
申请号：US16711141
申请日：2019-12-11
申请人： SAP SE
IPC分类号： G06F16/2457 , G06F16/21 , G06F16/27
摘要： A calculation engine of a database management system is described. The calculation engine may receive a query associated with a calculation scenario that defines a data flow model. The data flow model may include one or more calculation nodes, each of which corresponding to an operation performed on one or more database tables stored at a database. The one or more calculation nodes may include at least one calculation node corresponding to a ranking filter operation. The calculation engine may execute the query including by executing the calculation scenario. The executing of the calculation scenario may include performing the ranking filter operation to generate a result corresponding to at least a portion of rows included in a first partition of a database table stored at the database. Related systems, methods, and articles of manufacture are provided.
-
-
-
-
-
-
-
-
-
搜索结果
32 条记录 (耗时 0.015 秒)
