Post #69,574
12/18/02 5:29:51 AM
|
And here, IIRC, is where he got much of it from:
Joe Celko's Intelligent Enterprise Magazine [link|http://www.intelligententerprise.com/cgi-bin/printable.cgi?file=../001020/celko1_1.shtml|column on Trees in SQL of October 20, 2000] (if you want the pictures, here's the non-print version of that [link|http://www.intelligententerprise.com/001020/celko1_1.shtml|October 20, 2000, column on Trees in SQL]).
Dunno if Celko changed his mind before that column and after these earlier ones in DBMS Magazine: [link|http://www.dbmsmag.com/9603d06.html|A Look at SQL Trees, March 1996], and [link|http://www.dbmsmag.com/9605d06.html|Nontraditional Databases, May 1996], or if they're just older versions of the same thing.
HTH!
[link|mailto:MyUserId@MyISP.CountryCode|Christian R. Conrad] (I live in Finland, and my e-mail in-box is at the Saunalahti company.)
Actually, I rather like women, and don't particularly care for men, so I don't really mind that women are all completely insane. - [link|http://z.iwethey.org/forums/render/content/show?contentid=68920|Andrew Grygus]
|
Post #69,586
12/18/02 8:55:33 AM
|
Yep.
From the older articles. I hadn't seen the new one. The older series was more complete.
I've done a few things differently to get rid of the self-joins, however. That huge bump in speed we saw a few months ago back was largely due to that optimization.
Regards,
-scott anderson
"Welcome to Rivendell, Mr. Anderson..."
|
Post #69,768
12/18/02 8:18:13 PM
|
The left-right numbering is the key.
Once I know that, I can regenerate a set-tree implementation from nothing. The articles linked to come from an extremely SQL orientation which doesn't suit the way I (currently) think. Makes them a hard read, but I'll perserve because I want to learn how the coversion process works.
Fortunately, you spent time a year or so ago beating set-trees it into my head and for that I thank you! It's the kind of elegant design I like implementing.
Wade.
"Ah. One of the difficult questions."
|
Post #69,777
12/18/02 9:07:12 PM
|
Yep.
Celko has some good ideas. I don't know if they are all original, but he's to be credited with popularizing some of them.
On the other hand, I got into an email conversation with him once. I was left with the impression that he is quite egotistical, has very few social graces, and as a result is not interested in listening to Ideas Other Than His Own. Reminds me of someone else around here, as a matter of fact. We were discussing combinatorial algorithms in SQL, and I couldn't get across to him that hardcoding column names was a bad idea, and that I needed to be able to cross-combine arbitrary numbers of arbitrary-sized sets. I ended up solving my problem with an arithmetic trick, and I never did get him to understand. :-P
Regards,
-scott anderson
"Welcome to Rivendell, Mr. Anderson..."
|
Post #69,810
12/19/02 2:18:40 AM
|
What, you talkng in the singular?
Scott on Joe Celko: I was left with the impression that he is quite egotistical, has very few social graces, and as a result is not interested in listening to Ideas Other Than His Own. Reminds me of someone else around here, as a matter of fact. "Some one"??? There's lots of us like that here! :-)
[link|mailto:MyUserId@MyISP.CountryCode|Christian R. Conrad] (I live in Finland, and my e-mail in-box is at the Saunalahti company.)
Actually, I rather like women, and don't particularly care for men, so I don't really mind that women are all completely insane. - [link|http://z.iwethey.org/forums/render/content/show?contentid=68920|Andrew Grygus]
|
Post #69,821
12/19/02 5:52:21 AM
|
ObLRPD: "For Wade, it is to laugh. "
"Ah. One of the difficult questions."
|
Post #69,864
12/19/02 9:21:59 AM
|
Not on *this* level...
ObLRPD again: Will the real LRPD please stand up?
Regards,
-scott anderson
"Welcome to Rivendell, Mr. Anderson..."
|
Post #69,893
12/19/02 10:59:40 AM
|
Ob(?)LRPD: "Cococabanana Blaps...
"... - It's not just for breakfast anymore!"
So, since that is one of mine, you ARE ObViously talking about ME, eh?!?
:-)
[link|mailto:MyUserId@MyISP.CountryCode|Christian R. Conrad] (I live in Finland, and my e-mail in-box is at the Saunalahti company.)
Actually, I rather like women, and don't particularly care for men, so I don't really mind that women are all completely insane. - [link|http://z.iwethey.org/forums/render/content/show?contentid=68920|Andrew Grygus]
|