Relational databases
After a short break, Berta continues her presentation, now focusing on relational databases.
Berta: Now, let’s discuss relational databases in depth. Depending on your requirements, you may have databases for Online Transaction Processing (OLTP) or for Online Analytical Processing (OLAP). Both of them are relational but fine-tuned for different purposes.
OLTP systems are a great choice where short, rapid, high-volume transactions such as insert, update, or delete are required. Think about a database for any e-commerce platform, where lots of users are buying products, returning products, adding products to their shopping carts, writing reviews for a product, rating a product, and so on. In these situations, an OLTP system will be useful. Some of the common databases in this category are MySQL, Microsoft SQL Server, Oracle databases, MariaDB, and PostgreSQL.
Charles: They seem to be the classical databases...