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.
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.
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.
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 www.processlibrary.com 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.
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!
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.
August 31, 2004
Mobile Phone / PC connectivity
If, 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: http://fma.sourceforge.net/
Also if you want to access the internet via your mobile GPRS you can monitor your call costs using Magitime: http://www.geocities.com/magistone/welcome.htm
And if you want some java apps for your phone visit: http://www.getjar.com/ or http://midlet.org
May 16, 2004
All you wanted to know about Electronic Payments..
but were afraid to ask.. www.electronic-payments.co.uk