Facilitating dynamically controlled fetching of data at client computing devices in an on-demand services environment

• US 9,396,231 B2
• Filed: 06/20/2013
• Issued: 07/19/2016
• Est. Priority Date: 09/04/2012
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: White, Seth John
• Primary Examiner(s): Badawi, Sherief
• Assistant Examiner(s): Raab, Christopher J
• Application Number:
  US13/923,230
• Publication Number:
  US 20140067859A1
• Time in Patent Office: 1,125 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/2453 Query optimisation
• CPC Class Codes: G06F 16/24553 of query operations
• CPC Class Codes: G06F 16/24564 Applying rules; Deductive queries
• CPC Class Codes: G06F 16/24575 using context
• CPC Class Codes: G06F 16/24578 using ranking
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/28 Databases characterised by their database models, e.g. relational or object models

Abstract

In accordance with embodiments, there are provided mechanisms and methods for facilitating dynamically controlled fetching of data at client computing devices in an on-demand services environment in a multi-tenant environment according to one embodiment. In one embodiment and by way of example, a method includes receiving, at a server computing device, a request from a client computing device. The request includes a query for receiving data from a database coupled to the server computing device in an on-demand database system. The method may further include matching the request against a predetermine threshold value, and where the threshold value includes a first predetermined threshold range based on a first column range or a first row range and a second predetermined threshold range based on a second column range or a second row range. The method may further include generating multiple responses to the request based on one or more formulae and the predetermined threshold value if the request fails to satisfy the predetermined threshold value.

Claims

1. A database system-implemented method comprising:

receiving, by the database system, a request from a computing device that is communicatively part of a cloud network, wherein the request includes a query for receiving data from the database system, wherein the request is placed by a user having access to the computing device and representing a tenant in a multi-tenant environment; and

evaluating, by the database system, in runtime, the request to determine whether the request satisfies a predetermine threshold value, wherein the threshold value defines a permitted range of columns and a permitted range of rows based on a query policy associated with the tenant,

wherein if the request satisfies the predetermined threshold value, returning, by the database system, a response based on the predetermined threshold value, wherein the response is returned to the computing device,

wherein if the request fails to satisfy the predetermined threshold value, returning, by the database system, an adjusted response to the computing device, wherein the adjusted response is generated based on one or more adjustments made, in runtime, to at least one of the permitted range of columns and the permitted range of rows, wherein the one or more adjustments are calculated such that a net adjustment to the permitted ranges of columns and rows remains in compliance with the query policy, and

wherein the one or more adjustments are calculated using one or more formulae provided for adjusting the threshold value while remaining in compliance with at least one of the query policy and user expectations such that by at least one of limiting a number of the permitted range of columns or the permitted range of rows while avoiding a heap limit, wherein the permitted ranges of columns and rows include minimum and maximum integer values.

2. The method of claim 1, wherein the one or more formulae further consider the user expectations regarding the response or the adjusted response based on the query policy, wherein the user expectations include at least one of expecting a minimum amount of information to be returned in the response or the adjusted response, a minimum number or a maximum number of the permitted range of columns to be returned, a minimum number or a maximum number of the permitted rows to be returned.

3. The method of claim 2, wherein the one or more formulae further consider technological limitations comprising one or more of the heap limit, system bandwidth, power limitations, speed or performance limitations, other system resource limitations, business or services expectations for the tenant.

4. A database system comprising:

one or more computing devices in a multitenant environment, wherein a computing device includes a processing device coupled with a storage device, wherein the computing device performs one or more operations comprising;

receiving, by the processing device, a request from a computing device that is communicatively part of a cloud network, wherein the request includes a query for receiving data from the database system, wherein the request is placed by a user having access to the computing device and representing a tenant in the multi-tenant environment; and

evaluating, in runtime, by the processing device, the request to determine whether the request satisfies a predetermine threshold value, wherein the threshold value defines a permitted range of columns and a permitted range of rows based on a query policy associated with the tenant,

wherein if the request satisfies the predetermined threshold value, returning, by the database system, a response based on the predetermined threshold value, wherein the response is returned to the computing device,

wherein if the request fails to satisfy the predetermined threshold value, returning, by the database system, an adjusted response to the computing device, wherein the adjusted response is generated based on one or more adjustments made, in runtime, to at least one of the permitted range of columns and the permitted range of rows, wherein the one or more adjustments are calculated such that a net adjustment to the permitted ranges of columns and rows remains in compliance with the query policy, and

wherein the one or more adjustments are calculated using one or more formulae provided for adjusting the threshold value while remaining in compliance with at least one of the query policy and user expectations such that by at least one of limiting a number of the permitted range of columns or the permitted range of rows while avoiding a heap limit wherein the permitted ranges of columns and rows include minimum and maximum integer values.

5. The database system of claim 4, wherein the one or more formulae further consider the user expectations regarding the response or the adjusted response based on the query policy, wherein the user expectations include at least one of expecting a minimum amount of information to be returned in the response or the adjusted response, a minimum number or a maximum number of the permitted range of columns to be returned, a minimum number or a maximum number of the permitted rows to be returned.

6. The database system of claim 5, wherein the one or more formulae further consider technological limitations comprising one or more of the heap limit, system bandwidth, power limitations, speed or performance limitations, other system resource limitations, business or services expectations for the tenant.

7. A non-transitory machine-readable medium having stored thereon instructions which, when executed by a processor, cause the processor to perform one or more operations comprising:

receiving, by the database system, a request from a computing device that is communicatively part of a cloud network, wherein the request includes a query for receiving data from the database system, wherein the request is placed by a user having access to the computing device and representing a tenant in a multi-tenant environment; and

evaluating, by the database system, in runtime, the request to determine whether the request satisfies a predetermine threshold value, wherein the threshold value defines a permitted range of columns and a permitted range of rows based on a query policy associated with the tenant,

wherein if the request satisfies the predetermined threshold value, returning, by the database system, a response based on the predetermined threshold value, wherein the response is returned to the computing device,

wherein if the request fails to satisfy the predetermined threshold value, returning, by the database system, an adjusted response to the computing device, wherein the adjusted response is generated based on one or more adjustments made, in runtime, to at least one of the permitted range of columns and the permitted range of rows, wherein the one or more adjustments are calculated such that a net adjustment to the permitted ranges of columns and rows remains in compliance with the query policy, and

wherein the one or more adjustments are calculated using one or more formulae provided for adjusting the threshold value while remaining in compliance with at least one of the query policy and user expectations such that by at least one of limiting a number of the permitted range of columns or the permitted range of rows while avoiding a heap limit, wherein the permitted ranges of columns and rows include minimum and maximum integer values.

8. The non-transitory machine-readable medium of claim claim 7, wherein the one or more formulae further consider the user expectations regarding the response or the adjusted response based on the query policy, wherein the user expectations include at least one of expecting a minimum amount of information to be returned in the response or the adjusted response, a minimum number or a maximum number of the permitted range of columns to be returned, a minimum number or a maximum number of the permitted rows to be returned.

9. The non-transitory machine-readable medium of claim 8, wherein the one or more formulae further consider technological limitations comprising one or more of the heap limit, system bandwidth, power limitations, speed or performance limitations, other system resource limitations, business or services expectations for the tenant.