Which database management system?

A database management system (DBMS from now on) handles all the operations in the database, such as providing user access to stored data, as well as all the required operations on the database, such as backup, queries, permissions management, and so on.

A database engine is the underlying interface, part of the DBMS, that is used to Create, Read, Update, and Delete information from a database, which is often referred as CRUD.

Choosing the best DBMS and database engine is a key point in solution design, as it has a lot of implications – one of them being cost.

Example – SQL Server versus Oracle pricing for AWS RDS

Let’s use a simple example for clarification. In this example, we will analyze the price difference between the exact same AWS service offering – in this case, AWS RDS, where the only difference is the database engine:

Table 8.2 – Prices obtained using AWS Pricing Calculator...