Oracle-L: Re: OT: move over CBO, make room for Leo!

From: <Brian_P_MacLean_at_efunds.com>
Date: Wed, 07 Aug 2002 17:08:24 -0800
Message-ID: <F001.004AE612.20020807170824@fatcity.com>

I remember hearing Mike Ault at IOUG in 94 or 95 talk about the CBO (by the way, Mike was about the only the DBA God back then). At that time CBO had been out for a year+. His statement was "CBO, nice idea, maybe someday they will get it to work right". Well that was at least 7 years ago and IMAO CBO is/has now just finally matured.

So let me see, "LEO, nice idea, maybe someday I'll convert to it".

I will follow-up with another email on this in 10 years when LEO matures.

By the way, 5 years ago data warehousing news was talking about getting partial preliminary result sets, displayed in a real nice touchy gui, as the datamining queries were running so that you had a way of saying "I don't think this is what I want", and stopped the query, changing it, then re-submitting it again. It was a really kool wiz bang idea.....I'm still waiting for that one to come to market.

Next Please.....

                                                                                                                               
                      Jacques Kilchoer                                                                                         
                      <Jacques.Kilchoer        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>           
                      @quest.com>              cc:                                                                             
                      Sent by:                 Subject:  OT: move over CBO, make room for Leo!                                 
                      root_at_fatcity.com                                                                                         
                                                                                                                               
                                                                                                                               
                      08/07/02 03:38 PM                                                                                        
                      Please respond to                                                                                        
                      ORACLE-L

I noticed a couple of interesting nuggets of information in this computerworld article about new db developments:

<<Thirty years ago, IBM researcher Pat Selinger invented "cost-based" query optimization...>> I did not know that.
<<Now Selinger, is leading an effort at IBM called Leo-for Learning Optimizer ... Rather then optimizing a query once, when it's compiled, Leo will watch production queries as they run and fine-tune them as it learns about data relationships and user needs. "It empirically derives interesting things about the data," Selinger says. For example, Leo would come to realize that a ZIP code can be associated with only one state, or that a Camry is made only by Toyota, even if those rules aren't specified in advance.>>

and
c) Two out of the three people mentioned in the article, Pat Selinger and Jennifer Widom, are women! I guess those "take your daughter to work" days are paying off. I'm happy to see more gender equality in computer science.

http://computerworld.com/databasetopics/data/software/story/0,10801,73164,00.html

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Brian_P_MacLean_at_eFunds.Com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Aug 07 2002 - 20:08:24 CDT