Articles

Displaying 1–6 (of 6)

Popularity is determined by a calculation of page views and community comments.

Title Popularity * Date
The Use of Surrogate Keys Summary
 When designing a data warehouse, surrogate keys add a level of indirection and make the table a bit more extensible/flexible.

Topics: Data Warehousing, Data Modeling and Design
by Chuck Kelley | 0 comments		 10-13-2010
Performance Trade-Offs – Joins vs. Storage Summary
 Chuck Kelley's hypothesis is that landing data on disk (and hence requiring more space) may be worth the added cost based on being able to build the data warehouses and data marts faster.

Topics: Data Warehousing, Data Marts, Data Modeling and Design, Architecture
by Chuck Kelley | 2 comments		 03-11-2010
Dealing with Addresses in the Data Warehouse Summary
 With his 15+ years of related experience, Chuck Kelley discusses different ways to deal with addresses in the data warehouse.

Topics: Data Warehousing, Data Modeling and Design
by Chuck Kelley | 0 comments		 06-18-2009
Different Flavors of Design – The Data Vault Summary
 Chuck Kelley provides a brief introduction to the data vault technique developed by Dan Linstedt.

Topics: Data Warehousing, Data Modeling and Design
by Chuck Kelley | 2 comments		 05-14-2009
Different Flavors of Design for Business Intelligence Databases Summary
 Chuck Kelley looks at some of the different approaches to designing databases for business intelligence.

Topics: Data Warehousing, Data Modeling and Design
by Chuck Kelley | 0 comments		 04-16-2009
Order Header/Detail in Star Schema Summary
 Chuck Kelley provides an example of using the dimensional model technique to create the logical model.

Topics: Data Warehousing, Data Modeling and Design
by Chuck Kelley | 0 comments		 03-12-2009

PREV 1 NEXT