Dimensional Modelling Maxima Information Group

Oracle Design Tool – SQL Developer Data Modelling

On my most recent project I am again designing another data warehouse solution.

My tool of choice for data modelling has always been CA’s ERwin DataModeler

This is great, but we run into problems when trying to reverse engineer an existing database as this means that either my laptop has to go onto the customers network; that’s never going to happen. or the customer has to buy a copy of ERWin to use on their desktop.
My most recent customer is a dedicated Oracle customer using Database, Data Guard, RAC, Forms, OBIEE, Answers and on and on.

The obvious choice would be Oracle Designer. I have not used this in a few years but the last time it took me two days to get it installed and configured.

A quick search pointed me to an early adopters release of SQL Developer Data Modelling, you can find it here :
Here are a few of my thoughts:

Elaine Technology

The luddite is leaving the building !

Despite my working in IT and also “enjoying” technology, our kids being typical kids and having a PC each and an unstoppable curiosity, Elaine has never shared our passion.

Last week Elaine tore the ligaments in her left foot so has not been able to hit the shops at all and has been forced to stay at home with her feetĀ  up. Over the space of that week she did her first Asda shop online.

Last night, with no prompting Elaine had the laptop out and was shopping unaided !

The coup de grace was the next question:

How to I get the BBC iPlayer on the Wii to work again !


100 Pushups – 6 Weeks To Christmas !

It’s funny how your mind works, someone told me today that there were only six weeks until Christmas and my initial thought was of the six week challenge to do 100 consecutive pushups !

One Hundred Pushups
One Hundred Pushups

I faltered previously at week fix then subsequent events have meant that I have not been in the mindset for restarting this.

Tonight I went back and restarted at week 3, level 2 …… and failed.

Elaine Photography

My Latest Toy

I treated myself to a new toy for my camera.


Cactus Wireless Triggers