DYNAMIC INTEGRATION OF DISPARATE DATABASE ARCHITECTURES FOR EFFICIENT MANAGEMENT OF RESOURCES IN AN ON-DEMAND SERVICES ENVIRONMENT

• US 20160140200A1
• Filed: 11/23/2015
• Published: 05/19/2016
• 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
• Granted Patent: US 10,127,297 B2
• Time in Patent Office: Days
• 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, by a first database architecture of the database system, a job request from a computing device communicatively coupled with the first database architecture over a network;

transmitting, by the first database architecture, the job request to a second database architecture to process the job request and obtain a result output, wherein the second database architecture is independent of and disparate from the first database architecture;

receiving, by the first database architecture, the result output from the second database architecture in a format compatible with the second database architecture;

associating, by the first database architecture, a custom object to the result output to offer customized contents of the result output for the computing device, wherein the customized contents are offered in one or more formats compatible with and capable of being visualized at the computing device; and

communicating, by the first database architecture, the customized contents to the computing device.

2. The method of claim 1, wherein the format compatible with the second database architecture is independent of and disparate from the one or more formats compatible with the computing device.

3. The method of claim 1, wherein the second database architecture comprises a data-processing platform outside of the database system, wherein the data-processing platform hosting one or more data-processing servers including Apache™

Hadoop®

.

4. The method of claim 1, wherein the first database architecture comprises a local multi-tenant database platform capable of processing and distributing job requests.

5. The method of claim 1, wherein the one or more formats comprise at least one of a graph, a chart, a table, a textual message, or a spreadsheet capable of being visualized at the computing device via a user interface.

6. The method of claim 1, wherein the format compatible with the second database architecture is based on a first programming package as facilitated by first programming protocols, and wherein the one or more formats compatible with the computing device are based on a second programming package as facilitated by second programming protocols.

7. A system comprising:

a computing device having a processing device coupled with a 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;

receiving, at a first database architecture of a database system, a job request from a computing device communicatively coupled with the first database architecture over a network;

transmitting, from the first database architecture, the job request to a second database architecture to process the job request and obtain a result output, wherein the second database architecture is independent of and disparate from the first database architecture;

receiving, at the first database architecture, the result output from the second database architecture in a format compatible with the second database architecture;

associating, at the first database architecture, a custom object to the result output to offer customized contents of the result output for the computing device, wherein the customized contents are offered in one or more formats compatible with and capable of being visualized at the computing device; and

communicating, from the first database architecture, the customized contents to the computing device.

8. The system of claim 7, wherein the format compatible with the second database architecture is independent of and disparate from the one or more formats compatible with the computing device.

9. The system of claim 7, wherein the second database architecture comprises a data-processing platform outside of the database system, wherein the data-processing platform hosting one or more data-processing servers including Apache™

Hadoop®

.

10. The system of claim 7, wherein the first database architecture comprises a local multi-tenant database platform capable of processing and distributing job requests.

11. The system of claim 7, wherein the one or more formats comprise at least one of a graph, a chart, a table, a textual message, or a spreadsheet capable of being visualized at the computing device via a user interface.

12. The system of claim 7, wherein the format compatible with the second database architecture is based on a first programming package as facilitated by first programming protocols, and wherein the one or more formats compatible with the computing device are based on a second programming package as facilitated by second programming protocols.

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

receiving, at a first database architecture of a database system, a job request from a computing device communicatively coupled with the first database architecture over a network;

transmitting, from the first database architecture, the job request to a second database architecture to process the job request and obtain a result output, wherein the second database architecture is independent of and disparate from the first database architecture;

receiving, at the first database architecture, the result output from the second database architecture in a format compatible with the second database architecture;

associating, at the first database architecture, a custom object to the result output to offer customized contents of the result output for the computing device, wherein the customized contents are offered in one or more formats compatible with and capable of being visualized at the computing device; and

communicating, from the first database architecture, the customized contents to the computing device.

14. The machine-readable medium of claim 13, wherein the format compatible with the second database architecture is independent of and disparate from the one or more formats compatible with the computing device.

15. The machine-readable medium of claim 13, wherein the second database architecture comprises a data-processing platform outside of the database system, wherein the data-processing platform hosting one or more data-processing servers including Apache™

Hadoop®

.

16. The machine-readable medium of claim 13, wherein the first database architecture comprises a local multi-tenant database platform capable of processing and distributing job requests.

17. The machine-readable medium of claim 13, wherein the one or more formats comprise at least one of a graph, a chart, a table, a textual message, or a spreadsheet capable of being visualized at the computing device via a user interface.

18. The machine-readable medium of claim 13, wherein the format compatible with the second database architecture is based on a first programming package as facilitated by first programming protocols, and wherein the one or more formats compatible with the computing device are based on a second programming package as facilitated by second programming protocols.