First page Back Continue Last page Image

Google - HBase

First Formal NoSQL Database
Uses Hadoop HDFS as a file system
Allowing HBase to create Massive Tables
2 Significant differences in Tables from SQL

Multiple versions of data in a cell with timestamp
Columns more like distributed keys

Name	Sites	Visits
Tory	Ebay	507,018
Tory	Google	690,414
Sam	Google	716,426
Tory	Facebook	723,649
Sam	Facebook	643,261
Sam	Nicoleanddebbie.com	856,767
Tory	Seattlecolleges.edu	675,230

NameID	SiteID	Visits
1	1	507,018
1	2	690,414
2	2	716,426
1	3	723,649
2	3	643,261
2	4	856,767
1	5	675,230

NameID	Name
1	Tory
2	Sam

SiteID	SiteName
1	Ebay
2	Google
3	Facebook
4	nicoleanddebbie
5	Seattlecolleges.edu

id	Name	Ebay	Google	Facebook	(other Columns)	seattlecolleges
1	Tory	507,018	690,414	723,649	……….	675.230

id	Name	Google	Facebook	(other Columns)	nicoleanddebbie
2	Sam	716,426	643,216	……….	856,767

HBase Solution

SQL Solution

Raw Data