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