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

Patent metadata

Field	Value
Publication number	US-11086819-B2
Application number	US-201815959607-A
Country	US
Kind code	B2
Filing date	Apr 23, 2018
Priority date	Apr 23, 2018
Publication date	Aug 10, 2021
Grant date	Aug 10, 2021

Abstract

Disclosed are examples of systems, apparatus, methods and computer program products for deleting data of an object within a multi-tenant database. Described is a mechanism for performing operations such as an efficient delete operation by introducing a new delete operation (or method) that is configured to allow a data structure such as an object to identify one or more records to be deleted. 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, the first request identifying a data structure that specifies values for one or more fields of the first data object, the first organization being a tenant of the multi-tenant database;
obtaining, based on the received first request, one or more characteristics of a first data store storing the first data object in the multi-tenant database;
determining, based on the obtained one or more characteristics, a first performance requirement associated with the first data store for identifying one or more records of the first data object in the first data store using the specified values included in the first request;
identifying the one or more records of the first data object based on a determination that the first performance requirement satisfies one or more rules; and
initiating a delete of the identified one or more records of the first organization by executing a delete operation of the identified one or more records stored in the first data store.

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

3. The system of claim 1 , wherein the obtaining 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 obtained one or more characteristics of the second data store, a second performance requirement associated with using the specified values of the second request to identify one or more records of the second data store;
determining the second performance requirement does not satisfy the one or more rules for efficiently 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 the first performance requirement satisfies the one or more rules is performed on an Application Program Interface layer of an application platform of the multi-tenant database system and the delete operation is performed by the first 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.

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 Representational State Transfer (REST) Application Program interface (API), Simple Object Access Protocol (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, the first request identifying a data structure that specifies values for one or more fields of the first data object, the first organization being a tenant of the multi-tenant database;
obtaining based on the received first request, one or more characteristics of a first data store storing the first data object in the multi-tenant database;
determining, based on the obtained one or more characteristics, a first performance requirement associated with the first data store for identifying one or more records of the first data object in the first data store using the specified values included in the first request;
identifying the one or more records of the first data object based on a determination that the first performance requirement satisfies one or more rules; and
initiating a delete of the identified one or more records of the first organization by executing a delete operation of the identified one or more records stored in the first data store.

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

13. The method of claim 11 , wherein the obtaining 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 obtained one or more characteristics of the second data store, a second performance requirement associated with using the specified values of the second request to identify one or more records of the second data store;
determining the second performance requirement does not satisfy the one or more rules for efficiently 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 the first performance requirement satisfies the one or more rules is performed on an Application Program Interface layer of an application platform of the multi-tenant database system and the delete operation is performed by the first data store and initiated by the application platform.

16. A computer program product comprising a non-transitory computer-readable medium having stored thereon computer-readable program code capable of being executed by one or more processors, 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, the first request identifying a data structure that specifies values for one or more fields of the first data object, the first or orga

Assignees

• Salesforce Com 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/162 Primary

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

• G06F16/2365 Primary

  Ensuring data consistency and integrity · CPC title