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 ...




Being an Architect

There are a number of necessary skills for being an architect. Here's a list of four that occurred to me as I tried to piece together a coherent thought from a flurry of emails.

  • Summarize.
  • State A Goal.
  • Know The Technology.
  • Manage Your Investment In Learning.

These aren't sufficient skills …

more ...


Advanced Programming

First, I'm really pleased to see a focus on end-user applications of Python. It seems like most of the Open Source Community likes to build infrastructure, operating systems, servers, frameworks and components. Maybe I'm looking in all the wrong places, but I have a soft spot in my heart for …

more ...

What a Data Warehouse Can Never Do

In one form, the question is "How do we handle the [X] transaction in the warehouse?" Another form of the question is "What do we do when [Y] changes?" The third form is less clear, but essentially the same: "How do we maintain [Z] in the warehouse?"

All of these …

more ...


Refactoring and Unit Testing

I do a fair amount of manual refactoring. I've used WebSphere Studio (Eclipse) to do some automated refactoring, so I have some experience in using IDE's which exploit Java's static type-checking.

However, the question of type checking in a dynamic language is interesting. I don't use a sophisticated IDE for …

more ...