4 ms·

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 com

by 4buot 17y ago

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.

jhammerb 17y ago
are you sure facebook has a big oracle install? how do they use it?
- 4buot 17y ago
  They use it for OLAP but are building out most of the new stuff in Hadoop,Hive because its cheaper.
- rjurney 17y ago
  It was the failure of Oracle to scale cost-effectively that led them to create HIVE.
  - bayareaguy 17y ago
    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/ http://hadoop.apache.org/hive/
    - rjurney 17y ago
      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.
      - bayareaguy 17y ago
        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.
TheXenocide 17y ago
http://incubator.apache.org/cassandra/ http://incubator.apache.org/cassandra/

by 4buot 17y ago

jhammerb 17y ago

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

4buot 17y ago
They use it for OLAP but are building out most of the new stuff in Hadoop,Hive because its cheaper.
rjurney 17y ago
It was the failure of Oracle to scale cost-effectively that led them to create HIVE.
- bayareaguy 17y ago
  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/ http://hadoop.apache.org/hive/
  - rjurney 17y ago
    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.
    - bayareaguy 17y ago
      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.

TheXenocide 17y ago

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