Patent US5737536A successfully refreshed from Google Patents.
US5737536A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and methods for optimized access in a multi-user environment
Assignee: Borland Software Corp
•
Filing: 1995-11-02
•
Granted: 1998-04-07
•
Expires: 2015-11-02
Abstract
Abstract A client/server system providing methods of utilizing information stored locally on a client even after the client has modified data on the server is described. A client stores data from the server in a local "read-only" buffer(s), to speed up access to the data and reduce network traffic. Since the buffer is treated as a "read only" buffer, no locks are taken out at the server by the client. Accesses to particular data records are satisfied by looking first to the local buffer or cache. The client may proceed to modify the data records and commit changes back to the server. Moreover, the client updates or "writes through" the "read-only" buffer(s) with the changes so that the local buffer remains valid. The methods of updating data stored locally on the client provide significant performance increases as the client does not have to refresh data from the server.
Inventors
- 👤 Conrad Herrmann
- 👤 Randolph T. Solton
- 👤 Raymond Shigeru Kiuchi
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-25 18:52
CPC Classifications
G; G09; G09G; G09G5/00; G09G5/36; G09G5/39; G09G5/393; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/245; G06F16/2455; G06F16/24552
Claims Analysis
Total Claims: 22
Claim 1
Independent Claim
239 words
In a system comprising a computer network comprising a server for storing information records which may be shared among a plurality of client workstations, each of said client workstations having a processor and a memory, a method for providing a client access to information records stored on the server, the method comprising the steps of: receiving from a process executing at the client a request for access to particular records stored on the server; allocating a buffer in the memory of the client, said buffer for storing copies of said particular records; transferring copies of said particular records from the server into the buffer of the client, said transferring step being performed with shared access to said particular records; satisfying said request by providing said process access to said copies of said particular records from said buffer; receiving at the client input for modifying at least one of said particular records; transferring said modified at least one of said particular records from the client to the server; updating copies of records in the buffer which correspond to said modified at least one of said particular records so that said step of transferring said modified at least one of said particular records from the client to the server does not render the buffer invalid; and periodically marking the buffer as invalid regardless of whether modifications have been posted from clients to the server, upon expiration of a pre-selected time interval.
Claim 2
Dependent Claim
239 words
In a system comprising a computer network comprising a server for storing information records which may be shared among a plurality of client workstations, each of said client workstations having a processor and a memory, a method for providing a client access to information records stored on the server, the method comprising the steps of: receiving from a process executing at the client a request for access to particular records stored on the server; allocating a buffer in the memory of the client, said buffer for storing copies of said particular records; transferring copies of said particular records from the server into the buffer of the client, said transferring step being performed with shared access to said particular records; satisfying said request by providing said process access to said copies of said particular records from said buffer; receiving at the client input for modifying at least one of said particular records; transferring said modified at least one of said particular records from the client to the server; updating copies of records in the buffer which correspond to said modified at least one of said particular records so that said step of transferring said modified at least one of said particular records from the client to the server does not render the buffer invalid; and periodically marking the buffer as invalid regardless of whether modifications have been posted from clients to the server, upon expiration of a pre-selected time interval.
Claim 3
Dependent Claim
25 words
The method of claim 1, wherein said particular records on the server includes database records stored in at least one record block on the server.
Claim 4
Dependent Claim
36 words
The method of claim 2, wherein said step of transferring said modified at least one of said particular records from the client to the server includes transferring said at least one record block to the client.
Claim 5
Dependent Claim
21 words
The method of claim 1, further comprising the step of marking the buffer as valid upon completion of said updating step.
Claim 6
Dependent Claim
54 words
The method of claim 1, further comprising: receiving a subsequent request from a process executing at the client for access to records stored on the server; and if the records of the subsequent request are in the buffer, satisfying said request by providing access to said copies of said particular records from said buffer.
Claim 7
Dependent Claim
78 words
The method of claim 1, further comprising: receiving a query condition for selecting particular records; creating a filter bitmap of those records which meet the query condition; and upon occurrence of said step of transferring said modified at least one of said particular records from the client to the server, updating portions of said bitmap which correspond to said modified at least one of said particular records so that said transfer step does not render the bitmap invalid.
Claim 8
Dependent Claim
47 words
The method of claim 6, wherein said step of creating a filter bitmap of those records which meet the query condition comprises setting a bit for each record which meets the query condition and resetting the bit for each record which does not meet the query condition.
Claim 9
Dependent Claim
50 words
The method of claim 7, wherein said step of updating portions of said bitmap comprises: re-applying the query condition to each modified record, and setting a bit for each record which now meets the query condition and resetting the bit for each record which no longer meets the query condition.
Claim 10
Dependent Claim
45 words
The method of claim 1, wherein said satisfying step includes: providing said process executing at the client access to said copies of said particular records from said buffer by copying the records to a region in the memory of the client other than the buffer.
Claim 11
Dependent Claim
167 words
A server-based networking system with improved data access, comprising: a server having a storage device for storing records in blocks; at least one client operably coupled to said server through a communication line, each said at least one client having a processor and a memory; means for copying at least one of the blocks from the server into a local buffer in the memory of a client; means for accessing records from said local buffer; means, responsive to input at said client, for modifying records which are accessed from said local buffer; means for posting modified records to said server; means for determining whether any modified records posted to said server exist in said local buffer; means for updating copies of records in the local buffer which correspond to said records posted to said server from said client; and means for periodically marking said local buffer as invalid regardless of whether modifications have been posted from clients to the server, upon expiration of a preselected time interval.
Claim 12
Dependent Claim
167 words
A server-based networking system with improved data access, comprising: a server having a storage device for storing records in blocks; at least one client operably coupled to said server through a communication line, each said at least one client having a processor and a memory; means for copying at least one of the blocks from the server into a local buffer in the memory of a client; means for accessing records from said local buffer; means, responsive to input at said client, for modifying records which are accessed from said local buffer; means for posting modified records to said server; means for determining whether any modified records posted to said server exist in said local buffer; means for updating copies of records in the local buffer which correspond to said records posted to said server from said client; and means for periodically marking said local buffer as invalid regardless of whether modifications have been posted from clients to the server, upon expiration of a preselected time interval.
Claim 13
Dependent Claim
19 words
The system of claim 10, further comprising means for marking the buffer as valid when the buffer is updated.
Claim 14
Dependent Claim
84 words
The system of claim 10, further comprising: means for receiving a query condition for selecting particular records; means for creating a filter bitmap of those records which meet the query condition; and means for updating portions of said bitmap which correspond to said modified at least one of said particular records so that said transfer step does not render the bitmap invalid, upon occurrence of said step of transferring said modified at least one of said particular records from the client to the server.
Claim 15
Dependent Claim
55 words
The system of claim 10, wherein said means for copying at least one of the blocks from the server into a local buffer in the memory of the client includes: means for copying without exclusive access at least one of the blocks from the server into a local buffer in the memory of the client.
Claim 16
Dependent Claim
153 words
A server-based networking system with improved data access comprising: (a) a server having a storage device; (b) at least one client operably coupled to said server through a communication line, each said at least one client having a processor and a memory; (c) means for transferring a valid copy of data from the storage device of the server to memory of a client; (d) means, responsive to a request for data, for providing access to the valid copy of the data in the memory of the client; (e) time-based means for periodically marking the copy as invalid regardless of whether modifications have been posted from clients to the server; (f) modification means for creating a modified copy of the data and posting the modified copy to the server; and (g) update means for updating the copy of the data in the memory of the client, upon posting the modified copy to the server.
Claim 17
Dependent Claim
153 words
A server-based networking system with improved data access comprising: (a) a server having a storage device; (b) at least one client operably coupled to said server through a communication line, each said at least one client having a processor and a memory; (c) means for transferring a valid copy of data from the storage device of the server to memory of a client; (d) means, responsive to a request for data, for providing access to the valid copy of the data in the memory of the client; (e) time-based means for periodically marking the copy as invalid regardless of whether modifications have been posted from clients to the server; (f) modification means for creating a modified copy of the data and posting the modified copy to the server; and (g) update means for updating the copy of the data in the memory of the client, upon posting the modified copy to the server.
Claim 18
Dependent Claim
29 words
The system of claim 14, wherein said processor is an Intel® 80×86 class microprocessor and wherein said time-based means includes a real-time clock (RTC) capable of generating preemptive interrupts.
Claim 19
Dependent Claim
38 words
The system of claim 15, wherein said time-based means includes means responsive to interrupts from the RTC for transferring a new copy of the data from the storage device of the server to the memory of the client.
Claim 20
Dependent Claim
16 words
The system of claim 14, wherein said time interval is empirically selected to optimize data access.
Claim 21
Dependent Claim
20 words
The system of claim 14, wherein the time interval is selected from a range of about 1 to 4 seconds.
Claim 22
Dependent Claim
14 words
The system of claim 14, wherein the time interval substantially equals about 2 seconds.
References Cited (Backward Citations)
US4594656A
Cited
US4714996A
Cited
US4887204A
Cited
US4897781A
Cited
US5151989A
Cited
US5133075A
Cited
US5113519A
Cited
WO1991003024A1
Cited
US5265235A
Cited
US5493728A
Cited
US5581704A
Cited
US5434994A
Cited
US5603019A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-04-06 | 2001-10-06 | 2002-04-07 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-04-06 | 2005-10-06 | 2006-04-07 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-04-06 | 2009-10-06 | 2010-04-07 | $7700.00 | Window Closed / Lapsed |