« My Attempt at creating a hundred dimension data warehouse (Sarcastic) | Main
September 5, 2008
Salient Features of Data Modeling techniques
Relational: Normalization, Data Application Independence. One type of relation between entities
Object Model: Extensability, reuse, encapsulation. Conditional, Inheritance, association and other kinds of relationships between objects.
Dimensional: Precision, Understandability, Division of variables into measures / facts (Measures of business) and dimensions (parameters of Business Performance). One to many relationships between dimensions and facts. No relationships between dimensions. Hierarchhies within dimensions.
ORM: Mapping Objects onto relational space. Object relationships are built and maintained in application layer
ODM: Mapping Objects onto dimensional space. Multiple dimensional objects per dimension and multiple fact objects are all related to each other, and relationships implemented in reporting layer.
Posted by Vijay at September 5, 2008 6:45 AM
Comments
Vijay,
I am looking for hands on SSRS, SSAS and OLAP Cube workers that are interested in a full-time role in Manhattan paying 80-90K annually with a bonus. Please contact me if you or any of your friends/personal network are looking.
Thanks!
Daniel (dan@phisearch.com)
212-216-0007 x21
Posted by: Dan at October 21, 2008 3:23 PM
