Execution of bulk requests against one or more databases

• US 10,528,750 B2
• Filed: 04/05/2017
• Issued: 01/07/2020
• Est. Priority Date: 03/01/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Schneider, Donovan A., Le Stum, Guillaume, Tenenblat, Leo, Li, Wei
• Primary Examiner(s): Xiao, Di
• Application Number:
  US15/479,985
• Publication Number:
  US 20170249475A1
• Time in Patent Office: 1,007 Days
• CPC Class Codes: G06F 16/2386 Bulk updating operations data conversion details G06F16/258
• CPC Class Codes: G06F 16/24558 Binary matching operations
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 21/6218 to a system of files or objects, e.g. local or distributed file system or database
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Abstract

In accordance with embodiments, there are provided mechanisms and methods for displaying one or more data sets to a user. These mechanisms and methods for displaying one or more data sets to a user can enable enhanced data security, more relevant data display, reduced processing, etc.

Claims

1. A non-transitory computer-readable storage medium having stored thereon a plurality of instructions that are capable of being executed by a computer system to cause operations comprising:

receiving, from a plurality of users of a multi-tenant database system, a plurality of requests to update data sets associated with a graphical interface;

determining one or more similarities between a subset of the plurality of requests sent by a corresponding subset of the plurality of users, wherein the one or more similarities between the subset of the plurality of requests include at least one of;

the subset of the plurality of requests originated from a same time zone;

the subset of the plurality of requests originated from a same geographic location;

or

the corresponding subset of the plurality of users are associated with a same tenant of the multi-tenant database system;

based on the one or more similarities, executing a bulk request for the corresponding subset of the plurality of users against one or more databases of the multi-tenant database system; and

determining, based on a bulk data set, an updated data set for each of the corresponding subset of users.

2. The non-transitory computer-readable storage medium of claim 1, wherein the operations further comprise:

generating the bulk request based on the one or more similarities.

3. The non-transitory computer-readable storage medium of claim 2, wherein the generating the bulk request includes creating a database query specifying a union operation for the subset of the plurality of requests.

4. The non-transitory computer-readable storage medium of claim 1, wherein the operations further comprise:

prior to executing the bulk request, verifying whether each user of the corresponding subset of users is permitted to access a corresponding updated data set based on one or more privilege levels associated with each user.

5. The non-transitory computer-readable storage medium of claim 1, wherein the subset of the plurality of requests include one or more requests of the plurality of request received within a predetermined time period.

6. A method, comprising:

receiving, from a plurality of users of a multi-tenant database system, a plurality of requests to update data sets associated with a user interface;

determining one or more similarities between a subset of the plurality of requests sent by a corresponding subset of the plurality of users, wherein the one or more similarities between the subset of the plurality of requests includes at least one of;

the subset of the plurality of requests originated from a same time zone;

the subset of the plurality of requests originated from a same geographic location;

or

the corresponding subset of the plurality of users are associated with a same tenant of the multi-tenant database system;

based on the one or more similarities, executing a bulk request for the corresponding subset of the plurality of users against one or more databases of the multi-tenant database system; and

determining, based on a bulk data set, an updated data set for each of the corresponding subset of users.

7. The method of claim 6, further comprising:

prior to executing the bulk request, comparing the bulk data set to access permissions for each user of the corresponding subset of users.

8. The method of claim 6, further comprising:

sending, to each user of the corresponding subset of users, the updated data set associated with the user interface, wherein the user interface for each user of the corresponding subset of users is operable to display the updated data set.

9. The method of claim 8, wherein the sending the updated data set includes populating the user interface for each user of the corresponding subset of users with the updated data set that each user is authorized to access.

10. The method of claim 6, wherein the user interface for a given user is operable to graphically display a report associated with an updated data set corresponding to the given user.

11. The method of claim 6, wherein the receiving the plurality of requests includes receiving, from a first user of the plurality of users, a request to access an updated data set corresponding to a second user of the plurality of users.

12. The method of claim 11, further comprising:

determining, based on one or more access privileges of the first user, whether the first user is authorized to access the updated data set corresponding to the second user.

13. The method of claim 12, wherein the first user and the second user are associated with a first tenant of the multi-tenant database system, and wherein the one or more access privileges of the first user are based on a hierarchy associated with the first tenant.

14. An apparatus, comprising:

at least one processor; and

a memory having instructions stored thereon that, when executed by the at least one processor, cause the apparatus to perform operations, comprising;

receiving, from a plurality of users of a multi-tenant database system, a plurality of requests to update data sets associated with a graphical interface;

determining one or more similarities between a subset of the plurality of requests sent by a corresponding subset of the plurality of users, wherein the one or more similarities between the subset of the plurality of requests include at least one of;

the subset of the plurality of requests originated from a same time zone;

the subset of the plurality of requests originated from a same geographic location;

or

the corresponding subset of the plurality of users are associated with a same tenant of the multi-tenant database system;

based on the one or more similarities, executing a bulk request for the corresponding subset of the plurality of users against one or more databases of the multi-tenant database system; and

determining, based on a bulk data set, an updated data set for each of the corresponding subset of users.

15. The apparatus of claim 14, wherein the operations further comprise:

creating the bulk request, based on the one or more similarities, from the subset of the plurality of requests.

16. The apparatus of claim 14, wherein the determining the updated data set includes comparing the bulk data set to access permissions for each user of the corresponding subset of users.

17. The apparatus of claim 14, wherein the graphical interface includes a dashboard component operable to graphically display data sets corresponding users of the multi-tenant database system.

18. The apparatus of claim 14, wherein the operations further comprise:

sending, to each user of the corresponding subset of users, the updated data set associated with the graphical interface, wherein the graphical interface for each user of the corresponding subset is operable to display the updated data set.