公开(公告)号：US20160004746A1

公开(公告)日：2016-01-07

申请号：US14321457

申请日：2014-07-01

Applicant: Michael Wilking ,  Stefan Dipper

Inventor： Michael Wilking ,  Stefan Dipper

IPC: G06F17/30

CPC classification number: G06F17/30454

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.

Abstract translation: 本公开通常描述用于生成和执行查询的计算机实现的方法，软件和系统。 接收到查询。 确定与查询相关联的一组结构元素，其中结构元素用于在数据库中访问与该组结构元素相关联的数据元组。 可选地，减少了用于访问所选择的结构元素的数据元组的一组结构元素。 贡献结构元素被添加到缩减集中，以便不在结果集中产生对象，而是用于创建关联的对象。 以优化的方式来处理贡献结构元素，以便使尽可能小的计算查询结果集的数据集保持不变。 这是通过使用group-by子句中最小的一组特征来完成的，用于检索数据集以计算所请求的结构元素集。 提供查询的结果集。

公开(公告)号：US20140149462A1

公开(公告)日：2014-05-29

申请号：US13687348

申请日：2012-11-28

Applicant: Roman Moehl ,  Stefan Dipper

Inventor： Roman Moehl ,  Stefan Dipper

IPC: G06F17/30

CPC classification number: G06F16/221

Abstract: 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.

Abstract translation: 一种系统包括接收计算，识别计算的操作数，以及包括与操作数相关联的值的表的源列，并且用于在每个操作数的计算，创建中，创建包括与该操作数相关联的值的列 与该操作数相关联的列的一行中的操作数，将列创建的列的列逐列聚合到单个行中，使用单个行的值执行计算，并创建包含计算结果的结果列 ，并将结果列作为表的一行添加。

公开(公告)号：US20120130942A1

公开(公告)日：2012-05-24

申请号：US12951948

申请日：2010-11-22

Applicant: Stefan Dipper ,  Erich Marschall ,  Tobias Mindnich ,  Daniel Baeumges ,  Christoph Weyerhaeuser

Inventor： Stefan Dipper ,  Erich Marschall ,  Tobias Mindnich ,  Daniel Baeumges ,  Christoph Weyerhaeuser

IPC: G06F17/30

CPC classification number: G06F17/30563 ,  G06F17/30436 ,  G06F17/30592

Abstract: 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.

Abstract translation: 在一个实施例中，本发明包括使用关系操作的OLAP执行模型。 在一个实施例中，本发明包括一种方法，包括在一个或多个计算机上执行的在线分析处理器（OLAP）中接收第一查询，所述OLAP生成并包括指定限定多个节点的图形的模型和多个 每个节点对应于数据的不同操作。 第二个查询由OLAP生成。 第二查询包括多个分层子查询，每个子查询对应于图中的一个节点，用于指定关于数据的不同操作。 在耦合到数据存储的关系引擎中接收到第二个查询。 关系引擎执行第二个查询，并根据此查询数据。

公开(公告)号：US07865780B2

公开(公告)日：2011-01-04

申请号：US11868369

申请日：2007-10-05

Applicant: Stefan Dipper ,  Peter John

Inventor： Stefan Dipper ,  Peter John

IPC: G06F11/00

CPC classification number: G06F11/3684

Abstract: 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.

Abstract translation: 公开了一种用于为软件的一组接口提供随机生成的测试用例的系统和方法。 使用基数mp和素数qp的参数数组Sp初始化测试用例生成器。 对于接口集合中的每一个的每个独立参数p，生成测试用例号t。 然后基于每个独立参数p的值并基于t和Sp，mp和qp生成测试用例。

公开(公告)号：US20100250543A1

公开(公告)日：2010-09-30

申请号：US12813041

申请日：2010-06-10

Applicant: Franz X. Faerber ,  Christian M. Bartholomae ,  Erich Marschall ,  Stefan Dipper ,  Guenter Radestock

Inventor： Franz X. Faerber ,  Christian M. Bartholomae ,  Erich Marschall ,  Stefan Dipper ,  Guenter Radestock

IPC: G06F17/30

CPC classification number: G06F17/30501 ,  Y10S707/99933

Abstract: 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.

