← Back to Patent Explorer
US5946700A Expired / Lapsed US ⏱️ 0.0 years remaining

Method and apparatus for preserving non-current information that can be overwritten in a computer file

Assignee: Oracle International Corp
•
Filing: 1997-10-31
•
Granted: 1999-08-31
•
Expires: 2017-10-31
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

Abstract

Abstract A method and system periodically copies information from a computer file to a database to preserve non-current information from the file. As information from the file is overwritten by new information, the old information is preserved in the database, allowing non-current information to be used without reprogramming the computer programs or portions of the computer program that read or write the file. If the file is arranged into one or more sections, and new information stored in a section of the file is assigned an identifier higher than the other information in the section, the amount of time required to locate new information in the file can be reduced. Comparing the highest identifier in the section with the highest identifier in the database for that section can identify sections of the file that have received no new information since the last update made to the database.

Inventors

  • 👤 Gregory Pongracz
  • 👤 Tuomas Pystynen

Bibliographic Details

Application Number —
Jurisdiction US
Data Source google_patents
Last Synchronized 2026-11-04 08:56
CPC Classifications
G; G06; G06F; G06F11/00; G06F11/07; G06F11/14; G06F11/1446; G06F11/1448; G06F11/1451; G06F11/1471; G06F16/00; G06F16/20; G06F16/23; G06F16/2308; G06F16/2315; G06F16/2329; G06F16/2358; G06F2201/00; G06F2201/80; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99938; Y10S707/99951; Y10S707/99952; Y10S707/99953; Y10S707/99954

Claims Analysis

