|
|
Portland Chapter
Data Administration Management Association
P.O. Box 2343
Portland, OR 97208-2343
www.dama-pdx.org
Board Members
President
Wayne Little
VP Membership
Krishna Moorthy
VP Education
Open
VP Communication
James Lee
VP Financial Services
Nancy Hallock
VP Online Services
Atul Borkar
VP Secretarial Services
Don Rognlien
Past President
Hanteng Dai
| |
Tuesday, 19th August, 2008 Meeting |
|
Optimizing Enterprise Data Warehouse design utilizing dimentional
normal form.
|
| Presented by Michael Schmitz
Time: Registration/Refreshments - 8:30-9:00 a.m.
Presentation - 9:00-11:00 a.m.
Announcements - 11:00-11:30 a.m.
Dimensional Normal
Form is a hybrid approach to data warehouse data architecture. It
combines the strengths of both the normalized and the dimensional
design methodologies to provide usable, flexible, scalable, and high
performing schemas for the enterprise data warehouse. Dimensional
Normal Form eliminates the need for presentation layer data marts.
It also allows an Enterprise Data Warehouse to be constructed
iteratively by business process area. While this sounds like the
Dimensional approach it is differentiated by its completely
normalized ETL dimensions and its approach to tracking dimension
attribute history. This
presentation presents the new architecture and provides
implementation examples.
Michael Schmitz 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 for Knightsbridge Solutions and HP�s Information Management
practice. He is currently the Lead DW/BI Architect for Nike and is
building a new Enterprise Data Warehouse system for them based on
Informatica and Teradata. 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.
| |
