May 26, 2009

Oracle Database 10g OLAP Performance Tips & Techniques

The OLAP Option to Oracle 10g gives you the ability to store multidimensional cubes of data in your Oracle database, and perform OLAP queries on them using OLAP DML, regular SQL or query tools such as Oracle Discoverer Plus OLAP. Part 1 and 2 of this article provides tips and best practices for designing, loading, aggregating and querying Oracle OLAP cubes and in addition takes a look at some of the new features coming with 10g Release 2.

read the full article

Posted by tonyr at 09:46 AM

February 26, 2009

Data Modeling Tricks

Developing a good entity definition is more than just an exercise in documentation. Good entity definitions are essential to the identification and demarcation of the set of entities in a . To do this, each entity definition needs to be intentional1; that is, comprising a comprehensive set of criteria that an instance must meet in order to be distinguishable as a member of the entity set. An extentional definition, in contrast, is a list of examples. An extentional definition may provide good additional clarification for the “real,” intentional definition; but, by definition (ahem), an intentional definition cannot be comprehensive.

read the full article

Posted by tonyr at 12:49 PM

June 23, 2008

Open Web Design Offers Free Web Design Templates

Planning to spend some time this weekend, or during one of those mythical "free" weekends, whipping your web site into shape? Open Web Design, a free and frequently-updated collection of site templates handed out without copyright, is a great place to start looking. We've posted similar collections before, but Open Web Design trumps our archives for up-to-date designs and breadth of material—images, CSS templates, and standard HTML are all available. The site is free to use, and registration lets you submit ideas and post to a forum.

Posted by tonyr at 05:06 PM

January 31, 2005

Those darn pop-ups!

Adware usually installs itself into the Windows registry and re-installs itself when your computer starts-up.

To see what programs start automatically from your registry, click on "Windows-Start > Run" and type "regedit".

Next go to: "hkey_local_machine > software > microsoft > windows > currentversion > run"

Then check on the website to see what the processes are and if it looks undesirable then delete the processes from your registry. It is best to back up your computer before this or the Windows XP "restore" functionality may undo any changes if you get it wrong.

Posted by tonyr at 11:12 AM

September 24, 2004

GPRS internet cost warning

Should you want to connect to the internet from your Windows XP Laptop be very aware that Windows XP Automatic Update is enabled by default.

This can download many MBs in the background, which is very expensive for GPRS modems - 3/MB or more depending upon your network.

And browsing is best done with images turned OFF!

Posted by tonyr at 01:50 PM

September 17, 2004

Formatting external HDD in XP

Go into: Control Panel > Administrative Tools > Computer Management and click on the unformatted external HDD, then Format.

You may not be able to create paritions greater than 120GB (possibly due to IDE limitations rather than limitations with NTFS). In this case use a Partitioning tool to split your HDD in two.

Posted by tonyr at 12:03 PM

August 31, 2004

Mobile Phone / PC connectivity

t610.jpgIf, like me, you are the proud owner of a Sony Erricsson T610 mobile then why not try this excellent tool to connect your phone to your PC:

Also if you want to access the internet via your mobile GPRS you can monitor your call costs using Magitime:

And if you want some java apps for your phone visit: or

Posted by tonyr at 04:55 PM

May 16, 2004

All you wanted to know about Electronic Payments..

but were afraid to ask..

Posted by tonyr at 11:34 AM

April 09, 2004

Windows XP Processes


Posted by tonyr at 12:06 PM

April 08, 2004

Free PC System Information Tool

The excellent Aida32

Posted by tonyr at 10:01 PM