公开(公告)号：US11609934B2

公开(公告)日：2023-03-21

申请号：US15961075

申请日：2018-04-24

Applicant: SAP SE

Inventor： Christian Bensberg ,  Steffen Geissinger

IPC: G06F16/28 ,  G06F9/54 ,  G06F16/23

Abstract: Provided are systems and methods for implementing a database notification and statistics framework. In one example, the method may include receiving a message published by a database, the message including information about a database event performed by the database, determining a publication type of the message from among a plurality of publication types based on attributes included in the message, identifying one or more database components that have subscribed to the identified publication type of the message, and transferring the information about the database event included in the message to the one or more identified database components that have subscribed to the publication type of the message.

公开(公告)号：US10769214B2

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

申请号：US15344187

申请日：2016-11-04

Applicant: SAP SE

Inventor： Steffen Geissinger ,  Christian Bensberg

IPC: G06F16/20 ,  G06F16/93 ,  G06F16/951 ,  G06F16/9038 ,  G06F16/28 ,  G06F16/245 ,  G06F16/22

Abstract: A system for encoding and/or decoding documents for a document store is provided. In some implementations, the system performs operations comprising receiving a query related to at least a portion of a plurality of stored documents and retrieving one or more documents from the plurality of stored documents based on the query. The operations can further include generating a client-side dictionary including a plurality of definitions corresponding to a plurality of parameters (e.g., reference values for corresponding parameters) from the plurality of stored documents. The operations can also include providing the client-side dictionary and the one or more documents in response to the query. One or more of the operations can be implemented by a database server. Related systems, methods, and articles of manufacture are also described.

公开(公告)号：US10204044B2

公开(公告)日：2019-02-12

申请号：US15157746

申请日：2016-05-18

Applicant: SAP SE

Inventor： Burak Kurt ,  Steffen Geissinger ,  Anil Akay

IPC: G06F12/00 ,  G06F12/06 ,  G06F3/06

Abstract: Provided are a device and method of managing data stored in memory. The device may include a buffer for storing data blocks including a head data block, a tail data block, and intermediate data blocks. Non-used blocks may be further included in the buffer between the head data block and the tail data block. The device may further include a controller for managing the data blocks within the buffer. The managing may include determining a shift direction for the data blocks based on a distribution of the data blocks within the buffer, shifting at least one data block from among the data blocks in the determined direction, and shifting the one or more non-used blocks in an opposite direction from which the at least one data block is shifted. As a result of the shifting, the data blocks may be aggregated within the buffer.

公开(公告)号：US20180293276A1

公开(公告)日：2018-10-11

申请号：US15483690

申请日：2017-04-10

Applicant: SAP SE

Inventor： Jin Uk Bae ,  Stefan Baeuerle ,  Christian Bensberg ,  Steffen Geissinger ,  Ki Hong Kim ,  Taehyung Lee ,  Jaeyun Noh ,  Di Wu ,  Long Zhang

IPC: G06F17/30

Abstract: A method can include: generating a query execution plan for a query including a plurality of operations that operate on data from a relational database and data from a non-structured query language (NoSQL) database, the generating comprising optimizing the query by: identifying a first operation that operate on data from the relational database and an intermediate result output by a second operation, the second operation outputting the intermediate result by operating on the data from the NoSQL database; and determining a fixed datatype for the intermediate result, an indication of the fixed datatype being included in the query execution plan; and executing, based on the query execution plan, the query, the executing of the query comprising converting the intermediate result to the fixed datatype, the converting enabling the first operation to operate on the intermediate result output by the second operation along with the data from the relational database.

公开(公告)号：US20180137210A1

公开(公告)日：2018-05-17

申请号：US15354900

申请日：2016-11-17

Applicant: SAP SE

Inventor： Christian Bensberg ,  Steffen Geissinger

IPC: G06F17/30

