RE: No to SQL? Anti-database movement gains steam

From: Matthew Zito <mzito_at_gridapp.com>
Date: Mon, 6 Jul 2009 15:01:20 -0400
Message-ID: <C0A5E31718FC064A91E9FD7BE2F081B10228874A_at_exchange.gridapp.com>

I think very on-topic, but if you read the article, they modified PostgreSQL to be columnar instead of row-based. This holds up with another school of thought from folks like Vertica that column-oriented databases are the "way to go" to scale to these types of data sizes and ranges. Yet another variant on the traditional RDBMS for specific uses. They also mentioned that yahoo acquired the technology from a small startup, and then adapted it.  

Matt  

---

From: David Ballester [mailto:ballester.david_at_gmail.com] Sent: Monday, July 06, 2009 2:58 PM
To: Matthew Zito
Cc: dbvision_at_iinet.net.au; Oracle-L_at_freelists.org Subject: Re: No to SQL? Anti-database movement gains steam             

        Now certainly, you can build a >100TB Oracle instance, but the cost and

        the complexity would be challenging. In addition, presumably they only

        see this data store growing, and how do you deal with a 200, 300, 400TB

        Oracle instance? Google, for example, in 2006 had approximately 1.2PB

        of data in their structured data store. Heaven knows what it is now.

semi off topic

Yahoo has a datawarehouse of 2PB and 24 Bilions of 'events' ( changes? ) per day. They got postgresql source code and rebuild some parts to meet their needs

Afaik, they are very happy with the results

http://www.dbms2.com/2008/05/29/yahoo-scales-web-analytics-database-peta byte/

D.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 06 2009 - 14:01:20 CDT