Patents by Inventor Stefan Dipper
Stefan Dipper 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: 10664479Abstract: Methods, systems, and computer-readable storage media for receiving user input indicating a value of a first setting of one or more settings, the first setting defining a data integrity scenario that is be applied during a query session with a database system, the data integrity scenario defining data sources for reading data in response to one or more navigation requests, if a concurrent change occurs in the database system, receiving a query, reading, data from one or more data sources based on the query and the first setting, selectively caching at least a portion of the data based on the first setting, and providing a result for display to a user that submitted the query.Type: GrantFiled: June 27, 2014Date of Patent: May 26, 2020Assignee: SAP SEInventors: Sebastian Schroetel, Stefan Dipper, Stefan Unnebrink, Dirk Janning
-
Patent number: 10489394Abstract: In one embodiment, a method receives a query for analyzing data in a database. The query includes a first level calculation that is performed before a second level calculation. When an operator associated with the first level calculation is present in the query, the method performs: calculating the first level calculation by removing group by information for a reference characteristic for the first level calculation to determine a first level calculation result and calculating the second level calculation using the first level calculation result using the group by information for the reference characteristic to determine a second level calculation result, wherein the group by in the second level calculation combines groups of rows in a database table of the database that have the same content in their specified columns.Type: GrantFiled: May 25, 2016Date of Patent: November 26, 2019Assignee: SAP SEInventors: Sebastian Schroetel, Stefan Dipper, Michael Wilking, Christof Mueller
-
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: 9965512Abstract: In one embodiment, a method receives a query for analyzing data in a database. The method then determines a constant in the query and determines an operator applied to the constant in the query. The operator explicitly controls a behavior of the constant. The constant is represented as a scalar representation in the query instead of as a vectorial representation where the constant would have been used as the vectorial representation without the use of the operator due to a rule governing use of constants. Then, the method performs a calculation for the query to determine a query result using the constant as the scalar representation.Type: GrantFiled: June 25, 2013Date of Patent: May 8, 2018Assignee: SAP SEInventors: Stefan Dipper, Sebastian Schroetel, Michael Wilking, Christof Mueller, Tim Kaiser
-
Patent number: 9922087Abstract: The disclosure generally describes computer-implemented methods, software, and systems for generating and executing queries. A query is received. A set of structure elements associated with the query is determined, wherein the structure elements are used for accessing, in a database, data tuples associated with the set of structure elements. Optionally, the set of structure elements is reduced for accessing data tuples to the structure elements selected. Contributing structure elements are added to the reduced set to not produce objects in the result set but for creating associated objects. Contributing structure elements are handled in an optimized way to keep the data set on which the query result set is calculated as small as possible. This is done by using the smallest set of characteristics in the group-by clause for retrieving the data set to calculate the requested set of structure elements. A result set of the query is provided.Type: GrantFiled: July 1, 2014Date of Patent: March 20, 2018Assignee: SAP SEInventors: Michael Wilking, Stefan Dipper
-
Patent number: 9471662Abstract: A system includes reception of an instruction to evaluate homogeneity of a first set of values of a plurality of stored sets of values, determination of a first minimum of the first set of values, determination of a first maximum of the first set of values, determination of whether the first minimum and the first maximum are equal, and if it is determined that the first minimum and the first maximum are equal, return of a value equal to the first minimum and the first maximum in response to the instruction.Type: GrantFiled: June 24, 2013Date of Patent: October 18, 2016Assignee: SAP SEInventors: Stefan Dipper, Michael Wilking, Ingo Raasch, Frank Klingl
-
Patent number: 9449032Abstract: Embodiments provide a multi-buffering system in an application layer to support unified read/write access to different data source types of an underlying database layer. In a particular embodiment, the database layer comprises both a multi-dimensional data source (e.g. a cube), and another data source type (e.g. a Data Store Object—DSO). An abstract buffer component of the multi-buffering system is specialized into a delta buffer configured to read/write data of the cube, and into an after image buffer configured to read/write data of the DSO. A storage mechanism component of the multi-buffering system is specialized into a cache store configured to read/write data of the cube, and a calculation scenario store configured to read/write data of the DSO. The after image buffer may support certain aggregation rules during a DSO read/write operation. The calculation scenario store may leverage capabilities of an in memory database during a DSO read/write operation.Type: GrantFiled: April 22, 2013Date of Patent: September 20, 2016Assignee: SAP SEInventors: Martin Friedt, Hans-Georg Beuter, Helidon Dollani, Michael Wilking, Gregor Dieckmann, Ingo Raasch, Stefan Dipper
-
Publication number: 20160267129Abstract: In one embodiment, a method receives a query for analyzing data in a database. The query includes a first level calculation that is performed before a second level calculation. When an operator associated with the first level calculation is present in the query, the method performs: calculating the first level calculation by removing group by information for a reference characteristic for the first level calculation to determine a first level calculation result and calculating the second level calculation using the first level calculation result using the group by information for the reference characteristic to determine a second level calculation result, wherein the group by in the second level calculation combines groups of rows in a database table of the database that have the same content in their specified columns.Type: ApplicationFiled: May 25, 2016Publication date: September 15, 2016Inventors: Sebastian Schroetel, Stefan Dipper, Michael Wilking, Christof Mueller
-
Patent number: 9400830Abstract: A system and method of key figure data filters are presented. The key figure data filters are implemented in an analytical engine of a business warehouse system. The key figure data filters employ conditions, which can be expressed as a kind of selection that describe a set. A key figure data algorithm can be implemented by the analytical engine using the conditions, yet still respect hierarchies in the business warehouse database.Type: GrantFiled: March 21, 2013Date of Patent: July 26, 2016Assignee: SAP SEInventors: Stefan Dipper, Sebastian Schroetel, Stefan Unnebrink, Michael Wilking
-
Patent number: 9378264Abstract: In one embodiment, a method receives a query for analyzing data in a database. The query includes a first level calculation that is performed before a second level calculation. The method determines an operator in the query configured to explicitly remove group by information for a reference characteristic in the first level calculation where the group by information is specified for the reference characteristic in the second level calculation. The first level calculation is performed by removing the group by information for the reference characteristic for the first level calculation to determine a first level calculation result and the second level calculation is performed using the first level calculation result using the group by information for the reference characteristic to determine a second level calculation result.Type: GrantFiled: June 18, 2013Date of Patent: June 28, 2016Assignee: SAP SEInventors: Sebastian Schroetel, Stefan Dipper, Michael Wilking, Christof Mueller
-
Publication number: 20160140241Abstract: 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: ApplicationFiled: November 13, 2014Publication date: May 19, 2016Inventors: Christoph Weyerhaeuser, Tobias Mindnich, Johannes Merx, Joerg Schad, Stefan Dipper
-
Publication number: 20160004746Abstract: The disclosure generally describes computer-implemented methods, software, and systems for generating and executing queries. A query is received. A set of structure elements associated with the query is determined, wherein the structure elements are used for accessing, in a database, data tuples associated with the set of structure elements. Optionally, the set of structure elements is reduced for accessing data tuples to the structure elements selected. Contributing structure elements are added to the reduced set to not produce objects in the result set but for creating associated objects. Contributing structure elements are handled in an optimized way to keep the data set on which the query result set is calculated as small as possible. This is done by using the smallest set of characteristics in the group-by clause for retrieving the data set to calculate the requested set of structure elements. A result set of the query is provided.Type: ApplicationFiled: July 1, 2014Publication date: January 7, 2016Inventors: Michael Wilking, Stefan Dipper
-
Publication number: 20150379059Abstract: Methods, systems, and computer-readable storage media for receiving user input indicating a value of a first setting of one or more settings, the first setting defining a data integrity scenario that is be applied during a query session with a database system, the data integrity scenario defining data sources for reading data in response to one or more navigation requests, if a concurrent change occurs in the database system, receiving a query, reading, data from one or more data sources based on the query and the first setting, selectively caching at least a portion of the data based on the first setting, and providing a result for display to a user that submitted the query.Type: ApplicationFiled: June 27, 2014Publication date: December 31, 2015Inventors: Sebastian Schroetel, Stefan Dipper, Stefan Unnebrink, Dirk Janning
-
Patent number: 9195690Abstract: A system includes determination of a dimension over which to iterate, determination of a first measure for which an aggregated value is determined per iteration, determination of a second measure for which a value is determined once per calculation of an iterative measure and against which to compare the aggregated value per iteration, and storage of the dimension, the first measure and the second measure as metadata of an iterative measure.Type: GrantFiled: June 26, 2013Date of Patent: November 24, 2015Assignee: SAP SEInventors: Michael Wilking, Stefan Dipper, Sebastian Schroetel
-
Publication number: 20150006228Abstract: A system includes definition of a time dimension as a formula exception aggregation reference dimension of a stock coverage measure, modification of filters of a demand measure to retrieve demand values outside a time filter of a cell, retrieval of individual values of the demand measure for each value of the time dimension, generation of a table comprising, for each value of a stock measure, values of the demand measure needed to calculate the stock coverage measure, and determination of the stock coverage measure based on the table and on the formula exception aggregation.Type: ApplicationFiled: June 27, 2013Publication date: January 1, 2015Inventors: Michael Wilking, Stefan Dipper, Sebastian Schroetel
-
Publication number: 20150006588Abstract: A system includes determination of a dimension over which to iterate, determination of a first measure for which an aggregated value is determined per iteration, determination of a second measure for which a value is determined once per calculation of an iterative measure and against which to compare the aggregated value per iteration, and storage of the dimension, the first measure and the second measure as metadata of an iterative measure.Type: ApplicationFiled: June 26, 2013Publication date: January 1, 2015Inventors: Michael Wilking, Stefan Dipper, Sebastian Schroetel
-
Publication number: 20140379754Abstract: In one embodiment, a method receives a query for analyzing data in a database. The method then determines a constant in the query and determines an operator applied to the constant in the query. The operator explicitly controls a behavior of the constant. The constant is represented as a scalar representation in the query instead of as a vectorial representation where the constant would have been used as the vectorial representation without the use of the operator due to a rule governing use of constants. Then, the method performs a calculation for the query to determine a query result using the constant as the scalar representation.Type: ApplicationFiled: June 25, 2013Publication date: December 25, 2014Applicant: SAP AGInventors: Stefan Dipper, Sebastian Schroetel, Michael Wilking, Christof Mueller, Tim Kaiser
-
Publication number: 20140379742Abstract: A system includes reception of an instruction to evaluate homogeneity of a first set of values of a plurality of stored sets of values, determination of a first minimum of the first set of values, determination of a first maximum of the first set of values, determination of whether the first minimum and the first maximum are equal, and if it is determined that the first minimum and the first maximum are equal, return of a value equal to the first minimum and the first maximum in response to the instruction.Type: ApplicationFiled: June 24, 2013Publication date: December 25, 2014Inventors: Stefan Dipper, Michael Wilking, Ingo Raasch, Frank Klingl
-
Publication number: 20140372368Abstract: In one embodiment, a method receives a query for analyzing data in a database. The query includes a first level calculation that is performed before a second level calculation. The method determines an operator in the query configured to explicitly remove group by information for a reference characteristic in the first level calculation where the group by information is specified for the reference characteristic in the second level calculation. The first level calculation is performed by removing the group by information for the reference characteristic for the first level calculation to determine a first level calculation result and the second level calculation is performed using the first level calculation result using the group by information for the reference characteristic to determine a second level calculation result.Type: ApplicationFiled: June 18, 2013Publication date: December 18, 2014Applicant: SAP AGInventors: Sebastian Schroetel, Stefan Dipper, Michael Wilking, Christof Mueller
-
Publication number: 20140317149Abstract: Embodiments provide a multi-buffering system in an application layer to support unified read/write access to different data source types of an underlying database layer. In a particular embodiment, the database layer comprises both a multi-dimensional data source (e.g. a cube), and another data source type (e.g. a Data Store Object—DSO). An abstract buffer component of the multi-buffering system is specialized into a delta buffer configured to read/write data of the cube, and into an after image buffer configured to read/write data of the DSO. A storage mechanism component of the multi-buffering system is specialized into a cache store configured to read/write data of the cube, and a calculation scenario store configured to read/write data of the DSO. The after image buffer may support certain aggregation rules during a DSO read/write operation. The calculation scenario store may leverage capabilities of an in memory database during a DSO read/write operation.Type: ApplicationFiled: April 22, 2013Publication date: October 23, 2014Applicant: SAP AGInventors: Martin Friedt, Hans-Georg Beuter, Helidon Dollani, Michael Wilking, Gregor Dieckmann, Ingo Raasch, Stefan Dipper