Category: Database Engineering

  • 06. Transactional vs Analytical Databases

    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

    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

    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.…