公开(公告)号：US11106673B2

公开(公告)日：2021-08-31

申请号：US16209651

申请日：2018-12-04

Applicant: SAP SE

Inventor： Christian Bensberg ,  Kai Stammerjohann ,  Frederik Transier ,  Martin Richtarsky

IPC: G06F16/24 ,  G06F16/2455 ,  G06F16/23 ,  G06F16/248 ,  G06F16/2453

Abstract: A method, a system and a computer program product for execution of queries. A first query is executed using a first query execution plan to generate a first result data by applying a first query operator to a first data stored in a first storage location. The first result data is provided to a second query execution plan for execution of a second query. The second query is executed on a second data stored in a second storage location in accordance with the second query execution plan. The second query execution plan includes a second query operator. Based on the execution of the second query, a second result data is generated in accordance with the second query execution plan by at least applying the second query operator to at least the provided first result data.

公开(公告)号：US11010415B2

公开(公告)日：2021-05-18

申请号：US13874327

申请日：2013-04-30

Applicant: SAP SE

Inventor： Martin Richtarsky

IPC: G06F16/36 ,  G06F16/31 ,  G06F16/22

Abstract: The subject matter described herein relates to implementation of a dictionary in a column-based, in-memory database where values are not stored directly, rather, for each column, a dictionary is created with all distinct values. For each row, a reference to the corresponding value in the dictionary is stored. In one aspect, data is stored in a memory structure organized in a column store format defined by a plurality of columns and a plurality of rows. A dictionary for each column in the memory structure is generated. The dictionary has distinct values for each column. A reference to the dictionary is generated for each column in the memory structure. The dictionary and the reference to the dictionary are stored in the memory structure.

公开(公告)号：US20200175008A1

公开(公告)日：2020-06-04

申请号：US16209651

申请日：2018-12-04

Applicant: SAP SE

Inventor： Christian Bensberg ,  Kai Stammerjohann ,  Frederik Transier ,  Martin Richtarsky

IPC: G06F16/2455 ,  G06F16/2453 ,  G06F16/248 ,  G06F16/23

Abstract: A method, a system and a computer program product for execution of queries. A first query is executed using a first query execution plan to generate a first result data by applying a first query operator to a first data stored in a first storage location. The first result data is provided to a second query execution plan for execution of a second query. The second query is executed on a second data stored in a second storage location in accordance with the second query execution plan. The second query execution plan includes a second query operator. Based on the execution of the second query, a second result data is generated in accordance with the second query execution plan by at least applying the second query operator to at least the provided first result data.

公开(公告)号：US10769075B2

公开(公告)日：2020-09-08

申请号：US16197851

申请日：2018-11-21

Applicant: SAP SE

Inventor： Carsten Thiel ,  Guenter Radestock ,  Martin Richtarsky ,  Bernhard Scheirle

IPC: G06F12/10 ,  G06F12/02 ,  G06F16/22 ,  G06F12/06 ,  G06F3/06

Abstract: A system includes storage, in a volatile random access memory, of a first data block comprising an array of distinct values of a database table column, and first header data comprising a first pointer to the first data block, determination of a memory size associated with the first header data and the first data block, allocation of a first memory block of the non-volatile random access memory based on the determined memory size, determination of an address of the non-volatile random access memory associated with the allocated first memory block, and writing of an indicator of the number of distinct values of the array and a binary copy of the first data block at the address of the non-volatile random access memory.