What is the differenceand a non relational one As a reminder and consolidation it is worth starting by defining the differences between relational and non relational NoSQL databases. How do relational databases work Relational databases such as MariaDB use a well known approach to information storage. As can be seen in Figure data is built and stored in a pre established schema constituting a strictly defined relationship between objects.
The construction of an extensive relational database can be compared to a tree whose tables are leaves and the relationships between them resemble branches. Figure . Example of building a relational Phone Number List database | name Figure . Example of building a relational database. How do non relational databases work On the other hand Figure presents non relational database MongoDB mentioned earlier.
A basic change can be noticed in the form of the lack of branches between objects containing data the lack of "rigidly" declared relationships between data. It is worth noting that when talking about non relational databases the term objects is used instead of tables and this is due to the completely different characteristics of the construction of these bases. NoSQL is not based on tables or columns but – in the case of MongoDB – on documents. In Figure the document named POSTS contains all the objects. Figure . Example of building a non relational database | naml Figur.