公开(公告)号：US11308047B2

公开(公告)日：2022-04-19

申请号：US16816511

申请日：2020-03-12

Applicant: SAP SE

Inventor： Panfeng Zhou ,  Vivek Kandiyanallur ,  Colin Florendo ,  Robert Schulze ,  Zheng-Wei She ,  Yanhong Wang ,  Amarnadh Sai Eluri

IPC: G06F16/00 ,  G06F16/21 ,  G06F16/22 ,  G06N5/04

Abstract: System, method, and various embodiments for providing a data access and recommendation system are described herein. An embodiment operates by identifying a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period. A count of how many of the one or more data values are accessed during the column access are recorded. A first counter, corresponding to the first column and stored in a distributed hash table, is incremented by the count. The sampling period is determined to have expired. A load recommendation on how to load data values into the first column based on the first counter is computed. The load recommendation for implementation into the database for one or more subsequent column accesses is provided.

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

公开(公告)号：US11500928B2

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

申请号：US16734907

申请日：2020-01-06

Applicant: SAP SE

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

IPC: G06F16/835 ,  G06F16/84 ,  G06F16/25 ,  G06F16/174 ,  G06F16/21 ,  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.

公开(公告)号：US11249962B2

公开(公告)日：2022-02-15

申请号：US16411869

申请日：2019-05-14

Applicant: SAP SE

Inventor： Panfeng Zhou ,  Xu-Dong Qian ,  Yanhong Wang ,  Shyam Sunder Reddy Avula ,  Amarnadh Sai Eluri ,  Chirag Samtani

IPC: G06F16/21 ,  G06F16/185 ,  G06F11/34 ,  G06F16/242

Abstract: Disclosed herein are systems, methods, and devices for providing load unit recommendations. An example method includes monitoring queries executed by a database management system including a database object, determining an access frequency of the database object based upon the monitoring, and determining relative access counter information for the database object based on the access frequency. Subsequently, the method includes generating a sorted element based on the relative access counter information, determining threshold values based on threshold information and the sorted element, and determining a load unit for the database object based on the sorted element and the threshold values. The load unit indicates whether to load the whole database object, or only a portion thereof, into a main memory of the DBMS while accessing the database object.

公开(公告)号：US10558704B2

公开(公告)日：2020-02-11

申请号：US15692267

申请日：2017-08-31

Applicant: SAP SE

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

IPC: G06F16/00 ,  G06F16/835 ,  G06F16/84 ,  G06F16/25 ,  G06F16/174 ,  G06F16/21 ,  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.

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

公开(公告)号：US11775488B2

公开(公告)日：2023-10-03

申请号：US17699747

申请日：2022-03-21

Applicant: SAP SE

Inventor： Panfeng Zhou ,  Vivek Kandiyanallur ,  Colin Florendo ,  Robert Schulze ,  Zheng-Wei She ,  Yanhong Wang ,  Amarnadh Sai Eluri

IPC: G06F16/00 ,  G06F16/21 ,  G06F16/22 ,  G06N5/04

CPC classification number: G06F16/213 ,  G06F16/221 ,  G06F16/2255 ,  G06N5/04

Abstract: System, method, and various embodiments for providing a data access and recommendation system are described herein. An embodiment operates by identifying a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period. A count of how many of the one or more data values are accessed during the column access are recorded. A first counter is incremented by the count. The sampling period is determined to have expired. A load recommendation on how to load data values into the first column based on the first counter is computed. The load recommendation for implementation into the database for one or more subsequent column accesses is provided.

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

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