Granted Patent B2

US 7,590,665 · App. 11/328,526 · Granted Sep 15, 2009

Abstract

Claims (39)

1. A method for synchronizing a file in a cache comprising:

providing a system comprising a client computer running an operating system, a cache manager and one or more applications and a database server running a database management application managing a database;

receiving a database asset from the database at the client computer;

storing the database asset in a cache as a cached file, wherein the cache manager stores the database asset as the cached file;

notifying an operating system to open the cached file using a local application associated with a file type for the cached file, wherein the cache manager notifies the operating system to open the cached file;

opening the cached file with the local application associated with the file type for the cached file;

determining if the cached file has been modified based on a notification from a file management system of the operating system, wherein the file management system sends the notification to the cache manager; and

if the cached file has been modified, communicating the cached file to the database.

2. The method of claim 1 , further comprising associating the cached file with a connection.

3. The method of claim 2 , further comprising establishing the connection with the database.

4. The method of claim 3 , further comprising:

determining if the connection with the database has become disconnected; and

if the connection with the database has become disconnected, reestablishing the connection to the database.

5. The method of claim 4 , further comprising saving a user login and using the saved user login to reestablish the connection.

6. The method of claim 1 , further comprising associating the cached file with a location in a memory.

7. The method of claim 1 , further comprising notifying a first user that an additional user has accessed the database asset.

8. The method of claim 1 further comprising opening the cached file with an application associated with a file type associated with the cached file.

9. The method of claim 1 further comprising purging the cached file from the cache if the database asset is deleted from the database.

10. The method of claim 1 , wherein the cache manager communicates the cached file the database.

11. A computer program product comprising:

a computer readable storage medium including computer executable program

instructions for

connecting a client computer running an operating system, a cache manager and a local application to a database server running a database management program; reguesting a database asset from a database managed by the database management program; receiving at the client computer a database asset from a database;

computer executable program instructions for storing the database asset in a cache as a cached file in a computer readable memory of the client computer using a cache manager;

computer executable program instructions-to cause the cache manager to notify the operating system to open the cached file using the local application associated with a file type for the cached file;

computer executable program instructions for opening the cached file with the local application associated with the file type for the cached file;

computer executable program instructions for causing the cache manager to determine if the cached file has been modified based on a notification from a file management system of the operating system; and

if the cached file has been modified communicating the cached file to the database.

12. The computer program product of claim 11 , further comprising computer executable program instructions for associating the cached file with a connection.

13. The computer program product of claim 12 , further comprising computer executable program instructions for establishing the connection with the database.

14. The computer program product of claim 13 , further comprising:

computer program instructions for determining if the connection with the database has become disconnected; and

if the connection with the database has become disconnected reestablishing the connection to the database.

15. The computer program product of claim 14 , further comprising computer executable program instructions for saving a user login and computer program instructions for using the saved user login to reestablish the connection.

16. The computer program product of claim 11 , further comprising computer executable program instructions for associating the cached file with a location in a memory.

17. The computer program product of claim 11 , further comprising computer executable program instructions for notifying a first user that an additional user has accessed the database asset.

18. The computer program product of claim 11 , further comprising computer executable program instructions for opening the cached file with an application associated with a file type associated with the cached file.

19. The computer program product of claim 11 , further comprising computer executable program instructions for purging the cached file from the cache if the database asset is deleted from the database.

20. The computer program product of claim 11 , wherein the cache manager communicates the cached filed to the database.

Assignments (15)