Facilitating distributed data processing for dynamic and efficient generation of search results in an on-demand services environment

• US 9,424,336 B2
• Filed: 08/09/2013
• Issued: 08/23/2016
• Est. Priority Date: 09/14/2012
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Fuchs, Matthew, Ming, Lei
• Primary Examiner(s): Nguyen, Loan T
• Application Number:
  US13/963,840
• Publication Number:
  US 20140081978A1
• Time in Patent Office: 1,110 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/285 Clustering or classification

Abstract

In accordance with embodiments, there are provided mechanisms and methods for facilitating distributed data processing for dynamic and efficient generation of search results in a multi-tenant environment according to one embodiment. In one embodiment and by way of example, a method includes receiving, at a data processing platform, extracted data occurrences from a database coupled to a server computing device, where each data occurrence may be assigned a classification according to a category. The method may further include mapping values to the data occurrences based on classifications of the data occurrences, mapping prefixes to the data occurrences based on identifying names of the data occurrences, and generating search data based on the mapped values and mapped prefixes, where the search data may represent autosuggestions.

Claims

1. A database system-implemented method, comprising:

monitoring, by a local query platform of the database system, data at a database communicatively coupled to the local query platform, wherein monitoring includes detecting one or more data occurrences in the data, wherein the one or more data occurrences include one or more modifications to one or more portions of the data relating to one or more tenants in a multi-tenant environment;

transmitting, by the local query platform, the one or more data occurrences from the database to a remote data processing entity to process the one or more data occurrences, wherein results of the processing of the one or more data occurrences are cached at the database by the remote processing entity over a network, wherein the one or more data occurrences are assigned one or more classifications relating to the one or more tenants;

mapping, by the local query platform, one or more values to the results of the one or more data occurrences based on the one or more classifications; and

generating, by the local query platform, search data from the results based on the mapped values such that a customized portion of the search data is suggested to a tenant in response to a query placed by the tenant.

2. The method of claim 1, wherein the database comprises a local multi-tenant database.

3. The method of claim 1, wherein the search data including the customized portion of the search data is communicated to a computing device over the network including a cloud network, wherein the computing device includes a client computer accessible to the tenant.

4. The method of claim 3, wherein the customized portion of the search data to trigger and present automatic suggestions in response to one or more search queries placed at the computing device by a user representing the tenant, wherein the automatic suggestions include one or more predictive answers to the one or more search queries.

5. The method of claim 1, wherein the one or more predictive answers are based on processing of data occurrences by the remote data processing entity, wherein the one or more predictive answers are further based on a search history of the tenant such that a first portion of a predictive answer is pre-computed to match with a second portion of the predictive answer, wherein a first value of the first portion is predictively mapped to a second value of the second portion.

6. A system comprising:

a computing device having a processing device coupled with memory to store instructions relating to a mechanism, wherein the instructions, when executed by the processing device, cause the processing device to perform operations comprising;

monitoring, by a local query platform of the database system, data at a database communicatively coupled to the local query platform, wherein monitoring includes detecting one or more data occurrences in the data, wherein the one or more data occurrences include one or more modifications to one or more portions of the data relating to one or more tenants in a multi-tenant environment;

transmitting, by the local query platform, the one or more data occurrences from the database to a remote data processing entity to process the one or more data occurrences, wherein results of the processing of the one or more data occurrences are cached at the database by the remote processing entity over a network, wherein the one or more data occurrences are assigned one or more classifications relating to the one or more tenants;

mapping, by the local query platform, one or more values to the results of the one or more data occurrences based on the one or more classifications; and

generating, by the local query platform, search data from the results based on the mapped values such that a customized portion of the search data is suggested to a tenant in response to a query placed by the tenant.

7. The system of claim 6, wherein the database comprises a local multi-tenant database.

8. The system of claim 6, wherein the search data including the customized portion of the search data is communicated to a computing device over the network including a cloud network, wherein the computing device includes a client computer accessible to the tenant.

9. The system of claim 8, wherein the customized portion of the search data to trigger and present automatic suggestions in response to one or more search queries placed at the computing device by a user representing the tenant, wherein the automatic suggestions include one or more predictive answers to the one or more search queries.

10. The system of claim 6, wherein the one or more predictive answers are based on processing of data occurrences by the remote data processing entity, wherein the one or more predictive answers are further based on a search history of the tenant such that a first portion of a predictive answer is pre-computed to match with a second portion of the predictive answer, wherein a first value of the first portion is predictively mapped to a second value of the second portion.

11. A machine-readable medium having stored thereon instructions which, when executed by a machine, cause the machine to perform operations comprising:

monitoring, by a local query platform of the database system, data at a database communicatively coupled to the local query platform, wherein monitoring includes detecting one or more data occurrences in the data, wherein the one or more data occurrences include one or more modifications to one or more portions of the data relating to one or more tenants in a multi-tenant environment;

transmitting, by the local query platform, the one or more data occurrences from the database to a remote data processing entity to process the one or more data occurrences, wherein results of the processing of the one or more data occurrences are cached at the database by the remote processing entity over a network, wherein the one or more data occurrences are assigned one or more classifications relating to the one or more tenants;

mapping, by the local query platform, one or more values to the results of the one or more data occurrences based on the one or more classifications; and

generating, by the local query platform, search data from the results based on the mapped values such that a customized portion of the search data is suggested to a tenant in response to a query placed by the tenant.

12. The machine-readable medium of claim 11, wherein the database comprises a local multi-tenant database.

13. The machine-readable medium of claim 11, wherein the search data including the customized portion of the search data is communicated to a computing device over the network including a cloud network, wherein the computing device includes a client computer accessible to the tenant.

14. The machine-readable medium of claim 13, wherein the customized portion of the search data to trigger and present automatic suggestions in response to one or more search queries placed at the computing device by a user representing the tenant, wherein the automatic suggestions include one or more predictive answers to the one or more search queries.

15. The machine-readable medium of claim 11, wherein the one or more predictive answers are based on processing of data occurrences by the remote data processing entity, wherein the one or more predictive answers are further based on a search history of the tenant such that a first portion of a predictive answer is pre-computed to match with a second portion of the predictive answer, wherein a first value of the first portion is predictively mapped to a second value of the second portion.