Optimizing Enterprise Data Warehouse Design Utilizing Dimensional Normal Form

Venue: Visconti Palace Hotel

Location: Rome, Italy

Event Date/Time: Apr 20, 2009 End Date/Time: Apr 22, 2009
Report as Spam


Dimensional Normal Form is a new approach to Data Warehouse Data Architecture which combines the strengths of both the normalized and the dimensional design paradigms to provide usable, flexible, scalable, and high performing schemas for the Enterprise Data Warehouse. Dimensional Normal Form allows an Enterprise Data Warehouse to be constructed a Data Mart at a time without requiring an intermediate Data Warehouse. While this sounds like the Kimball approach it is differentiated by its completely normalized ETL dimensions and its methods for tracking dimension history and differentiating contextual from detail or audit history.
This seminar fully covers design techniques for Data Warehousing and BI solutions based on the Dimensional Normal Form Data Architecture and discusses the pros and cons of the many design decisions that must be made. History considerations are discussed in detail along with their impact on schema design.
Various schema design examples are presented and discussed. The seminar participants will also be given design exercises will have their solutions analyzed and discussed by the group.
The seminar will also present contrasting Data Warehouse architectures and discuss the variations in physical design that are required for different Data Warehousing environments.
The following seminar on Template-Driven ETL will show how to build, populate and maintain the schemas built following the Dimensional Normal Form Data Architecture.

He specializes in high performance Data Warehousing solutions. He has in-depth experience utilizing efficient, scalable techniques whether dealing with large-scale Data Warehouses or small-scale, platform constrained Data Mart implementations. After establishing a career in database management systems and working for Software AG and IBM he began specializing in Data Warehousing in 1987 with Teradata. He subsequently worked for Red Brick and Informix and served as Director of Data Warehousing for Oracles’ Mid-Market Solutions Group. After establishing a successful independent consultancy he worked Knightsbridge Solutions and HP’s Information Management practice. He is most recently acted as the Lead DW/BI Architect for Nike building a new Enterprise Data Warehouse based on Informatica and Teradata. He is currently the principal and owner of Database Performance LLC. His experience with different systems, architectures, and methodologies has enabled him to evolve a unique approach to Data Warehousing utilizing best of breed components and methods. He has written several articles on his approach and has co-authored one book. He actively works on Data Warehouse implementations and teaches design and implementation classes internationally.


Additional Information

For further information please do not hesitate to contact us at info@technologytransfer.it or visit our website at www.technologytransfer.eu