公开(公告)号：US20220019563A1

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

申请号：US17446592

申请日：2021-08-31

Applicant: salesforce.com, inc.

Inventor： Kamalakkannan Guru Devan ,  Mukesh Burgupalli ,  JithendraNadh Kottapalli

IPC: G06F16/21 ,  G06F16/22 ,  G06F16/2457 ,  G06F16/27 ,  G06F16/17

Abstract: A system and method are provided for logically copying data from a source database to a first target database and a second target database. Based on table partition information, the source database is queried to collect partition metadata information for a first set of partitions and a second set of partitions. A first set of the partition metadata information for the first set of partitions and a second set of the partition metadata information for the second set of partitions can be used to create at least one extent chunk for each partition of a table. The source database can be queried, based on a first set of extent chunks and a second set of extent chunks, for a first set of data to be written to the first target database and a second set of data from the source database to be written to the second target database.

公开(公告)号：US11194774B1

公开(公告)日：2021-12-07

申请号：US16947136

申请日：2020-07-20

Applicant: salesforce.com, Inc.

Inventor： Kamalakkannan Guru Devan ,  Mukesh Burgupalli ,  JithendraNadh Kottapalli

IPC: G06F16/00 ,  G06F16/21 ,  G06F16/27 ,  G06F16/17 ,  G06F16/2457 ,  G06F16/22

Abstract: A system and method are provided for logically copying data from a source database to a first target database and a second target database. Based on table partition information, the source database is queried to collect partition metadata information for a first set of partitions and a second set of partitions. A first set of the partition metadata information for the first set of partitions and a second set of the partition metadata information for the second set of partitions can be used to create at least one extent chunk for each partition of a table. The source database can be queried, based on a first set of extent chunks and a second set of extent chunks, for a first set of data to be written to the first target database and a second set of data from the source database to be written to the second target database.

公开(公告)号：US11657027B2

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

申请号：US17446592

申请日：2021-08-31

Applicant: salesforce.com, inc.

Inventor： Kamalakkannan Guru Devan ,  Mukesh Burgupalli ,  JithendraNadh Kottapalli

IPC: G06F16/00 ,  G06F16/21 ,  G06F16/27 ,  G06F16/17 ,  G06F16/2457 ,  G06F16/22

CPC classification number: G06F16/214 ,  G06F16/1734 ,  G06F16/2282 ,  G06F16/24573 ,  G06F16/278

Abstract: A system and method are provided for logically copying data from a source database to a first target database and a second target database. Based on table partition information, the source database is queried to collect partition metadata information for a first set of partitions and a second set of partitions. A first set of the partition metadata information for the first set of partitions and a second set of the partition metadata information for the second set of partitions can be used to create at least one extent chunk for each partition of a table. The source database can be queried, based on a first set of extent chunks and a second set of extent chunks, for a first set of data to be written to the first target database and a second set of data from the source database to be written to the second target database.