US5999947A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Distributing database differences corresponding to database change events made to a database table located on a server computer
Assignee: Pure Data Systems LLC
•
Filing: 1997-05-27
•
Granted: 1999-12-07
•
Expires: 2017-05-27
Abstract
Abstract A method, computer program product, and system that allows changes made to an original database table found on a server computer to be reflected in client copies of the database table based on intermittent client requests for synchronization. A server makes periodic updates of table differences between a current table receiving database change events and a reference table. Each client copy of a database table and update created by the server has a sequential version number associated therewith. The server will compare the version number of a client copy of a database table with the most recent version number of the table on the server to determine which updates need be applied in order to make the client copy current. Next, the updates will be translated from a generic format into instructions that are specific to the type of database engine being run on the client. Finally, the instructions are transmitted to the client (along with the new version number) so that the client may operate the database engine to apply the instructions for making the database table current with the original managed on the server.
Inventors
- 👤 John M. Zollinger
- 👤 Johnathan Devine
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-29 18:34
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/27; G06F16/275; G06F16/273; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99951; Y10S707/99952; Y10S707/99954
Claims Analysis
Total Claims: 17
Claim 1
Independent Claim
200 words
A method of distributing database differences corresponding to change events made to a database table located on a server computer to client copies of the database table located on one or more client computers comprising the steps of: creating and storing on the server computer one or more sequentially versioned updates, each update containing database differences in a generic format, the database differences corresponding to database change events made to the database table since the preceding update; receiving, from a client computer, a request for all the database differences needed to make the client copy of the database table current; determining which updates are necessary for making the client copy of the database table current; ascertaining a client database engine type wherein the client copy of the database table is held; generating and translating specific database differences, selected based on the necessary updates, into instructions based on the ascertained database engine type prior to transmission; and transmitting the specific database differences to the client computer so that the client computer may execute the instructions on the client database engine, thereby making the client copy of the database table current in response to the specific database differences translated into the instructions.
Claim 2
Independent Claim
200 words
A method of distributing database differences corresponding to change events made to a database table located on a server computer to client copies of the database table located on one or more client computers comprising the steps of: creating and storing on the server computer one or more sequentially versioned updates, each update containing database differences in a generic format, the database differences corresponding to database change events made to the database table since the preceding update; receiving, from a client computer, a request for all the database differences needed to make the client copy of the database table current; determining which updates are necessary for making the client copy of the database table current; ascertaining a client database engine type wherein the client copy of the database table is held; generating and translating specific database differences, selected based on the necessary updates, into instructions based on the ascertained database engine type prior to transmission; and transmitting the specific database differences to the client computer so that the client computer may execute the instructions on the client database engine, thereby making the client copy of the database table current in response to the specific database differences translated into the instructions.
Claim 3
Dependent Claim
30 words
A method as recited in claim 1 wherein the client database engine type is ascertained by the client computer supplying the client database engine type as part of the request.
Claim 4
Dependent Claim
24 words
A method as recited in claim 1 wherein the client database engine type is ascertained by reference to profile information regarding the client computer.
Claim 5
Dependent Claim
35 words
A method as recited in claim 1, further comprising the step of receiving from the client computer a plurality of requests for synchronization, wherein the plurality of requests for synchronization are received randomly in time.
Claim 6
Dependent Claim
17 words
A method as recited in claim 1 wherein the client is intermittently connected to the server computer.
Claim 7
Independent Claim
135 words
A method of distributing database differences corresponding to database change events made to a database table located on a server computer to client copies of the database table located on one or more client computers, each client computer capable of having different database engines comprising the steps of: storing database differences at the server computer in a generic format; receiving from a client computer a request for all database differences needed to make a client copy of the database table current; translating the differences from the generic format into instructions having a specific format compatible with the type of database engine associated with the client copy of the database table; and transmitting the instructions to the client computer for execution on the client database engine to make the client copy of the database table current.
Claim 8
Independent Claim
135 words
A method of distributing database differences corresponding to database change events made to a database table located on a server computer to client copies of the database table located on one or more client computers, each client computer capable of having different database engines comprising the steps of: storing database differences at the server computer in a generic format; receiving from a client computer a request for all database differences needed to make a client copy of the database table current; translating the differences from the generic format into instructions having a specific format compatible with the type of database engine associated with the client copy of the database table; and transmitting the instructions to the client computer for execution on the client database engine to make the client copy of the database table current.
Claim 9
Dependent Claim
30 words
A method as recited in claim 6 wherein the type of database engine is ascertained by the client computer supplying the type of database engine as part of the request.
Claim 10
Dependent Claim
24 words
A method as recited in claim 6 wherein the type of database engine is ascertained by reference to profile information regarding the client computer.
Claim 11
Dependent Claim
77 words
A method as recited in claim 6 further comprising the steps of: creating and storing on the server computer one or more sequentially versioned updates containing database differences corresponding to database change events made to the database table since the preceding update; determining which updates are necessary for making the client copy of the database table current; and generating the database differences based upon the necessary updates prior to the step of translating the differences into instructions.
Claim 12
Dependent Claim
49 words
A method as recited in claim 9 wherein the client computer supplies a client version of the client copy of the database table as part of the request and the step of determining which updates are necessary is done by comparing the client version with the latest update version.
Claim 13
Dependent Claim
46 words
A method as recited in claim 9 wherein a client version of the client copy of the database table is referenced from client profile information and the step of determining which updates are necessary is done by comparing the client version with a latest update version.
Claim 14
Dependent Claim
14 words
A computer-readable medium having computer-executable instructions for performing the steps recited in claim 6.
Claim 15
Dependent Claim
17 words
A method as recited in claim 6 wherein the client is intermittently connected to the server computer.
Claim 16
Dependent Claim
224 words
A computer program product comprising: a computer usable medium having computer readable program code means embodied in said medium for distributing database differences corresponding to database change events made to a database table located on a server computer to client copies of the database table located on one or more client computers, each client computer capable of having one or more database engines, said computer readable program code means comprising; means for creating and storing on the server computer one or more sequentially versioned updates, each update containing database differences that are stored in a generic format and correspond to database change events made to the database table since the preceding update; means for receiving from a client computer a request for all the database differences needed to make the client copy of the database table current; means for determining which updates are necessary for making the client copy of the database table current; means for ascertaining the client database type associated with the client copy of the database table; means for translating the specific differences based upon the necessary updates from the generic format into instructions having a specific format compatible with the client database type; and means for transmitting the instructions to the client computer for execution on the client database engine to make the client copy of the database table current.
Claim 17
Dependent Claim
224 words
A computer program product comprising: a computer usable medium having computer readable program code means embodied in said medium for distributing database differences corresponding to database change events made to a database table located on a server computer to client copies of the database table located on one or more client computers, each client computer capable of having one or more database engines, said computer readable program code means comprising; means for creating and storing on the server computer one or more sequentially versioned updates, each update containing database differences that are stored in a generic format and correspond to database change events made to the database table since the preceding update; means for receiving from a client computer a request for all the database differences needed to make the client copy of the database table current; means for determining which updates are necessary for making the client copy of the database table current; means for ascertaining the client database type associated with the client copy of the database table; means for translating the specific differences based upon the necessary updates from the generic format into instructions having a specific format compatible with the client database type; and means for transmitting the instructions to the client computer for execution on the client database engine to make the client copy of the database table current.
References Cited (Backward Citations)
US5341498A
Cited
US5873088A
Cited
US5261094A
Cited
US5737536A
Cited
US5493728A
Cited
US5600834A
Cited
US5689697A
Cited
US5634052A
Cited
US5832487A
Cited
US5689708A
Cited
US5682524A
Cited
US5765171A
Cited
US5752042A
Cited
US5884324A
Cited
US5758355A
Cited
US5870765A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-12-06 | 2003-06-07 | 2003-12-07 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-12-06 | 2007-06-07 | 2007-12-07 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-12-06 | 2011-06-07 | 2011-12-07 | $7700.00 | Window Closed / Lapsed |