Capturing data of a database system

Patent 5175849 Issued on December 29, 1992. Estimated Expiration Date:

December 20, 2010. Estimated Expiration Date is calculated based on simple USPTO term provisions. It does not account for terminal disclaimers, term adjustments, failure to pay maintenance fees, or other factors which might affect the term of a patent.

Abstract Claims Description Full Text

Patent References

Method for the dynamic replication of data under distributed system control to control utilization of resources in a multiprocessing, distributed data base system
Patent #: 4432057
Issued on: 02/14/1984
Inventor: Daniell , et al.

Method for assuring atomicity of multi-row update operations in a database system
Patent #: 4498145
Issued on: 02/05/1985
Inventor: Baker , et al.

Database management system for controlling concurrent access to a database
Patent #: 4627019
Issued on: 12/02/1986
Inventor: Ng

Method for refreshing multicolumn tables in a relational data base using minimal information
Patent #: 4631673
Issued on: 12/23/1986
Inventor: Haas , et al.

Database backup method
Patent #: 4686620
Issued on: 08/11/1987
Inventor: Ng

Data recovery system capable of performing transaction processing in parallel with data recovery processing
Patent #: 4815028
Issued on: 03/21/1989
Inventor: Saitoh

Method and apparatus for database update/recovery Patent #: 5043871
Issued on: 08/27/1991
Inventor: Nishigaki, et al.

Inventor

Schneider, Frederick W.

Assignee

Amdahl Corporation

Application

No. 632604 filed on 12/20/1990

US Classes:

707/202, Recoverability707/203, Version management714/19Undo record

Examiners

Primary: Anderson, Lawrence E.
Assistant: Lim, Krisna

Attorney, Agent or Firm

Lovejoy; David E.

International Class

G06F 015/40

Abstract

To create a snapshot copy of selected elements of a database in a data processing system, the selected elements are copied sequentially to a secondary storage device. During the copying operation, when a task requests to delete one of the selected elements from the database before it is copied to the secondary storage device, a record is made to identify the requested element, the task is allowed to continue processing. After the element has been copied to the secondary storage device, the identified element will be deleted based upon the record. Also, during the creation of the copy, when a task requests to update one of the selected elements, a duplicate copy of the requested element is created and the task is allowed to update the requested element. When it is time to copy the requested element to the secondary storage device, the duplicate copy will be used.

Other References

Kim et al., "Data consistency and exchange among nested transactions in a database", IBM Technical Disclosure, vol. 27, No. 1B, Jun. 1984
Aghili et al., "A practical guide to the design of differential file for recovery of on-time database," ACM Transaction on Database System, vol. 7, No. 4, Dec. 1982, pp. 540-565
Kaunitz et al. "Database backup-the problem of very large databases," The Australian Computer Journal, vol. 13, No. 4, Nov. 1981, pp. 136-142
Lien et al., "Consistency, Concurrency and Crash Recovery," Proceedings of the ACM SIGMOD International Conference on Management of Data, Austin, Texas 1978, pp. 9-1