The Spider Schema is a New Multi-Dimensional Data Warehouse Architecture / Schema developed by Mark Hargraves which solves many inherent issues with the commonly used Star and Snowflake Schema’s. This Architecture has been deployed in various industries over the past 5 years and proven viable. It is supported by all known BI (Business Intelligence) Analytical Tools including Microsoft SQL Server Analysis Services (SSAS). It replaces the Star and Snowflake Data Warehouse Schema’s with a more robust Schema.
The Spider Schema or Architecture supports full:
- Dimension to Dimension Relationships
- Data load balancing
- Support for Big Data
- Replaces Hierarchies
- Reduces data storage
- Decreases ETL and Cube Processing time