SQL Databases Don't Scale

Re:SQL Databases Don't Scale by 4buot on Tuesday July 07, 2009 @02:29AM (#691035)

For what its worth, Facebook does have a big Oracle install.

I find it strange that everyone trotted out their preformed opinion for this piece, but no one comments on the cassandra article which actually proposes a solution...although it requires you to learn something, how horrible.

[ Parent | on HN ]

Re:SQL Databases Don't Scale by TheXenocide on Tuesday July 07, 2009 @03:07PM (#692199)

http://incubator.apache.org/cassandra/

[ Parent | on HN ]

Re:SQL Databases Don't Scale by jhammerb on Tuesday July 07, 2009 @02:35AM (#691041)

are you sure facebook has a big oracle install? how do they use it?

[ Parent | on HN ]

Re:SQL Databases Don't Scale by rjurney on Tuesday July 07, 2009 @02:53AM (#691057)

It was the failure of Oracle to scale cost-effectively that led them to create HIVE.

[ Parent | on HN ]

Re:SQL Databases Don't Scale by bayareaguy on Tuesday July 07, 2009 @04:04AM (#691123)

You can't be talking about Hive[1], the SQL system for structuring and quering Hadoop datasets. That would never scale...

1- http://hadoop.apache.org/hive/

[ Parent | on HN ]

Re:SQL Databases Don't Scale by rjurney on Tuesday July 07, 2009 @04:49AM (#691157)

SQL atop an unstructured datastore, with minimal metadata. Something of an innovation, not a traditional RDBMS, but yes - still SQL :)

The nice thing about HIVE is - you're not limited to just SQL, though. You can still analyze your files on HDFS any whichaway, with Pig, with your own MapReduce jobs, whatever. Personally though, I look forward to Apache Pig getting SQL, and being able to run SQL queries on any intermediate state of a Pig script.

I don't think that anyone is really complaining about SQL. SQL is a swell query language for certain kinds of data. They're complaining about static schemas in relational dbs and having to store objects via SQL - reasonable complaints.

[ Parent | on HN ]

Re:SQL Databases Don't Scale by bayareaguy on Tuesday July 07, 2009 @05:04AM (#691172)

I don't think that anyone is really complaining about SQL. They're complaining about relational dbs.

Actually I suspect Mr. Wiggins is really only complaining about problems with MySQL and PostgreSQL. He would be less inaccurate if he admitted as much rather than making sweeping uninformed claims about SQL and relational systems.

[ Parent | on HN ]

Re:SQL Databases Don't Scale by 4buot on Tuesday July 07, 2009 @02:42AM (#691048)

They use it for OLAP but are building out most of the new stuff in Hadoop,Hive because its cheaper.

[ Parent | on HN ]