公开(公告)号：US10769034B2

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

申请号：US15452391

申请日：2017-03-07

Applicant: SAP SE

Inventor： Sarika Iyer ,  Vivek Kandiyanallur ,  Martin Heidel ,  Rolando Blanco ,  Stephan Kottler ,  Carsten Thiel ,  Peter Steinemann ,  Jörn Schmidt ,  Colin Florendo ,  Michael Muehle ,  Chaitanya Gottipati

IPC: G06F17/30 ,  G06F11/14 ,  G06F16/23 ,  G06F16/2453

Abstract: Objects across multiple database manipulation language (DML) redo log records are cached, during continuous replay of redo log records on a secondary system, for the same table partition to enable reuse of such cached objects. Later, these cached objects can be reused as they are accessed during the sequential processing of DML redo records for a specific table partition.

公开(公告)号：US20180260287A1

公开(公告)日：2018-09-13

申请号：US15452391

申请日：2017-03-07

Applicant: SAP SE

Inventor： Sarika Iyer ,  Vivek Kandiyanallur ,  Martin Heidel ,  Rolando Blanco ,  Stephan Kottler ,  Carsten Thiel ,  Peter Steinemann ,  Jörn Schmidt ,  Colin Florendo ,  Michael Muehle ,  Chaitanya Gottipati

IPC: G06F11/14 ,  G06F17/30

Abstract: Objects across multiple database manipulation language (DML) redo log records are cached, during continuous replay of redo log records on a secondary system, for the same table partition to enable reuse of such cached objects. Later, these cached objects can be reused as they are accessed during the sequential processing of DML redo records for a specific table partition.

公开(公告)号：US11514027B2

公开(公告)日：2022-11-29

申请号：US16857982

申请日：2020-04-24

Applicant: SAP SE

Inventor： Reza Sherkat ,  Chaitanya Gottipati ,  Colin Florendo ,  Martin Heidel

IPC: G06F16/22 ,  G06F16/23 ,  G06F12/02 ,  G06F3/06 ,  G06F12/0882 ,  G06F16/2455 ,  G06F12/0875 ,  G06F9/48

Abstract: Disclosed herein are system, method, and computer program product embodiments for storing a large object (LOB) in a database. An embodiment operates by identifying the LOB to be stored in an on-disk store of the database and determining the size of the LOB. Thereafter, an index vector for the on-disk store to include an identifier corresponding to the LOB is created. Additionally, a dictionary for the on-disk store to include a copy of the identifier and corresponding LOB data is also created. The LOB data corresponds to the LOB itself or a LOB location inside of the on-disk store based on the LOB's size.

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

公开(公告)号：US11170023B2

公开(公告)日：2021-11-09

申请号：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: G06F16/27 ,  G06F16/23 ,  G06F16/2455 ,  G06F11/20

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.

公开(公告)号：US11372845B2

公开(公告)日：2022-06-28

申请号：US16893703

申请日：2020-06-05

Applicant: SAP SE

Inventor： Deepak Shrivastava ,  Chaitanya Gottipati ,  Colin Florendo ,  Rolando Blanco ,  Michael Muehle ,  Awisha Makwana

IPC: G06F16/23 ,  G06F16/22 ,  G06F16/2455 ,  G06F12/02 ,  G06F3/06 ,  G06F12/0882 ,  G06F12/0875 ,  G06F9/48

Abstract: Disclosed herein are system, method, and computer program product embodiments for converting column loadable data in a database into a page loadable format. When a column oriented in-memory database needs to perform an operation on a table, the affected columns must be loaded fully into memory. In some cases, a database may partition tables, allowing for column fragments corresponding to those partitions to be loaded into memory. These column fragments may exceed available memory, such that it is beneficial to convert the column fragment into a page loadable format. Approaches are discussed herein for performing the conversion without the need to update global metadata during the process, allowing for multiple parallel column fragments to be updated, allowing data manipulation language (DML) operations to continue on the column during the conversion process, and reducing the impact of blocked parallel savepoint operations during the conversion process by chunking the conversion process.

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

公开(公告)号：US10762107B2

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

申请号：US15409234

申请日：2017-01-18

Applicant: SAP SE

Inventor： Colin Florendo ,  Chaitanya Gottipati ,  Michael Muehle ,  Nirvik Basak ,  Mihnea Andrei ,  Thomas Peh

IPC: G06F16/27

Abstract: A computer implemented method for updating a secondary database includes receiving transaction log information from a primary database system at a secondary database system. The transaction log information comprises a first marker identifying a beginning of an operation comprising a plurality of sub-operations and a second marker identifying an end of the operation. The transaction log information is sequentially parsed, a first marker is identified, and a lock state is created after replaying the first marker to ensure proper serialization of the plurality of sub-operations. The lock state is terminated after replaying the second marker. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US20180246947A1

公开(公告)日：2018-08-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: G06F17/30 ,  G06F17/27

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.

公开(公告)号：US20180150540A1

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

申请号：US15409234

申请日：2017-01-18

Applicant: SAP SE

Inventor： Colin Florendo ,  Chaitanya Gottipati ,  Michael Muehle ,  Nirvik Basak ,  Mihnea Andrei ,  Thoms Peh

IPC: G06F17/30

Abstract: A computer implemented method for updating a secondary database includes receiving transaction log information from a primary database system at a secondary database system. The transaction log information comprises a first marker identifying a beginning of an operation comprising a plurality of sub-operations and a second marker identifying an end of the operation. The transaction log information is sequentially parsed, a first marker is identified, and a lock state is created after replaying the first marker to ensure proper serialization of the plurality of sub-operations. The lock state is terminated after replaying the second marker. Related apparatus, systems, techniques and articles are also described.