DIMENSION ONE SIX

Brand Owner Address Description
DIMENSION 16 Winco Fireworks International 12521 15th Street Grandview MO 64030 DIMENSION ONE SIX; DIMENSION SIXTEEN;fireworks;
 

Where the owner name is not linked, that owner no longer owns the brand

    
Technical Examples
  1. A method and system for optimizing a query in a snow flake schema (60) within a relational database. The schema (60) includes a fact table (12) and multiple dimension tables and a plurality of dimension levels, with at least one dimension table at each level. A logical node (310) comprised of a level one child dimension table (32) and all dimension tables (62) rooted at this level one child dimension table is created based upon the cumulative selectivity calculation for all of the dimension tables at each level of the database (210). Creation of the logical node reduces a snow flake schema to a star schema, thereby mitigating search space traversal.