SYSTEM, METHOD AND COMPUTER PROGRAM PRODUCT FOR COMMUNICATING DATA BETWEEN A DATABASE AND A CACHE

• US 20110231481A1
• Filed: 03/16/2011
• Published: 09/22/2011
• Est. Priority Date: 03/16/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Calahan, Patrick
• Granted Patent: US 9,111,006 B2
• Time in Patent Office: Days
• US Class Current: 709/203
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/9574 of access to content, e.g. by caching
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]
• CPC Class Codes: H04L 67/5683 Storage of data provided by user terminals, i.e. reverse caching

Abstract

In accordance with embodiments, there are provided mechanisms and methods for communicating data between a database and a cache. These mechanisms and methods for communicating data between a database and a cache can enable improved application quality and performance, enhanced client application interaction, increased system performance, etc.

Claims

1. A computer program product, comprising a non-transitory computer usable medium having a computer readable program code embodied therein, the computer readable program code adapted to be executed to implement a method for communicating data between a database and a cache, the method comprising:

identifying a database of a system;

identifying a cache separate from the database that is associated with an application residing within a browser; and

communicating data between the database and the cache.

2. The computer program product of claim 1, wherein the database stores one or more objects that are used by one or more applications of the system.

3. The computer program product of claim 2, wherein the database contains metadata that describes one or more of the objects.

4. The computer program product of claim 1, wherein the application is a feature provided by the system.

5. The computer program product of claim 1, wherein the application includes a graphical approval process editor that enables customers of the system to add, remove, view, or manipulate one or more approval processes utilizing a visual user interface.

6. The computer program product of claim 5, wherein the approval process interface manages a description of each approval process.

7. The computer program product of claim 1, wherein the application is run in a browser inside a browser-based application runtime.

8. The computer program product of claim 1, wherein the cache includes a client-side cache external to the system.

9. The computer program product of claim 1, wherein the cache provides one or more interface components of the application with one or more objects from the database of the system.

10. The computer program product of claim 5, wherein the cache provides user interface (UI) components of the graphical approval process editor with a view of objects of the database that comprise an approval process.

11. The computer program product of claim 1, wherein a network connection exists between the database and the cache.

12. The computer program product of claim 1, wherein communicating the data includes retrieving the data from the database, compiling the data into a form recognizable by the application, and sending the data to the cache.

13. The computer program product of claim 1, wherein communicating the data includes sending data from the cache to the database.

14. The computer program product of claim 1, wherein communicating the data includes synchronizing data between the cache and the database.

15. The computer program product of claim 12, wherein a data dictionary is utilized to obtain descriptions of the data retrieved from the database.

16. The computer program product of claim 1, wherein the synchronizing includes saving the data in the cache at the object level.

17. The computer program product of claim 1, wherein the computer program product is operable such that a change is made to data in the database by an entity other than the application.

18. The computer program product of claim 17, wherein a copy of the data is stored in the cache before it is changed by the entity, and the copy of the data stored in the cache is automatically updated, in response to the change made by the entity.

19. A method, comprising:

identifying a database of a system;

identifying a cache separate from the database that is associated with an application residing within a browser; and

communicating data between the database and the cache, utilizing a processor.

20. An apparatus, comprising:

a processor for;

identifying a database of a system

identifying a cache separate from the database that is associated with an application residing within a browser; and

communicating data between the database and the cache.

21. A method for transmitting code for use in a multi-tenant database system on a transmission medium, the method comprising:

transmitting code for identifying a database of a system;

transmitting code for identifying a cache separate from the database that is associated an application residing within a browser; and

transmitting code for communicating data between the database and the cache, utilizing a processor.