公开(公告)号：US12056187B2

公开(公告)日：2024-08-06

申请号：US17669710

申请日：2022-02-11

Applicant: SAP SE

Inventor： Dheren Gala ,  Aditya Gurajada

IPC: G06F16/901 ,  G06F11/14 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2455

CPC classification number: G06F16/901 ,  G06F11/1471 ,  G06F16/2237 ,  G06F16/2255 ,  G06F16/2358 ,  G06F16/2365 ,  G06F16/24552 ,  G06F2201/80

Abstract: Example methods and systems are directed to existence checks on rows within a database. A page data structure stores bitmap data for the rows in the page. A row within the page corresponds to a single bit in the bitmap data. To determine if a row has been deleted, the page data structure for the page containing the row is located and the bit for the row in the page data structure is checked. An array of page data structures is created, indexed by a hash of the page identifier. In the event of a hash collision, a linked list of page data structures is used, sorted by page identifier.

公开(公告)号：US20200349193A1

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

申请号：US16399523

申请日：2019-04-30

Applicant: SAP SE

Inventor： Dheren Gala ,  Aditya Gurajada

IPC: G06F16/901

Abstract: Example methods and systems are directed to existence checks on rows within a database. A page data structure stores bitmap data for the rows in the page. A row within the page corresponds to a single bit in the bitmap data. To determine if a row has been deleted, the page data structure for the page containing the row is located and the bit for the row in the page data structure is checked. An array of page data structures is created, indexed by a hash of the page identifier. In the event of a hash collision, a linked list of page data structures is used, sorted by page identifier.

公开(公告)号：US11423000B2

公开(公告)日：2022-08-23

申请号：US16878894

申请日：2020-05-20

Applicant: SAP SE

Inventor： Nilesh Gohad ,  Adrian Dragusanu ,  Neeraj Kulkarni ,  Dheren Gala

IPC: G06F16/22 ,  G06F9/54 ,  G06F16/2455 ,  G06F12/0882

Abstract: Various embodiments for providing a data transfer and management system are described herein. An embodiment operates by determining that data of a column is stored in a column loadable format in which all of the data of the column is moved from the disk storage location to a memory responsive to a data request. A data vector that identifies a plurality of value IDs corresponding to at least a subset of the plurality of rows of the column, is identified. A page format that provides that a portion of the data of the column across a subset of the plurality of rows is moved from the second disk storage location into the memory responsive to the data request is determined. The entries of the data vector are requested, converted from column loadable format into the page persistent format, and stored across one or more memory pages.

公开(公告)号：US11263047B2

公开(公告)日：2022-03-01

申请号：US15897519

申请日：2018-02-15

Applicant: SAP SE

Inventor： Piyush Dungarwal ,  Dheren Gala ,  Tony Imbierski

IPC: G06F9/50

Abstract: Various examples are directed to systems and methods for managing resources in a multi-core computing system. A first thread executing at a first core of a multi-core processor unit may allocate a first element of a resource. The first thread may increment a first thread counter for a first metric describing the resource. The first thread may determine that the first thread counter is greater than a first thread counter threshold and update a first metric global value based at least in part on the first thread counter. The first thread may also reset the first thread counter.

公开(公告)号：US11775496B2

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

申请号：US17867487

申请日：2022-07-18

Applicant: SAP SE

Inventor： Nilesh Gohad ,  Adrian Dragusanu ,  Neeraj Kulkarni ,  Dheren Gala

IPC: G06F16/22 ,  G06F9/54 ,  G06F16/2455 ,  G06F12/0882

CPC classification number: G06F16/2282 ,  G06F9/54 ,  G06F12/0882 ,  G06F16/221 ,  G06F16/2237 ,  G06F16/24552

Abstract: Various embodiments for providing a data transfer and management system are described herein. An embodiment operates by determining that data of a column is stored in a column loadable format in which all of the data of the column is moved from the disk storage location to a memory responsive to a data request. A data vector that identifies a plurality of value IDs corresponding to at least a subset of the plurality of rows of the column, is identified. A page format that provides that a portion of the data of the column across a subset of the plurality of rows is moved from the second disk storage location into the memory responsive to the data request is determined. The entries of the data vector are requested, converted from column loadable format into the page persistent format, and stored across one or more memory pages.

