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

公开(公告)号：US11625503B2

公开(公告)日：2023-04-11

申请号：US16918478

申请日：2020-07-01

Applicant: salesforce.com, inc.

Inventor： Mukesh Burgupalli ,  Ravindarreddy Ankireddy ,  Anthony Frank Zucaro, III ,  Abhishek Chaturvedi

IPC: G06F16/21 ,  G06F21/64 ,  G06F21/62

Abstract: Techniques are disclosed relating to ensuring data integrity between database objects. A computer system may receive a data integrity request for a first set of database tables. The computer system may generate at least two work items that correspond to respective data cell groups in the first set of database tables. The computer system may then cause a plurality of processes to perform the at least two work items to generate a first plurality of hash values that includes hash values for the respective data cell groups. The first plurality of hash values may be usable to compare with corresponding ones of a second plurality of hash values generated based on corresponding data cell groups in a second set of database tables replicated from the first set of database tables.

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

公开(公告)号：US20210286824A1

公开(公告)日：2021-09-16

申请号：US16880965

申请日：2020-05-21

Applicant: salesforce.com, inc.

Inventor： Sheng Qiao ,  Zhaohui George Yao ,  Kim S. Lee ,  Abhishek Chaturvedi ,  Jeff Zhu ,  Mukesh Burgupalli

IPC: G06F16/27 ,  G06F16/21 ,  G06F3/06

Abstract: An online system performs upgrades of replicated databases. The online system stores data in a primary site and a secondary site. The primary site comprising databases used to process client requests and a secondary site comprising databases used as standby. The online system upgrades databases of both sites by upgrading the secondary site, switching client requests to the secondary site while using the databases of primary site as standby databases. The online system then upgrades the primary site. The process allows the online system to upgrade databases with small down time.

公开(公告)号：US12050618B2

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

申请号：US16880965

申请日：2020-05-21

Applicant: salesforce.com, inc.

Inventor： Sheng Qiao ,  Zhaohui George Yao ,  Kim S. Lee ,  Abhishek Chaturvedi ,  Jeff Zhu ,  Mukesh Burgupalli

IPC: G06F16/27 ,  G06F3/06 ,  G06F16/21

CPC classification number: G06F16/27 ,  G06F3/0607 ,  G06F3/064 ,  G06F3/065 ,  G06F3/0683 ,  G06F16/21

Abstract: An online system performs upgrades of replicated databases. The online system stores data in a primary site and a secondary site. The primary site comprising databases used to process client requests and a secondary site comprising databases used as standby. The online system upgrades databases of both sites by upgrading the secondary site, switching client requests to the secondary site while using the databases of primary site as standby databases. The online system then upgrades the primary site. The process allows the online system to upgrade databases with small down time.

公开(公告)号：US20220004664A1

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

申请号：US16918478

申请日：2020-07-01

Applicant: salesforce.com, inc.

Inventor： Mukesh Burgupalli ,  Ravindarreddy Ankireddy ,  Anthony Frank Zucaro, III ,  Abhishek Chaturvedi

IPC: G06F21/64 ,  G06F21/62

Abstract: Techniques are disclosed relating to ensuring data integrity between database objects. A computer system may receive a data integrity request for a first set of database tables. The computer system may generate at least two work items that correspond to respective data cell groups in the first set of database tables. The computer system may then cause a plurality of processes to perform the at least two work items to generate a first plurality of hash values that includes hash values for the respective data cell groups. The first plurality of hash values may be usable to compare with corresponding ones of a second plurality of hash values generated based on corresponding data cell groups in a second set of database tables replicated from the first set of database tables.