Deep dive into database internals

Architecture, storage and data structure

Database Management System (Author’s licensed image)

Introduction

Have you ever had a case that required debugging a database? or optimize queries? Have you ever wondered how a database works? how is the data stored? how is a query executed? why the database is able to search the data quickly? what mystery is hidden inside?