Relational vs Non Relational Databases
0 likes565 views
The document compares relational and non-relational databases. Relational databases organize data into tables with rows and columns and use SQL for queries. They are good for structured data but difficult to change. Non-relational databases have flexible schemas and adapt easily but can be less reliable. Examples of relational databases include MySQL and SQL Server, while non-relational options include MongoDB, Cassandra, and Redis.
More Related Content
What's hot (20)
Similar to Relational vs Non Relational Databases (20)
More from Angelica Lo Duca (10)
Recently uploaded (20)
Relational vs Non Relational Databases
- 1. Relational VS Non Relational Databases Angelica Lo Duca https://alod83.medium.com/
- 4. Definition A Relational Database is a collection of items with pre-established relationships among them. All the items are organised in tables, where columns represent items attributes. Every row of a table represents a single data item.
- 5. The Structured Query Language (SQL) is the most famous interface used to communicate with a Relational Database.
- 6. Examples of SQL databases Mysql Postgres Microsoft SQL Server SQLlite.
- 7. Pros and Cons of Relational DBs PROS Great for structured data Use of an existing query language (SQL) Great for complex queries Easy data navigation High level of data integration, due to relationships and constraints among tables Transactions are secure High reliability CONS Up-front schema definition No adaptation to changing requirements: dynamic changes to an item affect all the other items in the same table Data processing may be slow. High performance is possible with expensive hardware
- 9. Definition A Non Relational Database is a collection of unstructured, structured or semi-structured items, usually represented in the form key-value. Every item in the collection may either represent a document, a table or anything else.
- 10. Examples of Non Relational database engines MongoDB Apache Cassandra Redis Couchbase Apache HBase
- 11. Pros and Cons of Non Relational DBs PROS Flexible data model Rapid adaptation to changing requirements: dynamic changes to a item do not affect the other items Storage of huge amount of data with little structure High performance CONS Low reliability Manual query language It is difficult to verify data integrity and consistency
- 12. Relational VS Non Relational DB
- 14. Read more... You can read the full article at this link: https://towardsdatascience.com/relational-vs-non-relational-databases-f2ac79248 2e3