公开(公告)号：US11036709B2

公开(公告)日：2021-06-15

申请号：US16531666

申请日：2019-08-05

Applicant: SAP SE

Inventor： Christian Bensberg

IPC: G06F16/22 ,  G06F16/2455 ,  G06F16/28 ,  G06F16/27

Abstract: In a general aspect, a method includes inserting a record in a partitioned fact table of a star schema data mart. Inserting the record can include determining a first hash value from a first dimension value of the record and determining a first set of candidate partitions from the first hash value. The method can further include determining a second hash value from a second dimension value of the record and determining a second set of candidate partitions from the first hash value. The method can further include comparing the first set of candidate partitions with the second set of candidate partitions to determine a common partition and inserting the record into the common partition.

公开(公告)号：US10885062B2

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

申请号：US15361337

申请日：2016-11-25

Applicant: SAP SE

Inventor： Mihnea Andrei ,  Christian Bensberg ,  Alexander Boehm ,  Adrian Dragusanu ,  Xun Chen ,  Reza Sherkat ,  Anisoara Nica ,  Martin Heidel ,  Rolando Blanco

IPC: G06F16/28 ,  G06F16/21

Abstract: Persisting data in logical tiers of an in-memory database based on aging rules of the database system. The database system can be configured to age data by moving the data from a first logical tier supporting high performance data access to a second logical tier supporting lower performance data access, thereby improving the operational efficiency of the database system.

公开(公告)号：US10817507B2

公开(公告)日：2020-10-27

申请号：US15969124

申请日：2018-05-02

Applicant: SAP SE

Inventor： Christian Bensberg ,  Steffen Geissinger

IPC: G06F16/30 ,  G06F7/08 ,  G06F16/23 ,  G06F16/13 ,  G06F16/16

Abstract: Provided are systems and methods to acquire a manifest data file and a binary copy of a document store slice log having a first filename and comprising a plurality of entries, each of the plurality of entries associated with a respective database transaction and a commit identifier, and the manifest data file indicating one or more data partitions and one or more slices of each of the one or more data partitions, acquire a partition log for one of the indicated one or more data partitions, the generated partition log comprising a log entry associated with a transaction to create a slice and including a second filename associated with the slice, sort the plurality of entries of the document store slice log based on their associated commit identifiers, change the commit identifiers of each of the plurality of entries to a same commit identifier, and store the sorted and changed entries in a second document store slice log having the second filename.

公开(公告)号：US10810092B2

公开(公告)日：2020-10-20

申请号：US15959744

申请日：2018-04-23

Applicant: SAP SE

Inventor： Christian Bensberg ,  Steffen Geissinger ,  Thorsten Glebe

IPC: G06F16/00 ,  G06F7/00 ,  G06F11/14 ,  G06F16/93 ,  G06F16/11 ,  G06F16/17 ,  G06F16/176 ,  G06F16/23

Abstract: Provided are systems and methods for storing checkpoints of an in-memory storage device. In one example, the method may include detecting database transactions performed on a slice of an in-memory storage and storing a record of the database transactions in a log file, receiving a request to persist the slice of in-memory storage, the request comprising a timing indicator corresponding to a timing of database transactions, trimming the log file based on the timing indicator to remove a record of one or more database transactions from the log file that occurred prior to the timing indicator and to preserve a record of one or more database transactions that occurred after the timing indicator, and persisting, to disk, data from the slice of in-memory storage and the trimmed log file preserving the record of the one or more database transactions that occurred after the timing indicator.

公开(公告)号：US20200183918A1

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

申请号：US16730023

申请日：2019-12-30

Applicant: SAP SE

Inventor： Christian Bensberg ,  Steffen Geissinger

IPC: G06F16/23

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.

公开(公告)号：US10565204B2

公开(公告)日：2020-02-18

申请号：US15350798

申请日：2016-11-14

Applicant: SAP SE

Inventor： Christian Bensberg ,  Till Merker

IPC: G06F17/30 ,  G06F16/2455

Abstract: Disclosed herein are system, method, and computer program product embodiments for incrementally building hash collision tables. In some embodiments, hashes and hash collision tables may be used to improve efficiency of relational operations, such as those used in relational databases. An embodiment operates by determining hash collisions between data entries, then executing a join operation referencing the hash table and the hash collision table to produce a result set.

公开(公告)号：US20190384841A1

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

申请号：US16009779

申请日：2018-06-15

Applicant: SAP SE

Inventor： Steffen Geissinger ,  Christian Bensberg

IPC: G06F17/30

Abstract: A data storage and retrieval system for a computer memory configured according to a document store adapted to contain documents. The document store includes a document data structure containing a header and a document having one or more members. The document store further includes a chain of one or more differential data structures, each having a header and at least one updated member. The updated member has a value which is updated relative to a value in a corresponding member having a same identifier in the document data structure or in a preceding differential data structure in the chain. A header of each of the differential data structures includes a pointer to the document data structure or the preceding differential data structure in the chain, and a flag indicating that each of the differential data structures contains less than all of the members of the document data structure.

公开(公告)号：US20190324866A1

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

申请号：US15959744

申请日：2018-04-23

Applicant: SAP SE

Inventor： Christian Bensberg ,  Steffen Geissinger ,  Thorsten Glebe

IPC: G06F11/14 ,  G06F17/30

Abstract: Provided are systems and methods for storing checkpoints of an in-memory storage device. In one example, the method may include detecting database transactions performed on a slice of an in-memory storage and storing a record of the database transactions in a log file, receiving a request to persist the slice of in-memory storage, the request comprising a timing indicator corresponding to a timing of database transactions, trimming the log file based on the timing indicator to remove a record of one or more database transactions from the log file that occurred prior to the timing indicator and to preserve a record of one or more database transactions that occurred after the timing indicator, and persisting, to disk, data from the slice of in-memory storage and the trimmed log file preserving the record of the one or more database transactions that occurred after the timing indicator.

公开(公告)号：US20180329974A1

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

申请号：US15796365

申请日：2017-10-27

Applicant: SAP SE

Inventor： Christian Bensberg ,  Alexander Boehm ,  Adrian Dragusanu ,  Xun Cheng ,  Reza Sherkat ,  Anisoara Nica ,  Mihnea Andrei

IPC: G06F17/30

CPC classification number: G06F17/30303

Abstract: Disclosed herein are system, method, and computer program product embodiments for determining a constraint data statistics object is consistent. An embodiment operates by receiving a query for a database table. The embodiment determines a constraint data statistic object associated with a partition of the database table. The embodiment determines the constraint data statistics object is consistent with a data state of the partition of the database table based on consistency metadata of the constraint data statistics object. The embodiment processes the query for the database table based on the determining the constraint data statistics object is consistent with the data state of the partition of the database table.

公开(公告)号：US20180137163A1

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

申请号：US15350798

申请日：2016-11-14

Applicant: SAP SE

Inventor： Christian Bensberg ,  Till Merker

IPC: G06F17/30

CPC classification number: G06F16/2456

Abstract: Disclosed herein are system, method, and computer program product embodiments for incrementally building hash collision tables. In some embodiments, hashes and hash collision tables may be used to improve efficiency of relational operations, such as those used in relational databases. An embodiment operates by determining hash collisions between data entries, then executing a join operation referencing the hash table and the hash collision table to produce a result set.