公开(公告)号：US11593352B2

公开(公告)日：2023-02-28

申请号：US17197693

申请日：2021-03-10

Applicant: SAP SE

Inventor： Mohammed Abouzour ,  Gunes Aluc ,  Ivan Bowman ,  Xi Deng ,  Nandan Marathe ,  Sagar Ranadive ,  Muhammed Sharique ,  John Smirnios

IPC: G06F16/00 ,  G06F16/23 ,  G06F16/28

Abstract: Systems and methods include determination of a first logical page number of a first database page to be persisted, identification of a first blockmap page associated with the first logical page number, determination, from the first blockmap page, of a block number associated with the first logical page number, determination that the block number is an object key, determination, in response to the determination, that the block number is an object key, determination of a first object key to associate with the first logical page number, and writing of the first database page to the object store using the first object key.

公开(公告)号：US20200319941A1

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

申请号：US16415624

申请日：2019-05-17

Applicant: SAP SE

Inventor： Muhammed Sharique

IPC: G06F9/52 ,  G06F9/48

Abstract: A producer-consumer technique includes creating a pool of consumer threads. Producer threads can enqueue work items on a work queue. Consumer threads from the consumer pool are activated to process work items on the work queue. Only one consumer thread at time is activated from the consumer pool, the remaining consumer threads in the pool waiting for an activation event. When signaled by a producer thread, the activated consumer thread pops all the work items from the work queue for processing. The activate consumer thread then signals another consumer thread in the consumer pool by generating an activation event. When the consumer thread has processed its work items, it places itself in the consumer pool by blocking to wait for an activation event.

公开(公告)号：US20180246807A1

公开(公告)日：2018-08-30

申请号：US15584626

申请日：2017-05-02

Applicant: SAP SE

Inventor： Mihnea Andrei ,  Muhammed Sharique ,  Surendra Vishnoi ,  Rolando Blanco

IPC: G06F12/02 ,  G06F17/30 ,  G06F3/06

CPC classification number: G06F3/0649 ,  G06F3/0604 ,  G06F3/0646 ,  G06F3/0679 ,  G06F12/0246 ,  G06F16/00 ,  G06F16/113 ,  G06F16/211 ,  G06F16/27 ,  G06F16/901 ,  G11C11/5628

Abstract: A system includes creation of a first fragment of a first database column in a volatile memory system, reception of a first pointer to a first block of a second non-volatile memory system, the first block associated with the first fragment of the first database column, population of the first block of the second non-volatile memory system using the first pointer, while blocking creation of a database savepoint, commitment of the first block of the second non-volatile memory and association of a first block identifier of the first block of the second non-volatile memory with the first fragment of the first database column, and unblocking creation of the database savepoint.

公开(公告)号：US11379485B2

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

申请号：US17114823

申请日：2020-12-08

Applicant: SAP SE

Inventor： Muhammed Sharique

IPC: G06F16/2455 ,  G06F16/2453 ,  G06F16/215 ,  G06F16/22

Abstract: A system includes reception of a query comprising a join operation on a first table and a second table and a join condition associated with the join operation, determination of a first table column of the first table and a second table column of the second table associated with the join condition, determination of an inferred predicate of the query, the inferred predicate associated with a first column dictionary of the first table column and a second column dictionary of the second table column, determination of a cost of using the inferred predicate to perform the join operation, determination of a plurality of query execution plans to execute the join operation using the inferred predicate, and determination of a cost of each of the plurality of query execution plans based on the cost of using the inferred predicate to perform the join operation.

公开(公告)号：US20220179854A1

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

申请号：US17114823

申请日：2020-12-08

Applicant: SAP SE

Inventor： Muhammed Sharique

IPC: G06F16/2455 ,  G06F16/2453 ,  G06F16/22 ,  G06F16/215

Abstract: A system includes reception of a query comprising a join operation on a first table and a second table and a join condition associated with the join operation, determination of a first table column of the first table and a second table column of the second table associated with the join condition, determination of an inferred predicate of the query, the inferred predicate associated with a first column dictionary of the first table column and a second column dictionary of the second table column, determination of a cost of using the inferred predicate to perform the join operation, determination of a plurality of query execution plans to execute the join operation using the inferred predicate, and determination of a cost of each of the plurality of query execution plans based on the cost of using the inferred predicate to perform the join operation.

公开(公告)号：US11086691B2

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

申请号：US16415624

申请日：2019-05-17

Applicant: SAP SE

Inventor： Muhammed Sharique

IPC: G06F9/46 ,  G06F9/52 ,  G06F9/48

Abstract: A producer-consumer technique includes creating a pool of consumer threads. Producer threads can enqueue work items on a work queue. Consumer threads from the consumer pool are activated to process work items on the work queue. Only one consumer thread at time is activated from the consumer pool, the remaining consumer threads in the pool waiting for an activation event. When signaled by a producer thread, the activated consumer thread pops all the work items from the work queue for processing. The activate consumer thread then signals another consumer thread in the consumer pool by generating an activation event. When the consumer thread has processed its work items, it places itself in the consumer pool by blocking to wait for an activation event.