An efficient and flexible method for archiving a data base

ABSTRACT

We describe an efficient method for supporting incremental and full archiving of data bases (e.g., individual files). Customers archive their data bases quite frequently to minimize the duration of data outage. Because of the growing sizes of data bases and the ever increasing need for high availability of data, the efficiency of the archive copy utility is very important. The method presented here minimizes interferences with concurrent transactions by not acquiring any locks on the data being copied. It significantly reduces disk I/Os by not keeping on data pages any extra tracking information in connection with archiving. These features make the archive copy operation be more efficient in terms of resource consumption compared to other methods. The method is also flexible in that it optionally supports direct copying of data from disks, bypassing the DBMS's buffer pool. This reduces buffer pool pollution and processing overheads, and allows the utility to take advantage of device geometries for efficiently retrieving data. We also describe extensions to the method to accommodate the multisystem shared disks transaction environment. The method tolerates gracefully system failures during the archive copy operation.

REFERENCES

• CPM82: Crus, R., Putzolu, F., Mortenson, J. Incremental Data Base Log Image Copy, IBM Technical Disclosure Bulle. tin, Vol. 25, No. 7B, p3730-3732, December 1982.
• GMBLL81: Jim Gray , Paul McJones , Mike Blasgen , Bruce Lindsay , Raymond Lorie , Tom Price , Franco Putzolu , Irving Traiger, The Recovery Manager of the System R Database Manager, ACM Computing Surveys (CSUR), v.13 n.2, p.223-242, June 1981 [doi>10.1145/356842.356847]
• IBM: IBM Database 2 Version 2 Command and UtiZity Reference, Document Number SC'2S-4378, IBM Corp.
• Info91: INFORHIX OnLine Administrator's 6uide - Database Server Version 5.0, Part No. 000-7106, lntorrnix Software, Inc., December 1991.
• MHLPS92: C. Mohan , Don Haderle , Bruce Lindsay , Hamid Pirahesh , Peter Schwarz, ARIES: a transaction recovery method supporting fine-granularity locking and partial rollbacks using write-ahead logging, ACM Transactions on Database Systems (TODS), v.17 n.1, p.94-162, March 1992 [doi>10.1145/128765.128770]
• Moha92: Mohan, C. Support ing Very Large Tables, Proc. 7th Brazilian Symposium on Database Systems, Porto Alegre, May 1992. Also available as IBM Research Report RJ8687, iBM Almaden Research Center, March 1992.
• Moha93: C. Mohan, IBM's relational DBMS products: features and technologies, Proceedings of the 1993 ACM SIGMOD international conference on Management of data, p.445-448, May 25-28, 1993, Washington, D.C., United States
• MoNa91: C. Mohan , Inderpal Narang, Recovery and Coherency-Control Protocols for Fast Intersystem Page Transfer and Fine-Granularity Locking in a Shared Disks Transaction Environment, Proceedings of the 17th International Conference on Very Large Data Bases, p.193-207, September 03-06, 1991
• MoNa92a: C. Mohan , Inderpal Narang, Efficient Locking and Caching of Data in the Multisystem Shard Disks Transaction Environment, Proceedings of the 3rd International Conference on Extending Database Technology: Advances in Database Technology, p.453-468, March 23-27, 1992
• MoNa92b: Mohan, C., Narang, I. Data Base Recovery in Shared Disks and CZient-Server Architectures, Proc. 12th International Conference on Distributed Computing Systems, Yokohama, June 1992.
• TeGu84: Teng, J., Gurnaer, R.Hanaging IBH Database 2 Buffers to Maximize Performance, IBM Systems Journal, Vol. 23, No. 2, 1984.

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.4 Systems
          Subjects: Transaction processing

Additional Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.1 Logical Design
          Subjects: Data models
      H.2.4 Systems
          Subjects: Concurrency
      H.2.7 Database Administration
          Subjects: Logging and recovery

General Terms:
Algorithms, Design, Performance