Business Dimensional Model™

The Business Dimensional Model™ is a vehicle to document conformed dimensions with business attributes and their relationships in end user terms. This conceptual multi-dimensional model easily translates into both logical and physical database designs. The Business Dimensional Model™ identifies:

• Dimensionality of the business
• Business attributes within each dimension
• Attribute relationships within each dimension
• Hierarchical structures (drill paths)
• Required business measures or facts
• OLAP requirements
• Potential pre-stored aggregates

Data Warehouse Database Design

StarSoft Solutions uses the principals of star schema design as the basis for all Data Warehouse Database Designs. Star Schemas, are now the defacto industry standard for data warehousing and are required by the high end OLAP DSS tools. Using a blend of consolidated star and full snowflake schemas allows StarSoft Solutions to develop the most appropriate structure to fit your business needs and data access tool requirements. Primary components of Data Warehouse Database Design both logical and physical include:

• Star or snowflake schema designs
• Tables & columns
• Primary & foreign keys
• Partitioning strategy
• Indexing strategy
• Data clustering / organization

Return to the Business Dimensional Lifecycle™