Database updates over a network

• US 5,829,001 A
• Filed: 01/21/1997
• Issued: 10/27/1998
• Est. Priority Date: 01/21/1997
• Status: Expired due to Term

• Current Assignee: NetIQ Corporation (Open Text Corporation)
• Original Assignee: NetIQ Corporation (Open Text Corporation)
• Inventors: Chuang, Wei-Jen, Hwang, Ching-Fa, Li, Kong, Phathayakorn, Prayoon, Che, Her-Daw
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): MIZRAHI, DIANE D
• Application Number:
  US08/784,593
• Time in Patent Office: 644 Days
• Field of Search: 1/1, 707/10, 707/103, 707/201, 707/1, 702/186, 395/182.02, 395/182.18, 395/673
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

The present invention provides an improved method and apparatus for performing database updates in a distributed system having an originating database stored in a server and a partial or complete copy of the database stored in a client. In one embodiment, a database update system includes a server having a database, a network, and a client having a storage and software for accessing the database over the network. The client maintains the last update time of each table stored in its storage. The server maintains the modification time as an integral field of each record in the database. The modification time of a record indicates the last time at which the record was modified in the database. The client software requests copies of all records of a table stored in the client'"'"'s storage that have a modification time that is later than the last update time of the table. In another embodiment, the server also maintains a modification table that includes a record for each table in the database. Each record in the modification table includes a table modification time that indicates the last time at which any record in the associated table was modified in the database.

Claims

1. A method for updating data objects stored in a storage of a client with data objects of a database stored in a server, the method comprising:

the client providing a last update time to the server, wherein the last update time indicates a last time at which the client received an update from the server; and

the server providing a plurality of data objects stored in the database to the client, a value of the data objects having been updated in the database at a time later than the last update time.

2. The method of claim 1, wherein the server providing a plurality of data objects further comprises:

sorting the data objects based on a modification time of each data object, wherein the modification time is an integral value of each data object that indicates a last time at which a value of the data object was modified in the database.

3. The method of claim 2 further comprising:

the client setting the last update time equal to the modification time of the last data object provided by the server.

4. The method of claim 2, wherein the client providing a last update time further comprises:

providing a last update time of a set of data objects to the server, wherein the last update time of the set of data objects indicates the last time at which the client received an update of any data object of the set of data objects from the server.

5. The method of claim 4, wherein the server providing a plurality of data objects further comprises:

providing a plurality of data objects of the set of data objects stored in the database to the client, a value of the data objects having been updated in the database at a time later than the last update time of the set of data objects.

6. The method of claim 5 further comprising:

the client setting the last update time of the set of data objects equal to the modification time of the last data object provided by the server.

7. The method of claim 4, wherein the server providing a plurality of data objects further comprises:

maintaining a set modification time for the set of data objects, wherein the set modification time indicates a last time at which a value of any data object in the set of data objects was modified in the database; and

determining whether the set modification time is greater than the last update time of the set of data objects.

8. The method of claim 1 further comprising:

the client determining whether a data object provided by the server was deleted from the database; and

the client deleting a corresponding data object from the storage if the data object was deleted from the database.

9. An apparatus comprising a client having a storage, a server having a database, a network coupling the client to the server, and executable programs comprising:

an executable program on the client for providing a last update time to the server, wherein the last update time indicates a last time at which the client received an update from the server; and

an executable program on the server for maintaining a modification time for each data object in the database, wherein the modification time is an integral value of each data object that indicates a last time at which a value of the data object was modified in the database, and for providing a plurality of data objects stored in the database to the client, each of the plurality of data objects having a modification time greater than the last update time.

10. The apparatus of claim 9, wherein the executable program on the server further comprises:

sorting the data objects based on the modification time of each data object.

11. The apparatus of claim 10, wherein the executable program on the client further comprises:

setting the last update time equal to the modification time of the last data object provided by the server.

12. The apparatus of claim 10, wherein the executable program on the client further comprises:

providing a last update time of a set of data objects to the server, wherein the last update time of a set of data objects indicates the last time at which the client received an update of the set of data objects from the server.

13. The apparatus of claim 12, wherein the executable program on the server further comprises:

providing a plurality of data objects of the set of data objects stored in the database to the client, a value of the data objects having been updated in the database at a time later than the last update time of the set of data objects.

14. The apparatus of claim 13, wherein the executable program on the client further comprises:

setting the last update time of the set of data objects equal to the modification time of the last data object provided by the server.

15. The apparatus of claim 12, wherein the executable program on the server further comprises:

maintaining a set modification time for a set of data objects, wherein the set modification time indicates the last time at which a value of any data object in the set of data objects was modified in the database; and

determining whether the set modification time is greater than the last update time of the set of data objects.

16. The apparatus of claim 9, wherein the executable program on the client further comprises:

determining whether a data object provided by the server was deleted from the database; and

deleting the corresponding data object from the storage if the data object was deleted from the database.

17. A computer-readable storage medium storing software executable by a computer system, the software including instructions for:

providing a last update time stored in a storage of a client to a server, wherein the last update time indicates the last time at which the client received an update of the storage with data objects of a database stored in the server; and

providing a plurality of data objects stored in the database to the client, a value of the data objects having been modified in the database at a time later than the last update time.

18. The computer-readable storage medium of claim 17, wherein the providing a plurality of data objects stored in the database to the client further includes instructions for:

sorting the data objects based on a modification time of each data object, wherein the modification time is an integral value of each data object that indicates a last time at which a value of the data object was modified in the database.

19. The computer-readable storage medium of claim 18 further including instructions for:

setting the last update time equal to the modification time of the last data object provided by the server.

20. The computer-readable storage medium of claim 17 further including instructions for:

maintaining in the database a set modification time for a set of data objects, wherein the set modification time indicates the last time at which a value of any data object in the set of data objects was modified in the database; and

determining whether the set modification time is greater than the last update time of the set of data objects.

21. The computer-readable medium of claim 17 further including instructions for:

determining whether a data object provided by the server was deleted from the database; and

deleting the corresponding data object from the storage if the data object was deleted from the database.

22. The computer-readable medium of claim 17 further including instructions for:

managing a distributed system and monitoring the performance of the distributed system.