User view of existing systems for three of the target application scenarios:
Property |
Web Datastore |
Analytics System |
Transactional System |
---|---|---|---|
Data |
Records (possibly unstructured), upto 2MB |
Files, sets of records (often unstructured), maybe large records |
Structured records, typically small |
Queries |
Simple, lookups, sometimes secondary key access |
Rich analytic, procedural |
Complex, declarative |
Consistency |
Weak, per-record |
Static files |
ACID |
Latency |
~10s of milliseconds |
minutes/hours |
query-dependent: 3 milliseconds to minutes |
Scalability |
High, Elastic |
High |
Low |
Examples |
Yahoo PNUTS, Google AppEngine Datastore, Facebook Cassandra, Amazon Dynamo |
MapReduce, Hadoop, Aster, Terradata |
MySQL, Oracle, IBM DB2, MS SQL Server |