-
公开(公告)号:US10824673B2
公开(公告)日:2020-11-03
申请号:US15695621
申请日:2017-09-05
Applicant: SAP SE
Inventor: Oliver Rebholz , Ivan Schreter , Abdelkader Sellami , Daniel Booss , Gunter Radestock , Peter Bumbulis , Alexander Boehm , Frank Renkes , Werner Thesing , Thomas Willhalm
IPC: G06F16/901 , G06F3/06
Abstract: A system includes a non-volatile random access memory storing a column store main fragment of a column of a database table, and a processing unit to read the column store main fragment from the non-volatile random access memory. A volatile random access memory storing a column store delta fragment of the column of the database table may also be included, in which the processing unit is to write to the column store delta fragment. According to some systems, the stored column store main fragment is byte-addressable, and is copied from the volatile random access memory to the non-volatile random access memory without using a filesystem cache.
-
公开(公告)号:US10691688B2
公开(公告)日:2020-06-23
申请号:US15186300
申请日:2016-06-17
Applicant: SAP SE
Inventor: Anisoara Nica , Peter Bumbulis , Reza Sherkat , Mihnea Andrei , Anil K. Goel
IPC: G06F16/2453 , G06F16/2455 , G06F16/22
Abstract: Cracking page-loadable columns for in-memory data management is described herein. An embodiment operates by accessing a column according to a received query, determining that the received query requires a non-critical data structure associated with the column, and rebuilding the non-critical data structure from data associated with the column.
-
公开(公告)号:US20170357667A1
公开(公告)日:2017-12-14
申请号:US15182030
申请日:2016-06-14
Applicant: SAP SE
Inventor: Nathan Auch , Scott MacLean , Peter Bumbulis , Jeffrey Pound , Anil Kumar Goel
IPC: G06F17/30
Abstract: A system includes reception of a first write request from a client including a first key and a first one or more stream, payload pairs associated with the first key, copying of the first key and the first one or more stream, payload pairs to a first buffer of a volatile memory, storage of data of the first buffer in one or more blocks of a raw block non-volatile memory device, providing of the first buffer to a stream store server, reception of the first buffer at the stream store server, adding of the first key and the first one or more stream, payload pairs to a second buffer of the volatile memory, in key-order, storage of the data of the second buffer in a filesystem storage device, according to stream, and transmission of an indication of the durability of the key to the tail store server.
-
公开(公告)号:US09720774B2
公开(公告)日:2017-08-01
申请号:US14753521
申请日:2015-06-29
Applicant: SAP SE
Inventor: Ismail Oukid , Anisoara Nica , Peter Bumbulis , Wolfgang Lehner , Thomas Willhalm
CPC classification number: G06F11/142 , G06F3/0619 , G06F3/0644 , G06F3/068 , G06F11/00 , G06F2201/80
Abstract: A system includes determination of a plurality of secondary data structures of a database to be rebuilt, determination, for each of the plurality of secondary data structures, of a current ranking based on a pre-crash workload, a crash-time workload, the post-crash workload, and a rebuild time of the secondary data structure, determination to rebuild one of the plurality of secondary data structures based on the determined rankings, and rebuilding of the one of the plurality of secondary data structures in a dynamic random access memory based on primary data of a database stored in non-volatile random access memory.
-
公开(公告)号:US10671572B2
公开(公告)日:2020-06-02
申请号:US15182030
申请日:2016-06-14
Applicant: SAP SE
Inventor: Nathan Auch , Scott MacLean , Peter Bumbulis , Jeffrey Pound , Anil Kumar Goel
Abstract: A system includes reception of a first write request from a client including a first key and a first one or more stream, payload pairs associated with the first key, copying of the first key and the first one or more stream, payload pairs to a first buffer of a volatile memory, storage of data of the first buffer in one or more blocks of a raw block non-volatile memory device, providing of the first buffer to a stream store server, reception of the first buffer at the stream store server, adding of the first key and the first one or more stream, payload pairs to a second buffer of the volatile memory, in key-order, storage of the data of the second buffer in a filesystem storage device, according to stream, and transmission of an indication of the durability of the key to the tail store server.
-
公开(公告)号:US20160378601A1
公开(公告)日:2016-12-29
申请号:US14753521
申请日:2015-06-29
Applicant: SAP SE
Inventor: Ismail Oukid , Anisoara Nica , Peter Bumbulis , Wolfgang Lehner , Thomas Willhalm
CPC classification number: G06F11/142 , G06F3/0619 , G06F3/0644 , G06F3/068 , G06F11/00 , G06F2201/80
Abstract: A system includes determination of a plurality of secondary data structures of a database to be rebuilt, determination, for each of the plurality of secondary data structures, of a current ranking based on a pre-crash workload, a crash-time workload, the post-crash workload, and a rebuild time of the secondary data structure, determination to rebuild one of the plurality of secondary data structures based on the determined rankings, and rebuilding of the one of the plurality of secondary data structures in a dynamic random access memory based on primary data of a database stored in non-volatile random access memory.
Abstract translation: 系统包括确定要重建的数据库的多个辅助数据结构,对于多个次要数据结构中的每一个确定基于预碰撞工作负载的当前排序,崩溃时间工作负载,事件 基于所确定的排序重建所述多个辅助数据结构中的一个,以及基于动态随机存取存储器中的所述多个辅助数据结构中的一个重建所述次要数据结构的重构时间 存储在非易失性随机存取存储器中的数据库的主数据。
-
公开(公告)号:US10346387B2
公开(公告)日:2019-07-09
申请号:US15180720
申请日:2016-06-13
Applicant: SAP SE
Inventor: Peter Bumbulis , Jeffrey Pound , Nathan Auch , Anil Kumar Goel , Matthias Ringwald , Thomas Bodner , Scott MacLean
Abstract: A method includes a primary storage unit receiving a first write request including a first key and a first value; persisting the first value in a first non-volatile memory in association with the first key; broadcasting the first write request and a first set of globally-durable keys to secondary storage units; receiving, from the secondary storage units, an acknowledgement of the first write request and a first set of locally-durable keys, each of the first sets of locally-durable keys including the first key; the primary storage unit receiving a second write request including a second key and a second value; persisting the second value in the first non-volatile memory in association with the second key; and broadcasting the second write request and a second set of globally-durable keys to the secondary storage units, the second set of locally-durable keys including the first key. A system is also disclosed.
-
公开(公告)号:US20180246809A1
公开(公告)日:2018-08-30
申请号:US15695621
申请日:2017-09-05
Applicant: SAP SE
Inventor: Oliver Rebholz , Ivan Schreter , Abdelkader Sellami , Daniel Booss , Gunter Radestock , Peter Bumbulis , Alexander Boehm , Frank Renkes , Werner Thesing , Thomas Willhalm
Abstract: A system includes a non-volatile random access memory storing a column store main fragment of a column of a database table, and a processing unit to read the column store main fragment from the non-volatile random access memory. A volatile random access memory storing a column store delta fragment of the column of the database table may also be included, in which the processing unit is to write to the column store delta fragment. According to some systems, the stored column store main fragment is byte-addressable, and is copied from the volatile random access memory to the non-volatile random access memory without using a filesystem cache.
-
公开(公告)号:US20180165343A1
公开(公告)日:2018-06-14
申请号:US15373844
申请日:2016-12-09
Applicant: SAP SE
Inventor: Hua Fan , Jeffrey Pound , Peter Bumbulis , Anil Kumar Goel , Scott MacLean , Nathan Auch , Eric Garber
CPC classification number: G06F16/275 , G06F3/067 , G06F16/2358 , G06F16/2365 , G06F16/273 , H04L67/1002 , H04W4/06
Abstract: Disclosed herein are system, method, and computer program product embodiments for quorum-based replication of data records. In one embodiment, a read request for reading a record is received from a user node on a replica node of a cluster of replica nodes. The record is then determined not committed on the replica node. In response to the determination, an update message indicative of whether the number of replica nodes on which the record is durable exceeds a threshold is received on the replica node. In response to the number of replica nodes exceeds the threshold, a value of the record on the replica node is transmitted to the user node.
-
公开(公告)号:US20190332387A1
公开(公告)日:2019-10-31
申请号:US15964618
申请日:2018-04-27
Applicant: SAP SE
Inventor: Peter Bumbulis
Abstract: Disclosed herein are system, method, and computer program product embodiments for improving the performance of operations on compressed index vectors in columnar in-memory database management systems. By utilizing 512-bit SIMD processor instructions, database management systems may achieve performance gains in operations that compress and decompress bit vectors and evaluate predicates.
-
-
-
-
-
-
-
-
-