Join Martin Guidry for an in-depth discussion in this video Designing data warehouses, part of Designing Database Solutions for SQL Server 2012.
- View Offline
- Exercise Files
- In this section we'll talk about…Designing a Data Warehouse.…Rather than OLTP, Online Transaction Processing,…Data Warehouses are instead used for OLAP,…Online Analytical Processing.…So we took the word Transaction out,…which implies the data will not be changing.…Data Warehouses contain data that rarely changes,…and even some Data Warehouses…contain data that never changes.…So, in other words,…once the data is loaded initially…it will never be changed after that.…
Many of the design criteria we did in OLTP…was designed to make changes easier.…Now that changes are not going to occur,…or rarely going to occur,…we can change some things about our design.…The process of changing a database…into a structure that works better for OLAP…is sometimes called denormalization.…As the name implies it is the opposite…of the normalization we covered in the previous sections.…Whereas normalization often increased…the number of tables we have,…denormalization will often reduce…the number of tables we have.…
In some denormalized Data Warehouses…
- Planning the database infrastructure
- Designing databases vs. data warehouses
- Designing the physical database implementation
- Planning for partitioning
- Adding FileStream data
- Monitoring server health
- Managing SQL Server with PowerShell
Skill Level Intermediate
1. Designing a Database Server Infrastructure
2. Designing a Logical Database Schema
3. Designing a Physical Database Implementation
4. Incorporating Data Files into Databases
5. Tuning Database Performance
6. Policy-Based Management
7. Monitoring Server Health
Exploring health data5m 3s
8. Managing SQL Server with PowerShell
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.