NoSql type
There are four common types of NoSQL databases: columnar, document, graph, and memory key value. Generally, these databases differ in the way they store, access, and structure data, but they are optimized for different use cases and applications.
- Column databaseFor reading and writing data columns (not data rows) Optimized. Columnar storage for database tables is an important element of analyzing query performance because it greatly reduces overall disk I/O requirements and reduces the amount of data you need to load from disk.
- document databaseAim to store semi-structured data as documents, usually in JSON or XML format. Unlike traditional relational databases, the structure of each NoSQL document is different, allowing you to organize and store application data more flexibly and reduce the storage required for optional values.
- graphic database can store vertices and direct links called edges. Graph databases can be built on top of SQL and NoSQL databases. Vertices and edges can have their own related attributes.
- Memory key-value storageis for read-intensive application workloads (such as social networks, games, media sharing and Q&A portals) or computationally intensive NoSQL database optimized for type workloads (such as recommendation engines). Memory cache can store important data in memory for low-latency access, thereby improving application performance
SQL Comparison with NoSQL terms
|
SQL
|
MongoDB (NoSQL)
|
DynamoDB (NoSQL)
|
< div class="table-cell-line"> Cassandra (NoSQL) |
Couchbase (NoSQL)
|
|
Table
|
Collection
|
Table
|
Table
|
Data storage bucket
|
|
line
|
Document
|
Project
|
line
|
Document
|
|
Column
|
Field
|
Properties
|
Column
|
Field
|
|
primary key
|
Object ID
|
Primary key
|
primary key
|
Document ID
|
|
index
|
Index
|
secondary index
|
index
|
Index
|
|
View
|
View
|
Global secondary index
|
materialized view
|
View
|
|
Nested table or object
|
embedded document
|
mapping
|
mapping
|
mapping
|
|
array
|
array
|
list
|
list
|
list
|
NoSql type
There are four common NoSQL database types: columnar, document, graph and memory key value. Generally, these databases differ in the way they store, access, and structure data, but they are optimized for different use cases and applications.
- Column databaseFor reading and writing data columns (not data rows) Optimized. Columnar storage for database tables is an important element of analyzing query performance because it greatly reduces overall disk I/O requirements and reduces the amount of data you need to load from disk.
- document databaseAim to store semi-structured data as documents, usually in JSON or XML format. Unlike traditional relational databases, the structure of each NoSQL document is different, allowing you to organize and store application data more flexibly and reduce the storage required for optional values.
- graphic database can store vertices and direct links called edges. Graph databases can be built on top of SQL and NoSQL databases. Vertices and edges can have their own related attributes.
- Memory key-value storageis for read-intensive application workloads (such as social networks, games, media sharing and Q&A portals) or computationally intensive NoSQL database optimized for type workloads (such as recommendation engines). Memory cache can store important data in memory for low-latency access, thereby improving application performance
SQL Comparison with NoSQL terms
|
SQL
|
MongoDB (NoSQL)
|
DynamoDB (NoSQL)
|
Cassandra (NoSQL) < /div> |
Couchbase (NoSQL)
|
|
table |
collection |
table < /div> |
table
|
data bucket
|
|
line |
Document < /div> |
Project
|
OK
|
< span style="font-family:'Microsoft YaHei', STXihei;color:rgb(0,0,0);background-color:transparent;">Document
|
|
Column |
Field
|
attributes
|
Column
|
Field
|
|
primary key
|
Object ID
|
primary key
|
primary key
|
Document ID
|
|
Index
|
index
|
secondary index
|
index
|
Index
|
|
View
|
View
|
Global secondary index
|
materialized view
|
View
|
|
Nested table or object
|
embedded document
|
Mapping
|
Mapping
|
Mapping
|
|
Array
|
数组
|
列表
|
列表
|
列表
|
|
SQL
|
MongoDB (NoSQL)
|
DynamoDB (NoSQL)
|
Cassandra (NoSQL)
|
Couchbase (NoSQL)
|
|
表
|
集合
|
表
|
表
|
数据存储桶
|
|
行
|
文档
|
项目
|
行
|
文档
|
|
列
|
字段
|
属性
|
列
|
字段
|
|
主键
|
对象 ID
|
主键
|
主键
|
文档 ID
|
|
索引
|
索引
|
二级索引
|
索引
|
索引
|
|
视图
|
视图
|
全局二级索引
|
具体化视图
|
视图
|
|
嵌套表或对象
|
嵌入文档
|
映射
|
映射
|
映射
|
|
数组
|
数组
|
列表
|
列表
|
列表 |
SQL
MongoDB (NoSQL)
DynamoDB (NoSQL)
Cassandra (NoSQL)
Couchbase (NoSQL)
表
集合
表
表
数据存储桶
行
文档
项目
行
文档
列
字段
属性
列
字段
主键
对象 ID
主键
主键
文档 ID
索引
索引
二级索引
索引
索引
视图
视图
全局二级索引
具体化视图
视图
嵌套表或对象
嵌入文档
映射
映射
映射
数组
数组
列表
列表
列表