This chapter discusses one key aspect of data warehouse availability: the recovery of data after a data loss.īefore looking at the backup and recovery techniques in detail, it is important to discuss specific techniques for backup and recovery of a data warehouse. Therefore, availability is a key requirement for data warehousing. In a typical enterprise, hundreds or thousands of users may rely on the data warehouse to provide the information to help them understand their business and make better decisions. This chapter contains the following sections:Ī data warehouse is a system that is designed to support analysis and decision-making. This chapter proposes an efficient backup and recovery strategy for very large databases to reduce the overall resources necessary to support backup and recovery by using some special characteristics that differentiate data warehouses from OLTP systems. Assuming a fixed allowed downtime, a large OLTP system requires more hardware resources than a small OLTP system. Generally, the availability considerations for a very large OLTP system are no different from the considerations for a small OLTP system. OLTP and data warehouse systems have some distinct characteristics. Very large databases are unique in that they are large and data may come from many resources. Backup and recovery is a crucial and important job for a DBA to protect business data.Īs data storage grows larger each year, DBAs are continually challenged to ensure that critical data is backed up and that it can be recovered quickly and easily to meet business needs.
0 kommentar(er)
