Mechanism for facilitating dynamic integration of disparate database architectures for efficient management of resources in an on-demand services environment

• US 9,195,726 B2
• Filed: 03/15/2013
• Issued: 11/24/2015
• Est. Priority Date: 04/17/2012
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Bharadwaj, Narayan, Kommireddi, Prashant, Crosby, Jed
• Primary Examiner(s): Lee, Wilson
• Application Number:
  US13/841,153
• Publication Number:
  US 20140279857A1
• Time in Patent Office: 984 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Abstract

In accordance with embodiments, there are provided mechanisms and methods for facilitating dynamic integration of disparate database architectures for efficient management of resources 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 first database platform, a job request in a first programming package, transforming the job request from the first programming package to a second programming package, transmitting the job request in the second programming package to a second database platform for processing. The job request may be processed at the second database platform that is independent of the first database platform. The method may further include receiving an output relating to the processing of the job request.

Claims

1. A database system-implemented method comprising:

receiving, at a first database platform of the database system, a job request from a user having access to a computing device, wherein the job request is associated with a first programming package based on at least one of a first programming language and a first set of programming protocols;

seeking, by the database system, a third-party entity, at a second database platform, to process the job request;

translating, by the database system, the first programming package into a second programming package, wherein the second programming package is compatible with the third-party entity, and wherein the second programming package is based on at least one of a second programming language and a second set of programming protocols;

transmitting, by the database system, the job request associated with the second programming package to the third-party entity; and

receiving, by the database system and from the third-party entity, an output relating to the processing of the job request.

2. The method of claim 1, further comprising displaying the output of the processed job request via a display device of the computing device coupled to the first database platform, wherein displaying includes visualizing the output in a format including one or more of graphs, charts, text formats, and spreadsheets.

3. The method of claim 1, wherein the first programming language and the first set of programming protocols are compatible with the first database platform.

4. The method of claim 1, wherein the second programming language and the second set of programming protocols are compatible with the second database platform.

5. The method of claim 1, wherein the second database platform comprises a data processing server including an Apache™

Hadoop®

.

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

7. The method of claim 6, wherein the first database platform and the second database platforms include disparate platforms that are remotely located.

8. A system comprising:

a computing device having a memory to store instructions, and a processing device to execute the instructions, the computing device further having a mechanism to;

receive, at a first database platform of the database system, a job request from a user having access to a computing device, wherein the job request is associated with a first programming package based on at least one of a first programming language and a first set of programming protocols;

seek, by the database system, a third-party entity, at a second database platform, to process the job request;

translate, by the database system, the first programming package into a second programming package, wherein the second programming package is compatible with the third-party entity, and wherein the second programming package is based on at least one of a second programming language and a second set of programming protocols;

transmit, by the database system, the job request associated with the second programming package to the third-party entity; and

receive, by the database system and from the third-party entity, an output relating to the processing of the job request.

9. The system of claim 8, wherein the mechanism is further to display the output of the processed job request via a display device of the computing device coupled to the first database platform, wherein displaying includes visualizing the output in a format including one or more of graphs, charts, text formats, and spreadsheets.

10. The system of claim 8, wherein the first programming language and the first set of programming protocols are compatible with the first database platform.

11. The system of claim 8, wherein the second programming language and the second set of programming protocols are compatible with the second database platform.

12. The system of claim 8, wherein the second database platform comprises a data processing server including an Apache™

Hadoop®

.

13. The system of claim 8, wherein the first database platform comprises a local multi-tenant database.

14. The system of claim 13, wherein the first database platform and the second database platforms include disparate platforms that are remotely located.

15. A non-transitory computer-readable medium having stored thereon instructions which, when executed by a processor, cause the processor to:

receive, at a first database platform of the database system, a job request from a user having access to a computing device, wherein the job request is associated with a first programming package based on at least one of a first programming language and a first set of programming protocols;

seek, by the database system, a third-party entity, at a second database platform, to process the job request;

translate, by the database system, from the first programming package into a second programming package, wherein the second programming package is compatible with the third-party entity, and wherein the second programming package is based on at least one of a second programming language and a second set of programming protocols;

transmit, by the database system, the job request associated with the second programming package to the third-party entity; and

receive, by the database system and from the third-party entity, an output relating to the processing of the job request.

16. The non-transitory computer-readable medium of claim 15, wherein the mechanism is further to display the output of the processed job request via a display device of the computing device coupled to the first database platform, wherein displaying includes visualizing the output in a format including one or more of graphs, charts, text formats, and spreadsheets.

17. The non-transitory computer-readable medium of claim 15, wherein the first programming language and the first set of programming protocols are compatible with the first database platform.

18. The non-transitory computer-readable medium of claim 15, wherein second programming language and the second set of programming protocols are compatible with the second database platform, wherein the second database platform comprises a data processing server including an Apache™

Hadoop®

.

19. The non-transitory computer-readable medium of claim 15, wherein the first database platform comprises a local multi-tenant database.

20. The non-transitory computer-readable medium of claim 19, wherein the first database platform and the second database platforms include disparate platforms that are remotely located.