System and method for the synchronization of a file in a cache
DC CAFCFirst Claim
1. A system for synchronizing a cached file with a database:
- a computer processor;
a network connection device operable to establish a connection with a database;
a computer readable memory containing a local cache; and
a software program, executable to run in user space on a client computer, stored on a computer medium and executable by the computer processor to;
send a request to the database for a file;
receive the file at the client computer directly from a database;
store the file as a cached file in the local cache;
notify the operating system to open the cached file using a locally running application associated with the file type for the cached file;
determine if the cached file at the client computer has been modified by a user using the locally running application based on a notification from a file management system of an operating system; and
if the cached file has been modified, save the cached file from the cache directly to the database.
17 Assignments
Litigations
0 Petitions
Accused Products
Abstract
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 that can include 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.
-
Citations
27 Claims
-
1. A system for synchronizing a cached file with a database:
-
a computer processor; a network connection device operable to establish a connection with a database; a computer readable memory containing a local cache; and a software program, executable to run in user space on a client computer, stored on a computer medium and executable by the computer processor to; send a request to the database for a file; receive the file at the client computer directly from a database; store the file as a cached file in the local cache; notify the operating system to open the cached file using a locally running application associated with the file type for the cached file; determine if the cached file at the client computer has been modified by a user using the locally running application based on a notification from a file management system of an operating system; and if the cached file has been modified, save the cached file from the cache directly to the database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A system for synchronizing a file in a cache comprising:
-
a database server further comprising; a server processor; a server memory;
a database stored on said server memory containing a plurality of files; anda database management program stored on the server memory executable by the server processor to; receive a client request for a file; and retrieve the file; and a client computer communication with the database server further comprising; a client processor; a client memory; and a cache manager program, stored on the client memory executable by the client processor to run in user space and to; establish a connection to the database server; forward the client request for the file to the database server; receive the file from the database server; store the file as a cached file in the client memory; notify an operating system to open the cached file with a locally running application associated with a file type for the cached file; determine if the cached file has been modified based on a notification from a file management system of an operating system; and if the cached file has been modified, communicate the cached file to the database. - View Dependent Claims (15, 16, 17, 18, 19, 20, 21, 22, 23, 24)
-
-
25. A method of managing a cache comprising:
-
establishing a connection with a database; retrieving a database asset from the database; storing the database asset in a cache as a cached file; associating the cached file with the connection; opening the cached file in 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 an operating system; if the cached file has been modified; determining if the connection with the database is still established; if the connection with the database is not still established, reestablishing the connection to the database; communicating the cached file directly to the database; and saving the cached file in the database as the database asset.
-
-
26. A system for synchronizing a cached file with a database:
-
a computer processor; a network connection device operable to establish a connection with a database; a computer readable memory containing a cache; and a software program, executable to run in user space, stored on the computer readable memory and executable by the computer processor to; send a request to the database for a database asset; receive a database asset directly from a database; notify an operating system to open the cached file with a local application associated with the file type for the cached file; store the database asset as a cached file in the cache; determine if the cached file has been modified by polling the cached asset according to a predefined schedule; and if the cached file has been modified, save the cached file directly to the database.
-
-
27. A system for synchronizing a cached file with a database:
-
a computer processor; a network connection device operable to establish a connection with a database; a computer readable memory containing a local cache; and a software program, executable to run in user space, stored on a computer medium and executable by the computer processor to; send a request to the database for a first database asset; receive the first database asset directly from a database; store the first database asset as a first cached file in the local cache; notify the operating system to open the first cached file using a first locally running application associated with the file type for the cached file; determine if the first cached file has been modified by the first locally running application based on a notification from a file management system of an operating system; and if the first cached file has been modified, save the cached from the cache the database; send a request to the database for a second database asset; receive the second database asset directly from the database; store the second database asset as a second cached file in the local cache; notify the operating system to open the second cached file using a second locally running application associated with the file type for the cached file; determine if the second cached file has been modified by the second locally running application based on a notification from a file management system of an operating system; and if the second cached file has been modified, save the cached file directly to the database, wherein the first database asset and the second database asset have different file types and the first locally running application and the second locally running application are different application types.
-
Specification