More Effective Data Warehousing: How to Move from an OLTP System to an OLAP System
Do you like this story?
What is the difference between a data warehouse and a data mart? Both are storage mechanisms for read-only historical aggregated data. This paper assesses how a Star Schema Database fits in with data storage approaches.
Readers will learn: How Online Analytical Processing works with a Star Schema Database; How to achieve database normalization; The best ways to logically view database information;How to utilize "joins" and query multiple tables to acquire all the data required;The number-one reason to denormalize.
This post was written by: Rahil Anouar
Rahil Anouar is a professional blogger, web designer and Linux user. Follow him on Twitter
Subscribe to:
Post Comments (Atom)
0 Responses to “More Effective Data Warehousing: How to Move from an OLTP System to an OLAP System”
Post a Comment