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.
18.3. PHYSICAL DESIGN CONSIDERATIONS
We have traced the steps for the physical design of the data warehouse. Each step consists of specific activities that finally lead to the physical model. When you look back at the steps, one step relates to the physical storage structure and several others deal with the performance of the data warehouse. Physical storage and performance are significant factors. We will cover these two in sufficient depth later in the chapter.
In this section, we will firm up our understanding of the physical model itself. Let us review the components and track down what it takes to move from the logical model to the physical model. First, let us begin with the overall objectives of the physical design process.
18.3.1. Physical Design Objectives
When you perform the logical design of the database, your goal is to produce a conceptual model that reflects the information content of the real-world situation. The logical model represents the overall data components and the relationships. The objectives of the physical design process do not center on the structure. In physical design, you are getting closer to the operating systems, the database software, the hardware, and the platform. You are now more concerned about how the model is going to work than on how the model is going to look.
If you want to summarize, the major objectives of the physical design process are improving performance on the one hand, and improving the management of the stored data on 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.