September 2001
Beginner
544 pages
17h 43m
English
Content preview from DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
19.5. BACKUP AND RECOVERY
You are aware of the backup and recovery procedures in OLTP systems. Some of you, as database administrators, must have been responsible for setting up the backups and probably been involved in one or two disaster recoveries.
In an OLTP mission-critical system, loss of data and downtime cannot be tolerated. Loss of data can produce serious consequences. In a system such as airlines reservations or online order-taking, downtime even for a short duration can cause losses in the millions of dollars.
How critical are these factors in a data warehouse environment? When an online order-taking system is down for recovery, you probably can survive for a few hours using manual fall-back procedures. If an airlines reservation system is down, there can be no such manual fall-back. How do these compare with the situation in the data warehouse? Is downtime critical? Can the users tolerate a small loss of data?
19.5.1. Why Back Up the Data Warehouse?
A data warehouse houses huge amounts of data that has taken years to gather and accumulate. The historical data may go back 10 or even up to 20 years. Before the data arrives at the data warehouse, you know that it has gone through an elaborate process of cleansing and transformation. Data in the warehouse represents an integrated, rich history of the enterprise. The users cannot afford to lose even a small part of the data that was so painstakingly put together. It is critical that you are able to recreate the data if ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.