公开(公告)号：US20210326259A1

公开(公告)日：2021-10-21

申请号：US17363736

申请日：2021-06-30

Applicant: SAP SE

Inventor： Gary Lin ,  Reza Sherkat ,  John Smirnios

IPC: G06F12/0804 ,  G06F16/22 ,  G06F16/25

Abstract: A computer implemented system and method of memory management for an in-memory database. The system implements a paged data vector using non-uniform compression of its chunks. In this manner, the system achieves greater compression than systems that use uniform compression.

公开(公告)号：US20200183839A1

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

申请号：US16215276

申请日：2018-12-10

Applicant: SAP SE

Inventor： Gary Lin ,  Reza Sherkat ,  John Smirnios

IPC: G06F12/0804 ,  G06F16/25 ,  G06F16/22

Abstract: A computer implemented system and method of memory management for an in-memory database. The system implements a paged data vector using non-uniform compression of its chunks. In this manner, the system achieves greater compression than systems that use uniform compression.

公开(公告)号：US12047098B2

公开(公告)日：2024-07-23

申请号：US18072979

申请日：2022-12-01

Applicant: SAP SE

Inventor： Jia Shi ,  Reza Sherkat ,  John Smirnios

IPC: H03M7/46 ,  G06F16/22 ,  H03M7/30

CPC classification number: H03M7/46 ,  G06F16/2282 ,  H03M7/3088

Abstract: Techniques and solutions are described for compressing data and facilitating access to compressed data. Compression can be applied to proper data subsets of a data set, such as to columns of a table. Using various methods, the proper data subsets can be evaluated to be included in a group of proper data subsets to be compressed using a first compression technique, where unselected proper data subsets are not compressed using the first compression technique. Data in the data set can be reordered based on a reordering sequence for the proper data subsets. Reordering data in the data set can improve compression when at least a portion of the proper data subsets are compressed. A data structure is provided that facilitates accessing specified data stored in a compressed format.

公开(公告)号：US11558067B2

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

申请号：US16878419

申请日：2020-05-19

Applicant: SAP SE

Inventor： Jia Shi ,  Reza Sherkat ,  John Smirnios

IPC: H03M7/46 ,  G06F16/22 ,  H03M7/30

Abstract: Techniques and solutions are described for compressing data and facilitating access to compressed data. Compression can be applied to proper data subsets of a data set, such as to columns of a table. Using various methods, the proper data subsets can be evaluated to be included in a group of proper data subsets to be compressed using a first compression technique, where unselected proper data subsets are not compressed using the first compression technique. Data in the data set can be reordered based on a reordering sequence for the proper data subsets. Reordering data in the data set can improve compression when at least a portion of the proper data subsets are compressed. A data structure is provided that facilitates accessing specified data stored in a compressed format.

公开(公告)号：US20190236193A1

公开(公告)日：2019-08-01

申请号：US15964624

申请日：2018-04-27

Applicant: SAP SE

Inventor： Yu-Jui CHEN ,  Reza Sherkat ,  John Smirnios ,  Mihnea Andrei

IPC: G06F17/30

CPC classification number: G06F16/24561 ,  G06F16/2282 ,  G06F16/242 ,  G06F16/278

Abstract: Disclosed herein are system, method, and computer program product embodiments for partition pruning using globally encoded range partition information. An embodiment operates by partitioning a data table into a plurality of data partitions, determining a plurality of sub-partitions within the data partitions, and determining a global range table based at least in part on value ranges corresponding to the sub-partitions. Further, the global range table may be used to determine bit vectors for the data partitions and query predicates. In some examples, the bit vectors may be used to determine whether to prune data partitions during execution of a query over a large data volume.

公开(公告)号：US20190155705A1

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

申请号：US15877074

申请日：2018-01-22

Applicant: SAP SE

Inventor： Mahendra Chavan ,  Reiner Singer ,  Markus Behrens ,  John Smirnios ,  Anant Agarwal

IPC: G06F11/20 ,  G06F17/30

Abstract: Disclosed herein are system, method, and computer program product embodiments for coordinated replication of heterogeneous database stores. An embodiment operates by determining a synchronization point based on a commit log of a primary data center. A current log position of each of a plurality of secondary slave servers associated with a secondary master server of a secondary data center is requested. It is determined that the current log position of at least one of the secondary slave servers does not correspond to the logged position of a corresponding primary slave server relative to the synchronization point. An update indicating that the current log position of each of the secondary slave servers corresponds to the logged position of each of the relative corresponding primary slave servers is received. A replay of each of the secondary slave servers up to the synchronization point is initiated.