US6714935B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Management of non-persistent data in a persistent database
Assignee: Microsoft Technology Licensing LLC
•
Filing: 1998-09-21
•
Granted: 2004-03-30
•
Expires: 2018-09-21
Abstract
Abstract A method of managing non-persistent data in a persistent database includes adding the non-persistent data to the database in the form of a temporary entry. The temporary entry can be a temporary row or column, a temporary table or a temporary database with temporary tables. The method also includes tracking the non-persistent data in order to maintain the original state of the persistent database. A column of temporary bits is added to track the rows, and the temporary columns are tracked via a bit in the schema. Non-persistent temporary entries can be added to any relational database to manipulate data while maintaining the original state of the database. Using temporary entries is advantageous when a large amount of data already exists in a database and a user needs to enhance and/or manipulate the data while still retaining the original state of the data.
Inventors
- 👤 John C. Delo
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-07 05:52
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/245; G06F16/2458; G06F16/2477; G06F16/242; G06F16/2433; G06F16/2448; G06F16/28; G06F16/284; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/954; Y10S707/99931; Y10S707/99932; Y10S707/99933; Y10S707/99941; Y10S707/99942; Y10S707/99943
Claims Analysis
Total Claims: 40
Claim 1
Independent Claim
57 words
A computerized method of managing integrated non-persistent data in a persistent database, the method comprising: creating an integrated entry in a persistent database; identifying the integrated entry as an entry containing non-persistent data; and ignoring the integrated entry when writing the persistent database to a computer readable medium to preserve the original state of the persistent database.
Claim 2
Dependent Claim
57 words
A computerized method of managing integrated non-persistent data in a persistent database, the method comprising: creating an integrated entry in a persistent database; identifying the integrated entry as an entry containing non-persistent data; and ignoring the integrated entry when writing the persistent database to a computer readable medium to preserve the original state of the persistent database.
Claim 3
Dependent Claim
22 words
The method of claim 1 , wherein the integrated entry is created as a column of a table in the persistent database.
Claim 4
Dependent Claim
23 words
The method of claim 2 , wherein the integrated entry is identified by at least one bit in a schema for the table.
Claim 5
Dependent Claim
22 words
The method of claim 1 , wherein the integrated entry is created as a row of a table in the persistent database.
Claim 6
Dependent Claim
31 words
The method of claim 4 , wherein the integrated entry is identified by a reserved column in the table, the reserved column containing data identifying the row as containing non-persistent data.
Claim 7
Dependent Claim
19 words
The method of claim 1 , wherein the integrated entry is created as a table in the persistent database.
Claim 8
Dependent Claim
97 words
A computerized system comprising: a relational database containing persistent data; a database engine for maintaining the relational database; and a database application program interface (API) having extensions for adding an entry containing non-persistent data to the relational database; wherein the database engine integrates the non-persistent data into the relational database with the persistent data while the database exists in memory of a computer and wherein the database engine ignores the non-persistent data in the relational database when writing the relational database to a computer readable medium so that an original state of the persistent data is preserved.
Claim 9
Dependent Claim
97 words
A computerized system comprising: a relational database containing persistent data; a database engine for maintaining the relational database; and a database application program interface (API) having extensions for adding an entry containing non-persistent data to the relational database; wherein the database engine integrates the non-persistent data into the relational database with the persistent data while the database exists in memory of a computer and wherein the database engine ignores the non-persistent data in the relational database when writing the relational database to a computer readable medium so that an original state of the persistent data is preserved.
Claim 10
Dependent Claim
31 words
The system of claim 7 , wherein the non-persistent data exists in the relational database in memory as long as a view is associated with a table containing the non-persistent data.
Claim 11
Dependent Claim
21 words
The system of claim 8 , wherein the entry is added as a column of the table in the relational database.
Claim 12
Dependent Claim
21 words
The system of claim 8 , wherein the entry is added as a row of the table in the relational database.
Claim 13
Dependent Claim
109 words
A computerized system comprising: a relational database containing persistent data; a means for maintaining the relational database; a means for adding an entry containing non-persistent data to the relational database; and a means for identifying the entry containing non-persistent data; wherein the means for maintaining the relational database integrates the non-persistent data into the relational database with the persistent data while the database exists in memory of a computer and wherein the means for maintaining the relational database removes the non-persistent data identified by the means for identifying when writing the relational database to a computer readable medium so that an original state of the persistent data is preserved.
Claim 14
Dependent Claim
109 words
A computerized system comprising: a relational database containing persistent data; a means for maintaining the relational database; a means for adding an entry containing non-persistent data to the relational database; and a means for identifying the entry containing non-persistent data; wherein the means for maintaining the relational database integrates the non-persistent data into the relational database with the persistent data while the database exists in memory of a computer and wherein the means for maintaining the relational database removes the non-persistent data identified by the means for identifying when writing the relational database to a computer readable medium so that an original state of the persistent data is preserved.
Claim 15
Dependent Claim
21 words
The system of claim 11 , wherein the entry is added as a column of a table in the relational database.
Claim 16
Dependent Claim
21 words
The system of claim 11 , wherein the entry is added as a row of a table in the relational database.
Claim 17
Independent Claim
60 words
A method of managing the run-time state of a computer, the method comprising: creating a plurality of integrated entries in a persistent installation database, the integrated entries representing a run-time state of a computer; identifying each one of the integrated entries as an entry containing non-persistent data; and ignoring the entries containing non-persistent data when writing the database to storage.
Claim 18
Independent Claim
60 words
A method of managing the run-time state of a computer, the method comprising: creating a plurality of integrated entries in a persistent installation database, the integrated entries representing a run-time state of a computer; identifying each one of the integrated entries as an entry containing non-persistent data; and ignoring the entries containing non-persistent data when writing the database to storage.
Claim 19
Dependent Claim
23 words
The method of claim 14 , wherein at least one of the integrated entries indicates a software component is installed on a computer.
Claim 20
Dependent Claim
16 words
The method of claim 14 , wherein the method is performed during the application installation process.
Claim 21
Dependent Claim
20 words
The method of claim 16 , wherein one or more of the integrated entries tracks the progress of the installation.
Claim 22
Dependent Claim
21 words
The method of claim 16 , wherein one or more of the integrated entries tracks a current state of the computer.
Claim 23
Dependent Claim
28 words
The method of claim 16 , wherein one or more of the integrated entries tracks a desired state of the computer upon completion of the application installation process.
Claim 24
Dependent Claim
71 words
A computer readable medium having instructions stored thereon for causing a computer to perform a method of managing integrated non-persistent data in a persistent database, the method comprising: creating an integrated entry in a persistent database; identifying the integrated entry as an entry containing non-persistent data; and ignoring the integrated entry prior to saving the persistent database to a computer readable medium to preserve the original state of the persistent database.
Claim 25
Dependent Claim
71 words
A computer readable medium having instructions stored thereon for causing a computer to perform a method of managing integrated non-persistent data in a persistent database, the method comprising: creating an integrated entry in a persistent database; identifying the integrated entry as an entry containing non-persistent data; and ignoring the integrated entry prior to saving the persistent database to a computer readable medium to preserve the original state of the persistent database.
Claim 26
Dependent Claim
31 words
The computer readable medium of claim 20 , further comprising maintaining the integrated entry in memory as long as at least one view is associated with a table containing the entry.
Claim 27
Dependent Claim
70 words
A computer readable medium having instructions stored thereon for causing a computer to perform a method of managing the run-time state of a computer, the method comprising: integrating a plurality of entries in a persistent installation database, the entries representing a run-time state of a computer; identifying each one of the entries as an entry containing non-persistent data; ignoring the entries containing non-persistent data when writing the database to storage.
Claim 28
Dependent Claim
70 words
A computer readable medium having instructions stored thereon for causing a computer to perform a method of managing the run-time state of a computer, the method comprising: integrating a plurality of entries in a persistent installation database, the entries representing a run-time state of a computer; identifying each one of the entries as an entry containing non-persistent data; ignoring the entries containing non-persistent data when writing the database to storage.
Claim 29
Dependent Claim
24 words
The computer readable medium of claim 22 , wherein at least one of the entries indicates a current state of software on the computer.
Claim 30
Dependent Claim
24 words
The computer readable medium of claim 22 , wherein at least one of the entries indicates a desired state of software on the computer.
Claim 31
Dependent Claim
61 words
A computerized system comprising: a database engine for managing a relational database containing persistent data; an interface for specifying temporary data to be integrated into the relational database; and a module that modifies the database with the temporary data and identifies the temporary data as non-persistent data such that the non-persistent data is ignored when writing the database to permanent storage.
Claim 32
Dependent Claim
61 words
A computerized system comprising: a database engine for managing a relational database containing persistent data; an interface for specifying temporary data to be integrated into the relational database; and a module that modifies the database with the temporary data and identifies the temporary data as non-persistent data such that the non-persistent data is ignored when writing the database to permanent storage.
Claim 33
Dependent Claim
54 words
A database stored on a computer readable medium comprising: a plurality of rows and columns of persistent data; at least one entry of non-persistent data wherein the entry is a row or a column; and an indicator identifying the non-persistent data so that when writing the database to storage the non-persistent data is ignored.
Claim 34
Dependent Claim
54 words
A database stored on a computer readable medium comprising: a plurality of rows and columns of persistent data; at least one entry of non-persistent data wherein the entry is a row or a column; and an indicator identifying the non-persistent data so that when writing the database to storage the non-persistent data is ignored.
Claim 35
Dependent Claim
64 words
A computerized method of managing non-persistent data in a relational database, the method comprising: creating an entry in the relational database, the relational database being adapted to contain persistent data; identifying the entry as an entry containing non-persistent data; wherein the non-persistent data is integrated with any persistent data in the relational database; and ignoring the non-persistent data when writing the database to storage.
Claim 36
Dependent Claim
64 words
A computerized method of managing non-persistent data in a relational database, the method comprising: creating an entry in the relational database, the relational database being adapted to contain persistent data; identifying the entry as an entry containing non-persistent data; wherein the non-persistent data is integrated with any persistent data in the relational database; and ignoring the non-persistent data when writing the database to storage.
Claim 37
Dependent Claim
45 words
A computerized system comprising: a relational database containing persistent data; a database engine for maintaining the relational database; wherein the database engine integrates the non-persistent data into the relational database with the persistent data; and ignoring the non-persistent data when writing the database to storage.
Claim 38
Dependent Claim
45 words
A computerized system comprising: a relational database containing persistent data; a database engine for maintaining the relational database; wherein the database engine integrates the non-persistent data into the relational database with the persistent data; and ignoring the non-persistent data when writing the database to storage.
Claim 39
Dependent Claim
56 words
A database stored on a computer-readable medium comprising: a plurality of rows and columns of persistent data; at least one entry of non-persistent data wherein the entry is a row or a column; wherein the non-persistent data is integrated with the persistent data; and wherein the non-persistent data is ignored when writing the database to storage.
Claim 40
Dependent Claim
56 words
A database stored on a computer-readable medium comprising: a plurality of rows and columns of persistent data; at least one entry of non-persistent data wherein the entry is a row or a column; wherein the non-persistent data is integrated with the persistent data; and wherein the non-persistent data is ignored when writing the database to storage.
References Cited (Backward Citations)
US4769772A
Cited
US5280610A
Cited
US5937435A
Cited
US5724575A
Cited
US6151702A
Cited
US5701461A
Cited
US5870611A
Cited
US5799310A
Cited
US5717924A
Cited
US6112199A
Cited
US5794030A
Cited
US5819251A
Cited
US6128771A
Cited
US5758337A
Cited
US5765147A
Cited
US5930795A
Cited
US5933647A
Cited
US6006224A
Cited
US5930779A
Cited
US5937402A
Cited
US6049807A
Cited
US6016553A
Cited
US6058389A
Cited
US6076090A
Cited
US6158001A
Cited
US6016497A
Cited
US6151608A
Cited
US6119129A
Cited
US6085198A
Cited
US6115715A
Cited
US6421711B1
Cited
US6341288B1
Cited
US6499036B1
Cited
US6237144B1
Cited
US6378127B1
Cited
US6542899B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2007-03-30 | 2007-09-29 | 2008-03-30 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2011-03-30 | 2011-09-29 | 2012-03-30 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2015-03-30 | 2015-09-29 | 2016-03-30 | $7700.00 | Window Closed / Lapsed |