Re: The TransRelational Model: Performance Concerns

From: Jan Hidders <jan.hidders_at_REMOVETHIS.pandora.be>
Date: Fri, 12 Nov 2004 11:41:29 GMT
Message-ID: <Jj1ld.20136$ic5.1272973@phobos.telenet-ops.be>

Marshall Spight wrote:
> "Mikito Harakiri" <mikharakiri_at_iahu.com> wrote in message news:b2Ukd.15$vi7.138_at_news.oracle.com...
>

>>"Marshall Spight" <mspight_at_dnai.com> wrote in message
>>news:mJTkd.22827$V41.7166_at_attbi_s52...
>>
>>>Do you have any suggestions for places to start learning
>>>about query optimization and query execution? I have
>>>gone looking but not found much of anything.
>>
>>Did you check "Database Implementation" textbook by Garcia-Molina & Ulman &
>>Widom?

>
>
> No. I'll pick it up. It's like 1000 pages of small print, isn't it? :-(
>
> Darn it. Why is learning hard, complicated subjects so hard and complicated?!

Mikito's advice is excellent, but if you are looking for something shorter I can recommend the following two excellent surveys:

M. Jarke and J. Koch. Query Optimization in Database Systems. ACM Computing Surveys, 16(2): 111--152 (1984).

G. Graefe. Query evaluation techniques for large databases. ACM Computing Surveys, 25(2): 73--170, June 1993.

They are on line, but not for free. Mail me if you have trouble getting your hands on them, and I'll see what I can do.

Jan Hidders

Received on Fri Nov 12 2004 - 05:41:29 CST