Method for improving the responsiveness of a client device
A method for improving the responsiveness of a client application by providing that application with a local database which is a replicated subset of a database held on a remote server.
1. A method for improving responsiveness of a client media player application executable on a client device, by providing the client media player application with a local relational database which is a replicated subset of a database held on a remote server, wherein data items in the local relational database have associated expiration points and wherein expired data items are refreshed with data from the remote server, the method comprising the steps of:
(i) providing the client media player application running on the client device with the local relational database, wherein the local relational database is a replicated subset of the database held on the remote server, wherein the local relational database is embodied on a non-transient storage medium, and wherein the client media player application is embodied on a non-transient storage medium,
(ii) identifying expired data items in the local relational database,
(iii) obtaining data from the remote server to refresh the expired data items, and
(iv) refreshing identified expired data items with the data obtained from the remote server.
2. The method of claim 1 wherein the local relational database is supplied pre-packaged with a client application installer.
3. The method of claim 1 wherein a client application installer downloads a pre-prepared local relational database from the remote server.
4. The method of claim 1 wherein the remote server maintains a record of which data is stored on each client installation along with expiration metadata for that data, the method including the step of: the remote server updating the record of which data is stored on each client installation along with expiration metadata for that data each time data is downloaded from the remote server to the local relational database.
5. The method of claim 4 wherein the remote server pushes refreshed data to the local relational database when the local relational database data items are near, at or beyond their expiration point defined in the expiration metadata.
6. The method of claim 5 wherein the push of refreshed data from the remote server to the local relational database happens automatically.
7. The method of claim 5 wherein the push of refreshed data from the remote server to the local relational database also updates a structure of the local relational database and relocates existing and new data into the updated structure.
8. The method of claim 1 wherein the client application is installed on a computing device wherein the computing device is a desktop computer, a laptop computer, a mobile device, a games console or any other computing device.
9. The method of claim 1 wherein a client installer performs an update to one or more of the client application, local relational database content or local relational database structure.
10. The method of claim 1 wherein the client application causes the client device to function as a media player.
11. The client device of claim 1 , wherein the client device includes the client media player application running on the client device, and wherein the client device includes the local relational database.
12. The method of claim 1 , further comprising the step of: synchronizing the local relational database with the database held on the remote server.
13. The method of claim 1 , further comprising the step of: incorporating scripts to restructure a local database schema within an update package.
14. A non-transient storage medium embodying the client media player application and the local relational database of claim 1 .