Joe Celko, Bill of Materials, hierarchical nested trees, data explosion...

'Andrew Shepherd' on Tue, 01 Nov 2005 21:39:06 GMT, sez:

Dude,

Are we expected to have any idea WTF you're talking about?

'secretGeek' on Tue, 01 Nov 2005 21:41:51 GMT, sez:

generally yes, today no.

'Steve Hiner' on Thu, 03 Nov 2005 18:40:58 GMT, sez:

I know exactly what you're talking about. I got into Celko a while back. Never got his book but I did play with this nested sets stuff a fair bit.

I ended up not using it because I was adding way too much data to the sets. His sets seem to work better with relatively static data. There's just too much re-jiggering of the data for it to work on a system that deals with 8000-12000 new records every day like my mutual fund trade sorting platform did.

I never did benchmark it though - maybe it would work OK in SQL Server. I moved away from it because adding a new record could easily involved changing data in thousands of other records.

However, that being said, maybe your needs are far enough different from mine that it's perfect for you.

Feel free to email me at my gmail account (just my name without spaces) and I'll help you in any way I can. I'm quite facinated by Celko's stuff - he really is a SQL wizard.

name


website (optional)


enter the word:
 

comment (HTML not allowed)

All viewpoints welcome. But the right to delete any post for any reason is reserved. Don't make me do it. Aim for constructiveness. Comments may be republished, emailed to your loved ones or printed and used as toilet paper. Also, I get particularly nasty on comment spam. It's not worth even trying to post comment spam here -- your html is escaped, and your links are given a rel='nofollow'. By attempting to post a comment, you understand that if the comment is considered spam, at my absolute discretion, your IP address may be used as the target of a prolonged distributed denial of service attack. Your electricity might suddenly stop working. Your car tyres will go mysteriously flat. You will suffer permanent hairloss. Your dreams will be filled with terrifying monsters. And in any case I reserve the right to record and publish your IP address.

 

TimeSnapper_{Know thyself!}

TimeSnapper is a life analysis system that stores and plays-back your computer use. It makes timesheet recording a breeze, helps you recover lost work and shows you how to sharpen your act.

 

NimbleText is a Powerful FREE Tool

Use it for:

• extracting data from text
• manipulating text
• generating code

It makes you look awesome. Use it right now! Go on! Hurry! Don't walk, run!