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: 10489394
    Abstract: 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: Grant
    Filed: May 25, 2016
    Date of Patent: November 26, 2019
    Assignee: SAP SE
    Inventors: Sebastian Schroetel, Stefan Dipper, Michael Wilking, Christof Mueller
  • Patent number: 10303726
    Abstract: 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: Grant
    Filed: November 13, 2014
    Date of Patent: May 28, 2019
    Assignee: SAP SE
    Inventors: Christoph Weyerhaeuser, Tobias Mindnich, Johannes Merx, Joerg Schad, Stefan Dipper
  • Patent number: 9965512
    Abstract: 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: Grant
    Filed: June 25, 2013
    Date of Patent: May 8, 2018
    Assignee: SAP SE
    Inventors: Stefan Dipper, Sebastian Schroetel, Michael Wilking, Christof Mueller, Tim Kaiser
  • Patent number: 9922087
    Abstract: 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: Grant
    Filed: July 1, 2014
    Date of Patent: March 20, 2018
    Assignee: SAP SE
    Inventors: Michael Wilking, Stefan Dipper
  • Patent number: 9471662
    Abstract: 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: Grant
    Filed: June 24, 2013
    Date of Patent: October 18, 2016
    Assignee: SAP SE
    Inventors: Stefan Dipper, Michael Wilking, Ingo Raasch, Frank Klingl
  • Patent number: 9449032
    Abstract: 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: Grant
    Filed: April 22, 2013
    Date of Patent: September 20, 2016
    Assignee: SAP SE
    Inventors: Martin Friedt, Hans-Georg Beuter, Helidon Dollani, Michael Wilking, Gregor Dieckmann, Ingo Raasch, Stefan Dipper
  • Publication number: 20160267129
    Abstract: 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: Application
    Filed: May 25, 2016
    Publication date: September 15, 2016
    Inventors: Sebastian Schroetel, Stefan Dipper, Michael Wilking, Christof Mueller
  • Patent number: 9400830
    Abstract: 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: Grant
    Filed: March 21, 2013
    Date of Patent: July 26, 2016
    Assignee: SAP SE
    Inventors: Stefan Dipper, Sebastian Schroetel, Stefan Unnebrink, Michael Wilking
  • Patent number: 9378264
    Abstract: 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: Grant
    Filed: June 18, 2013
    Date of Patent: June 28, 2016
    Assignee: SAP SE
    Inventors: Sebastian Schroetel, Stefan Dipper, Michael Wilking, Christof Mueller
  • Publication number: 20160140241
    Abstract: 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: Application
    Filed: November 13, 2014
    Publication date: May 19, 2016
    Inventors: Christoph Weyerhaeuser, Tobias Mindnich, Johannes Merx, Joerg Schad, Stefan Dipper
  • Publication number: 20160004746
    Abstract: 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: Application
    Filed: July 1, 2014
    Publication date: January 7, 2016
    Inventors: Michael Wilking, Stefan Dipper
  • Publication number: 20150379059
    Abstract: 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: Application
    Filed: June 27, 2014
    Publication date: December 31, 2015
    Inventors: Sebastian Schroetel, Stefan Dipper, Stefan Unnebrink, Dirk Janning
  • Patent number: 9195690
    Abstract: 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: Grant
    Filed: June 26, 2013
    Date of Patent: November 24, 2015
    Assignee: SAP SE
    Inventors: Michael Wilking, Stefan Dipper, Sebastian Schroetel
  • Publication number: 20150006228
    Abstract: 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: Application
    Filed: June 27, 2013
    Publication date: January 1, 2015
    Inventors: Michael Wilking, Stefan Dipper, Sebastian Schroetel
  • Publication number: 20150006588
    Abstract: 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: Application
    Filed: June 26, 2013
    Publication date: January 1, 2015
    Inventors: Michael Wilking, Stefan Dipper, Sebastian Schroetel
  • Publication number: 20140379754
    Abstract: 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: Application
    Filed: June 25, 2013
    Publication date: December 25, 2014
    Applicant: SAP AG
    Inventors: Stefan Dipper, Sebastian Schroetel, Michael Wilking, Christof Mueller, Tim Kaiser
  • Publication number: 20140379742
    Abstract: 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: Application
    Filed: June 24, 2013
    Publication date: December 25, 2014
    Inventors: Stefan Dipper, Michael Wilking, Ingo Raasch, Frank Klingl
  • Publication number: 20140372368
    Abstract: 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: Application
    Filed: June 18, 2013
    Publication date: December 18, 2014
    Applicant: SAP AG
    Inventors: Sebastian Schroetel, Stefan Dipper, Michael Wilking, Christof Mueller
  • Publication number: 20140317149
    Abstract: 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: Application
    Filed: April 22, 2013
    Publication date: October 23, 2014
    Applicant: SAP AG
    Inventors: Martin Friedt, Hans-Georg Beuter, Helidon Dollani, Michael Wilking, Gregor Dieckmann, Ingo Raasch, Stefan Dipper
  • Publication number: 20140289183
    Abstract: 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: Application
    Filed: March 21, 2013
    Publication date: September 25, 2014
    Inventors: Stefan Dipper, Sebastian Schroetel, Stefan Unnebrink, Michael Wilking