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

  • From: "Matthew Zito" <mzito@xxxxxxxxxxx>
  • To: "David Ballester" <ballester.david@xxxxxxxxx>
  • Date: Mon, 6 Jul 2009 15:01:20 -0400

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.





From: David Ballester [mailto:ballester.david@xxxxxxxxx] 
Sent: Monday, July 06, 2009 2:58 PM
To: Matthew Zito
Cc: dbvision@xxxxxxxxxxxx; Oracle-L@xxxxxxxxxxxxx
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

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


Other related posts: