style="margin-top:70px;" Clickstream


Data Quality Keynote Audio is Available Online

This was one of the better-received keynotes I've given. Maybe because it was totally unrehearsed, or maybe because the audience was hopped up on sugar and happy to have me end exactly on time for lunch.

Firstlogic put the audio and slides of my iSummit keynote up at their web site (registration required). This is a replay of the webcast from the conference, so it's a timed slide show and audio. A PDF containing copies of the slides is available on the playback page.

They use Interwise software to stream the audio and video, which unfortunately requires a client download and doesn't work with Mozilla / Firefox. I'll try to create an mp3 and post it and the PDF here after I get a copy of the audio back from them. I want non-Microsoft users to enjoy me as much as I do. The Firstlogic site is best if you use IE because the slides are synchronized with the audio, making the presentation easier to follow. I like the Interwise software for webcasting better than many of the other packages I've seen, even if it is Microsoft-centric.

Update: Jose Cardenas has been kind enough to post an AVI for me (53MB).

DB2 UDB: Just Say No

I've decided to resurrect an article I wrote two years ago about databases for data warehousing, after encountering a series of flaws in DB2 UDB that are simply inexcusable. For those not in the know, UDB is the non-mainframe version of DB2. Everything I say from here on out refers only to UDB, and not to the mainframe product which is actually different (and superior) code.

For a long time I didn't think there was a huge difference between using any of the major vendors' databases unless you were at the extreme high end of data volumes or users. Then I started using DB2 in earnest for a data warehouse three years ago. I kept stumbling over lackings between DB2 and everyone else.

The biggest gaps at first had to do with basic functionality that DB2 lacked (and in some cases still lacks). In the past two releases they have managed to close that gap a little, although the problem now is one of technological maturity. The features they added are not as robust as those same features in Oracle or even SQLServer because IBM has not had the time to work through the kinks that Oracle and Microsoft and Teradata worked out. The sad thing is that these features were available in 1996-97 in the other databases, and UDB has only added them in the past two years.

Then I started noticing how poor IBM's development and client tools are for UDB. Then picking up on the fact that the database is harder to manage, harder to tune, in general much harder to support than any of the other products. It wasn't just me. DBAs who have gone from UDB to Oracle or SQLServer (or in one case Teradata) have all said the same thing: UDB is not comparable to these other products, particularly when looking at data warehouse features.

I thought I was finished griping until recently, when IBM released version 8 of UDB. I term this the "apoplectic release" because I've been that way since it came out. Among other things, they took some shortcuts in their SQLJ (embedded SQL in Java) implementation. The SQLJ translator and bind utilities, compiler if you will, was broken. It would not properly handle syntactically correct SQL statements. A few workarounds and several weeks of technical support and things are straightened out. Until the latest bug affecting code that worked perfectly for the past three years.

It turns out that their software converts the != operator to an = operator when creating a package in the database! What moron could let something so obviously wrong creep through QA and be released into production code? How many customers have code out there using a not equals and therefore generating bogus results? How could IBM get something so simple and basic so incredibly wrong?

My official position has shifted from one of neutrality to outright disdain. Until IBM gets their act together with UDB, they are on the bottom of my list and I am actively discouraging people from using it on any platform other than the mainframe. Go to any other database, but stay away from this product. Even if you already have it in-house and have experieinced staff. The other products are more reliable, easier to manage, and more developer friendly.

I'll be posting the old "why not db2?" article after I clean it up and make it more current.

Business Objects User Group in November

I'll be at the Business Objects annual user conference this November, hoping to pick up some useful info on new products and where the company will be taking its Data Integrator ETL product. Report will be here after I get back.


Data warehousing, business intelligence, IT strategy and architecture, and occasional interesting bits.

Subscribe to XML feed

Bio / About Me

Check out my book

Clickstream data warehousing book cover Buy clickstream data warehousing from

Search this site or  the web

Site search   Web search
powered by FreeFind
Popular Posts
Primate programming.
Why development in crunch mode doesn't work.
Enterprise data modeling sucks big rocks.
XP Exaggerated.
Ping-pong in the matrix.
Time management for anarchists.
Is Ab Initio worth evaluating?
Job posting: omniscient architect.
Why hiring more sales people won't grow revenues faster.
Some resources for Open Source CMS.

Reading List
The Cruise of the Snark
Blue Latitudes
Everyone in Silico
The Klamath Knot
Swarm Intelligence (Bonabeau)
A three year backlog of F&SF

Listening List
Toots and the Maytals
The Buena Vista Social Club
American Idiot

Watching List
Winged Migration Quicktime trailer
Ghengis Blues
Howl's Moving Castls
A Bronx Tale

Daily KOS
Due Diligence
Boing Boing
Kevin Kelly (Recomendo)
Not Geniuses
3 Quarks Daily

War in Context
Valmiki's Ramayana
Choose the Blue
Third Nature
Mark Madsen
The Data Warehouse Institute
James Howard Kunstler
Clickstream Data Warehousing
Technorati Profile

04/01/2003 - 05/01/2003 05/01/2003 - 06/01/2003 06/01/2003 - 07/01/2003 07/01/2003 - 08/01/2003 08/01/2003 - 09/01/2003 09/01/2003 - 10/01/2003 10/01/2003 - 11/01/2003 11/01/2003 - 12/01/2003 12/01/2003 - 01/01/2004 05/01/2004 - 06/01/2004 06/01/2004 - 07/01/2004 07/01/2004 - 08/01/2004 08/01/2004 - 09/01/2004 09/01/2004 - 10/01/2004 10/01/2004 - 11/01/2004 11/01/2004 - 12/01/2004 12/01/2004 - 01/01/2005 01/01/2005 - 02/01/2005 02/01/2005 - 03/01/2005 03/01/2005 - 04/01/2005 05/01/2005 - 06/01/2005 06/01/2005 - 07/01/2005 07/01/2005 - 08/01/2005 08/01/2005 - 09/01/2005 09/01/2005 - 10/01/2005 10/01/2005 - 11/01/2005 11/01/2005 - 12/01/2005 12/01/2005 - 01/01/2006 01/01/2006 - 02/01/2006 03/01/2006 - 04/01/2006 05/01/2006 - 06/01/2006 06/01/2006 - 07/01/2006 07/01/2006 - 08/01/2006 08/01/2006 - 09/01/2006 09/01/2006 - 10/01/2006 10/01/2006 - 11/01/2006 01/01/2007 - 02/01/2007 02/01/2007 - 03/01/2007 03/01/2007 - 04/01/2007 04/01/2007 - 05/01/2007 05/01/2007 - 06/01/2007 06/01/2007 - 07/01/2007 07/01/2007 - 08/01/2007 08/01/2007 - 09/01/2007 09/01/2007 - 10/01/2007 10/01/2007 - 11/01/2007 11/01/2007 - 12/01/2007 12/01/2007 - 01/01/2008 01/01/2008 - 02/01/2008 02/01/2008 - 03/01/2008 03/01/2008 - 04/01/2008 08/01/2008 - 09/01/2008 06/01/2009 - 07/01/2009 08/01/2009 - 09/01/2009 10/01/2009 - 11/01/2009 01/01/2010 - 02/01/2010 09/01/2011 - 10/01/2011 04/01/2013 - 05/01/2013

Powered by Blogger.

Creative Commons License
This work is licensed under this Creative Commons License except where indicated.