Truncating data associated with objects in a multi-tenant database

• US 9,069,788 B2
• Filed: 11/01/2011
• Issued: 06/30/2015
• Est. Priority Date: 07/01/2011
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Dutta, Arup, Wong, Simon, Soble, Dan, Black, Nathanael, Macklem, Walter
• Primary Examiner(s): Lee, Wilson
• Application Number:
  US13/287,022
• Publication Number:
  US 20130007062A1
• Time in Patent Office: 1,337 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/162 Delete operations erasing in storage systems G06F3/0652
• CPC Class Codes: G06F 16/176 Support for shared access to files; File sharing support
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: G06F 16/907 Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually

Abstract

An embodiment of a multi-tenant database system includes a multi-tenant database, an entity definition table, and a data processing engine. The database has objects for multiple tenants, including an existing object for a designated tenant. Each entry in the existing object has a respective entity identifier. The definition table has entries for the database objects, including a metadata entry for the existing object. This metadata entry has a tenant identifier for the designated tenant, an entity name for the existing object, and an old key prefix for the existing object. Each entity identifier of the existing object begins with the old key prefix. The engine performs a data truncation operation on the existing object by updating the metadata entry to replace the old key prefix with a new key prefix. This results in an updated object that is identified by the new key prefix and the tenant identifier.

Claims

1. A computer-implemented method of removing stored data associated with a database object, the method comprising:

assigning a new and previously unused key prefix to an existing database object to disassociate stored data from an old key prefix, resulting in an empty database object that is void of data;

updating a graphical representation of a table to reflect the empty database object; and

presenting the graphical representation of the table to a user, wherein;

each entry in the existing database object is uniquely associated with a respective custom entity identifier that begins with the old key prefix; and

each entry in the updated database object is uniquely associated with a respective custom entity identifier that begins with the new and previously unused key prefix.

2. The computer-implemented method of claim 1, further comprising:

creating a soft deleted database object that includes the stored data associated with the old key prefix; and

maintaining the soft deleted database object for a time period after assigning the new and previously unused key prefix to the existing database object.

3. The computer-implemented method of claim 2, further comprising deleting the stored data associated with the old key prefix after the time period ends.

4. The computer-implemented method of claim 2, further comprising deleting the soft deleted database object after the time period ends.

5. The computer-implemented method of claim 1, further comprising repopulating the updated database object with new data.

10. The computer-implemented method of claim 1, further comprising:

prior to assigning the new and previously unused key prefix, scanning the key prefixes of the stored data; and

in response to the scanning, determining a candidate key prefix to be used as the new and previously unused key prefix.

6. A computer-implemented method of removing stored data associated with a database object, the method comprising:

assigning a new and previously unused key prefix to an existing database object to disassociate stored data from an old key prefix, resulting in an empty database object that is void of data;

updating a graphical representation of a table to reflect the empty database object and

presenting the graphical representation of the table to a user, wherein;

the existing database object includes a first entry that is linked to a foreign key maintained in a second entry of a target database object, the foreign key stored in a field identified by a first column number; and

the method further comprises altering metadata for the second entry of the target database object by replacing the first column number with a new and previously unused column number, in response to assigning the new and previously unused key prefix to the existing database object.

11. The computer-implemented method of claim 6, further comprising:

creating a soft deleted database object that includes the stored data associated with the old key prefix; and

maintaining the soft deleted database object for a time period after assigning the new and previously unused key prefix to the existing database object.

15. The computer-implemented method of claim 6, further comprising:

prior to assigning the new and previously unused key prefix, scanning the key prefixes of the stored data; and

in response to the scanning, determining a candidate key prefix to be used as the new and previously unused key prefix.

7. A computer-implemented method of removing stored data associated with a database object, the method comprising:

assigning a new and previously unused key prefix to an existing database object to disassociate stored data from an old key prefix, resulting in an empty database object that is void of data;

updating a graphical representation of a table to reflect the empty database object; and

presenting the graphical representation of the table to a user, wherein;

the existing database object includes a first entry that is linked to a foreign key maintained in a second entry of a target database object; and

the method further comprises removing the second entry of the target database object, in response to assigning the new and previously unused key prefix to the existing database object.

12. The computer-implemented method of claim 7, further comprising:

creating a soft deleted database object that includes the stored data associated with the old key prefix; and

maintaining the soft deleted database object for a time period after assigning the new and previously unused key prefix to the existing database object.

16. The computer-implemented method of claim 7, further comprising:

prior to assigning the new and previously unused key prefix, scanning the key prefixes of the stored data; and

in response to the scanning, determining a candidate key prefix to be used as the new and previously unused key prefix.

8. A computer-implemented method of removing stored data associated with a database object, the method comprising:

assigning a new and previously unused key prefix to an existing database object to disassociate stored data from an old key prefix, resulting in an empty database object that is void of data;

updating a graphical representation of a table to reflect the empty database object; and

presenting the graphical representation of the table to a user, wherein;

the existing database object includes a first entry that is linked to a summary field value maintained in a second entry of a target database object; and

the method further comprises updating the summary field value in response to assigning the new and previously unused key prefix to the existing database object.

13. The computer-implemented method of claim 8, further comprising:

creating a soft deleted database object that includes the stored data associated with the old key prefix; and

maintaining the soft deleted database object for a time period after assigning the new and previously unused key prefix to the existing database object.

17. The computer-implemented method of claim 8, further comprising:

prior to assigning the new and previously unused key prefix, scanning the key prefixes of the stored data; and

in response to the scanning, determining a candidate key prefix to be used as the new and previously unused key prefix.

19. The computer-implemented method of claim 8, further comprising repopulating the updated database object with new data.

9. A computer-implemented method of removing stored data associated with a database object, the method comprising:

maintaining a custom entity definition table having a metadata entry corresponding to an existing database object;

assigning a new and previously unused key prefix to the existing database object to disassociate stored data from an old key prefix, resulting in an empty database object that is void of data;

updating a graphical representation of a table to reflect the empty database object; and

presenting the graphical representation of the table to a user, wherein;

the metadata entry includes the old key prefix in a key prefix field; and

assigning the new and previously unused key prefix comprises updating the metadata entry to include the new and previously unused key prefix in the key prefix field, to obtain an updated metadata entry that corresponds to the updated database object.

14. The computer-implemented method of claim 9, further comprising:

creating a soft deleted database object that includes the stored data associated with the old key prefix; and

maintaining the soft deleted database object for a time period after assigning the new and previously unused key prefix to the existing database object.

18. The computer-implemented method of claim 9, further comprising:

prior to assigning the new and previously unused key prefix, scanning the key prefixes of the stored data; and

in response to the scanning, determining a candidate key prefix to be used as the new and previously unused key prefix.

20. The computer-implemented method of claim 9, further comprising repopulating the updated database object with new data.