|
|
February 17, 2004 Meeting
|
|
A compare and contrast of: Operational vs. Informational Systems and Relational vs. Dimensional Modeling
|
|
Presented by Wayne Little
Time: Registration/Refreshments - 8:30-9:00 a.m.
Presentation
- 9:00-11:00 a.m.
Announcements
- 11:00-11:30 a.m.
Location: Menlo WorldWide - Freemont Conference Room
Presentation Download: Click
Here
A compare and contrast of:
- Operational (OLTP) vs. Informational (Analytical, DW, DM) Systems
- Relational vs. Dimensional Modeling
A what, why, how and where compare and contrast will be given.
- What, why where and how are they different? ... the same?
- What, why, where and how are they / should they be used?
Including:
- A brief tour of the historical and theoretical underpinnings of:
- Relational Data Bases
- Entity-Relationship (ER) Modeling
- An overview and synthesis of the 2 major Dimensional Modeling camps
- Inmon vs. Kimball.
- Bill Inmon's Corporative Information Factory Components
- Data Warehouses (DW) and Data Marts
- A real-life case study - When Two Worlds Collide
- Untangling conflicting requirements
- With apologies to Sgt. Friday, It's more than "Just the facts, Ma'am"
- Accommodating operational AND analytical requirements in a dimensional design
Wayne Little is a Sr. Data Architect and Oracle Developer for ServerLogic Inc. in Portland, OR.
Through an IT career of almost 25 years, he has worked in analysis and design, programming,
data architecture, data base administration, system management, consulting and education roles.
He has been data modeling and developing large data base systems since 1991.
|
|
