公开(公告)号：US20180137166A1

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

申请号：US15354883

申请日：2016-11-17

Applicant: SAP SE

Inventor： Christian Bensberg ,  Steffen Geissinger ,  Thorsten Glebe

IPC: G06F17/30

CPC classification number: G06F16/2379 ,  G06F16/1727 ,  G06F16/951

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 can have a first transaction manager and the second database can have 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 is then coordinated using the first transaction manager and the second transaction manager. All changes specified by the at least one database operation are logged in a distributed log in the first database including changes implicating data stored within the second database. The distributed log is configured such that it is accessible by both of the first transaction manager and the second transaction manager.

公开(公告)号：US09798759B2

公开(公告)日：2017-10-24

申请号：US14553535

申请日：2014-11-25

Applicant: SAP SE

Inventor： Ivan Schreter ,  Juchang Lee ,  Mihnea Andrei ,  Thorsten Glebe ,  Changgyoo Park ,  Eunsang Kim

IPC: G06F17/30 ,  G06F15/16

CPC classification number: G06F17/30348

Abstract: A plurality of transactions are handled in a database. Each transaction comprises a plurality of operations on at least one record in the database with at least two of the transactions being handled concurrently. Thereafter, a temporary timestamp is assigned to each record that is based, at least in part, on the corresponding transaction. A first transaction among the plurality of transactions is subsequently committed. Afterwards, re-stamping of at least one commit timestamp modified by the first transaction is delegated. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US11429388B2

公开(公告)日：2022-08-30

申请号：US16883241

申请日：2020-05-26

Applicant: SAP SE

Inventor： Dirk Thomsen ,  Thorsten Glebe ,  Tobias Scheuer ,  Werner Thesing ,  Johannes Gloeckle

IPC: G06F9/30 ,  G06F16/28 ,  G06F9/38 ,  G06F9/54

Abstract: Aspects of the current subject matter are directed to an approach in which a parallel load operation of file ID mapping containers is accomplished at start and/or restart of a database system. Parallel load operation of file ID mapping and/or large binary object (LOB) file ID mapping is done among a plurality of scanning engines into a plurality of data buffers that are associated with each of the plurality of scanning engines. Each scanning engine operates on a certain path of a page chain of a page structure including the mapping, causing the page chain to be split among scanning engines to process maps. Contents of the data buffers are pushed to mapping engines via a queue. The mapping engines load the file ID mapping and the LOB file ID mapping into maps for in-system access.

公开(公告)号：US11222007B2

公开(公告)日：2022-01-11

申请号：US15970727

申请日：2018-05-03

Applicant: SAP SE

Inventor： Dirk Thomsen ,  Thorsten Glebe ,  Blaise Lengrand

IPC: G06F16/23 ,  G06F11/14

Abstract: Checking of a database snapshot of an active database is initiated. Thereafter, an anchor page associated with a most recent snapshot that links to a restart page is read. Subsequently, the linked restart page is read. It is then initially determined, based on the reading of the anchor page and the restart page, whether the snapshot is accurate. If it is initially determined that the snapshot is not accurate, the anchor page and the restart page are re-read until a final determination is made that whether the snapshot is accurate. Alternatively, if not is initially determined that the snapshot is accurate, then data is provided (e.g., displayed, loaded into memory, transmitted to a remote computing system, stored in physical persistence, etc.) that indicates that the snapshot is accurate.

公开(公告)号：US10474668B2

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

申请号：US15354883

申请日：2016-11-17

Applicant: SAP SE

Inventor： Christian Bensberg ,  Steffen Geissinger ,  Thorsten Glebe

IPC: G06F16/23 ,  G06F16/951 ,  G06F16/17

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 can have a first transaction manager and the second database can have 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 is then coordinated using the first transaction manager and the second transaction manager. All changes specified by the at least one database operation are logged in a distributed log in the first database including changes implicating data stored within the second database. The distributed log is configured such that it is accessible by both of the first transaction manager and the second transaction manager.

公开(公告)号：US20190340118A1

公开(公告)日：2019-11-07

申请号：US15970704

申请日：2018-05-03

Applicant: SAP SE

