公开(公告)号：US12282475B2

公开(公告)日：2025-04-22

申请号：US17527559

申请日：2021-11-16

Applicant: salesforce.com, inc.

Inventor： Karthik Mohan Subramanian ,  Varun Mohta ,  Ted Liu ,  Yeshwant Sai Madanagopal ,  Jeffrey Zoch ,  Bo Xia

IPC: G06F16/23 ,  G06F16/2453

Abstract: Systems, devices, and techniques are disclosed for multi-threaded dynamic queries on an unpartitioned database. An instruction to perform a database operation on rows of a database may be received. Processing threads may be generated by generating three random numbers. A starting point of a processing thread may be set to a first random number, an offset may be set to a second random number, and an order may be based on a third random number. The processing threads may each generate a dynamic query. A dynamic query generated by a processing thread may include an instruction to perform the database operation on rows of the database based on the offset, starting point, and order for the processing thread. Each dynamic query may be run against the database to perform the database operation.

公开(公告)号：US20230153293A1

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

申请号：US17527559

申请日：2021-11-16

Applicant: salesforce.com, inc.

Inventor： Karthik Mohan Subramanian ,  Varun Mohta ,  Ted Liu ,  Yeshwant Sai Madanagopal ,  Jeffrey Zoch ,  Bo Xia

IPC: G06F16/23 ,  G06F16/2455 ,  G06F7/58 ,  G06F16/2453

CPC classification number: G06F16/2379 ,  G06F16/24564 ,  G06F7/58 ,  G06F16/24532

Abstract: Systems, devices, and techniques are disclosed for multi-threaded dynamic queries on an unpartitioned database. An instruction to perform a database operation on rows of a database may be received. Processing threads may be generated by generating three random numbers. A starting point of a processing thread may be set to a first random number, an offset may be set to a second random number, and an order may be based on a third random number. The processing threads may each generate a dynamic query. A dynamic query generated by a processing thread may include an instruction to perform the database operation on rows of the database based on the offset, starting point, and order for the processing thread. Each dynamic query may be run against the database to perform the database operation.