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.
6.3. THE ARCHITECTURAL PLAN
You know that data warehouse architecture refers to the proper arrangement of the architectural components for maximum benefit. How do you plan your data warehouse architecture? Basically, every data warehouse is composed of pretty much the same components. Therefore, when you are planning the architecture, you are not inventing any new components to go into your particular warehouse. You are really sizing up each component for your environment. You are planning how all the components must be knit together so that they will work as an integrated system.
Before we proceed further, let us recap the major architectural components as discussed in Chapter 2:
Source data
- Production data
- Internal data
- Archived data
- External data
Data staging
- Data extraction
- Data transformation
- Data loading
Data storage
Information delivery
Metadata
Management and control
When you plan the overall architecture for your data warehouse, you will be setting the scope and contents of each of these components. For example, in your company all of the source data might fortunately reside on a single computing platform and also on a single relational database. If this were the case, then the data extraction component in the architecture would be substantially smaller and straightforward. Again, if your company decides on using just the facilities provided by the DBMS, such as alias definition and comments features, for metadata storage, then your metadata component would be simple.
Planning the ...
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.