理解Engine in Database

Overview

Clickhouse，DolphinDB都对引擎做了专门介绍。

那什么是引擎，引擎的作用原理又是什么？

From Dr. Richard Hipp, the creator of SQLite, SQL is a peculiar programming language rather a query language, each SQL statement is a program, and SQL descibes what instead of how.

An sql database engine consists of two parts:

• Compiler

  The compiler takes your program which is a statement of sql and compiles it down into procedures they’re going to be run;

• Virtual Machine

  The Virtual Machine actually runs the procedures.

Database Engine

A database engine (or storage engine) is the underlying software component that a database management system (DBMS) uses to create, read, update and delete (CRUD) data from a database.

Design considerations

Information in a database is stored as bits laid out as data structure in storage that take can be efficiently read from and written to given the properties of hardware.

Data structures

MySQL engine

Database engine provide the underlying functionality for MySQL to work with and process data.

References