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.
- 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.Google Scholar
- GMBLL81 Gray, J., McJones, P., Blasgen, M., Lindsay, B., Lone, R., Price, T., Putzolu, F., Traiger, 1. The Recovery Hanager of the System R Database l#nager, AGM Computing Surveys, Vol. 13, No. 2, June 1981. Google ScholarDigital Library
- IBM IBM Database 2 Version 2 Command and UtiZity Reference, Document Number SC'2S-4378, IBM Corp.Google Scholar
- Info91 INFORHIX OnLine Administrator's 6uide - Database Server Version 5.0, Part No. 000-7106, lntorrnix Software, Inc., December 1991.Google Scholar
- MHLPS92 Mohan, C., Haderle, D., Ltndsay, B., P=rahesh, H., Schwarz, P. ARIES: A Transaction Recovery Method Supporting Fine-6ranulartty Locking and Par#iaZ RolZbacks Using Write-Ahead Logging, ACM Transac. tions on Database Systems, Vol. 17, No. 1, March 1992. Google ScholarDigital Library
- 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.Google Scholar
- Moha93 Mohan, C. IBM's RelationaZ DBH$ Products: Features and Technologies, Proc. ACM SIGMOD International Conference on Management of Data, Washington, D.C., May 1993. Google ScholarDigital Library
- MoNa91 Mohan, C., Narang, I. Recovery and Coherency-ControZ Protocols for Fast Intersystem Page Transfer and Fine-Granularity Locking in a Shared Disks Transaction Environment, Proc. 17th International Conference on Very Large Data Bases, Barcelona, September 1991. A longer version of this paper is available as IBM Research Report RJ8017, IBM Almaden Research Center, March 1991. Google ScholarDigital Library
- MoNa92a Mohan, C., Narang, I. Efftcient Locking and Caching of Data in #he HuZ tisystem Shared Disks Transaction Environment, Proc. International Conference on Extending Data Base Technology, Vienna, March 1992. Google ScholarDigital Library
- 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.Google Scholar
- TeGu84 Teng, J., Gurnaer, R.Hanaging IBH Database 2 Buffers to Maximize Performance, IBM Systems Journal, Vol. 23, No. 2, 1984.Google ScholarDigital Library
Index Terms
- An efficient and flexible method for archiving a data base
Recommendations
An efficient and flexible method for archiving a data base
SIGMOD '93: Proceedings of the 1993 ACM SIGMOD international conference on Management of dataWe 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 ...
Towards Archiving-as-a-Service: A Distributed Index for the Cost-effective Access to Replicated Multi-Version Data
IDEAS '15: Proceedings of the 19th International Database Engineering & Applications SymposiumWith the advent of data Clouds that come with nearly unlimited storage capacity combined with low storage costs, the well-established update-in-place paradigm for data management is more and more replaced by a multi-version approach. Especially in a ...
Data base recovery at CMIC
SIGMOD '76: Proceedings of the 1976 ACM SIGMOD international conference on Management of dataSeveral techniques have been combined to provide for data base recovery at CMIC. The CMIC environment is presented first in order to identify the constraints which data base recovery must satisfy.A technique is described for updating mass-storage ...
Comments