Friday, 17 April 2015

Dean Wampler: SQL Strikes Back! Recent Trends in Data Persistence and Analysis


Traditional Data Warehouse:  Pros
–Mature
–Rich SQL, analytics functions
–Scales to “mid-size” data
Cons
–Expensive per TB
–Can’t scale to Hadoop-sized data sets

Data Warehouse vs. Hadoop? : • Data Warehouse
+Mature
+Rich SQL, analytics
–Scalability
–$$/TB
• Hadoop
–Maturity vs. DWs
+Growing SQL
+Massive scalability
+Excellent $$/TB

Facebook had data in Hadoop.  Facebook’s Data Analysts needed access to it...
 so they created Hive...





Note that Lingual has pure ANSI SQL front end....

No comments:

Post a Comment