Abstract translation: 可以处理具有多个部分的查询以形成中间结果集。 该中间结果集可以被划分成多个组。 此后，组可以被分类成多个容器，使得每个容器包含足以在多部分查询中计算一个请求结果的数据。 还描述了相关技术，装置，系统和计算机程序产品。

公开(公告)号：US07593957B2

公开(公告)日：2009-09-22

申请号：US11513815

申请日：2006-08-30

Applicant: Stefan Biedenstein ,  Erich R. Marschall ,  Hartmut Koerner ,  Peter K. Zimmerer ,  Stefan Dipper

Inventor： Stefan Biedenstein ,  Erich R. Marschall ,  Hartmut Koerner ,  Peter K. Zimmerer ,  Stefan Dipper

IPC: G06F17/00

CPC classification number: G06F17/30292 ,  Y10S707/99931 ,  Y10S707/99943

Abstract: 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.

Abstract translation: 描述了混合提供数据的系统和技术。 在一个方面，系统包括根据报告数据模型存储的信息的第一集合，设置一个或多个添加增量记录的集合的信息的第二集合，以及分析引擎，以对第一集合 信息和第二信息收集，以产生基于第一信息收集和第二信息收集的内容的聚合结果集合。 加性增量记录每个都包括一个数字值，其表征第一个收集中的数字度量的变化幅度，以及标识第一个集合中的数字度量的标识信息。 识别的数字度量不再是最新的。

公开(公告)号：US20090094486A1

公开(公告)日：2009-04-09

申请号：US11868369

申请日：2007-10-05

Applicant: Stefan Dipper ,  Peter John

Inventor： Stefan Dipper ,  Peter John

IPC: G06F11/00

CPC classification number: G06F11/3684

Abstract: 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.

Abstract translation: 公开了一种用于为软件的一组接口提供随机生成的测试用例的系统和方法。 使用基数mp和素数qp的参数数组Sp初始化测试用例生成器。 对于接口集合中的每一个的每个独立参数p，生成测试用例号t。 然后基于每个独立参数p的值并基于t和Sp，mp和qp生成测试用例。

公开(公告)号：US20070094233A1

公开(公告)日：2007-04-26

申请号：US11321720

申请日：2005-12-28

Applicant: Wolfgang Otter ,  Christel Rueger ,  Stefan Dipper ,  Tobias Hagen

Inventor： Wolfgang Otter ,  Christel Rueger ,  Stefan Dipper ,  Tobias Hagen

IPC: G06F17/30

CPC classification number: G06F16/283 ,  G06F16/2456

Abstract: A method and system for linking the contents of two or more at least partially time-independent tables in a multidimensional data source are disclosed. A join operation is generated for the two or more at least partially time-independent tables. The join operation includes a query instruction that is executable on the multidimensional data source, and the query instruction has at least one time attribute. A pseudo time dependency between the two or more at least partially time-independent tables is determined. A time interval for the join operation is generated based on the pseudo time dependency. The join operation is then executed using the time interval as the at least one time attribute.

Abstract translation: 公开了一种在多维数据源中链接两个或更多个至少部分时间不相关的表的内容的方法和系统。 为两个或多个至少部分与时间无关的表生成连接操作。 连接操作包括可在多维数据源上执行的查询指令，并且查询指令具有至少一个时间属性。 确定两个或更多个至少部分时间无关的表之间的伪时间依赖性。 基于伪时间依赖性生成连接操作的时间间隔。 然后使用时间间隔来执行联接操作作为至少一个时间属性。

公开(公告)号：US10664479B2

公开(公告)日：2020-05-26

申请号：US14318103

申请日：2014-06-27

Applicant: Sebastian Schroetel ,  Stefan Dipper ,  Stefan Unnebrink ,  Dirk Janning

Inventor： Sebastian Schroetel ,  Stefan Dipper ,  Stefan Unnebrink ,  Dirk Janning

IPC: G06F16/24 ,  G06F16/2457 ,  G06F16/23 ,  G06F16/25

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.

公开(公告)号：US09922087B2

公开(公告)日：2018-03-20

申请号：US14321457

申请日：2014-07-01

Applicant: Michael Wilking ,  Stefan Dipper

Inventor： Michael Wilking ,  Stefan Dipper

IPC: G06F17/30

CPC classification number: G06F17/30454

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.