Another Dimensional Model Implementation

The Cubulus project and Alexandru Toth 's page describe an "OLAP Aggregation Engine". It is very nice to see advanced work done on the dimensional model.

The cited research dates from 1999 (V. Markl, F. Ramsak, R. Bayer, "Improving OLAP Performance by Multidimensional Hierarchical Clustering", Proceedings of the Intl. Database …

more ...




The Web Mart Design Pattern.

Date Tags news

The Web Mart design pattern identifies three aspects to a piece of web content:

  • The Core Concept - the "fact" that we will present.
  • The Access Dimensions - objects that identify a concept or support navigation to the concept.
  • The Details - objects that provide details in support of a concept.

There are …

more ...



Python and Reverse Engineering, Part 5

Python is a top-shelf toolset for creating sample data to do performance testing.

Let's say that you need to validate a data warehouse design, and you need a million facts that join with thousands of dimension entities across a half-dozen dimensions. You'll be generating data for seven different tables, and …

more ...