US6480847B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Database repository with deferred transactions
Assignee: SAGENT TECHNOLOGIES Inc
•
Filing: 1999-01-29
•
Granted: 2002-11-12
•
Expires: 2019-01-29
Abstract
Abstract A deferred transaction mechanism facilitates multi-threaded operation of database application programs. The deferred transaction mechanism allows data items to be committed from the local memory of a computer system to a database system in a background thread, while other foreground threads continue to read the data item. In most instances, this makes the delay in committing a data item to the database imperceptible to a human user of a database application program. The deferred transaction mechanism further supports an “undo” feature, which allows modifications to a data item located in a computer's local memory to be rapidly discarded.
Inventors
- 👤 Terris J. Linenbach
- 👤 Vladimir Gorelik
- 👤 Craig R. Powers
- 👤 Robert E. Powers
- 👤 Tana C. Netsch
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-04 06:53
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/23; G06F16/2308; G06F16/2336; G06F16/2343; G06F16/2379; G06F16/25; G06F16/252; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/954; Y10S707/99931; Y10S707/99938; Y10S707/99941; Y10S707/99944; Y10S707/99945; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 19
Claim 1
Independent Claim
135 words
An apparatus for modifying a data item, comprising: a client computer system including a first memory to store said data item, wherein said data item is modified in response to a request of a user of the client computer system; a database server, coupled to said client computer system, to store a plurality of data items including said data item; said computer system including a plurality of processes comprising at least one user process and at least one other process; wherein the client computer system is operable to create a lock on the data item being modified to allow said at least one user process to read the modified data item from said first memory, while said at least one other process writes the modified data item from said first memory to said database server.
Claim 2
Independent Claim
135 words
An apparatus for modifying a data item, comprising: a client computer system including a first memory to store said data item, wherein said data item is modified in response to a request of a user of the client computer system; a database server, coupled to said client computer system, to store a plurality of data items including said data item; said computer system including a plurality of processes comprising at least one user process and at least one other process; wherein the client computer system is operable to create a lock on the data item being modified to allow said at least one user process to read the modified data item from said first memory, while said at least one other process writes the modified data item from said first memory to said database server.
Claim 3
Dependent Claim
25 words
The apparatus of claim 1 , wherein said client computer system includes a user interface for modifying said data item in response to user input.
Claim 4
Dependent Claim
42 words
The apparatus of claim 1 , wherein said client computer system is to create a write lock on said data item, the write lock blocking said at least one other process from reading said data item and writing to said data item.
Claim 5
Dependent Claim
25 words
The apparatus of claim 1 , in which said lock is a read lock blocking said plurality of processes from writing to said data item.
Claim 6
Dependent Claim
22 words
The apparatus of claim 1 , wherein said at least one other process includes an event process to release said read lock.
Claim 7
Dependent Claim
15 words
The apparatus of claim 1 , wherein said database server comprises a database management system.
Claim 8
Dependent Claim
20 words
The apparatus of claim 6 further comprising at least one on-line transaction processing system to access said database management system.
Claim 9
Dependent Claim
16 words
The apparatus of claim 6 further comprising a data warehouse to access said database management system.
Claim 10
Independent Claim
118 words
A method for selectively undoing modification to a data item, comprising: creating in a first memory an original version of a data item that is stored in a database server, the first memory being included in a client computer system coupled to the database server; making a first copy of the original version in the first memory; modifying said first copy of the original version in the first memory; creating a second copy from said original version in the first memory, when a command is received to undo said modifications; and creating a new data item in the database server from the modified first copy of the original version, when a command is received to commit said modifications.
Claim 11
Independent Claim
118 words
A method for selectively undoing modification to a data item, comprising: creating in a first memory an original version of a data item that is stored in a database server, the first memory being included in a client computer system coupled to the database server; making a first copy of the original version in the first memory; modifying said first copy of the original version in the first memory; creating a second copy from said original version in the first memory, when a command is received to undo said modifications; and creating a new data item in the database server from the modified first copy of the original version, when a command is received to commit said modifications.
Claim 12
Dependent Claim
15 words
The method of claim 9 , wherein the database server comprises a database management system.
Claim 13
Dependent Claim
20 words
The method of claim 9 further comprising storing the modified first copy of the original version to a relational database.
Claim 14
Dependent Claim
23 words
The method of claim 10 , wherein said data item comprises metadata, which describes relationships between data items in said database management system.
Claim 15
Dependent Claim
111 words
The method of claim 9 , wherein creating a new data item from said copy comprises: setting a read lock on said modified first copy in the first memory, which allows said plurality of processes to read said modified first copy, but blocks said plurality of processes from modifying said modified first copy; creating a new data item from said modified first copy; copying said modified first copy from said first memory to said database server, wherein a time interval to create said new data item and to copy said modified first copy defines a copy latency; reading said modified first copy during said copy latency; and releasing said read lock.
Claim 16
Independent Claim
123 words
An apparatus for selectively undoing modification to a data item, comprising: a database server to store a plurality of data items, including a particular data item; and a client computer system, coupled to the database server, to create a first copy of the particular data item in a first memory of the client computer system, to modify the first copy of the particular data item in the first memory, to create a second copy of the particular data item in the first memory when receiving a command to undo the modification, and to trigger a creation of a new data item in the database server from the modified first copy of the particular data item when receiving a command to commit the modification.
Claim 17
Independent Claim
123 words
An apparatus for selectively undoing modification to a data item, comprising: a database server to store a plurality of data items, including a particular data item; and a client computer system, coupled to the database server, to create a first copy of the particular data item in a first memory of the client computer system, to modify the first copy of the particular data item in the first memory, to create a second copy of the particular data item in the first memory when receiving a command to undo the modification, and to trigger a creation of a new data item in the database server from the modified first copy of the particular data item when receiving a command to commit the modification.
Claim 18
Dependent Claim
124 words
A machine-readable medium containing instructions which, when executed by a processing system, cause the processing system to: create in a first memory an original version of a data item that is stored in a database server, the first memory being included in a client computer system coupled to the database server; make a first copy of the original version in the first memory; modify said first copy of the original version in the first memory; create a second copy from said original version in the first memory, when a command is received to undo said modifications; and create a new data item in the database server from the modified first copy of the original version, when a command is received to commit said modifications.
Claim 19
Dependent Claim
124 words
A machine-readable medium containing instructions which, when executed by a processing system, cause the processing system to: create in a first memory an original version of a data item that is stored in a database server, the first memory being included in a client computer system coupled to the database server; make a first copy of the original version in the first memory; modify said first copy of the original version in the first memory; create a second copy from said original version in the first memory, when a command is received to undo said modifications; and create a new data item in the database server from the modified first copy of the original version, when a command is received to commit said modifications.
References Cited (Backward Citations)
US4965719A
Cited
US5212788A
Cited
US5832481A
Cited
US5752018A
Cited
US5566330A
Cited
US5701480A
Cited
US5692178A
Cited
US5586315A
Cited
US5649200A
Cited
US5666546A
Cited
US5689706A
Cited
US5809503A
Cited
US5499365A
Cited
US5485369A
Cited
US5678040A
Cited
US5715428A
Cited
US5564044A
Cited
US5781915A
Cited
US5675785A
Cited
US5742813A
Cited
US5813016A
Cited
US5826253A
Cited
US5682537A
Cited
US6128771A
Cited
US6321234B1
Cited
US6256712B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2005-11-11 | 2006-05-13 | 2006-11-12 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2009-11-11 | 2010-05-13 | 2010-11-12 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2013-11-11 | 2014-05-13 | 2014-11-12 | $7700.00 | Window Closed / Lapsed |