SYSTEM AND METHOD FOR THE SYNCHRONIZATION OF A FILE IN A CACHE

• US 20100049757A1
• Filed: 08/21/2009
• Published: 02/25/2010
• Est. Priority Date: 12/28/2001
• Status: Active Grant

• Current Assignee: Ip Ot Sub Ulc
• Original Assignee: Vignette Corporation (Open Text Corporation)
• Inventors: Thomas, David, Wells, Scott
• Granted Patent: US 8,117,152 B2
• Time in Patent Office: Days
• US Class Current: 707/613
• 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 present invention provides a system and method of synchronizing a cache that substantially eliminates or reduces disadvantages associated with previously developed systems and methods of synchronizing caches. More particularly, embodiments of the present invention provide a system and method for bi-directional synchronization of a cache. 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 run in user space and perform steps comprising: receiving a database asset from a database; storing the database asset as a cached file in a cache; determining if the cached file has been modified; and if the cached file has been modified, communicate the cached file directly to the database. In one embodiment of the present invention, the software program can determine if the cached file has been modified through automatic notification from a file management system. Alternatively, the software program can poll a cached file to determine if the cached file has changed. In another embodiment of the present invention, the software program can be further executable to perform the step of prompting an operating system to open the cached file in an application associated with the cached file'"'"'s file type. In yet another embodiment of the present invention, the software program can be further executable to receive notifications from a database of when contention for a database asset occurs. Thus, bi-directional synchronization can occur.

Claims

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 a 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;

associating the cached file with a connection;

associating the cached file with a location in memory;

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.