Menu
I am interested in learning more about data warehousing. I see terms like "dimension", "snowflake schema" and "star schema" thrown about. Where would one start in learning about this stuff? Are there good books or Internet resources?
ETL is in this space too right?
726
How Long Does It Take to Learn Data Warehousing Techniques? Learning data warehousing can take as little as one week for those with a background in IT development, while those with little to no background in tech can take up to seven months to learn data warehousing.
Unfortunately, as you might imagine, the manipulation of the data itself and the creation of multiple data copies for different purposes at different levels in the data warehouse architecture has resulted in a very complex system that is incredibly difficult, time-consuming and expensive for organizations to create and ...
Wikipedia's resources on Data Warehousing are good.
Reading any of Ralph Kimball's books, such as "The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling "
Yes, ETL is in this space.
You may also be interested in Column oriented databases.
Vertica have a blog with a few posts regarding how they're often better for what data warehouses are used for. For example "Reflections on the Kimball Data Warehouse "Bible": Time for a New Testament?" and "The Truth About MPP & Data Warehousing"
170
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
