9

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?

Jordie
  • 899
  • 2
  • 11
  • 20

2 Answers2

8

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"

Jeff Meatball Yang
  • 37,839
  • 27
  • 91
  • 125
Stephen Denne
  • 36,219
  • 10
  • 45
  • 60
  • 1
    The link to "Reflections on the Kimball Data Warehouse "Bible":[...]" you give is broken. I believe this is the text: http://databasecolumn.vertica.com/database-miscellaneous/reflections-on-the-kimball-data-warehouse-bible-time-for-a-new-testament/ – sleske Jun 19 '10 at 14:45
  • Hi @Stephen & Jeff, I confused with the toolkit books of Kimball series, which is for what, like warehouse tool kit 2nd edition for complete ref. where as edition 3rd for definitive study, other are toolkit for lifecycle & ETL in warehousing. I would really appreciate if you focus on 2nd & 3rd edition of the warehousing toolkit & diff. Thanks. – Aditya Apr 18 '14 at 19:40
  • The two links to the Vertica columns are dead :( – Peter Smit Feb 19 '15 at 15:56
0

You can try this, Data Warehousing Tutorials

farhankhwaja
  • 159
  • 7