Branch-based recovery in a database system
Assigneesalesforce.com, inc.
InventorsMikhail Chainani, Xiaodan Wang, Vijayanth Devadhar
Life of this patent
Estimating the term…
Abstract
A staging table created in a database system may store a snapshot of live database table captured prior to an unintended change to the live database table. One or more entries in the staging table may be updated to incorporate one or more intended changes to the live database table that occurred after the unintended change. The live database table may be updated by merging each of the updated entries from the staging table to the live database table. The updated database table may eliminate the unintended change.
Claims20
A computer-implemented method implemented in a database system, the method comprising:
- creating a staging table in the database system, the staging table storing a snapshot of a live database table, the snapshot of the live database table being captured prior to an unintended change to the live database table;
- updating one or more entries in the staging table, the updated entries incorporating one or more intended changes to the live database table that occurred after the unintended change;
- and
- updating the live database table by merging each of the updated entries from the staging table to the live database table, the updated database table eliminating the unintended change.
A database system implemented on a computer system, the computer system configured to perform a method comprising:
- creating a staging table in the database system, the staging table storing a snapshot of a live database table, the snapshot of the live database table being captured prior to an unintended change to the live database table;
- updating one or more entries in the staging table, the updated entries incorporating one or more intended changes to the live database table that occurred after the unintended change;
- and
- updating the live database table by merging each of the updated entries from the staging table to the live database table, the updated database table eliminating the unintended change.
One or more non-transitory computer readable media having instructions stored thereon for performing a method in a database system, the method comprising:
- creating a staging table in the database system, the staging table storing a snapshot of a live database table, the snapshot of the live database table being captured prior to an unintended change to the live database table;
- updating one or more entries in the staging table, the updated entries incorporating one or more intended changes to the live database table that occurred after the unintended change;
- and
- updating the live database table by merging each of the updated entries from the staging table to the live database table, the updated database table eliminating the unintended change.
Dependencies are inferred from the claim text.