Method and apparatus for database update/recovery

Boots – shoes – and leggings

Patent

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

3642821, 364285, 3642851, 3642852, G06F 1300

Patent

active

050438719

ABSTRACT:
There are provided a backup version page table in a storage for providing a correspondence between the pages of a database and the slots in a database storage medium in which the contents of pages to be recovered, if necessary, are stored; a current version page table for providing a correspondence between pages updated by a transaction and slots in the database storage medium wherein the updated contents of the pages are stored; and a journal file for recording various system journals; wherein the updated page contents are stored in the database stored medium at the slots not-used at that time and found with reference to the backup version page table and the current version page table. According to an aspect of another embodiment, there are provided a database constructed of a plurality of sub-areas; a differential file for each sub-area, and a backup file for each sub-area for copying the contents of each sub-area; wherein if the information in a certain sub-area of said database is updated, the updated information is stored in the differential file for the sub-area, and information is recovered using the backup file and the differential file for the certain sub-area.

REFERENCES:
patent: 4020466 (1977-04-01), Cordi et al.
patent: 4044337 (1977-08-01), Hicks et al.
patent: 4077059 (1978-02-01), Cordi et al.
patent: 4084231 (1978-04-01), Capozzi et al.
patent: 4459658 (1984-07-01), Gabbe et al.
patent: 4507751 (1985-03-01), Gawlick et al.
patent: 4627019 (1986-02-01), Ng
C. J. Date, An Introduction to Database Systems, vol. I, 4th Edition, 1986, pp. 411-419.
Gray et al., The Recovery Manager of the System R Database Manager, Computing Surveys, vol. 13, No. 2, Jun. 1981, pp. 224-242.
Severance et al, Differential Files: Their Application to the Maintenance of Large Databases, ACM Transactions of Database Systems, vol. 1, No. 3, Sep. 1976, pp. 256-267.
Lorie, "Physical Integrity in a Large Segmented Database", Assocation for Computing Machinery, Mar. 1977, pp. 91-104.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Method and apparatus for database update/recovery does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for database update/recovery, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for database update/recovery will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-1419066

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.