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).
-
Publication number: 20140289183Abstract: 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: ApplicationFiled: March 21, 2013Publication date: September 25, 2014Inventors: Stefan Dipper, Sebastian Schroetel, Stefan Unnebrink, Michael Wilking
-
Publication number: 20140149462Abstract: A system includes reception of a calculation, identification of operands of the calculation, and a source column of a table including values associated with the operands and used in the calculation, creation, for each operand, creation of a column including the value associated with that operand in a row of the column associated with that operand, column-wise aggregation of the values of the created columns into a single row, execution of the calculation using the values of the single row and create a result column including a result of the calculation, and addition of the result column as a row of the table.Type: ApplicationFiled: November 28, 2012Publication date: May 29, 2014Inventors: Roman Moehl, Stefan Dipper
-
Publication number: 20140108331Abstract: In one embodiment the present invention includes an OLAP execution model using relational operations. In one embodiment, the present invention includes, a method comprising receiving a first query in an online analytic processor (OLAP) executing on one or more computers, the OLAP generating and comprising a model specifying a graph defining a plurality of nodes and a plurality of tiers, each node corresponding to a different operation on data. A second query is generated by the OLAP. The second query includes a plurality of layered subqueries each corresponding to one of the nodes in the graph for specifying the different operations on data. The second query is received in a relational engine coupled to the datastore. The relational engine executes the second query, and in accordance therewith, retrieves data.Type: ApplicationFiled: December 17, 2013Publication date: April 17, 2014Applicant: SAP AGInventors: STEFAN DIPPER, ERICH MARSCHALL, TOBIAS MINDNICH, DANIEL BAEUMGES, CHRISTOPH WEYERHAEUSER
-
Patent number: 8650181Abstract: In one embodiment the present invention includes an OLAP execution model using relational operations. In one embodiment, the present invention includes, a method comprising receiving a first query in an online analytic processor (OLAP) executing on one or more computers, the OLAP generating and comprising a model specifying a graph defining a plurality of nodes and a plurality of tiers, each node corresponding to a different operation on data. A second query is generated by the OLAP. The second query includes a plurality of layered subqueries each corresponding to one of the nodes in the graph for specifying the different operations on data. The second query is received in a relational engine coupled to the datastore. The relational engine executes the second query, and in accordance therewith, retrieves data.Type: GrantFiled: November 22, 2010Date of Patent: February 11, 2014Assignee: SAP AGInventors: Stefan Dipper, Erich Marschall, Tobias Mindnich, Daniel Baeumges, Christoph Weyerhaeuser
-
Publication number: 20120130942Abstract: In one embodiment the present invention includes an OLAP execution model using relational operations. In one embodiment, the present invention includes, a method comprising receiving a first query in an online analytic processor (OLAP) executing on one or more computers, the OLAP generating and comprising a model specifying a graph defining a plurality of nodes and a plurality of tiers, each node corresponding to a different operation on data. A second query is generated by the OLAP. The second query includes a plurality of layered subqueries each corresponding to one of the nodes in the graph for specifying the different operations on data. The second query is received in a relational engine coupled to the datastore. The relational engine executes the second query, and in accordance therewith, retrieves data.Type: ApplicationFiled: November 22, 2010Publication date: May 24, 2012Applicant: SAP AGInventors: Stefan Dipper, Erich Marschall, Tobias Mindnich, Daniel Baeumges, Christoph Weyerhaeuser
-
Patent number: 8161070Abstract: In one aspect there is provided a method for handling deltas being posted to a repository, database, or other Business Information Warehouse (BW). The method includes receiving, at a delta handler, absolute data without an indication of a change between the received absolute data and data posted to a repository including a fact table. Identifiers are created for the received absolute data. The absolute data including the created identifier is written into a temporary table. One or more deltas are determined by performing a join of the temporary table and the fact table of the repository. The deltas correspond to the indication of the change between the received absolute data and the data posted to the repository. The delta handler provides the one or more deltas to be posted to the fact table of the repository. Related systems, apparatus, methods, and/or articles are also described.Type: GrantFiled: July 2, 2008Date of Patent: April 17, 2012Assignee: SAP AGInventor: Stefan Dipper
-
Patent number: 8073834Abstract: A query having multiple parts may be processed to form an intermediate results set. This intermediate results set may be partitioned into a plurality of groups. Thereafter, the groups may be sorted into a plurality of containers so that each container contains data sufficient to calculate one requested result in the multipart query. Related techniques, apparatuses, systems, and computer program products are also described.Type: GrantFiled: June 10, 2010Date of Patent: December 6, 2011Assignee: SAP AGInventors: Franz X. Faerber, Christian M. Bartholomae, Erich Marschall, Stefan Dipper, Guenter Radestock
-
Patent number: 8032520Abstract: A system, method and article for handling ambiguous joins among a plurality of tables based on a query are disclosed. Metadata associated with the plurality tables is generated. The metadata comprises ambiguous join dimensions and special measures, where the ambiguous join dimensions provide a list of all dimensions used in conditions of the query that are ambiguous, and the special measures provide a list of measures that are affected by the ambiguous join dimensions. Data is aggregated in the plurality of tables according to an aggregation level expressed in the query and based on the metadata.Type: GrantFiled: October 4, 2007Date of Patent: October 4, 2011Assignee: SAP AGInventors: Stefan Dipper, Christel Rueger, Stefan Biedenstein
-
Patent number: 7996633Abstract: Systems and techniques for sequencing transactions and operations. In one aspect, an article includes one or more machine-readable media storing instructions operable to cause one or more machines to perform operations. The operations include identifying a delta of a first data store, and replicating the delta, including the transaction, to a second data store. The delta comprising a collection of changes to the first data store since a previous replication. The delta includes a transaction that began before the previous replication but did not commit before the previous replication replicated data from the first data store.Type: GrantFiled: July 21, 2006Date of Patent: August 9, 2011Assignee: SAP AGInventors: Peter K. Zimmerer, Stefan Dipper, Stefan Biedenstein, Rainer Brendle
-
Patent number: 7865780Abstract: A system and method for providing randomly-generated test cases for a set of interfaces of a piece of software are disclosed. A test case generator is initialized with parameter arrays Sp with cardinality mp and a prime number qp. For each independent parameter p of each of the set of interfaces, a test case number t is generated. A test case is then generated based on the values for each independent parameter p and based on t and Sp, mp, and qp.Type: GrantFiled: October 5, 2007Date of Patent: January 4, 2011Assignee: SAP AGInventors: Stefan Dipper, Peter John
-
Publication number: 20100250543Abstract: A query having multiple parts may be processed to form an intermediate results set. This intermediate results set may be partitioned into a plurality of groups. Thereafter, the groups may be sorted into a plurality of containers so that each container contains data sufficient to calculate one requested result in the multipart query. Related techniques, apparatuses, systems, and computer program products are also described.Type: ApplicationFiled: June 10, 2010Publication date: September 30, 2010Inventors: Franz X. Faerber, Christian M. Bartholomae, Erich Marschall, Stefan Dipper, Guenter Radestock
-
Patent number: 7739285Abstract: A query having multiple parts may be processed to form an intermediate results set. This intermediate results set may be partitioned into a plurality of groups. Thereafter, the groups may be sorted into a plurality of containers so that each container contains data sufficient to calculate one requested result in the multipart query. Related techniques, apparatuses, systems, and computer program products are also described.Type: GrantFiled: September 29, 2005Date of Patent: June 15, 2010Assignee: SAP AGInventors: Franz X. Faerber, Christian M. Bartholomae, Erich Marschall, Stefan Dipper, Guenter Radestock
-
Patent number: 7668803Abstract: A method for estimating a runtime of a query of a data repository may abstract, extract, or otherwise generate one or more parameters of the query. Thereafter, the abstracted parameters may be associated with one or more statistical query records. From these statistical query records, a query runtime may be estimated. Related apparatuses, computer program products, and computer systems are also described.Type: GrantFiled: February 15, 2008Date of Patent: February 23, 2010Assignee: SAP AGInventors: Thomas Zurek, Klaus Nagel, Stefan Dipper
-
Publication number: 20100005114Abstract: In one aspect there is provided a method for handling deltas being posted to a repository, database, or other Business Information Warehouse (BW). The method includes receiving, at a delta handler, absolute data without an indication of a change between the received absolute data and data posted to a repository including a fact table. Identifiers are created for the received absolute data. The absolute data including the created identifier is written into a temporary table. One or more deltas are determined by performing a join of the temporary table and the fact table of the repository. The deltas correspond to the indication of the change between the received absolute data and the data posted to the repository. The delta handler provides the one or more deltas to be posted to the fact table of the repository. Related systems, apparatus, methods, and/or articles are also described.Type: ApplicationFiled: July 2, 2008Publication date: January 7, 2010Inventor: Stefan Dipper
-
Patent number: 7620642Abstract: A first data storage schema in which a characteristic in a first dimension table is mapped by a first table and a second table can be received and a second data storage schema can be received. The first table maps the characteristic to a first object that include attributes to which time information is irrelevant to data processing activities and the second maps the characteristic to a second object that includes attributes to which time information is relevant to data processing activities. The second data storage schema includes a fact table including at least some facts drawn from the first data storage schema and a second dimension table that includes at least some characteristics drawn from at least one of the first object and the second object.Type: GrantFiled: December 13, 2005Date of Patent: November 17, 2009Assignee: SAP AGInventors: Thomas F. Zurek, Stefan Dipper, Stefan Unnebrink, Klaus Nagel, Erich R. Marschall, Franz X. Faerber, Guenter Radestock, Christian M. Bartholomae
-
Patent number: 7593957Abstract: Systems and techniques for the hybrid provision of data are described. In one aspect, a system includes a first collection of information stored in accordance with a reporting data model, a second collection of information setting forth a collection of one or more additive delta records, and an analytic engine to perform queries on the first collection of information and the second collection of information to yield an aggregated result set that is based on the contents of both the first collection of information and the second collection of information. The additive delta records each include a numeric value that characterizes the magnitude of a change to a numeric measure in the first collection and identification information that identifies the numeric measure in the first collection. The identified numeric measure is no longer current.Type: GrantFiled: August 30, 2006Date of Patent: September 22, 2009Assignee: SAP AGInventors: Stefan Biedenstein, Erich R. Marschall, Hartmut Koerner, Peter K. Zimmerer, Stefan Dipper
-
Publication number: 20090094486Abstract: A system and method for providing randomly-generated test cases for a set of interfaces of a piece of software are disclosed. A test case generator is initialized with parameter arrays Sp with cardinality mp and a prime number qp. For each independent parameter p of each of the set of interfaces, a test case number t is generated. A test case is then generated based on the values for each independent parameter p and based on t and Sp, mp, and qp.Type: ApplicationFiled: October 5, 2007Publication date: April 9, 2009Inventors: Stefan Dipper, Peter John
-
Publication number: 20090094215Abstract: A system, method and article for handling ambiguous joins among a plurality of tables based on a query are disclosed. Metadata associated with the plurality tables is generated. The metadata comprises ambiguous join dimensions and special measures, where the ambiguous join dimensions provide a list of all dimensions used in conditions of the query that are ambiguous, and the special measures provide a list of measures that are affected by the ambiguous join dimensions. Data is aggregated in the plurality of tables according to an aggregation level expressed in the query and based on the metadata.Type: ApplicationFiled: October 4, 2007Publication date: April 9, 2009Inventors: Stefan Dipper, Christel Rueger, Stefan Biedenstein
-
Patent number: 7464083Abstract: A system, method and computer program product for linking multidimensional data sources in a relational database using database joins are disclosed. Attributes from a join query are filtered. The attributes include characteristics and restrictions of the join query. A subset of the attributes that are relevant to the multidimensional data source are extracted. A partial join query is generated from the extracted subset of the attributes. The partial join query includes characteristics and restrictions that are relevant to the multidimensional data source. It makes use of aggregated data defined for the multidimensional data source if appropriate.Type: GrantFiled: December 28, 2005Date of Patent: December 9, 2008Inventors: Wolfgang Otter, Christel Rueger, Stefan Dipper, Tobias Hagen
-
Publication number: 20080140615Abstract: A method for estimating a runtime of a query of a data repository may abstract, extract, or otherwise generate one or more parameters of the query. Thereafter, the abstracted parameters may be associated with one or more statistical query records. From these statistical query records, a query runtime may be estimated.Type: ApplicationFiled: February 15, 2008Publication date: June 12, 2008Inventors: Thomas Zurek, Klaus Nagel, Stefan Dipper