Efficiently deleting data from objects in a multi-tenant database system

Patent metadata

Field	Value
Publication number	US-11520740-B2
Application number	US-202017133029-A
Country	US
Kind code	B2
Filing date	Dec 23, 2020
Priority date	Jan 31, 2018
Publication date	Dec 6, 2022
Grant date	Dec 6, 2022

Abstract

Systems, apparatus, methods and computer program products for deleting data of an object within a multi-tenant database via an efficient delete operation are described herein. The new delete operation (or method) may be configured to identify one or more records to be deleted within a data structure such as an object. In order to ensure that the operation is efficient, the mechanism may determine characteristics of a data store and determine whether the information provided within the data structure provides an efficient identification of the data to be deleted. Upon a successful validation, an initial delete request may be translated to an appropriate delete operation for the underlying database.

First claim

What is claimed is:

1. A system comprising:
one or more processors; and
a non-transitory computer readable medium storing a plurality of instructions, which when executed, cause the one or more processors to perform operations comprising:
receiving a first request to delete data related to a first data object of a plurality of data objects associated with a first organization in a multi-tenant database system, wherein the first request identifies a data structure that specifies values for one or more fields of the first data object, and the first object is not identified by the one or more fields;
obtaining one or more characteristics of a first data store storing the first data object;
determining, based on the one or more characteristics, a performance requirement associated with using the specified values to identify one or more records of the first data store;
responsive to determining that the performance requirement satisfies one or more rules, identifying one or more records of the first data object; and
initiating a delete of the identified one or more records of the first organization by executing a delete operation for the first data store.

2. The system of claim 1 , wherein the obtaining of the one or more characteristics comprises obtaining one or more attributes associated with the first data store, and the performance requirement comprises a query time.

3. The system of claim 1 , wherein the obtaining of the one or more characteristics comprises obtaining one or more runtime characteristics of the first data store storing the first data object.

4. The system of claim 1 , the operations further comprising:
receiving a second request to delete data related to a second data object of a plurality of data objects associated with a second organization in the multi-tenant database system, the second request identifying a data structure that specifies values for one or more fields of the second data object;
obtaining one or more characteristics of a second data store storing the second data object;
determining, based on the one or more characteristics of the second data store, a performance requirement associated with using the specified values to identify one or more records of the second data store;
determining that the performance requirement does not satisfy one or more rules for identifying one or more records of the second data object; and
providing an indication that the specified values of the second request do not satisfy the one or more rules for deleting the data related to the second data object.

5. The system of claim 1 , wherein the determining of the performance requirement satisfies the one or more rules is performed on an API layer of an application platform of the multi-tenant database system and the delete operation is performed by the data store and initiated by the application platform.

6. The system of claim 1 , wherein the specified values for the one or more fields correspond to at least a portion of a composite primary key defined for the first data object.

7. The system of claim 1 , the operations further comprising:
translating the first request to the delete operation for the first data store, the delete operation using the specified values to identify one or more records of the first organization to be deleted.

8. The system of claim 1 , the operations further comprising:
validating, using one or more permissions associated with the first data object, that the first organization is authorized to access the first data object.

9. The system of claim 1 , wherein the delete operation is invoked from an application platform of the multi-tenant database system and the data structure comprises an object passed as an argument to the delete operation.

10. The system of claim 1 , wherein the first request is received via a REST API, SOAP API, or an application platform specific programming language.

11. A method comprising:
receiving a first request to delete data related to a first data object of a plurality of data objects associated with a first organization in a multi-tenant database system, wherein the first request identifies a data structure that specifies values for one or more fields of the first data object, and the first object is not identified by the one or more fields;
obtaining one or more characteristics of a first data store storing the first data object;
determining, based on the one or more characteristics, a performance requirement associated with using the specified values to identify one or more records of the first data store;
responsive to determining that the performance requirement satisfies one or more rules, identifying one or more records of the first data object; and
initiating a delete of the identified one or more records of the first organization by executing a delete operation for the first data store.

12. The method of claim 11 , wherein the obtaining of the one or more characteristics comprises obtaining one or more attributes associated with the first data store, and the performance requirement comprises a query time.

13. The method of claim 11 , wherein the obtaining of the one or more characteristics comprises obtaining one or more runtime characteristics of the first data store storing the first data object.

14. The method of claim 11 , further comprising:
receiving a second request to delete data related to a second data object of a plurality of data objects associated with a second organization in the multi-tenant database system, the second request identifying a data structure that specifies values for one or more fields of the second data object; obtaining one or more characteristics of a second data store storing the second data object;
determining, based on the one or more characteristics of the second data store, one or more performance requirement associated with using the specified values to identify one or more records of the second data store;
determining that the one or more performance requirement do not satisfy one or more rules for identifying one or more records of the second data object; and
providing an indication that the specified values of the second request do not satisfy the one or more rules for deleting the data related to the second data object.

15. The method of claim 11 , wherein the determining of the performance requirement satisfies the one or more rules is performed on an API layer of an application platform of the multi-tenant database system and the delete operation is performed by the data store and initiated by the application platform.

16. A computer program product comprising computer-readable program code capable of being executed by one or more processors when retrieved from a non-transitory computer-readable medium, the program code including instructions to:
receive a first request to delete data related to a first data object of a plurality of data objects associated with a first organization in a multi-tenant database system, wherein the first request identifies a data structure that specifies values for one or more fields of the first data object, and the first object is not identified by the one or more fields;
obtain one or more characteristics of a first data store storing the first data object;
determine, based on the one or more characteristics, a performance requirement associated with using the specified values to identify one or more records of the first data store;
responsive to determining that the performance requirement satisfies one or more rules, identify one or more records of the first data object; and
initiate a delete of the identified one o

Assignees

• Salesforce Com Inc
• Salesforce Inc

Inventors

• Fernando Jan Asita
• Marcel Cody
• Ramrakhyani Sahil
• Jain Samarpan
• Esserlieu Brian
• Ferguson James
• Perumala Saikiran
• Fineman Charles
• Hurst Jay
• Kalvala Seshank

Classifications

• G06F16/2365 Primary

  Ensuring data consistency and integrity · CPC title

• G06F16/162 Primary

  Delete operations (erasing in storage systems G06F3/0652) · CPC title