Data Warehousing Fundamentals: A Comprehensive Guide for IT ProfessionalsGeared to IT professionals eager to get into the all-important field of data warehousing, this book explores all topics needed by those who design and implement data warehouses. Readers will learn about planning requirements, architecture, infrastructure, data preparation, information delivery, implementation, and maintenance. They'll also find a wealth of industry examples garnered from the author's 25 years of experience in designing and implementing databases and data warehouse applications for major corporations. Market: IT Professionals, Consultants. |
From inside the book
Results 1-3 of 33
Page 266
As is ” or static data is the capture of data at a given point in time . It is like taking
a snapshot of the relevant source data at a certain point in time . For current or
transient data , this capture would include all transient data identified for
extraction .
As is ” or static data is the capture of data at a given point in time . It is like taking
a snapshot of the relevant source data at a certain point in time . For current or
transient data , this capture would include all transient data identified for
extraction .
Page 269
SOURCE DATABASES SOURCE OPERATIONAL SYSTEMS Today ' s Extract
Source Data DBMS Yesterday ' s Extract EXTRACT PROGRAMS FILE
COMPARISON PROGRAMS OPTION 1 : Capture based on date and time stamp
Extract ...
SOURCE DATABASES SOURCE OPERATIONAL SYSTEMS Today ' s Extract
Source Data DBMS Yesterday ' s Extract EXTRACT PROGRAMS FILE
COMPARISON PROGRAMS OPTION 1 : Capture based on date and time stamp
Extract ...
Page 271
Capture of static data Capture in source applications Good flexibility for capture
specifications . Performance of source systems not affected . No revisions to
existing applications . Can be used on legacy systems . Can be used on file -
oriented ...
Capture of static data Capture in source applications Good flexibility for capture
specifications . Performance of source systems not affected . No revisions to
existing applications . Can be used on legacy systems . Can be used on file -
oriented ...
What people are saying - Write a review
We haven't found any reviews in the usual places.
Contents
OVERVIEW AND CONCEPTS | 1 |
The Building Blocks | 19 |
Trends in Data Warehousing | 39 |
Copyright | |
23 other sections not shown
Other editions - View all
Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals Paulraj Ponniah Limited preview - 2004 |
Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals Paulraj Ponniah No preview available - 2004 |
Common terms and phrases
able aggregate analysis applications approach architecture attributes build changes chapter cleansing columns complex components consider contain costs create data extraction data marts data mining data quality data structures data transformation data warehouse data warehousing database decision definition dimension table discuss environment example executive fact table Figure files functions important individual information delivery initial integrated load look major marketing metadata methods month Name OLAP operational systems options performance physical platform problem queries records relational reports represent requirements rows schema selection shows single source systems specific standards STAR step storage strategic structures summary techniques tion types users values various vendors
Bibliographic information
| Title | Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals |
| Author | Paulraj Ponniah |
| Edition | illustrated |
| Publisher | Wiley, 2001 |
| Original from | the University of Michigan |
| Digitized | 19 Nov 2007 |
| ISBN | 0471412546, 9780471412540 |
| Length | 544 pages |
| Subjects | › › Computers / Databases / Data Warehousing Computers / Information Technology |
| Export Citation | BiBTeX EndNote RefMan |