Re: Query Optimization of the future...
Good post, Kirti! Quote... "Oracle Corp. says its customers are moving toward data stores of huge size and complexity, spread over multiple locations. The company says its products will not only evolve to handle those kinds of jobs, but will also do them extraordinarily well. "Over the next couple of releases, we'll see essentially fully autonomous databases," says Robert Shimp, vice president of database marketing." --- Well, he had to say *something* after IBM and Microsoft had such cool things to announce and discuss. Assuming the past record of 3-5 years on average between releases, the "next couple releases" will take 6-15 years or so. Personally, by that timeI'll beexpecting artificial intelligence, rather than just *autonomy*. Of course, I'm also expecting to be dead, too... It's clear that the basic research efforts by both IBM and Microsoftcontinue to bearfruit. IBM has a decades-old tradition of pushing its people to PhD research, while Microsoft has just gotten started relatively recently. To my knowledge, Oracle does not have a similar program within, does it? Nevertheless, Oracle has made a living exploitingpublicly availablebasic research (starting with its origins) and luring people from elsewhere (remember Informix's lawsuit some years ago?). As IBM, ATT,and Xerox will attest, its really tough to keep basic research under wraps for exploitation... Still, LEO and "stream queries" aren't necessary very far off in Oracle. Well, maybe LEO is, but not "stream queries" when you consider the underlying aspects of external tables... - Original Message - From: "Deshpande, Kirti" [EMAIL PROTECTED] To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 6:28 AM Subject: Query Optimization of the future... Interesting article on Query Optimization research.. http://www.computerworld.com/databasetopics/data/software/story/0,10801,7316 4,00.html - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Query Optimization of the future...
Kirti, The article is interesting and raises a lot of doubt and concern. Normally a companies database has a lot of queries against it that are the same and can be optimized at the source. The application is created and used by the employees with different variables placed in the blanks on the form. Repetitive look up of information. What is there to learn about different relationships of data if the applications we run at the companies provide answers to the same questions all day every day? If this technology was to be applied to a web site database that has many varied questions about many subjects, how large would the SGA,PGA, and other areas of the database have to be to contain the queries that it would optimize? And at what speed would this optimization occur? As an example, Let's use the Ford Motor Company web site, of the thousand of hits it receives how many are requesting similar information about the same model vehicle, same door panel, same trim design? With all of the varied information requested from the database it would take nothing short of artificial intelligence to know what you were looking for before you were looking for it. The article talked about autonomous databases, Hasn't uncle Larry been taunting that with 9i? Just a few thoughts, Ron ROR mª¿ªm [EMAIL PROTECTED] 08/15/02 08:28AM Interesting article on Query Optimization research.. http://www.computerworld.com/databasetopics/data/software/story/0,10801,7316 4,00.html - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Query Optimization of the future...
Well, he had to say *something* after IBM and Microsoft had such cool things to announce and discuss. Assuming the past record of 3-5 years on average between releases, the next couple releases will take 6-15 years or so. Personally, by that time I'll be expecting artificial intelligence, rather than just *autonomy*. Of course, I'm also expecting to be dead, too... nah, you're too young to die in 15 years... --- Tim Gorman [EMAIL PROTECTED] wrote: Good post, Kirti! Quote... Oracle Corp. says its customers are moving toward data stores of huge size and complexity, spread over multiple locations. The company says its products will not only evolve to handle those kinds of jobs, but will also do them extraordinarily well. Over the next couple of releases, we'll see essentially fully autonomous databases, says Robert Shimp, vice president of database marketing. --- Well, he had to say *something* after IBM and Microsoft had such cool things to announce and discuss. Assuming the past record of 3-5 years on average between releases, the next couple releases will take 6-15 years or so. Personally, by that time I'll be expecting artificial intelligence, rather than just *autonomy*. Of course, I'm also expecting to be dead, too... It's clear that the basic research efforts by both IBM and Microsoft continue to bear fruit. IBM has a decades-old tradition of pushing its people to PhD research, while Microsoft has just gotten started relatively recently. To my knowledge, Oracle does not have a similar program within, does it? Nevertheless, Oracle has made a living exploiting publicly available basic research (starting with its origins) and luring people from elsewhere (remember Informix's lawsuit some years ago?). As IBM, ATT, and Xerox will attest, its really tough to keep basic research under wraps for exploitation... Still, LEO and stream queries aren't necessary very far off in Oracle. Well, maybe LEO is, but not stream queries when you consider the underlying aspects of external tables... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 6:28 AM Interesting article on Query Optimization research.. http://www.computerworld.com/databasetopics/data/software/story/0,10801,7316 4,00.html - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Query Optimization of the future...
Thanks, Tim. I thought it was pretty 'interesting' response from Oracle Marketing ;) - Kirti -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 15, 2002 8:29 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Query Optimization of the future... Good post, Kirti! Quote... "Oracle Corp. says its customers are moving toward data stores of huge size and complexity, spread over multiple locations. The company says its products will not only evolve to handle those kinds of jobs, but will also do them extraordinarily well. "Over the next couple of releases, we'll see essentially fully autonomous databases," says Robert Shimp, vice president of database marketing." --- Well, he had to say *something* after IBM and Microsoft had such cool things to announce and discuss. Assuming the past record of 3-5 years on average between releases, the "next couple releases" will take 6-15 years or so. Personally, by that timeI'll beexpecting artificial intelligence, rather than just *autonomy*. Of course, I'm also expecting to be dead, too... It's clear that the basic research efforts by both IBM and Microsoftcontinue to bearfruit. IBM has a decades-old tradition of pushing its people to PhD research, while Microsoft has just gotten started relatively recently. To my knowledge, Oracle does not have a similar program within, does it? Nevertheless, Oracle has made a living exploitingpublicly availablebasic research (starting with its origins) and luring people from elsewhere (remember Informix's lawsuit some years ago?). As IBM, ATT,and Xerox will attest, its really tough to keep basic research under wraps for exploitation... Still, LEO and "stream queries" aren't necessary very far off in Oracle. Well, maybe LEO is, but not "stream queries" when you consider the underlying aspects of external tables... - Original Message - From: "Deshpande, Kirti" [EMAIL PROTECTED] To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 6:28 AM Subject: Query Optimization of the future... Interesting article on Query Optimization research.. http://www.computerworld.com/databasetopics/data/software/story/0,10801,7316 4,00.html - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).