Patents by Inventor Bernhard Jaecksch
Bernhard Jaecksch 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: 10929395Abstract: A system, medium, and method including modifying a graphical view representation of a first table of a set of data, the first table having at least a first column subject to changes in value; modifying a graphical view representation of a second table of a second set of data; determining a query operation of the view representations of the first table and second table; aggregating values of the view representation of the result of the query operation having a same key; determining, based on the aggregated values, values for the first column of the view representation of the first table; and providing an output of the values for the first column of the view representation of the first table, the output values including changed values.Type: GrantFiled: December 12, 2014Date of Patent: February 23, 2021Assignee: SAP SEInventors: Markus Ulke, Bernhard Jaecksch, Franz Faerber
-
Patent number: 10210209Abstract: A procedural pattern in a received query execution plan can be matched to a stored pattern for which an equivalent declarative operator has been pre-defined. The query execution plan can describe a query for accessing data. A hybrid execution plan can be generated by replacing the procedural pattern with the equivalent declarative operator. A hybrid execution plan processing cost can be assigned to execution of the hybrid execution plan and a query execution plan processing cost can be assigned to execution of the query execution plan. The assigning can include evaluating a cost model for the hybrid execution plan and the query execution plan. The query can be executed using the hybrid execution plan if the hybrid execution plan processing cost is less than the query execution plan processing cost or the query execution plan if the hybrid execution plan processing cost is greater than the query execution plan processing cost. Related systems, methods, and articles of manufacture are disclosed.Type: GrantFiled: July 14, 2016Date of Patent: February 19, 2019Assignee: SAP SEInventors: Bernhard Jaecksch, Franz Faerber
-
Patent number: 9922300Abstract: According to some embodiments, input data may be received from a data source in an enterprise database in accordance with an enterprise performance management planning model, stored by a processor at the enterprise database. An operation may then be performed on the input data to produce a result. The result may then be stored in a data target, wherein the data target points to a data holding entity in an instantiation of a plan data container at the enterprise database.Type: GrantFiled: January 9, 2014Date of Patent: March 20, 2018Assignee: SAP SEInventors: Jan Rittinger, Bernhard Jaecksch, Daniel Merkel, Gerrit Simon Kazmaier, Lars Volker, Stefan Uhrig, Yeonghee Choi
-
Publication number: 20160321322Abstract: A procedural pattern in a received query execution plan can be matched to a stored pattern for which an equivalent declarative operator has been pre-defined. The query execution plan can describe a query for accessing data. A hybrid execution plan can be generated by replacing the procedural pattern with the equivalent declarative operator. A hybrid execution plan processing cost can be assigned to execution of the hybrid execution plan and a query execution plan processing cost can be assigned to execution of the query execution plan. The assigning can include evaluating a cost model for the hybrid execution plan and the query execution plan. The query can be executed using the hybrid execution plan if the hybrid execution plan processing cost is less than the query execution plan processing cost or the query execution plan if the hybrid execution plan processing cost is greater than the query execution plan processing cost. Related systems, methods, and articles of manufacture are disclosed.Type: ApplicationFiled: July 14, 2016Publication date: November 3, 2016Inventors: Bernhard Jaecksch, Franz Faerber
-
Patent number: 9418108Abstract: A procedural pattern in a received query execution plan can be matched to a stored pattern for which an equivalent declarative operator has been pre-defined. The query execution plan can describe a query for accessing data. A hybrid execution plan can be generated by replacing the procedural pattern with the equivalent declarative operator. A hybrid execution plan processing cost can be assigned to execution of the hybrid execution plan and a query execution plan processing cost can be assigned to execution of the query execution plan. The assigning can include evaluating a cost model for the hybrid execution plan and the query execution plan. The query can be executed using the hybrid execution plan if the hybrid execution plan processing cost is less than the query execution plan processing cost or the query execution plan if the hybrid execution plan processing cost is greater than the query execution plan processing cost. Related systems, methods, and articles of manufacture are disclosed.Type: GrantFiled: January 11, 2013Date of Patent: August 16, 2016Assignee: SAP SEInventors: Bernhard Jaecksch, Franz Faerber
-
Publication number: 20160048559Abstract: A system, medium, and method including modifying a graphical view representation of a first table of a set of data, the first table having at least a first column subject to changes in value; modifying a graphical view representation of a second table of a second set of data; determining a query operation of the view representations of the first table and second table; aggregating values of the view representation of the result of the query operation having a same key; determining, based on the aggregated values, values for the first column of the view representation of the first table; and providing an output of the values for the first column of the view representation of the first table, the output values including changed values.Type: ApplicationFiled: December 12, 2014Publication date: February 18, 2016Inventors: Markus Ulke, Bernhard Jaecksch, Franz Faerber
-
Publication number: 20150149258Abstract: According to some embodiments, input data may be received from a data source in an enterprise database in accordance with an enterprise performance management planning model, stored by a processor at the enterprise database. An operation may then be performed on the input data to produce a result. The result may then be stored in a data target, wherein the data target points to a data holding entity in an instantiation of a plan data container at the enterprise database.Type: ApplicationFiled: January 9, 2014Publication date: May 28, 2015Inventors: Jan Rittinger, Bernhard Jaecksch, Daniel Merkel, Gerrit Simon Kazmaier, Lars Volker, Stefan Uhrig, Yeonghee Choi
-
Publication number: 20130132370Abstract: A procedural pattern in a received query execution plan can be matched to a stored pattern for which an equivalent declarative operator has been pre-defined. The query execution plan can describe a query for accessing data. A hybrid execution plan can be generated by replacing the procedural pattern with the equivalent declarative operator. A hybrid execution plan processing cost can be assigned to execution of the hybrid execution plan and a query execution plan processing cost can be assigned to execution of the query execution plan. The assigning can include evaluating a cost model for the hybrid execution plan and the query execution plan. The query can be executed using the hybrid execution plan if the hybrid execution plan processing cost is less than the query execution plan processing cost or the query execution plan if the hybrid execution plan processing cost is greater than the query execution plan processing cost. Related systems, methods, and articles of manufacture are disclosed.Type: ApplicationFiled: January 11, 2013Publication date: May 23, 2013Inventors: Bernhard Jaecksch, Franz Faerber
-
Patent number: 8356027Abstract: A procedural pattern in a received query execution plan can be matched to a stored pattern for which an equivalent declarative operator has been pre-defined. The query execution plan can describe a query for accessing data. A hybrid execution plan can be generated by replacing the procedural pattern with the equivalent declarative operator. A hybrid execution plan processing cost can be assigned to execution of the hybrid execution plan and a query execution plan processing cost can be assigned to execution of the query execution plan. The assigning can include evaluating a cost model for the hybrid execution plan and the query execution plan. The query can be executed using the hybrid execution plan if the hybrid execution plan processing cost is less than the query execution plan processing cost or the query execution plan if the hybrid execution plan processing cost is greater than the query execution plan processing cost. Related systems, methods, and articles of manufacture are disclosed.Type: GrantFiled: December 17, 2010Date of Patent: January 15, 2013Assignee: SAP AGInventors: Bernhard Jaecksch, Franz Faerber
-
Publication number: 20120089595Abstract: A procedural pattern in a received query execution plan can be matched to a stored pattern for which an equivalent declarative operator has been pre-defined. The query execution plan can describe a query for accessing data. A hybrid execution plan can be generated by replacing the procedural pattern with the equivalent declarative operator. A hybrid execution plan processing cost can be assigned to execution of the hybrid execution plan and a query execution plan processing cost can be assigned to execution of the query execution plan. The assigning can include evaluating a cost model for the hybrid execution plan and the query execution plan. The query can be executed using the hybrid execution plan if the hybrid execution plan processing cost is less than the query execution plan processing cost or the query execution plan if the hybrid execution plan processing cost is greater than the query execution plan processing cost. Related systems, methods, and articles of manufacture are disclosed.Type: ApplicationFiled: December 17, 2010Publication date: April 12, 2012Inventor: Bernhard Jaecksch