Wednesday, June 29, 2005

Am I a Cartesian Product ?

Whilst being involved in the world of computers and technology, I have always tried to stay clear of technical acronyms and confusing (unnecessary) 'tech speak'(I frankly refuse to use the words g**k speak)... but every now and then I enter the abyss and talk in terms that alienate 90% of the population. This becomes particularly surreal when laughing and joking about a technical phrase... especially if the participants of the conversation can see the humour on multiple levels... as a joke between each other and as a fly on the wall... looking around at the strangest faces as 'non-technical' people struggle to comprehend what the hell it all means... The particular phrase that amused us was Cartesian Product... how the hell do you even start to explain it to not only non-technical people... but even to people on the technical ladder... For those of you who have escaped falling into a coma... a Cartesian Product is a table created when data is pulled from two other tables with no WHERE clause... all that happens is that you end up with a table that is full of data... but 9/10 that data is rubbish and meaningless... So where is the humour in that... well for the technical team the momment came about when we considered that there is a term for a relatively pointless process... someone actually thought it required naming ? Referring to the SQL for Dummies book... which in itself is nuts... PC's for Dummies I understand... Driving a car for Dummies I could get... but SQL... that is just frankly crazy... it may as well say nuclear fission for dummies... or brain surgery for dummies... unless you had some understanding of the human body... you wouldn't even know where to begin. Anyway back to the Cartesian Product... in the previously mentioned giant of the literal world... a Cartesian Product is descibed as... "When youre trying to get useful information out of a multitable database, the Cartesian Product produced is almost never what you want. It's almost always the first step toward what you want...' Does that make me a Cartesian Product... I am certainly at the first step towards what I want...

3 comments:

Richard Sheppard said...

What if you're 100% correct from a technical point of view, yet the answer is still of no use?

Richard Sheppard said...
This comment has been removed by a blog administrator.
Richard Sheppard said...

I forgot to mention that you left this around my house the other day:

=IF((VALUE(RIGHT(FIXED(H7),1))<9),
(((VALUE(RIGHT(FIXED(H7),2))-
((RIGHT(FIXED(H7),1))+1)))*0.01
+ROUNDDOWN(FIXED(H7),0),FIXED(H7))