Change-protected database system

Patent metadata

Field	Value
Publication number	US-11334539-B2
Application number	US-201916526334-A
Country	US
Kind code	B2
Filing date	Jul 30, 2019
Priority date	Jul 30, 2019
Publication date	May 17, 2022
Grant date	May 17, 2022

Abstract

A plurality of database access requests are received at a database system within a designated database access scope. The plurality of database access requests may include a first request to read from a first database table and a second request to write to a second database table. The second request may occur during or after the receipt of the first request. A database access dependency rule linking the first database table and the second database table may be created. The database access dependency rule may impose a protected database access framework when executing a subsequent write request to the second database table when the first database table is updated. The protected database access framework may store one or more values associated with the subsequent write request in a staging table that are capable of being used to undo the subsequent write request.

First claim

The invention claimed is:

1. A method comprising:
receiving a plurality of database access requests at a database system within a designated database access scope, the plurality of database access requests including a first request to read from a first database table and a second request to write to a second database table, the second request occurring during or after the receipt of the first request;
creating a database access dependency rule linking the first database table and the second database table, the database access dependency rule imposing a protected database access framework when executing a subsequent write request to the second database table when the first database table is updated, the protected database access framework storing one or more values associated with the subsequent write request in a staging table, the staging table values capable of being used to undo the subsequent write request, wherein executing the subsequent write request comprises receiving a third request to update an original data value in a first row in the second database table, writing an updated data value corresponding with the original data value to a second row in the staging table, and replacing the original data value in the second database table with a corresponding replacement value determined based on a value replacement update function that takes as input the updated data value, the first and second rows each including the database table key;
receiving a second request to reverse the update to the second database table;
determining a restored data value for the first row by applying a value replacement restore function; and
replacing the updated data value in the database table with the restored data value.

2. The method recited in claim 1 , wherein the database access scope is defined as a database transaction that includes one or more database scripts.

3. The method recited in claim 1 , wherein the database access scope is defined as a database transaction that includes one or more application procedure interface (API) calls.

4. The method recited in claim 1 , wherein the database access scope is defined as a period of time.

5. The method recited in claim 1 , wherein the staging table is implemented as a temporal database that stores values associated with a succession of changes to the second database table.

6. The method recited in claim 1 , wherein the database system includes a data definition repository, the data definition repository storing the database access dependency rule, the data definition repository also storing a table definition for the staging table.

7. The method recited in claim 1 , wherein the value replacement restore function is an inverse of the value replacement update function.

8. The method recited in claim 1 , wherein the first and second database tables are configured as multitenant database tables.

9. A database system including memory and one or more processors, the database system configured to perform a method comprising:
receiving a plurality of database access requests at a database system within a designated database access scope, the plurality of database access requests including a first request to read from a first database table and a second request to write to a second database table the second request occurring during or after the receipt of the first request;
creating a database access dependency rule linking the first database table and the second database table, the database access dependency rule imposing a protected database access framework when executing a subsequent write request to the second database table when the first database table is updated, the protected database access framework storing one or more values associated with the subsequent write request in a staging table, the staging table values capable of being used to undo the subsequent write request, wherein executing the subsequent write request comprises receiving a third request to update an original data value in a first row in the second database table, writing an updated data value corresponding with the original data value to a second row in the staging table, and replacing the original data value in the second database table with a corresponding replacement value determined based on a value replacement update function that takes as input the updated data value, the first and second rows each including the database table key;
receiving a second request to reverse the update to the second database table;
determining a restored data value for the first row by applying a value replacement restore function; and
replacing the updated data value in the database table with the restored data value.

10. The database system recited in claim 9 , wherein the database access scope is defined as a database transaction that includes one or more database scripts.

11. The database system recited in claim 9 , wherein the database access scope is defined as a database transaction that includes one or more application procedure interface (API) calls.

12. The database system recited in claim 9 , wherein the database access scope is defined as a period of time.

13. The database system recited in claim 9 , wherein the staging table is implemented as a temporal database that stores values associated with a succession of changes to the second database table.

14. The database system recited in claim 9 , wherein the database system includes a data definition repository, the data definition repository storing the database access dependency rule, the data definition repository also storing a table definition for the staging table.

15. One or more non-transitory computer readable media having instructions stored thereon for performing a method, the method comprising:
receiving a plurality of database access requests at a database system within a designated database access scope, the plurality of database access requests including a first request to read from a first database table and a second request to write to a second database table the second request occurring during or after the receipt of the first request;
creating a database access dependency rule linking the first database table and the second database table the database access dependency rule imposing a protected database access framework when executing a subsequent write request to the second database table when the first database table is updated, the protected database access framework storing one or more values associated with the subsequent write request in a staging table, the staging table values capable of being used to undo the subsequent write request, wherein executing the subsequent write request comprises receiving a third request to update an original data value in a first row in the second database table, writing an updated data value corresponding with the original data value to a second row in the staging table, and replacing the original data value in the second database table with a corresponding replacement value determined based on a value replacement update function that takes as input the updated data value, the first and second rows each including the database table key;
receiving a second request to reverse the update to the second database table;
determining a restored data value for the first ow by applying a value replacement restore function; and
replacing the updated data value in the database table with the restored data value.

Assignees

• Salesforce Com Inc

Inventors

• Mathur Rohitashva

Classifications

• G06F11/1435

  using file system or storage system metadata · CPC title

• G06F16/219 Primary

  Managing data history or versioning (querying versioned data G06F16/2474; querying temporal data G06F16/2477) · CPC title

• G06F16/2358 Primary

  Change logging, detection, and notification (replication G06F16/27) · CPC title

• G06F16/2365

  Ensuring data consistency and integrity · CPC title

• G06F16/2282

  Tablespace storage structures; Management thereof · CPC title