SQL vs NoSQL
개념 | SQL (MySQL) | NoSQL |
---|---|---|
Database | Database | Database |
Table | Table | Collection |
Row | Row / Record | Document / BSON |
Column | Column | Key / Field |
Join | Table Join | Embedded Documents / linking |
Index | index | index |
Aggregattion | Aggregation (ex. GROUP BY) | Aggergation Framework |
Primary Key | Primary Key (PK) | Primary Key (_id) |
Database Server | mysqld | mongod |
Database Client | mysql | mongo |