PASS Data Arch. Virtual Chapter: Row Versioned Data Warehouses
|Subject:||Row Versioned Data Warehouses|
|Start Time:||Thursday, December 15, 2011 6:00 PM US Pacific Time (December 16, 2011 2:00 AM GMT)|
|End Time:||Thursday, December 15, 2011 7:00 PM US Pacific Time (December 16, 2011 3:00 AM GMT)|
|Presenter:||Jeremy Huppatz (Blog|@OzzieMedes)|
|Live Meeting Link:|
|Row Versioned Data Warehouses
Jeremy will discuss the strengths and disadvantages of a row-versioned data warehouse design in the context of a real world case study, sharing lessons learnt and demonstrating some of the technologies and techniques used to build a row-versioned data warehouse. He will discuss row-versioning in the context of Kimball slowly-changing dimensions, and will also provide some details on the relative strengths of row-versioning as applied to measure information in situations where such data cannot be considered finalized at the time it is loaded into the warehouse.
Jeremy has been a SQL Server data guy going back as far as 1997. During his 14 years working with Microsoft’s flagship database, he has filled the roles of DBA, data modeller, database designer, data analyst, BI developer and data architect in a multitude of projects, which have included departmental database apps, enterprise data warehouses and a bit of just about everything in between. Jeremy now runs his own IT consulting firm called Solitaire Systems and lives in the scenic Adelaide Hills with his partner Alison and her cat. He also plays, writes and records music and writes in his spare time, and has been described optimistically as an avid (as opposed to obsessive) computer gamer.
|Add to calendar|