Abstract: A database system can receive, from a client, a query specifying at least one database operation implicating data within a first database and within a second database. The first database can have a first transaction manager and the second database can have a second transaction manager. Thereafter, a plurality of transactions are initiated that are responsive to the query to access the data within the first database and the second database. The first transaction manager and the second transaction manager together coordinate execution of the plurality of transactions. All changes specified by the at least one database operation are persisted in persistence of the first database including changes implicating data stored within the second database. Data responsive to the query can then optionally be provided to the client. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US20180137185A1

公开(公告)日：2018-05-17

申请号：US15354910

申请日：2016-11-17

Applicant: SAP SE

Inventor： Christian Bensberg ,  Steffen Geissinger

IPC: G06F17/30

Abstract: A query is received from a client that specifies at least one database operation implicating data within a first database and within a second database. The first database has a first transaction manager and the second database has a second transaction manager. Thereafter, a plurality of transactions responsive to the query are initiated to access the data within the first database and the second database. Execution of the plurality of transactions are coordinated using the first transaction manager such that commits for both of the first database and the second database are handled by the first transaction manager. Data responsive to the query can then be provided to the client. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US20180129655A1

公开(公告)日：2018-05-10

申请号：US15344187

申请日：2016-11-04

Applicant: SAP SE

Inventor： Steffen Geissinger ,  Christian Bensberg

IPC: G06F17/30

Abstract: A system for encoding and/or decoding documents for a document store is provided. In some implementations, the system performs operations comprising receiving a query related to at least a portion of a plurality of stored documents and retrieving one or more documents from the plurality of stored documents based on the query. The operations can further include generating a client-side dictionary including a plurality of definitions corresponding to a plurality of parameters (e.g., reference values for corresponding parameters) from the plurality of stored documents. The operations can also include providing the client-side dictionary and the one or more documents in response to the query. One or more of the operations can be implemented by a database server. Related systems, methods, and articles of manufacture are also described.

公开(公告)号：US11550485B2

公开(公告)日：2023-01-10

申请号：US15959821

申请日：2018-04-23

Applicant: SAP SE

Inventor： Christian Bensberg ,  Steffen Geissinger

IPC: G06F3/06 ,  G06F12/1009 ,  G06F16/13 ,  G06F16/11

Abstract: Provided are systems and methods for paging data into main memory from checkpoint data stored on disk. In one example, the method may include one or more of receiving a request for a database record in main memory, determining whether the database record has been previously stored in the main memory, in response to determining that the database record has been previously stored in the main memory, identifying a slice where the database record was stored from among a plurality of slices included in the main memory, and paging content of the identified slice including a copy of the requested database record into the main memory from a snapshot captured of content included in the identified slice and previously stored on disk. Accordingly, documents can be paged into main memory on-demand from snapshots of slice content rather than paging an entire partition of content.

公开(公告)号：US10997164B2

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

申请号：US14949699

申请日：2015-11-23

Applicant: SAP SE

Inventor： Steffen Geissinger ,  Ivan Schreter

IPC: G06F16/00 ,  G06F16/23 ,  G06F16/27 ,  G06F16/28

Abstract: A new unique value to be added to a column of a database table can be written to an in-memory array representing a dictionary of the column, and space can be allocated in at least one dictionary block on at least one page maintained on a persistent storage without writing the new unique value to the at least one dictionary block. A pending materialization bit for the at least one page can be set to identify the at least one page for deferred materialization.

公开(公告)号：US10521117B2

公开(公告)日：2019-12-31

申请号：US14951046

申请日：2015-11-24

Applicant: SAP SE

Inventor： Steffen Geissinger ,  Ivan Schreter ,  Mihnea Andrei

IPC: G06F3/06 ,  G06F12/0891 ,  G06F13/00 ,  G06F16/00 ,  G06F16/22

Abstract: First page data from one or more pages stored on a persistent storage can be loaded into a page buffer in a main system memory of one or more computing systems, and second page data that includes first dictionary values of a first dictionary for a first database column can be loaded and pinned into the page buffer in the main system memory. First contents of a first dictionary block containing first re-direction references to the first dictionary can be copied from the loaded first page data into a first in-memory array, and the first page data can be deallocated from the page buffer. The first re-direction references can direct to the first dictionary values of the first dictionary in the pinned second page data.