RE: RE: Google's architecture -- was Re: paging and google.com
Title: Message An brief overview of Googles architecture http://www.computer.org/micro/mi2003/m2022.pdf Google does use Oracle, but afaik only in-house for internal applications. The clustered search engine is entirely custom code and engine. 10,000 servers would be a pretty big RAC install. :) Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 12:55 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Google's architecture -- was Re: paging and google.com I'm confused. Does Tom Kyte actually say that Google uses Oracle or is he talking of "google-like behaviour" in Oracle queries ? Hemant At 07:24 AM 26-09-03 -0800, you wrote: http://tinyurl.com/ordz HTH Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, September 26, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Subject: Re: Google's architecture -- was Re: paging and google.com hmmm. must have read it wrong in the book. any idea how to get the 'estimated number of record returned? Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Google's architecture -- was Re: paging and google.com
Title: Message There you go. That's how we (DBAs) gonna make money in the future. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Friday, September 26, 2003 12:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Google's architecture -- was Re: paging and google.com Google like behavior in oracle queries? On top of real results you get "paid placement" entries, some of them X-rated? That'll be the day. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hemant K ChitaleSent: Friday, September 26, 2003 12:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Google's architecture -- was Re: paging and google.comI'm confused. Does Tom Kyte actually say that Google uses Oracleor is he talking of "google-like behaviour" in Oracle queries ?HemantAt 07:24 AM 26-09-03 -0800, you wrote: http://tinyurl.com/ordz HTH Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, September 26, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Subject: Re: Google's architecture -- was Re: paging and google.com hmmm. must have read it wrong in the book. any idea how to get the 'estimated number of record returned? Hemant K ChitaleOracle 9i Database Administrator Certified ProfessionalMy personal web site is : http://hkchital.tripod.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
RE: RE: Google's architecture -- was Re: paging and google.com
Title: Message Google does use Oracle, but afaik only in-house for internal applications. The clustered search engine is entirely custom code and engine. 10,000 servers would be a pretty big RAC install. :) Thanks, Matt --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Friday, September 26, 2003 12:55 PMTo: Multiple recipients of list ORACLE-LSubject: Re: RE: Google's architecture -- was Re: paging and google.comI'm confused. Does Tom Kyte actually say that Google uses Oracleor is he talking of "google-like behaviour" in Oracle queries ?HemantAt 07:24 AM 26-09-03 -0800, you wrote: http://tinyurl.com/ordz HTH Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, September 26, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Subject: Re: Google's architecture -- was Re: paging and google.com hmmm. must have read it wrong in the book. any idea how to get the 'estimated number of record returned? Hemant K ChitaleOracle 9i Database Administrator Certified ProfessionalMy personal web site is : http://hkchital.tripod.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Google's architecture -- was Re: paging and google.com
Title: Message
Hmm...
gives me something to work on... I've got the name to go with it
too...
"Before we look at your boring data, Bambi recommends you check this HOT
HOT HOT XXXInfo!!"
Gives
a whole new meaning to Relational Database.
-Original Message-From: Mladen Gogala
[mailto:[EMAIL PROTECTED]Sent: Friday, September 26, 2003
11:50 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Google's architecture -- was Re: paging and
google.com
Google like behavior in oracle queries? On top of real results you get
"paid placement" entries, some of them
X-rated? That'll be the day.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Hemant K ChitaleSent: Friday, September 26, 2003 12:40
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Google's architecture -- was Re: paging and
google.comI'm confused. Does Tom Kyte
actually say that Google uses Oracleor is he talking of "google-like
behaviour" in Oracle queries ?HemantAt 07:24 AM 26-09-03 -0800,
you wrote:
http://tinyurl.com/ordz
HTH Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
personal. QOTD: Any clod can have facts, having an
opinion is an art ! -Original
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 26, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L Subject: Re: Google's architecture -- was Re: paging and
google.com hmmm. must have read it wrong in
the book. any idea how to get the 'estimated number of record returned?
Hemant K ChitaleOracle 9i Database Administrator Certified
ProfessionalMy personal web site is : http://hkchital.tripod.com-- Please see the
official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale
INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051
http://www.fatcity.com San Diego, California -- Mailing list and web hosting
services
- 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).
Note:
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this message in error, please immediately delete it and
all copies of it from your system, destroy any hard copies of it and notify
the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the
intended recipient. Wang Trading
LLC and any of its subsidiaries each reserve the right to
monitor all e-mail communications through its networks. Any views
expressed in this message are those of the individual sender, except where the
message states otherwise and the sender is authorized to state them to be the
views of any such entity.
RE: Google's architecture -- was Re: paging and google.com
Title: Message
Google
like behavior in oracle queries? On top of real results you get "paid placement"
entries, some of them
X-rated? That'll be the day.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Hemant K ChitaleSent: Friday, September 26, 2003 12:40
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Google's architecture -- was Re: paging and
google.comI'm confused. Does Tom Kyte actually
say that Google uses Oracleor is he talking of "google-like behaviour" in
Oracle queries ?HemantAt 07:24 AM 26-09-03 -0800, you
wrote:
http://tinyurl.com/ordz
HTH Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
personal. QOTD: Any clod can have facts, having an
opinion is an art ! -Original
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, September 26, 2003 11:00 AM To:
Multiple recipients of list ORACLE-L Subject: Re:
Google's architecture -- was Re: paging and google.com hmmm. must have read it wrong in the book. any idea how to get the
'estimated number of record returned?
Hemant K ChitaleOracle 9i Database Administrator Certified
ProfessionalMy personal web site is : http://hkchital.tripod.com-- Please see the
official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET:
[EMAIL PROTECTED] Fat City Network Services -- 858-538-5051
http://www.fatcity.com San Diego, California -- Mailing list and web hosting
services -
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).
Note:
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. Wang Trading
LLC and any of its subsidiaries each reserve the right to
monitor all e-mail communications through its networks. Any views
expressed in this message are those of the individual sender, except where the
message states otherwise and the sender is authorized to state them to be the
views of any such entity.
Re: RE: Google's architecture -- was Re: paging and google.com
must have been google like behavior. i dont focus on every word. > > From: Hemant K Chitale <[EMAIL PROTECTED]> > Date: 2003/09/26 Fri PM 12:39:53 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Google's architecture -- was Re: paging and google.com > > I'm confused. Does Tom Kyte actually say that Google uses Oracle or is he talking of "google-like behaviour" in Oracle queries ? Hemant At 07:24 AM 26-09-03 -0800, you wrote: http://tinyurl.com/ordz HTH Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, September 26, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Subject: Re: Google's architecture -- was Re: paging and google.com hmmm. must have read it wrong in the book. any idea how to get the 'estimated number of record returned? Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Google's architecture -- was Re: paging and google.com
Sorry Hemant ...
The link points to RGaffuri's quest to find 'approximately how many rows
will be received' part of the question.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !
-Original Message-From: Hemant K Chitale
[mailto:[EMAIL PROTECTED]Sent: Friday, September 26, 2003
12:40 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Google's architecture -- was Re: paging and
google.comI'm confused. Does Tom Kyte actually
say that Google uses Oracleor is he talking of "google-like behaviour" in
Oracle queries ?HemantAt 07:24 AM 26-09-03 -0800, you
wrote:
http://tinyurl.com/ordz
HTH Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
personal. QOTD: Any clod can have facts, having an
opinion is an art ! -Original
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, September 26, 2003 11:00 AM To:
Multiple recipients of list ORACLE-L Subject: Re:
Google's architecture -- was Re: paging and google.com hmmm. must have read it wrong in the book. any idea how to get the
'estimated number of record returned?
Hemant K ChitaleOracle 9i Database Administrator Certified
ProfessionalMy personal web site is : http://hkchital.tripod.com-- Please see the
official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET:
[EMAIL PROTECTED] Fat City Network Services -- 858-538-5051
http://www.fatcity.com San Diego, California -- Mailing list and web hosting
services -
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).
This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, attorney work product or exempt from
disclosure under applicable law. If you have received this message in error, or are
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank
you.*1
RE: Google's architecture -- was Re: paging and google.com
I'm confused. Does Tom Kyte actually say that Google uses Oracle or is he talking of "google-like behaviour" in Oracle queries ? Hemant At 07:24 AM 26-09-03 -0800, you wrote: http://tinyurl.com/ordz HTH Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, September 26, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Subject: Re: Google's architecture -- was Re: paging and google.com hmmm. must have read it wrong in the book. any idea how to get the 'estimated number of record returned? Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Google's architecture -- was Re: paging and google.com
Title: RE: Google's architecture -- was Re: paging and google.com http://tinyurl.com/ordz HTH Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, September 26, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Subject: Re: Google's architecture -- was Re: paging and google.com hmmm. must have read it wrong in the book. any idea how to get the 'estimated number of record returned? This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: Google's architecture -- was Re: paging and google.com
hmmm. must have read it wrong in the book. any idea how to get the 'estimated number of record returned? > > From: Hemant K Chitale <[EMAIL PROTECTED]> > Date: 2003/09/26 Fri AM 10:44:40 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Google's architecture -- was Re: paging and google.com > > > Google certainly doesn't use an Oracle database. They just wouldn't get the > performance > that they achieve currently. > See this link on Google's architecture > : http://www.computer.org/micro/mi2003/m2022.pdf > > Hemant > > At 05:44 AM 26-09-03 -0800, you wrote: > >Im in the middle of Kytes new tuning book. He states that google uses a > >query similiar to this to return web pages in their search function: > > > >select /*+ FIRST_ROWS */ b.* > >from ( select a.*, a.rownum > > from (your query here) a > > where rownum < <>) > >where rownum > <> > > > > > >If they are using oracle to do this, how do they get the estimated number > >of total results? Is it from 'cardinality'? Do you know which data > >dictionary that comes from? explain plan is costly so they cant be using that. > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.net > >-- > >Author: <[EMAIL PROTECTED] > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com > >San Diego, California-- Mailing list and web hosting services > >- > >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). > > Hemant K Chitale > Oracle 9i Database Administrator Certified Professional > My personal web site is : http://hkchital.tripod.com > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Hemant K Chitale > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
