公开(公告)号：US11347709B2

公开(公告)日：2022-05-31

申请号：US16878870

申请日：2020-05-20

Applicant: SAP SE

Inventor： Nirvik Basak ,  Souvik Pal ,  Chaitanya Gottipati ,  Amit Saonerkar ,  Prasanta Ghosh ,  Mihnea Andrei ,  Norman May

IPC: G06F16/22 ,  G06F16/245

Abstract: System, method, and various embodiments for providing a metadata based memory management system are described herein. An embodiment operates by determining metadata of a table of a database indicating whether data of the table is to be stored in memory or disk storage, wherein the table comprises a plurality of columns and a plurality of rows. A first column of the table is identified. A hierarchy of the metadata for the table including a column value, partition value, and table value is determined, wherein the column value is prioritized over the partition value, and wherein the partition value is prioritized over the table value. The data of the table stored in the column is loaded from the disk storage into the memory based on the hierarchy. A query is processed based on the data loaded into the memory.

公开(公告)号：US20210311922A1

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

申请号：US16878870

申请日：2020-05-20

Applicant: SAP SE

Inventor： Nirvik Basak ,  Souvik Pal ,  Chaitanya Gottipati ,  Amit Saonerkar ,  Prasanta Ghosh ,  Mihnea Andrei ,  Norman May

IPC: G06F16/22 ,  G06F16/245

Abstract: System, method, and various embodiments for providing a metadata based memory management system are described herein. An embodiment operates by determining metadata of a table of a database indicating whether data of the table is to be stored in memory or disk storage, wherein the table comprises a plurality of columns and a plurality of rows. A first column of the table is identified. A hierarchy of the metadata for the table including a column value, partition value, and table value is determined, wherein the column value is prioritized over the partition value, and wherein the partition value is prioritized over the table value. The data of the table stored in the column is loaded from the disk storage into the memory based on the hierarchy. A query is processed based on the data loaded into the memory.

公开(公告)号：US10853343B2

公开(公告)日：2020-12-01

申请号：US15596603

申请日：2017-05-16

Applicant: SAP SE

Inventor： Michael Muehle ,  Chaitanya Gottipati ,  Nirvik Basak ,  Mihnea Andrei

IPC: G06F16/22 ,  G06F16/245

Abstract: Systems, apparatus, techniques, articles, and methods include a unified table container for storing data and metadata in pages organized in one or more page chains. A determination is made as to whether the query includes a data definition statement. In response to determining that the query includes a data definition statement, in-memory runtime data is persisted to a persistent volume that is configured to be accessed by the database system. The in-memory runtime data includes one or more first data fields and one or more second data fields that are different from the one or more first data fields. Furthermore, the unified table container includes a persistent runtime data descriptor that is associated with the one or more first data fields and persists the first one or more first data fields when persisting the in-memory runtime data.

公开(公告)号：US10698921B2

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

申请号：US15445505

申请日：2017-02-28

Applicant: SAP SE

Inventor： Colin Florendo ,  Michael Muehle ,  Thorsten Glebe ,  Rolando Blanco ,  Chaitanya Gottipati ,  Nirvik Basak ,  Günter Radestock

IPC: G06F16/27 ,  G06F16/23

Abstract: A computer implemented method for initializing a secondary database system includes receiving table state information from a primary database system at a secondary database system. The table state information includes information identifying which tables had an open operation during a savepoint event. Metadata associated with the tables is parsed to identify table state information from the metadata and a lock is created for each table identified as having an open operation during the savepoint event. Afterwards, log transaction information is sequentially parsed. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US20180246948A1

公开(公告)日：2018-08-30

申请号：US15445593

申请日：2017-02-28

Applicant: SAP SE

Inventor： Colin Florendo ,  Michael Muehle ,  Thorsten Glebe ,  Rolando Blanco ,  Chaitanya Gottipati ,  Nirvik Basak ,  Martin Heidel ,  Peter Steinemann ,  Vivek Kandiyanallur ,  Shiping Chen ,  Sarika Iyer ,  Jörn Schmidt

IPC: G06F17/30

CPC classification number: G06F16/273 ,  G06F11/2094 ,  G06F11/2097 ,  G06F16/2365 ,  G06F16/2455 ,  G06F2201/80 ,  G06F2201/855

Abstract: A computer implemented method for manipulating data comprises receiving log transaction information from a primary database system at a secondary database system and parsing the log transaction information to identify data objects that have been modified on the primary database system. The secondary database system determines whether the data objects are present in main memory on the secondary database system and whether the log transaction corresponds to a data manipulation language (DML) query or a data definition language (DDL) query. If the data objects are not in the main memory and the query is a DML query, they are copied from persistence data volumes to the main memory. The data objects in main memory are modified by replaying the log transactions on the data objects in the main memory. Then, the data objects in the persistence data volumes are modified. Related apparatus, systems, techniques and articles are also described.