The Inner Dimension is a place in between the real world and beyond, inadvertently created by mankind. A tunnel, before the light - or the dark. But this is not a place for the dead, nor the living. It is not safe to linger here. Three seemingly random strangers suddenly find themselves lost in this adjacent dimension, completely unaware of how they got there.
Runtime: 21 minutes
Inner Dimension - Star schema - Netflix
In computing, the star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts. The star schema consists of one or more fact tables referencing any number of dimension tables. The star schema is an important special case of the snowflake schema, and is more effective for handling simpler queries. The star schema gets its name from the physical model's resemblance to a star shape with a fact table at its center and the dimension tables surrounding it representing the star's points.
Inner Dimension - Benefits - Netflix
Star schemas are denormalized, meaning the normal rules of normalization applied to transactional relational databases are relaxed during star schema design and implementation. The benefits of star schema denormalization are: Simpler queries - star schema join logic is generally simpler than the join logic required to retrieve data from a highly normalized transactional schema. Simplified business reporting logic - when compared to highly normalized schemas, the star schema simplifies common business reporting logic, such as period-over-period and as-of reporting. Query performance gains - star schemas can provide performance enhancements for read-only reporting applications when compared to highly normalized schemas. Fast aggregations - the simpler queries against a star schema can result in improved performance for aggregation operations. Feeding cubes - star schemas are used by all OLAP systems to build proprietary OLAP cubes efficiently; in fact, most major OLAP systems provide a ROLAP mode of operation which can use a star schema directly as a source without building a proprietary cube structure.