Biomedical Engineering Reference
In-Depth Information
Table 20.1
Database comparisons
PostgreSQL
MySQL
Cassandra
Riak
CouchDB
HBase
Hive
Type
SQL
SQL
NoSQL
NoSQL
NoSQL
NoSQL
HiveQL
Access Protocol
ODBC, JDBC,
Native API
ODBC, JDBC,
Native API
Thrift-based
Client APIs
Native APIs
REST JSON
REST JSON
Thrift and
REST
JDBC
Processing
Pluggable (e.g.
plpgsql, pltcl,
plperl)
Procedural SQL
Can be paired
with Hadoop
Internal
JSON Map/
Reduce
Internal
JavaScript
Map/Reduce
Native API
Map
Reduce
HiveQL
compiled to
Map Reduce
Data Schema
SQL DDL
SQL DDL
'Big Table'
Column Store
Key Value
Document
Style
'Big Table'
Column
Store
Semi-
Structured
Data
Storage Engine
PostGresSQL
Pluggable
(ISAM, InnoDB)
SSTable
BitCask
Native
FileSystem
BLOB
Hadoop
HDFS
Hadoop
HDFS
Cluster
Many options
NDB Storage
Engine
Built-in Dynamo
Based
Built-in
Dynamo
Based
Lounge and
Sharding
Proxy
Hadoop
OLTP
Yes
Yes
Yes
Yes
Yes
Yes
No
OLAP
Yes
Yes
No
No
No
No
No
Cubing
Yes
No
No
No
No
No
No
Search WWH ::
Custom Search