How does Airflow maintain the DAG and tasks status and historical data?

For maintaining any results and data, any tool will have some sort of database storage. Airflow also uses DB. It uses SQLite by default, and there is a way to use MySQL and Postgres DB for more performance improvisation.