Patents by Inventor Johannes Merx
Johannes Merx has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 10452659Abstract: 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.Type: GrantFiled: January 23, 2017Date of Patent: October 22, 2019Assignee: SAP SEInventors: Berthold Von Haaren, Christoph Weyerhaeuser, Johannes Merx, Julian Schwing
-
Publication number: 20190311058Abstract: 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.Type: ApplicationFiled: April 4, 2018Publication date: October 10, 2019Inventors: Davide Corradi, Johannes Merx, Julian Schwing, Christoph Weyerhaeuser
-
Publication number: 20190311059Abstract: Described herein includes a calculation scenario of a calculation engine that efficiently filters and joins data for processing. The calculation engine enhances the performance of the join operations by allowing join inputs to be pre-filtered more effectively. Such join operations can allow for faster processing times, and a reduction in the amount of data to be joined, resulting in more efficient processing.Type: ApplicationFiled: April 4, 2018Publication date: October 10, 2019Inventors: Alena Bakulina, Johannes Merx, Julian Schwing, Christoph Weyerhaeuser
-
Patent number: 10324930Abstract: A query is received by a database server from a remote application server that is associated with a calculation scenario that defines a data flow model including one or more calculation nodes including stacked multiproviders. Subsequently, the database server instantiates the calculation scenario and afterwards optimizes the calculation scenario. As part of the optimization, the calculation scenario is optimized by merging the two multiproviders. Thereafter, the operations defined by the calculation nodes of the optimized calculation scenario can be executed to result in a responsive data set. Next, the data set is provided to the application server by the database server.Type: GrantFiled: May 27, 2015Date of Patent: June 18, 2019Assignee: SAP SEInventors: Christoph Weyerhaeuser, Tobias Mindnich, Johannes Merx, Julian Schwing, Daniel Patejdl, Isil Pekel
-
Patent number: 10324927Abstract: Methods and apparatus, including computer program products, are provided for union node pruning. In one aspect, there is provided a method, which may include receiving, by a calculation engine, a query; processing a calculation scenario including a union node; accessing a pruning table associated with the union node, wherein the pruning table includes semantic information describing the first input from the first data source node and the second input from the second data source node; determining whether the first data source node and the second data source node can be pruned by at least comparing the semantic information to at least one filter of the query; and pruning, based on a result of the determining, at least one the first data source node or the second data source node. Related apparatus, systems, methods, and articles are also described.Type: GrantFiled: November 19, 2015Date of Patent: June 18, 2019Assignee: SAP SEInventors: Tobias Mindnich, Julian Schwing, Christoph Weyerhaeuser, Isil Pekel, Johannes Merx, Alena Bakulina
-
Patent number: 10303726Abstract: According to an aspect, a system for moving a filter in a query model to ensure query semantics includes a query engine configured to obtain a query model for a query to be executed on a database. The query engine includes a query optimizer configured to instantiate the query model by merging the query with the query model. The query optimizer includes a filter mover configured to move a filter to a point within the instantiated query model such that semantics for the query within the instantiated query model is ensured.Type: GrantFiled: November 13, 2014Date of Patent: May 28, 2019Assignee: SAP SEInventors: Christoph Weyerhaeuser, Tobias Mindnich, Johannes Merx, Joerg Schad, Stefan Dipper
-
Patent number: 10275490Abstract: A database server receives a query from a remote application server that is associated with a calculation scenario. The calculation scenario defines a data flow model that includes one or more calculation nodes that each define one or more operations to execute on the database server. A top operator node of the calculation nodes specifies a plurality of attributes and the query requests a subset of the attributes specified by the top operator node; Thereafter, the database server instantiates the calculation scenario so that it is optimized by requesting only the subset of attributes. 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 then provides the data set to the application server.Type: GrantFiled: January 28, 2015Date of Patent: April 30, 2019Assignee: SAP SEInventors: Christoph Weyerhaeuser, Tobias Mindnich, Isil Pekel, Johannes Merx, Daniel Patejdl
-
Patent number: 10255316Abstract: A database server receives a request to perform a primary query on a table of a database. A first table query can be generated and can include a starting row identifier, ROW A, and a number of rows, n, for generating a data chunk from the table of the database. Multiple table queries can be performed each having a different starting row identifier and each defining the number of rows forming a data chunk. The primary query can be extended with the first table query in preparation for performing the primary query on the first data chunk.Type: GrantFiled: November 18, 2015Date of Patent: April 9, 2019Assignee: SAP SEInventors: Christoph Weyerhaeuser, Alena Bakulina, Tobias Mindnich, Johannes Merx, Julian Schwing
-
Patent number: 10198475Abstract: A query that requests a filter attribute is received by a database server from a remote application server that is associated with a calculation scenario that defines a data flow model including one or more calculation nodes. Subsequently, the database server instantiates the calculation scenario. As part of the instantiation, the calculation scenario is optimized by (i) pushing down a filter attribute from a first node to a lowest available child node, (ii) removing the filter attribute from the first node, and (iii) removing non-required join-attributes from the instantiated calculation scenarios. Thereafter, the operations defined by the calculation nodes of the instantiated calculation scenario can be executed to result in a responsive data set. Next, the data set is provided to the application server by the database server.Type: GrantFiled: January 28, 2015Date of Patent: February 5, 2019Assignee: SAP SEInventors: Tobias Mindnich, Christoph Weyerhaeuser, Johannes Merx
-
Publication number: 20190018876Abstract: 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.Type: ApplicationFiled: July 14, 2017Publication date: January 17, 2019Inventors: Julian Schwing, Johannes Merx, Christoph Weyerhaeuser
-
Patent number: 10169410Abstract: A stacked calculation view, defining a calculation scenario, having calculation views associated with high-level programming logic which can include complex analytical privileges. Resolving, using a high-level programming logic layer, a calculation view having associated high-level programming logic with the next calculation view in the stack to generate a sub-query. Converting the sub-query into a format readable by a database system and separating the part of the sub-query provided by the high-level programming logic from the sub-query to form a high-level programming logic filter in the database system format. Merge the high-level programming logic filter into the calculation scenario to provide a calculation scenario including high-level programming logic information in the database system format.Type: GrantFiled: November 18, 2015Date of Patent: January 1, 2019Assignee: SAP SEInventors: Johannes Merx, Tobias Mindnich, Christoph Weyerhaeuser
-
Patent number: 10140335Abstract: A calculation engine is described that executes calculation scenarios comprising a plurality of calculation nodes that each specify operations to be performed to execute the query. One of the nodes can be a semantic node that is used to modify a higher-level programming language query that stacks the calculation scenario on top of another semantic node based calculation scenario for operations that call for processing of non-processable key figures. Non-processable key figures being key figures that produce incorrect semantics when processed by higher-level calculation scenarios. Related apparatus, systems, methods, and articles are also described.Type: GrantFiled: November 18, 2015Date of Patent: November 27, 2018Assignee: SAP SEInventors: Christoph Weyerhaeuser, Tobias Mindnich, Johannes Merx, Alena Bakulina
-
Patent number: 10114825Abstract: As part of query processing within a distributed execution environment framework, available resources taken into account when generating an execution plan and/or executing an execution plan to determine whether to parallelize any operations. Related apparatus, systems, methods and articles are also described.Type: GrantFiled: March 14, 2014Date of Patent: October 30, 2018Assignee: SAP SEInventors: Christoph Weyerhaeuser, Tobias Mindnich, Johannes Merx, Joerg Schad, Julian Schwing
-
Patent number: 10067980Abstract: 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.Type: GrantFiled: June 16, 2015Date of Patent: September 4, 2018Assignee: SAP SEInventors: Christoph Weyerhaeuser, Tobias Mindnich, Johannes Merx, Julian Schwing, Daniel Patejdl
-
Publication number: 20180210921Abstract: 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.Type: ApplicationFiled: January 23, 2017Publication date: July 26, 2018Inventors: Berthold Von Haaren, Christoph Weyerhaeuser, Johannes Merx, Julian Schwing
-
Publication number: 20180196833Abstract: 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.Type: ApplicationFiled: January 10, 2017Publication date: July 12, 2018Inventors: Davide Corradi, Daniel Patejdl, Christoph Weyerhaeuser, Johannes Merx, Julian Schwing
-
Publication number: 20180137011Abstract: 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.Type: ApplicationFiled: November 17, 2016Publication date: May 17, 2018Inventors: JULIAN SCHWING, Johannes Merx, Christoph Weyerhaeuser
-
Patent number: 9916374Abstract: A query is received by a database server from a remote application server. The query encapsulates an on-the-fly calculation scenario that defines a data flow model that includes one or more calculation nodes. Thereafter, the database server instantiates the on-the-fly calculation scenario. The database server then executes the operations defined by the calculation nodes of the instantiated calculation scenario to result in a responsive data set so that the database server can provide the data set to the application server. Related apparatus, systems, methods, and articles are also described.Type: GrantFiled: May 31, 2013Date of Patent: March 13, 2018Assignee: SAP SEInventors: Christoph Weyerhaeuser, Tobias Mindnich, Daniel Baeumges, Johannes Merx
-
Patent number: 9846724Abstract: According to an aspect, a database system for integrating calculation models into execution plans includes a first engine configured to parse a query to be applied on a database. The first engine is configured to invoke a second engine during query compilation. The second engine is configured to instantiate a calculation model based on the query, and the second engine is configured to derive a converted calculation model by converting the calculation model into a format compatible with the first engine. The first engine is configured to incorporate the converted calculation model into an execution plan during the query compilation and execute the query on the database according to execution plan.Type: GrantFiled: November 13, 2014Date of Patent: December 19, 2017Assignee: SAP SEInventors: Christoph Weyerhaeuser, Tobias Mindnich, Johannes Merx, Yongsik Yoon, Sung Heun Wi, Jeong Ae Han
-
Publication number: 20170323001Abstract: A calculation engine of a database management system is described. In some implementations, the calculation engine receives a calculation scenario including a plurality of calculation views comprising one or more relational operations. The calculation engine determines whether a first calculation view includes a second calculation view configured as an operand of one of the relational operations of the first calculation view, and also determines whether the second calculation view comprises a non-relational operation. The calculation engine further converts the plurality of calculation views into a calculation plan via merging the first calculation view with the second calculation view when the first calculation view is determined to comprise the second calculation view as an operand, and replacing the second calculation view with a view search operation when the second calculation view is determined to comprise the non-relational operation.Type: ApplicationFiled: May 9, 2016Publication date: November 9, 2017Applicants: SAP SE, SAP SEInventors: Julian Schwing, Johannes Merx, Christoph Weyerhaeuser