Download as PDF, PPTX
Uploaded byAngelica Lo Duca
Relational vs Non Relational Databases
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.
In this document
Powered by AI
Introduction to the topic of relational vs non-relational databases and the basic structure of databases.
Definition, examples (MySQL, PostgreSQL), pros (structured data, SQL interface), and cons (up-front schema, performance issues) of relational databases.
Definition, examples (MongoDB, Apache Cassandra), pros (flexibility, performance) and cons (reliability, complexity) of non-relational databases.
A brief mention of the comparison between relational and non-relational databases, with a suggestion to read further.
More Related Content
Similar to Relational vs Non Relational Databases
![[DSC Europe 25] Nikola Rajovic - Hardware Technologies Under the Hood: RISC-V...](https://cdn.slidesharecdn.com/ss_thumbnails/o2gptrmtoyqndgoshwgq-dsc2025-tenstorrent-rajovic-251205090438-814685f5-thumbnail.jpg?width=640&height=640&fit=bounds)
![[DSC Europe 25] Yemi Olagbaiye - From Senses to Systems: Building Organisatio...](https://cdn.slidesharecdn.com/ss_thumbnails/zhgiesqoqd68z6lkos3o-5-251203092157-dcce0c99-thumbnail.jpg?width=640&height=640&fit=bounds)
![[DSC Europe 25] Petar Zivanov - AI meets documents From chatbots to AI-powere...](https://cdn.slidesharecdn.com/ss_thumbnails/xer2bb6nrdc8pdpev0pc-8-251204082258-7c2fa4a1-thumbnail.jpg?width=640&height=640&fit=bounds)
![[DSC Europe 25] Selena Milanovic - Educational AI in Sales.pptx](https://cdn.slidesharecdn.com/ss_thumbnails/rfwm0sbrackye9prpaww-9-251203092459-32ca27e3-thumbnail.jpg?width=640&height=640&fit=bounds)
Relational vs Non Relational Databases
- 1. Relational VS Non RelationalDatabases Angelica Lo Duca https://alod83.medium.com/
- 2.
- 3.
- 4. Definition ● A RelationalDatabase 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 QueryLanguage (SQL) is the most famous interface used to communicate with a Relational Database.
- 6. Examples of SQLdatabases ● Mysql ● Postgres ● Microsoft SQL Server ● SQLlite.
- 7. Pros and Consof 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
- 8.
- 9. Definition ● A NonRelational 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 NonRelational database engines ● MongoDB ● Apache Cassandra ● Redis ● Couchbase ● Apache HBase
- 11. Pros and Consof 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 NonRelational DB
- 14. Read more... You canread the full article at this link: https://towardsdatascience.com/relational-vs-non-relational-databases-f2ac79248 2e3