Advantages and Disadvantages of Relational Databases
Posted: Thu Feb 20, 2025 10:19 am
We will consider the main pros and cons taking into account the organizational structure of the relational database.
Modern database models built on the SQL programming language to some extent depart finland mobile database from the logical relational model created by mathematician E. Codd. For example, the founder of the system initially envisaged the need to ensure the uniqueness of each new row. This was prescribed in the Codd model, but many new relational databases allow for the repetition of rows, which is caused by practical expediency.
Read also!
Working with SQL Databases for Beginners
Read more
At the same time, some researchers believe that if SQL-based DBs do not fully comply with the set of criteria of the Codd model, they cannot be called relational databases. In reality, the situation is somewhat different. All DBMSs created on the basis of SQL and, to some extent, corresponding to the essence of a relational database, can be considered relational systems.
Modern database models built on the SQL programming language to some extent depart finland mobile database from the logical relational model created by mathematician E. Codd. For example, the founder of the system initially envisaged the need to ensure the uniqueness of each new row. This was prescribed in the Codd model, but many new relational databases allow for the repetition of rows, which is caused by practical expediency.
Read also!
Working with SQL Databases for Beginners
Read more
At the same time, some researchers believe that if SQL-based DBs do not fully comply with the set of criteria of the Codd model, they cannot be called relational databases. In reality, the situation is somewhat different. All DBMSs created on the basis of SQL and, to some extent, corresponding to the essence of a relational database, can be considered relational systems.