System and method for the synchronization of a file in a cache

• US 9,594,768 B2
• Filed: 02/05/2016
• Issued: 03/14/2017
• Est. Priority Date: 12/28/2001
• Status: Expired due to Term

• Current Assignee: Ip Ot Sub Ulc
• Original Assignee: Open Text Sa Ulc (Open Text Corporation)
• Inventors: Thomas, David, Wells, Scott
• Primary Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US15/017,189
• Publication Number:
  US 20160154819A1
• Time in Patent Office: 403 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 12/0804 with main memory updating G06F12/0806 takes precedence
• CPC Class Codes: G06F 12/0866 for peripheral storage systems, e.g. disk cache
• CPC Class Codes: G06F 16/168 Details of user interfaces specifically adapted to file systems, e.g. browsing and visualisation, 2d or 3d GUIs query results presentation G06F16/156
• CPC Class Codes: G06F 16/172 Caching, prefetching or hoarding of files
• CPC Class Codes: G06F 16/178 Techniques for file synchronisation in file systems
• CPC Class Codes: G06F 16/184 implemented as replicated file system
• CPC Class Codes: G06F 2212/1024 Latency reduction
• CPC Class Codes: G06F 2212/154 Networked environment
• CPC Class Codes: G06F 2212/163 Server or database system
• CPC Class Codes: G06F 2212/263 Network storage, e.g. SAN or NAS
• CPC Class Codes: G06F 2212/264 Remote server
• CPC Class Codes: G06F 2212/463 File
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence
• CPC Class Codes: H04L 67/1095 Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes
• CPC Class Codes: Y10S 707/951 Calendar or scheduling
• CPC Class Codes: Y10S 707/959 Network
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

The invention provides a system and method for file synchronization. One embodiment of the system of this invention includes a software program stored on a computer readable medium. The software program can be executed by a computer processor to receive a file from a server; store the file as a cached file in a cache; determine if the cached file has been modified; and if the cached file has been modified, communicate the cached file directly to the database.

Claims

1. A system, comprising:

at least one processor;

at least one non-transitory computer readable medium;

a local cache; and

stored instructions translatable by the at least one processor to provide a cache manager that runs in user space on a computer having an operating system, the cache manager configured to;

establish a connection with a server, the server associated with a database;

determine contents of the database;

enumerate the contents of the database for display in a user interface, the contents comprising database assets;

responsive to a user selection of a database asset from the database assets via the user interface, request a copy of the database asset from the server over the connection;

store the copy of the database asset as a cached file in the local cache at a location in a file system of the operating system;

associate the cached file with the connection to the server;

determine whether the cached file has been modified via a local application; and

when the cached file has been modified, communicate with the server to synchronize the database with the cached file.

2. The system of claim 1, wherein the cache manager is configured to:

request information regarding the cached file from the operating system;

receive the information regarding the cached file from the operating system; and

determine whether the cached file has been modified via a local application based on the information regarding the cached file.

3. The system of claim 2, wherein requesting the information regarding the cached file from the operating system comprises polling the operating system for file system metadata of the cached file.

4. The system of claim 3, wherein the file system metadata comprises a last modified time stamp for the cached file.

5. The system of claim 2, wherein requesting information regarding the cached file from the operating system comprises registering with the operating system to receive automatic notifications and wherein receiving the information regarding the cached file comprises receiving an automatic notification from the operating system.

6. The system of claim 1, wherein the cache manager is further configured to prompt the operating system to open the cached file in the local application.

7. The system of claim 1, wherein the cache manager is further configured to display contents of the database as local files in the user interface.

8. A method comprising:

establishing by a client computer a connection with a server, the server associated with a database;

determining contents of the database;

enumerating the contents of the database for display in a user interface at a client computer, the contents comprising database assets;

responsive to a user selection of a database asset from the database assets via the user interface, requesting a copy of the database asset from the server over the connection;

storing the copy of the database asset as a cached file in a local cache at the client computer;

associating the cached file with the connection to the server;

determining whether the cached file has been modified via a local application; and

when the cached file has been modified, communicating with the server over the connection to synchronize the database with the cached file.

9. The method of claim 8, further comprising providing a cache manager that runs in user space on the client computer, wherein the client computer comprises an operating system having a file system.

10. The method of claim 9, wherein storing the copy of the database asset as the cached file comprises storing, by the cache manager, the copy of the database asset at a location in the file system of the operating system.

11. The method of claim 10, further comprising:

requesting, by the cache manager, information regarding the cached file from the operating system; and

receiving, by the cache manager, the information regarding the cached file from the operating system;

wherein determining whether the cached file has been modified via the local application comprises determining, by the cache manager, whether the cached file has been modified via the local application based on the information regarding the cached file.

12. The method of claim 11, wherein requesting by the cache manager the information regarding the cached file from the operating system comprises polling by the cache manager the operating system for file system metadata of the cached file.

13. The method of claim 12, wherein the file system metadata comprises a last modified time stamp for the cached file.

14. The method of claim 11, wherein requesting, by the cache manager, information regarding the cached file from the operating system comprises registering with the operating system to receive automatic notifications and wherein receiving by the cache manager the information regarding the cached file comprises receiving an automatic notification from the operating system.

15. The method of claim 11, further comprising prompting by the cache manager the operating system to open the cached file in the local application.

16. The method of claim 11, wherein enumerating the contents of the database for display in the user interface at a client computer comprises enumerating by the cache manager the contents of the database for display as local files in the user interface.

17. The method of claim 11, wherein requesting a copy of the database asset from the server over the connection comprises requesting by the cache manager the copy of the database asset from the server.

18. The method of claim 11, wherein communicating with to the server over the connection to synchronize the database with the cached file comprises communicating by the cache manager with the server to synchronize the database with the cached file.

19. A computer program product comprising a non-transitory computer readable storage storing instructions, the stored instructions translatable by at least one processor to:

establish a connection with a server, the server associated with a database;

determine contents of the database;

enumerate the contents of the database for display in a user interface, the contents comprising database assets;

responsive to a user selection of a database asset from the database assets via the user interface, request a copy of the database asset from the server over the connection;

store the copy of the database asset as a cached file in a local cache;

associate the cached file with the connection to the server;

determine whether the cached file has been modified via a local application; and

when the cached file has been modified, communicate with the server over the connection to synchronize the database with the cached file.

20. The computer program product of claim 19, wherein the stored instructions are translatable to provide a cache manager that runs in user space on a client computer, wherein the cache manager is configured to store the copy of the database asset as the cached file at a location in a file system of an operating system of the client computer.

21. The computer program product of claim 20, wherein the cache manager is configured to:

request information regarding the cached file from the operating system of the client computer;

receive the information regarding the cached file from the operating system;

determine whether the cached file has been modified via the local application based on the information regarding the cached file; and

communicate with the server over the connection to synchronize the database.

22. The computer program product of claim 21, wherein requesting the information regarding the cached file from the operating system comprises polling the operating system for file system metadata of the cached file.

23. The computer program product of claim 22, wherein the file system metadata comprises a last modified time stamp for the cached file.

24. The computer program product of claim 21, wherein requesting information regarding the cached file from the operating system comprises registering with the operating system to receive automatic notifications and wherein receiving the information regarding the cached file comprises receiving an automatic notification from the operating system.

25. The computer program product of claim 21, wherein the cache manager is configured to enumerate the contents of the database for display as local files in the user interface.