Resident good: NoSQL
Lyubomir Filipov * TarnovoConf 2015 * @FilipovG
Who am I?
Lyubomir Filipov
PHP Dev
Enthusiast
NoSQL
History
1998
2009
Strozzi NoSQL
Johan Oskarsson
NoSQL
This all happened
- Not using relational model
- Well-clustered
- Open source
- Schemaless
Too many relations
Main types
- Key-Value databases
- Document databases
- Graph databases
- Column-Family databases
Key-Value databases
- Based on “key-value”
- Well-clustered
- Speed
- Indexes
- Examples: Riak, Redis, Berkeley DB, Hamster DB
Key-Value databases
| Oracle | Riak |
|---|---|
| Database instance | Riak cluster |
| table | bucket |
| row | Key-value |
| rowid | key |
Key-Value databases
Key-Value databases
Suitable Use Cases:
- Sessions
- User settings
- E-commerce shopping carts
Key-Value databases
When Not to Use:
- Relations among data
- Multioperation Transactions
- Query by data
Key-Value databases
Document databases
- Document-based
- Large amount of data per document
- No transactions
- Examples: MongoDB, CouchDB, Terrastore, OrientDB, RavenDB
Document databases
| Oracle | MongoDB |
|---|---|
| Database instance | MongoDB instance |
| schema | database |
| table | collection |
| row | document |
| rowid | _id |
| join | DBRef |
Document databases
Document databases
Suitable Use Cases:
- Logs
- Comments, CMS
- Data analysis
- E-commerce
Document databases
When Not to Use:
- Operations between aggregates
- Queries against Varying Aggregate Structure
Document databases
Column-Family databases
- Key and family of values
- Indexes
- No transactions
- Examples: Cassandra, Hbase, Amazon Simple DB
Column-Family databases
| RDBMS | Cassandra |
|---|---|
| Database instance | cluster |
| database | keyspace |
| table | Column family |
| row | row |
| column(same for all rows) | column(can be different per row) |
Column-Family databases
Column-Family databases
Suitable Use Cases:
- Logs
- CMS
- Counters
- Expiring usage
Column-Family databases
When Not to Use:
- Aggregate functions
- Prototypes
Column-Family databases
Graph databases
- Complicated relations
- Indexes
- Transactions
- Examples: Neo4j, OrientDB, FlockDB
Graph databases
Suitable Use Cases:
- Connected Data
- Marketing
- Location-Based Services
Graph databases
When Not to Use:
- Update all or a subset of entities
Graph databases
Polyglot Persistence
Polyglot Persistence
Question
Brewer's theorem
Brewer's theorem
DB-Engines Ranking
More..
