公开(公告)号：US20210089552A1

公开(公告)日：2021-03-25

申请号：US16713194

申请日：2019-12-13

Applicant: SAP SE

Inventor： Ruediger Karl ,  Mihnea Andrei ,  Juchang Lee ,  Stefan Baeuerle ,  Seyeong Bae ,  Joo Yeon Lee

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

Abstract: Techniques and solutions are described for implementing virtual table schemas. A virtual table schema includes a logical pointer that is used to target a table that includes data and is defined according to the virtual table schema. Values assigned to the logical pointer can be used to target tables at different locations, such as tables located in a remote database system, replica tables containing data replicated from a table in a remote database system, or cached table data. Replica tables targeted by a logical pointer of a virtual table schema can have various locations, such as being located in main memory of a database system, being located in a dynamic storage system, or being located in a data lake. Replica tables can be transferred between locations based on various criteria.

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

公开(公告)号：US20200264786A1

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

申请号：US16277250

申请日：2019-02-15

Applicant: SAP SE

Inventor： Anupam Mukherjee ,  Mihnea Andrei

IPC: G06F3/06 ,  G06F16/22

Abstract: Provided is a system and method for improving memory management in a database. In one example, the method may include receiving a request to store a data object within a database, determining a category type associated with the data object from among a plurality of category types based on an attribute of the data object, and storing the data object via a memory pool corresponding to the determined category from among a plurality of memory pools corresponding to the plurality of respective categories, where the storing comprises allocating a first category type of data object to a first memory pool locked to main memory and allocating a second category type of data object to a second memory pool that is swapped out to disk over time. The locked memory pool can ensure that more important data items remain available even when they are the least recently used.

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

公开(公告)号：US20190026387A1

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

申请号：US15692267

申请日：2017-08-31

Applicant: SAP SE

Inventor： Panfeng Zhou ,  Mihnea Andrei ,  Vivek Kandiyanallur ,  Xin Liu ,  Neeraj Kulkarni

IPC: G06F17/30

CPC classification number: G06F16/835 ,  G06F16/1744 ,  G06F16/21 ,  G06F16/258 ,  G06F16/86 ,  G06F16/90 ,  G06F16/907

Abstract: A system and method, including determining, by a processor, a data type for each column of a database table; determining, by the processor and based on the determined data type for each column of the database table, an indication of a size of the database table; calculating, by the processor and based on the determined indication of the size of the database table, a start nbit size for a nbit compression process to be used on the database table; specifying, by the processor, the calculated start nbit size for the nbit compression process; and compressing the database table by executing the nbit data compression process using the specified start nbit size.

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

公开(公告)号：US20180329973A1

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

申请号：US15796288

申请日：2017-10-27

Applicant: SAP SE

Inventor： Reza Sherkat ,  Anisoara Nica ,  Xun Cheng ,  Prabhas Kumar Samanta ,  Mihnea Andrei

IPC: G06F17/30

CPC classification number: G06F17/30584 ,  G06F17/30292 ,  G06F17/30306 ,  G06F17/30339 ,  G06F17/30371 ,  G06F17/30469 ,  G06F17/30536

Abstract: Disclosed herein are system, method, and computer program product embodiments for performing dynamic partition pruning using data statistic objects as data integrity constraints. An embodiment operates by partitioning a database table into a plurality of partitions based on a partition criterion. The embodiment creates a data statistics object for a partition in the plurality of partitions. The embodiment receives a query for the database table. The embodiment determines the data statistics object is consistent with data in the partition. The embodiment processes the query for the partition based on the data statistics object.

公开(公告)号：US20180329941A1

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

申请号：US15796326

申请日：2017-10-27

Applicant: SAP SE

Inventor： Anisoara NICA ,  Reza Sherkat ,  Mihnea Andrei

IPC: G06F17/30

CPC classification number: G06F17/30584 ,  G06F17/30292 ,  G06F17/30306 ,  G06F17/30339 ,  G06F17/30371 ,  G06F17/30469 ,  G06F17/30536

Abstract: Disclosed herein are system, method, and computer program product embodiments for using a data statistic as a dynamic data integrity constraint. An embodiment operates by defining a data statistic for a column or a set of columns of a partition of a plurality of partitions of a database table. The embodiment creates a constraint data statistics object based on the data statistic. The embodiment receives a query for the database table. The embodiment determines the constraint data statistics object is consistent with a data state of the partition. The embodiment derives an implied constraint based on the constraint data statistics object. The embodiment processes the query for the partition based on the implied constraint.

公开(公告)号：US20170147225A1

公开(公告)日：2017-05-25

申请号：US14951046

申请日：2015-11-24

Applicant: SAP SE

Inventor： STEFFEN GEISSINGER ,  Ivan Schreter ,  Mihnea Andrei

IPC: G06F3/06 ,  G06F12/08

CPC classification number: G06F3/0608 ,  G06F3/064 ,  G06F3/065 ,  G06F3/0652 ,  G06F3/0656 ,  G06F3/0673 ,  G06F12/0891 ,  G06F13/00 ,  G06F16/00 ,  G06F16/221

Abstract: First page data from one or more pages stored on a persistent storage can be loaded into a page buffer in a main system memory of one or more computing systems, and second page data that includes first dictionary values of a first dictionary for a first database column can be loaded and pinned into the page buffer in the main system memory. First contents of a first dictionary block containing first re-direction references to the first dictionary can be copied from the loaded first page data into a first in-memory array, and the first page data can be deallocated from the page buffer. The first re-direction references can direct to the first dictionary values of the first dictionary in the pinned second page data.

公开(公告)号：US20170083243A1

公开(公告)日：2017-03-23

申请号：US15369618

申请日：2016-12-05

Applicant: SAP SE

Inventor： David Wein ,  Mihnea Andrei ,  Dirk Thomsen ,  Ivan Schreter

IPC: G06F3/06 ,  G06F17/30

CPC classification number: G06F3/065 ,  G06F3/0608 ,  G06F3/0617 ,  G06F3/0644 ,  G06F3/0673 ,  G06F3/0685 ,  G06F17/30315 ,  G06F17/30339 ,  G06F17/3048 ,  G06F17/30575

Abstract: The subject matter disclosed herein provides methods for materializing data from an in-memory array to one or more pages. An in-memory array holding a column of data can be maintained. One or more pages can be maintained. Each of the one or more pages can have one or more rows for storing the column of data. At least one of the one or more pages can be marked for materialization. The column of data can be materialized by copying the data from the in-memory array to the one or more rows of the one or more pages. The materializing can be based on the marking. Related apparatus, systems, techniques, and articles are also described.