公开(公告)号：US09830109B2

公开(公告)日：2017-11-28

申请号：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.

公开(公告)号：US10747737B2

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

申请号：US14552902

申请日：2014-11-25

Applicant: SAP SE

Inventor： Colin Florendo ,  Ivan Schreter ,  Panfeng Zhou ,  David Wein ,  Steffen Geissinger ,  Michael Muehle

IPC: G06F17/22 ,  G06F16/22

Abstract: Disclosed herein are system, method, and computer program product embodiments for altering the data type of a column in a database. An embodiment operates by converting an original dictionary associated with a column into a new dictionary. The new dictionary stores the values of the original dictionary using a different data type. An index vector containing the keys of the original dictionary is then updated to contain the associated keys of the new dictionary. Because the size of the original dictionary is often substantially smaller than the number of rows in the associated column, this dictionary conversion decreases the computation cost to the database system of altering the data type of the column and reduces or even minimizes database downtime for users.

公开(公告)号：US20170139981A1

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

申请号：US14944068

申请日：2015-11-17

Applicant: SAP SE

Inventor： David Wein

IPC: G06F17/30

CPC classification number: G06F17/30368 ,  G06F3/0619 ,  G06F3/0665 ,  G06F3/0689 ,  G06F17/30008 ,  G06F17/30171 ,  G06F17/30309 ,  G06F17/30348 ,  G06F17/30353 ,  G06F17/30356 ,  G06F17/30359 ,  G06F17/30383 ,  G06F17/30575 ,  G06F17/30592

Abstract: Changes to data in a column in an in memory array resulting from operations of a transaction thread can be written to a database object associated with the column. The database object can be marked for materialization upon completion of all of the plurality of operations of the transaction thread such that the column and the changes are materialized from the in-memory array to one or more pages stored on a persistent storage based on the marking.

公开(公告)号：US20170109044A1

公开(公告)日：2017-04-20

申请号：US14885752

申请日：2015-10-16

Applicant: SAP SE

Inventor： Panfeng Zhou ,  Colin Florendo ,  Ivan Schreter ,  Thorsten Glebe ,  David Wein

IPC: G06F3/06 ,  G06F17/30

CPC classification number: G06F16/22 ,  G06F12/00

Abstract: The subject matter disclosed herein relates to out of memory error handling in a database system. A database operation can be received by an in-memory database. The database operation can be for a database object stored in a database table that can be represented as a plurality of pages that can be persisted in a page chain. The in-memory database can reserve out of memory space sufficient to load a predetermined number of pages in the page chain into memory. The in-memory database can iteratively process each page in the page chain until completion of the database operation. The iterative process can include loading the page from persistence into memory of the in-memory database, performing at least a portion of the database operation using the loaded page, and unloading the page from the memory of the in-memory database. Related apparatus, systems, techniques, and articles are also described.

公开(公告)号：US11086832B2

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

申请号：US14885752

申请日：2015-10-16

Applicant: SAP SE

Inventor： Panfeng Zhou ,  Colin Florendo ,  Ivan Schreter ,  Thorsten Glebe ,  David Wein

IPC: G06F16/22 ,  G06F12/00

Abstract: The subject matter disclosed herein relates to out of memory error handling in a database system. A database operation can be received by an in-memory database. The database operation can be for a database object stored in a database table that can be represented as a plurality of pages that can be persisted in a page chain. The in-memory database can reserve out of memory space sufficient to load a predetermined number of pages in the page chain into memory. The in-memory database can iteratively process each page in the page chain until completion of the database operation. The iterative process can include loading the page from persistence into memory of the in-memory database, performing at least a portion of the database operation using the loaded page, and unloading the page from the memory of the in-memory database. Related apparatus, systems, techniques, and articles are also described.

公开(公告)号：US10311048B2

公开(公告)日：2019-06-04

申请号：US14944068

申请日：2015-11-17

Applicant: SAP SE

Inventor： David Wein

IPC: G06F16/23 ,  G06F16/2453 ,  G06F3/06 ,  G06F16/27 ,  G06F16/21 ,  G06F16/28 ,  G06F16/176 ,  G06F15/16

Abstract: Changes to data in a column in an in memory array resulting from operations of a transaction thread can be written to a database object associated with the column. The database object can be marked for materialization upon completion of all of the plurality of operations of the transaction thread such that the column and the changes are materialized from the in-memory array to one or more pages stored on a persistent storage based on the marking.

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