Total Claims: 32
Claim 1
Independent Claim 156 words
A method of updating a database comprising information from a file comprising at least one section, each section comprising at least one block of information, each block having a first identifier, the file additionally comprising a set of a plurality of second identifiers, each second identifier corresponding to at least one of the first identifiers, the database comprising a set of a plurality of third identifiers, each third identifier corresponding to at least one of the second identifiers from a version of the file, the method comprising: a. comparing at least one of the second identifiers with at least one of the third identifiers corresponding to said at least one of the second identifiers; and b. responsive to the at least one second identifier compared different from the at least one third identifier compared, copying at least one block having a first identifier indicating storage after a block corresponding to the at least one third identifier.
Claim 2
Independent Claim 156 words
A method of updating a database comprising information from a file comprising at least one section, each section comprising at least one block of information, each block having a first identifier, the file additionally comprising a set of a plurality of second identifiers, each second identifier corresponding to at least one of the first identifiers, the database comprising a set of a plurality of third identifiers, each third identifier corresponding to at least one of the second identifiers from a version of the file, the method comprising: a. comparing at least one of the second identifiers with at least one of the third identifiers corresponding to said at least one of the second identifiers; and b. responsive to the at least one second identifier compared different from the at least one third identifier compared, copying at least one block having a first identifier indicating storage after a block corresponding to the at least one third identifier.
Claim 3
Dependent Claim 32 words
The method of claim 1, additionally comprising: c. repeating steps a and b for each of at least one section different from a section corresponding to said at least one second identifier.
Claim 4
Dependent Claim 29 words
The method of claim 1, wherein steps a and b are performed responsive to a request comprising at least one selected from an access request and an update request.
Claim 5
Dependent Claim 30 words
The method of claim 2, wherein steps a, b and c are performed responsive to a request comprising at least one selected from an access request and an update request.
Claim 6
Dependent Claim 67 words
The method of claim 4, wherein the request comprises an access request and the access request references a referenced section, the method comprising the additional steps of: determining if the referenced section contains noncurrent information; and responsive to the referenced section not containing noncurrent information: making a copy of the file; and wherein steps a, b and c are performed on the copy of the file made.
Claim 7
Independent Claim 172 words
A method of updating a database comprising a plurality of rows of information from a file comprising a plurality of sections, each section comprising at least one block of information, each block having a first identifier, the file additionally comprising a set of a plurality of second identifiers, each second identifier corresponding to at least one of the first identifiers, the database comprising a set of a plurality of third identifiers, each third identifier corresponding to at least one of the second identifiers from a version of the file, the method comprising: a. comparing at least one of the second identifiers with at least one of the third identifiers corresponding to said at least one of the second identifiers; and b. responsive to the at least one second identifier compared different from the at least one third identifier compared: creating a new row in the database; and copying at least a portion of the file corresponding to the at least one second identifier compared into the new row in the database created.
Claim 8
Independent Claim 172 words
A method of updating a database comprising a plurality of rows of information from a file comprising a plurality of sections, each section comprising at least one block of information, each block having a first identifier, the file additionally comprising a set of a plurality of second identifiers, each second identifier corresponding to at least one of the first identifiers, the database comprising a set of a plurality of third identifiers, each third identifier corresponding to at least one of the second identifiers from a version of the file, the method comprising: a. comparing at least one of the second identifiers with at least one of the third identifiers corresponding to said at least one of the second identifiers; and b. responsive to the at least one second identifier compared different from the at least one third identifier compared: creating a new row in the database; and copying at least a portion of the file corresponding to the at least one second identifier compared into the new row in the database created.
Claim 9
Dependent Claim 94 words
The method of claim 6, additionally comprising: c. responsive to the at least one second identifier compared at least similar to the at least one third identifier compared: locating a row in the database corresponding to the at least one second identifier compared; comparing to the row located to at least a portion of a block corresponding to the row located; and responsive to the comparing step indicating information in the block compared different from information in the row compared, updating the information in the row to correspond to the information in the block.
Claim 10
Dependent Claim 32 words
The method of claim 7, additionally comprising repeating steps a, b and c for each of at least one section different from a section corresponding to the at least one second identifier.
Claim 11
Dependent Claim 53 words
The method of claim 7, additionally comprising: d. determining whether a block corresponding to the at least one second identifier compared is capable of modification; and wherein at least step c is responsive to the determining step d indicating the block corresponding to the at least one second identifier is capable of modification.
Claim 12
Dependent Claim 28 words
The method of claim 7, wherein steps a, b and c are performed responsive to at least one request selected from an access request and an update request.
Claim 13
Dependent Claim 13 words
The method of claim 7, comprising the additional step of copying the file.
Claim 14
Dependent Claim 33 words
The method of claim 11 wherein the copying step is responsive to the request comprising at least one selected from an update request and an access request referencing a section comprising noncurrent information.
Claim 15
Dependent Claim 66 words
The method of claim 8, additionally comprising the step of, responsive to the determining step d indicating the block corresponding to the at least one second identifier is not capable of modification, providing into a row of the database information corresponding to at least a portion of a block having a first identifier indicating storage after a block corresponding to the at least one third identifier.
Claim 16
Dependent Claim 27 words
The method of claim 6, wherein steps a and b are performed responsive to at least one request selected from an access request and an update request.
Claim 17
Dependent Claim 194 words
A computer program product comprising a computer useable medium having computer readable program code embodied therein for updating a database comprising information from a file comprising at least one section, each section comprising at least one block of information, each block having a first identifier, the file additionally comprising a set of a plurality of second identifiers, each second identifier corresponding to at least one of the first identifiers, the database comprising a set of a plurality of third identifiers, each third identifier corresponding to at least one of the second identifiers from a version of the file, the computer program product comprising: a. computer readable program code devices configured to cause a computer to compare at least one of the second identifiers with at least one of the third identifiers corresponding to said at least one of the second identifiers; and b. computer readable program code devices configured to cause a computer to, responsive to the at least one second identifier compared different from the at least one third identifier compared, copy at least one block having a first identifier indicating storage after a block corresponding to the at least one third identifier.
Claim 18
Dependent Claim 194 words
A computer program product comprising a computer useable medium having computer readable program code embodied therein for updating a database comprising information from a file comprising at least one section, each section comprising at least one block of information, each block having a first identifier, the file additionally comprising a set of a plurality of second identifiers, each second identifier corresponding to at least one of the first identifiers, the database comprising a set of a plurality of third identifiers, each third identifier corresponding to at least one of the second identifiers from a version of the file, the computer program product comprising: a. computer readable program code devices configured to cause a computer to compare at least one of the second identifiers with at least one of the third identifiers corresponding to said at least one of the second identifiers; and b. computer readable program code devices configured to cause a computer to, responsive to the at least one second identifier compared different from the at least one third identifier compared, copy at least one block having a first identifier indicating storage after a block corresponding to the at least one third identifier.
Claim 19
Dependent Claim 45 words
The computer program product of claim 15, additionally comprising: c. computer readable program code devices configured to cause a computer to repeat steps a and b for each of at least one section different from a section corresponding to said at least one second identifier.
Claim 20
Dependent Claim 45 words
The computer program product of claim 16, additionally comprising computer readable program code devices configured to cause a computer to execute code devices a, b and c responsive to a request comprising at least one request selected from an access request and an update request.
Claim 21
Dependent Claim 74 words
The computer program product of claim 17, wherein the request comprises an access request and the access request references a referenced section, the computer program product additionally comprising: computer readable program code devices configured to cause a computer to determine if the referenced section contains noncurrent information; and computer readable program code devices configured to cause a computer to, responsive to the referenced section not containing noncurrent information, make a copy of the file.
Claim 22
Dependent Claim 44 words
The computer program product of claim 15, additionally comprising computer readable program code devices configured to cause a computer to execute code devices a and b responsive to a request comprising at least one request selected from an access request and an update request.
Claim 23
Dependent Claim 210 words
A computer program product comprising a computer useable medium having computer readable program code embodied therein for updating a database comprising a plurality of rows of information from a file comprising a plurality of sections, each section comprising at least one block of information, each block having a first identifier, the file additionally comprising a set of a plurality of second identifiers, each second identifier corresponding to at least one of the first identifiers, the database comprising a set of a plurality of third identifiers, each third identifier corresponding to at least one of the second identifiers from a version of the file, the computer program product comprising: a. computer readable program code devices configured to cause a computer to compare at least one of the second identifiers with at least one of the third identifiers corresponding to said at least one of the second identifiers; and b. computer readable program code devices configured to cause a computer to, responsive to the at least one second identifier compared different from the at least one third identifier compared: create a new row in the database; and copy at least a portion of the file corresponding to the at least one second identifier compared into the new row in the database created.
Claim 24
Dependent Claim 210 words
A computer program product comprising a computer useable medium having computer readable program code embodied therein for updating a database comprising a plurality of rows of information from a file comprising a plurality of sections, each section comprising at least one block of information, each block having a first identifier, the file additionally comprising a set of a plurality of second identifiers, each second identifier corresponding to at least one of the first identifiers, the database comprising a set of a plurality of third identifiers, each third identifier corresponding to at least one of the second identifiers from a version of the file, the computer program product comprising: a. computer readable program code devices configured to cause a computer to compare at least one of the second identifiers with at least one of the third identifiers corresponding to said at least one of the second identifiers; and b. computer readable program code devices configured to cause a computer to, responsive to the at least one second identifier compared different from the at least one third identifier compared: create a new row in the database; and copy at least a portion of the file corresponding to the at least one second identifier compared into the new row in the database created.
Claim 25
Dependent Claim 117 words
The computer program product of claim 20, additionally comprising: c. computer readable program code devices configured to cause a computer to, responsive to the at least one second identifier compared at least similar to the at least one third identifier compared: locate a row in the database corresponding to the at least one second identifier compared; compare to the row located to at least a portion of a block corresponding to the row located; and responsive to the computer readable program code devices configured to cause a computer to compare indicating information in the block compared different from information in the row compared, update the information in the row to correspond to the information in the block.
Claim 26
Dependent Claim 46 words
The computer program product of claim 21, additionally comprising computer readable program code devices configured to cause a computer to reexecute code devices a, b and c for each of at least one section different from a section corresponding to the at least one second identifier.
Claim 27
Dependent Claim 67 words
The computer program product of claim 21, additionally comprising: d. computer readable program code devices configured to cause a computer to determine whether a block corresponding to the at least one second identifier compared is capable of modification; and wherein at least code devices c are responsive to the code devices d indicating the block corresponding to the at least one second identifier is capable of modification.
Claim 28
Dependent Claim 76 words
The computer program product of claim 22, additionally comprising computer readable program code devices configured to cause a computer to, responsive to the code devices d indicating the block corresponding to the at least one second identifier is not capable of modification, provide into a row of the database information corresponding to at least a portion of a block having a first identifier indicating storage after a block corresponding to the at least one third identifier.
Claim 29
Dependent Claim 29 words
The computer program product of claim 20, wherein steps a and b are performed responsive to at least one request selected from an access request and an update request.
Claim 30
Dependent Claim 42 words
The computer program product of claim 21, additionally comprising computer readable program code devices configured to cause a computer to perform code devices a, b and c responsive to at least one request selected from an access request and an update request.
Claim 31
Dependent Claim 23 words
The computer program product of claim 21, additionally comprising computer readable program code devices configured to cause a computer to copy the file.
Claim 32
Dependent Claim 46 words
The computer program product of claim 27 wherein the computer readable program code devices configured to cause a computer to copy step are responsive to the request comprising at least one selected from an update request and an access request referencing a section comprising noncurrent information.

References Cited (Backward Citations)

US4853843A Cited
US4912637A Cited
US5375237A Cited
US5530855A Cited
US5696967A Cited
US5778388A Cited
US5499965A Cited
US5850507A Cited
US5881292A Cited

USPTO Annuity & Maintenance Windows

Annuity Stage Window Opens Payment Deadline Surcharge Period Until Estimated Fee Status
3.5 Years (Year 4) 2002-08-30 2003-03-01 2003-08-31 $2000.00 Window Closed / Lapsed
7.5 Years (Year 8) 2006-08-30 2007-03-01 2007-08-31 $3760.00 Window Closed / Lapsed
11.5 Years (Year 12) 2010-08-30 2011-03-01 2011-08-31 $7700.00 Window Closed / Lapsed

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag