RDBMS vs NoSQL
In this topic i will show the difference between RDBMS and NoSQL.
| Topics | RDBMS | NoSQL |
| Formalization | Formalizazion must be respected to get consitent data | It does not need to respect formalization |
| Integrity constraint | Relation data consists in primary foreign keys | It support integrity but is not mandatory. |
| Data Structure | Data is composed with Table, Row and relations between data. | Data consists in key-value pairs or json data. |
| Schema and models | Data is less flexible and must live with fixes columns and data types. | Data can be unstructured or can have dynamic schema. |
| Scaling | Vertical scaling is quite easy but horizontal scale demands more effrots | Vertical and horizontal scale are more flexible. |
The next table will help you understand the transition from RDBMS to NoSQL.
| RDBMS | NoSQL |
| Database | Database |
| Table | Collection |
| Row | Document |
| Index | Index |
| Foreign Key | Reference |