Category: Database Engineering
-
06. Transactional vs Analytical Databases
This is the sixth chapter of the DB engineering series. As a prerequisite ensure that you read the previous chapters. Jump to other chapters: Introduction In order to achieve better performance, efficiency, and maintainability for both transactional and analytical tasks, there’s a need to have specific designs for these databases. Transactional and analytical databases are…
-
04. Database Partitions
This is the fourth chapter of the DB engineering series. As a prerequisite ensure that you read the previous chapters. Jump to other chapters: As more and more rows get added to the table, the database has to scan more pages and data. Queries are bound to become slower. Indexes will help to a great…
-
02. Database Indexes
This is the second chapter of the DB engineering series. As a prerequisite ensure that you read the first chapter about databases storing the data here. Jump to other chapters: Creating a table with a million rows Before we move forward about learning indexes, let’s first create a table and populate the same with data.…