Database management cleared up

The content of this blogpost builds up on my previous article: Data Integration and Data Modelling demystified and consolidates a large amount of content from the book Data Management at Scale. This content didn’t make it to the final book, because various external reviewers found it unchallenging. So, if you believe you have a good understanding of data and database management already, the content discussed in this article might sound familiar.

A crucial application component that I haven’t dived deep into the previous article is the application data layer, or database layer, of the application. The values or data of the application can be stored in various ways, but modern applications usually use databases. Databases are everywhere and used in our routines every day: When we make payments, check social media, shop online, view media, book a hotel, etc. They even sit on all of today’s modern smartphones. They play an essential role in the way value from data is delivered, therefore it is important to look at Database Management, and dive deeper into aspects like RDBMs, NoSQL, NewSQL, ACID, CAP, Consistency levels, and other design patterns.

Relational Database Management Systems

Databases started to emerge in the 70s, based on Edgar Codd’s idea to store values in tables, rather than using the linked list methods…