Rating Your Dimensional Data Warehouse Article Example | Topics and Well Written Essays - 500 words

Rating Your Dimensional Data store - Article ExampleWhile a sum total score of 0 would indicate a system completely unsupportive of a dimensional approach, a score of 20 would indicate a system that is fully supportive of a dimensional approach.The author outlays 12 of the 20 criteria in the article. Some of the criteria that pertain to the Architecture of the Data W arehouse are Explicit Declaration, Conformed Dimensions and Facts, Dimensional Integrity, coarse Aggregate Navigation, Dimensional Symmetry, Dimensional Scalability and Sparsity Tolerance, etc. Kimb any explains Open Aggregate Navigation as followsThe system uses physically stored aggregates as a way to enhance consummation of common queries. These aggregates, like indexes, are chosen silently by the database if they are physically present. End users and practical application developers do not need to know what aggregates are available at any point in time, and applications are not required to explicitly code the nam e of an aggregate. All query processes accessing the data, even those from unlike application vendors, realize the full benefit of aggregate navigation. (Kimball, 2000)Similarly, some of the criteria that fall under Administration stratum are Graceful Modification, Dimensional Replication, Dimension Notification, Surrogate Key Administration, International Consistency, etc. Kimball explains Dimensinal Replication as followsThe system supports the explicit replication of a conformed dimension outward from a dimension authority to all the client data marts, in such a way that we can only perform drill-across queries on data marts if they have legitimate versions of the dimensions. Aggregates that are affected by changes to the content of a dimension are automatically taken offline in each client data mart until we can make them consistent with the revised dimension and the base fact table. (Kimball, 2000)One of the impressive aspects of the article is its compact