Run-time querying of multi-tenant non-relational platform objects

Patent metadata

Field	Value
Publication number	US-11714811-B2
Application number	US-201715717772-A
Country	US
Kind code	B2
Filing date	Sep 27, 2017
Priority date	Sep 27, 2017
Publication date	Aug 1, 2023
Grant date	Aug 1, 2023

Abstract

Disclosed are examples of systems, apparatus, methods and computer program products for providing run-time querying of multi-tenant non-relational database objects. A database system maintains a multi-tenant non-relational database associated with a number of enterprises, a number of records, and a number of data objects for each of the enterprises, each data object having at least one composite key field. A request is received during runtime to query data related to a data object, and the system determines that the data object is defined to be used in associated with a non-relational database. The system then retrieves a metadata model of the data object, determines that the request includes at least one composite key field for the data object, and processes the requery to query data in synchronous fashion. Finally, a query response is provided to the user.

First claim

What is claimed is:

1. A system comprising:
A database system implemented using a server system implemented with a processor and a memory, the database system configured to cause:
accessing a multi-tenant non-relational database associated with a plurality of enterprises, the multi-tenant non-relational database storing data objects for each enterprise;
processing, during runtime of the database system, a request from a computing device of a user of the database system to query data related to a first one of the data objects, the processing of the request to query data being synchronous with one or more further requests to query data, the processing comprising:
determining that the first data object is defined to be used in association with a non-relational database,
retrieving a metadata model of the first data object, the metadata model comprising a plurality of fields of the first data object, the metadata model having been generated using a first script designating a plurality of enterprise-selected composite key fields as a composite primary key of the first data object and designating one or more attributes of the first data object, the enterprise-selected composite key fields being a subset of a plurality of enterprise-configurable custom fields,
processing a second script having been generated using the metadata model to define one or more database data sets corresponding to the enterprise-selected composite key fields, the second script being a data definition script implemented as a data dictionary, the data definition script configured to define the first data object and the one or more attributes of the first data object as database structures in a data description language associated with the multi-tenant non-relational database,
determining, responsive to retrieving the metadata model, that the request to query data includes a filter condition having the composite primary key, and
determining, using the metadata model, that the request to query data includes at least one composite key field of the first data object; and

providing a query response to the computing device, the query response being based on application of the filter condition with respect to the first data object.

2. The system of claim 1 , wherein the at least one composite key field of the first data object is defined by an entity associated with the user and the first data object.

3. The system of claim 1 , wherein processing the request and providing the query response are completed within one continuous user session associated with the user.

4. The system of claim 1 , the database system further configurable to cause:
determining that the user is associated with one or more permissions to access the first data object.

5. The system of claim 1 , wherein filter criteria specify the at least one composite key field of the first data object.

6. The system of claim 1 , wherein the at least one composite key field of the first data object is associated with the composite primary key and a composite secondary key.

7. A method comprising:
accessing a multi-tenant non-relational database associated with a plurality of enterprises, the multi-tenant non-relational database storing data objects for each enterprise;
processing, during runtime of a database system, a request from a computing device of a user of the database system to query data related to a first one of the data objects, the processing of the request to query data being synchronous with one or more further requests to query data, the processing comprising:
determining that the first data object is defined to be used in association with a non-relational database,
retrieving a metadata model of the first data object, the metadata model comprising a plurality of fields of the first data object, the metadata model having been generated using a first script designating a plurality of enterprise-selected composite key fields as a composite primary key of the first data object and designating one or more attributes of the first data object, the enterprise-selected composite key fields being a subset of a plurality of enterprise-configurable custom fields,
processing a second script having been generated using the metadata model to define one or more database data sets corresponding to the enterprise-selected composite key fields, the second script being a data definition script implemented as a data dictionary, the data definition script configured to define the first data object and the one or more attributes of the first data object as database structures in a data description language associated with the multi-tenant non-relational database,
determining, responsive to retrieving the metadata model, that the request to query data includes a filter condition having the composite primary key, and
determining, using the metadata model, that the request to query data includes at least one composite key field of the first data object; and

providing a query response to the computing device, the query response being based on application of the filter condition with respect to the first data object.

8. The method of claim 7 , wherein the at least one composite key field of the first data object is defined by an entity associated with the user and the first data object.

9. The method of claim 7 , wherein processing the request and providing the query response are completed within one continuous user session associated with the user.

10. The method of claim 7 , further comprising:
determining that the user is associated with one or more permissions to access the first data object.

11. The method of claim 7 , wherein filter criteria specify the at least one composite key field of the first data object.

12. The method of claim 7 , wherein the at least one composite key field of the first data object is associated with the composite primary key and a composite secondary key.

13. A computer program product comprising a non-transitory computer-readable medium storing computer-readable program code that, when executed by one or more processors, is configured to cause:
accessing a multi-tenant non-relational database associated with a plurality of enterprises, the multi-tenant non-relational database storing data objects for each enterprise;
processing, during runtime of a database system, a request from a computing device of a user of the database system to query data related to a first one of the data objects, the processing of the request to query data being synchronous with one or more further requests to query data, the processing comprising:
determining that the first data object is defined to be used in association with a non-relational database,
retrieving a metadata model of the first data object, the metadata model comprising a plurality of fields of the first data object, the metadata model having been generated using a first script designating a plurality of enterprise-selected composite key fields as a composite primary key of the first data object and designating one or more attributes of the first data object, the enterprise-selected composite key fields being a subset of a plurality of enterprise-configurable custom fields,
processing a second script having been generated using the metadata model to define one or more database data sets corresponding to the enterprise-selected composite key fields, the second script being a data definition script implemented as a data dictionary, the data definition script configured to define the first data object and the one or more attributes of the first data object as database structures in a data description language associated with the multi-tenant non-relational datab

Assignees

• Salesforce Com Inc
• Salesforce Inc

Inventors

• Levine Eli
• Jain Samarpan
• Ferguson James
• Fernando Jan Asita

Classifications

• G06F16/24549 Primary

  Run-time optimisation · CPC title

• G06F16/24568

  Data stream processing; Continuous queries · CPC title

• G06F16/28

  Databases characterised by their database models, e.g. relational or object models · CPC title

• G06F21/6218

  to a system of files or objects, e.g. local or distributed file system or database · CPC title

• G06F21/6227

  where protection concerns the structure of data, e.g. records, types, queries · CPC title