Inventor： Dirk Thomsen ,  Thorsten Glebe

IPC: G06F12/02 ,  G06F12/1009 ,  G06F17/30 ,  G06F3/06 ,  G06F9/455

Abstract: A provisional page to be filled with data is allocated in an in-memory database system in which pages are loaded into memory and having associated physical disk storage a provisional page to be filled with data. Thereafter, the provisional page is filled with data. The provisional page is register after the provisional page has been filled with data such that consistent changes in the database are not required for the provisional page prior to the registering.

公开(公告)号：US10452613B2

公开(公告)日：2019-10-22

申请号：US15654179

申请日：2017-07-19

Applicant: SAP SE

Inventor： Dirk Thomsen ,  Thorsten Glebe

IPC: G06F12/00 ,  G06F16/17 ,  G06F3/06 ,  G06F12/12

Abstract: Disclosed herein are embodiments for free-space handling in pages and in-memory containers allowing variable-size data entries. An example system may determine expanses of unallocated space, within a page loaded in memory and configured to allocate a first data entry of a first size within the page that may also allocate at least one subsequent data entry of a second size different from the first size; save, into memory, transient free-space information corresponding to the page, including first position information for a first number of expanses of contiguous unallocated space within the page; evict the page from memory, writing allocated data entries contained therein to persistent storage; store, into persistent storage, persistent free-space information corresponding to the page, including second position information for a second number of expanses of unallocated space within the page, the second number being less than the first number; and discard the transient free-space information.

公开(公告)号：US20180246947A1

公开(公告)日：2018-08-30

申请号：US15445505

申请日：2017-02-28

Applicant: SAP SE

Inventor： Colin Florendo ,  Michael Muehle ,  Thorsten Glebe ,  Rolando Blanco ,  Chaitanya Gottipati ,  Nirvik Basak ,  Günter Radestock

IPC: G06F17/30 ,  G06F17/27

Abstract: A computer implemented method for initializing a secondary database system includes receiving table state information from a primary database system at a secondary database system. The table state information includes information identifying which tables had an open operation during a savepoint event. Metadata associated with the tables is parsed to identify table state information from the metadata and a lock is created for each table identified as having an open operation during the savepoint event. Afterwards, log transaction information is sequentially parsed. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US20160063432A1

公开(公告)日：2016-03-03

申请号：US14859006

申请日：2015-09-18

Applicant: SAP SE

Inventor： Andrei Suvernev ,  Thorsten Glebe ,  Volkmar Soehner ,  Daniel Booss

IPC: G06Q10/08

CPC classification number: G06Q10/087 ,  G06F9/466

Abstract: A method is described that involves providing a persisted quantity for a time series time interval to a first transaction, then, providing the same persisted quantity to a second transaction that operates in parallel with the first transaction. The second transaction is not permitted to change the persisted quantity. The method also involves replacing the persisted quantity with a second persisted quantity within the time series. The second persisted quantity is determined by the first transaction. The method also involves writing a persisted quantity change for the time series time interval. The persisted quantity change is determined by the second transaction.

Abstract translation: 描述了一种方法，其涉及为第一事务提供时间序列时间间隔的持久数量，然后向与第一事务并行操作的第二事务提供相同的持久数量。 第二个交易不允许更改持续的数量。 该方法还包括在时间序列内用第二个持续量替换持续数量。 第二个持续数量由第一个交易决定。 该方法还涉及为时间序列时间间隔写入持久数量变化。 持续的数量变化由第二次交易决定。

公开(公告)号：US11249968B2

公开(公告)日：2022-02-15

申请号：US15150301

申请日：2016-05-09

Applicant: SAP SE

Inventor： Thorsten Glebe ,  Martin Heidel ,  Michael Muehle ,  Felix Knittel ,  Reza Sherkat

IPC: G06F16/22 ,  G06F3/06

Abstract: A method, computer program product and system are provided. The method, computer program product and system execute a process for storing an object in an object container that is stored in a persistency of a disk storage. The object container has size criteria whereby objects meeting the size criteria of the object container can be assigned to the object container. The object container can facilitate storing multiple objects to optimize disk storage usage by facilitating the assigning of multiple objects to the same disk storage page.