公开(公告)号：US11281719B2

公开(公告)日：2022-03-22

申请号：US16399523

申请日：2019-04-30

Applicant: SAP SE

Inventor： Dheren Gala ,  Aditya Gurajada

IPC: G06F16/22 ,  G06F16/901 ,  G06F16/23 ,  G06F16/2455 ,  G06F11/14

Abstract: Example methods and systems are directed to existence checks on rows within a database. A page data structure stores bitmap data for the rows in the page. A row within the page corresponds to a single bit in the bitmap data. To determine if a row has been deleted, the page data structure for the page containing the row is located and the bit for the row in the page data structure is checked. An array of page data structures is created, indexed by a hash of the page identifier. In the event of a hash collision, a linked list of page data structures is used, sorted by page identifier.

公开(公告)号：US20190250948A1

公开(公告)日：2019-08-15

申请号：US15897519

申请日：2018-02-15

Applicant: SAP SE

Inventor： Piyush Dungarwal ,  Dheren Gala ,  Tony Imbierski

IPC: G06F9/50

CPC classification number: G06F9/50 ,  G06F9/5016 ,  G06F2209/5011 ,  G06F2209/5018

Abstract: Various examples are directed to systems and methods for managing resources in a multi-core computing system. A first thread executing at a first core of a multi-core processor unit may allocate a first element of a resource. The first thread may increment a first thread counter for a first metric describing the resource. The first thread may determine that the first thread counter is greater than a first thread counter threshold and update a first metric global value based at least in part on the first thread counter. The first thread may also reset the first thread counter.

公开(公告)号：US11886723B2

公开(公告)日：2024-01-30

申请号：US17455749

申请日：2021-11-19

Applicant: SAP SE

Inventor： Prateek Agarwal ,  Paresh Rathod ,  Samar Desai ,  Shrikant Awate ,  Amit Pathak ,  Dheren Gala ,  Mitali Yadav

IPC: G06F3/00 ,  G06F3/06

CPC classification number: G06F3/0632 ,  G06F3/0604 ,  G06F3/067 ,  G06F3/0644

Abstract: According to some embodiments, a system, method and non-transitory, computer readable medium are provided comprising a memory storing processor-executable program code; and a processing unit to cause the system to: receive a range of persistent volume disk size values from a cloud service provider; receive a value for an upper bound of a number of persistent volume disks attachable to a virtual machine per the cloud service; determine a number of persistent volume disks based on the upper bound, wherein the number is at least two; generate a plurality of configurations of the determined number of persistent volume disks, wherein a configuration is provided for each persistent volume disk size value, and each configuration divides the persistent volume disk size value between two or more persistent volume disks; and aggregate the generated plurality of configurations in a decision table. Numerous other aspects are provided.

公开(公告)号：US20220164385A1

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

申请号：US17669710

申请日：2022-02-11

Applicant: SAP SE

Inventor： Dheren Gala ,  Aditya Gurajada

IPC: G06F16/901 ,  G06F16/23 ,  G06F16/2455 ,  G06F16/22 ,  G06F11/14

Abstract: Example methods and systems are directed to existence checks on rows within a database. A page data structure stores bitmap data for the rows in the page. A row within the page corresponds to a single bit in the bitmap data. To determine if a row has been deleted, the page data structure for the page containing the row is located and the bit for the row in the page data structure is checked. An array of page data structures is created, indexed by a hash of the page identifier. In the event of a hash collision, a linked list of page data structures is used, sorted by page identifier.

公开(公告)号：US11256680B2

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

申请号：US16411700

申请日：2019-05-14

Applicant: SAP SE

Inventor： Nilesh Gohad ,  Amit Pathak ,  Dheren Gala

IPC: G06F16/00 ,  G06F16/23 ,  G06F16/22 ,  G06F12/02 ,  G06F16/2455

Abstract: Systems and methods may include execution of a database workload on a plurality of database tables, collection of execution statistics associated with execution of the database workload, determination of an in-memory row storage cache size for multi-version concurrency control based on the collected execution statistics, and configuration of a database system to allocate the in-memory row storage cache size for multi-version concurrency control.