Data Warehousing FAQ
Some common questions that DBAs new to data warehousing might encounter are as follows:
| Q1: | When should I consider a data warehousing solution? |
| A1: | When users are requesting access to large amounts of historical information for reporting purposes, you should strongly consider a warehouse or mart. The user will benefit when the information is organized in an efficient manner for this type of access. |
| Q2: | DBAs have always been told that having non-normalized data is bad. Why is it now okay? |
| A2: | Normalization in relational databases results in an efficient use of database storage. Data warehousing is not concerned with accomplishing the same storage efficiencies. The main concern is to provide information to the user as fast as ... |
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
