Summary
In this chapter, the concepts of data warehousing were covered. A warehouse is a central storage facility for subject-oriented data throughout an organization and data warehousing is the process involved in extracting, storing, aggregating this information to provide easy access for end users. You learned how warehousing data differs from online transactional systems and how to transform the transactional data from these systems to the warehouse. You were introduced to the concept of the data mart as a smaller, more specialized warehouse designed to satisfy a particular functional unit. You were also presented with issues related to planning, designing, and maintaining data warehouses in your own organization. Finally, you were presented ...
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.
