公开(公告)号：US12242497B1

公开(公告)日：2025-03-04

申请号：US18504435

申请日：2023-11-08

Applicant: SAP SE

Inventor： Anish Maniyar ,  Santhosh T Kumar ,  Guo Gang Ye ,  Amit Pathak ,  Sebastian Seifert ,  Souvik Pal

IPC: G06F16/25

Abstract: A database system detects a query targeting a first database object stored in a unified persistence format in a persistence store. In response to detecting the query, the database system determines whether to load the first database object in column-loadable format or page-loadable format into an in-memory store. In response to determining to load the first database object in the column-loadable format, the database system determines if a first bit representation of one or more corresponding primitives in the persistence store is compatible with a second bit representation used for storing the primitives in the in-memory store. The database system performs a native copy operation to copy the primitives from the persistence store to the in-memory store if the bit representations are compatible, where the native copy operation involves copying the primitives on a page-by-page basis without decoding and encoding values of the one or more primitives.

公开(公告)号：US11347743B2

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

申请号：US16878877

申请日：2020-05-20

Applicant: SAP SE

Inventor： Nirvik Basak ,  Souvik Pal ,  Chaitanya Gottipati

IPC: G06F16/2455 ,  G06F16/22

Abstract: System, method, and various embodiments for providing a metadata converter and memory management system are described herein. An embodiment operates by determining that first metadata corresponding to a table of a database comprising load preferences for a column level for a plurality of columns of the table, wherein the load preferences include either column load or page load. It is determined that the database is enabled with both load preferences for a table level and load preferences partition level, in addition to load preferences for the column level. Values for the load preferences are automatically assigned for both the table level and the partition level in second metadata, and wherein the second metadata preserves the load preferences for the column level of the first metadata. A query against the table based on load preferences from the second metadata.

公开(公告)号：US20210311949A1

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

申请号：US16878877

申请日：2020-05-20

Applicant: SAP SE

Inventor： Nirvik Basak ,  Souvik Pal ,  Chaitanya Gottipati

IPC: G06F16/2455 ,  G06F16/22

Abstract: System, method, and various embodiments for providing a metadata converter and memory management system are described herein. An embodiment operates by determining that first metadata corresponding to a table of a database comprising load preferences for a column level for a plurality of columns of the table, wherein the load preferences include either column load or page load. It is determined that the database is enabled with both load preferences for a table level and load preferences partition level, in addition to load preferences for the column level. Values for the load preferences are automatically assigned for both the table level and the partition level in second metadata, and wherein the second metadata preserves the load preferences for the column level of the first metadata. A query against the table based on load preferences from the second metadata.

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

公开(公告)号：US20170308547A1

公开(公告)日：2017-10-26

申请号：US15137648

申请日：2016-04-25

Applicant: SAP SE

Inventor： Gaurav Kumar GUPTA ,  Souvik Pal ,  Amit Pathak ,  Jay Sudrik

IPC: G06F17/30

CPC classification number: G06F16/178 ,  G06F16/182 ,  G06F16/27

Abstract: Disclosed herein are system, method, and computer program product embodiments for synchronizing an unsynchronized distributed database system. An embodiment operates by locking, by a second node, partitions in the second node based on first information received from, a first node responsive to execution of partition utility based on a first query received by the first node. Blocking, by the second node, a second query to a data portion of the partitions in the second node based on the first information. Locking, by the second node, second node object metadata based on second information received from the first node. Receiving, by the second node, changes to first node object metadata and applying the changes to the second node object metadata. Unlocking, by the second node, the partitions in the second node and the second node object metadata while unblocking the second query.