公开(公告)号：US10678812B2

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

申请号：US15354910

申请日：2016-11-17

Applicant: SAP SE

Inventor： Christian Bensberg ,  Steffen Geissinger

IPC: G06F16/00 ,  G06F16/27

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.

公开(公告)号：US10565205B2

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

申请号：US15350852

申请日：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 storing newly determined hash values corresponding to collisions in a hash collision table. The storing can be done incrementally, without needing to rebuild hash tables or hash collision tables for all data entries.

公开(公告)号：US10565187B2

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

申请号：US15354900

申请日：2016-11-17

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.

公开(公告)号：US20190354516A1

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

申请号：US16531666

申请日：2019-08-05

Applicant: SAP SE

Inventor： Christian Bensberg

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

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.

公开(公告)号：US10482076B2

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

申请号：US14826626

申请日：2015-08-14

Applicant: SAP SE

Inventor： Christian Bensberg

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

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.

公开(公告)号：US10474697B2

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

申请号：US14973596

申请日：2015-12-17

Applicant: SAP SE

Inventor： Christian Bensberg ,  Lars Fricke ,  Martin Heidel ,  Holger Bischoff ,  Joern Schmidt ,  Edward-Robert Tyercha ,  Andreas Tonder

IPC: G06F16/22 ,  G06F16/23 ,  G06F16/27

Abstract: An update to a partitioning column for a partitioned table in a database can be performed by handling rows for which the update will not require moving to a different partition separately (e.g. “locally”) for each partition followed by re-inserting those rows that will require moving to a different partition and deleting them from the original partition. The re-inserted rows are directed to a correct partition by application of the partitioning criteria for the table. Methods, articles, and systems are described.

公开(公告)号：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.

公开(公告)号：US20190340278A1

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

申请号：US15969124

申请日：2018-05-02

Applicant: SAP SE

Inventor： Christian Bensberg ,  Steffen Geissinger

IPC: G06F17/30 ,  G06F7/08

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.

公开(公告)号：US20190339894A1

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

申请号：US15972467

申请日：2018-05-07

Applicant: SAP SE

Inventor： Christian Bensberg ,  Steffen Geissinger

IPC: G06F3/06 ,  G06F17/30

Abstract: A data storage and retrieval system for a computer memory including a memory slice formed of segments and adapted to contain one or more documents and a checkpoint adapted to persist the memory slice. The checkpoint includes a document vector containing a document pointer corresponding to a document. The document pointer including a segment identifier identifying a logical segment of the memory slice and an offset value defining a relative memory location of the first document within the identified segment. There are checkpoint memory blocks, each storing a copy of a corresponding segment of the memory slice. The segment identifier of the document pointer identifies a checkpoint memory block and the offset value of the document pointer defines a relative location of the document within the checkpoint memory block.

公开(公告)号：US10223420B2

公开(公告)日：2019-03-05

申请号：US15160771

申请日：2016-05-20

Applicant: SAP SE

Inventor： Hans-Joerg Leu ,  Christian Bensberg ,  Johannes Beigel ,  Jochen Becker ,  Carsten Mueller

IPC: G06F17/30

Abstract: A node type of a plurality of distributed nodes to which a table to be added to a distributed database should be assigned can be identified by applying a set of placement rules defined for the table. The set of placement rules can also be applied to determine whether the table should be partitioned into more than one partition. A table group name associated with the table can be obtained and used in conjunction with the node type and determination of whether to partition the table to store the table in the distributed database on at least one node of the plurality of nodes as one or more partitions.