A definition for each of these types of databases is given.
Key-value
A key-value pair (KVP) is a set of two linked data items: a key, which is a unique identifier for some item of data, and the value, which is either the data that is identified or a pointer to the location of that data. Key-value pairs are frequently used in lookup tables, hash tables and configuration files.
https://searchenterprisedesktop.techtarget.com/definition/key-value-pair
Column
A column-oriented DBMS (or columnar database management system) is a database management system (DBMS) that stores data tables by column rather than by row.
https://en.wikipedia.org/wiki/Column-oriented_DBMS
Document
Document stores, also called document-oriented database systems, are characterized by their schema-free organization of data.That means records do not need to have a uniform structure, i.e. different records may have different columns. The types of the values of individual columns can be different for each record. Columns can have more than one value (arrays). Records can have a nested structure. E.g. MongoDB
https://db-engines.com/en/article/Document+Stores
Graph
A graph database, also called a graph-oriented database, is a type of NoSQL database that uses graph theory to store, map and query relationships. Every node in a graph database is defined by a unique identifier, a set of outgoing edges and/or incoming edges and a set of properties expressed as key/value pairs.
https://whatis.techtarget.com/definition/graph-database
The five consistency
levels offer predictable low latency
guarantees and multiple well-defined relaxed consistency models.
Consistency Levels and guarantees
Consistency Level
|
Guarantees
|
Strong
|
Linearizability.
Reads are guaranteed to return the most recent version of an item.
|
Bounded
Staleness
|
Consistent
Prefix. Reads lag behind writes by at most k prefixes or t interval
|
Session
|
Consistent
Prefix. Monotonic reads, monotonic writes, read-your-writes,
write-follows-reads
|
Consistent
Prefix
|
Updates
returned are some prefix of all the updates, with no gaps
|
Eventual
|
Out of
order reads
|
There is a useful capacity planer that looks at request units throughput per second, request unit consumption and the amount of data storage needed by your application.
No comments:
Post a Comment
Note: only a member of this blog may post a comment.