Big data columnar database

column oriented database examples and advantages of column oriented database and columnar database comparison
Dr.GordenMorse Profile Pic
Dr.GordenMorse,France,Professional
Published Date:22-07-2017
Your Website URL(Optional)
Comment
Ghislain Fourny Big Data 5. Column stores 1Introduction 2Relational model 3Relational model Schema 4Issues with relational databases (RDBMS) • Small scale • Single machine 5Can we fix a RDBMS? Scale up (remember?) 6Can we fix a RDBMS? Scale out 7Can we fix a RDBMS? • Cluster Scale out 8Can we fix a RDBMS? • Cluster Scale out • Replicate 9Can we fix a RDBMS? • Hard to set up Scale out • Very high maintenance costs 10HBase By design running on a scalable cluster of commodity hardware 11HBase By design running on a scalable cluster of commodity hardware HDFS 12Wide column stores: data model 13Founding paper 's BigTable 14The tabular model 15The tabular model: expensive joins 16Design paradigm of BigTable store together what is accessed together 17The tabular model: expensive joins 1 1 4 2 2 3 2 4 4 5 6 6 18The columnar model: denormalized 1 4 2 2 4 6 19Rows Row ID 000 002 0A1 1E0 22A 4A2 20