RDB-List

RDB List

Resource

Collection

Internals

  • 2018-手写 SQL 编译器: 因为工作关系,需要开发支持众多方言的 SQL 编辑器,所以复习了一下编译原理相关知识。相比编译原理专家,我们只需要了解部分编译原理即可实现 SQL 编辑器,所以这是一篇写给前端的编译原理文章。

  • 2018-SQL Query Optimization Meets Deep Reinforcement Learning: We show that deep reinforcement learning is successful at optimizing SQL joins, a problem studied for decades in the database community.

  • 2013-How did the modern relational database come to be?: The purpose of this Annotated Bibliography is to illustrate, in chronological order, the major development of database models from 1st generation (network model etc) to second generation (relational) to 3rd generation (e.g. semantic). The Bibliography is presented in order of the year when the paper was published.

  • 2017-How does a relational database work: When it comes to relational databases, I can’t help thinking that something is missing. They’re used everywhere. There are many different databases: from the small and useful SQLite to the powerful Teradata. But, there are only a few articles that explain how a database works.

Transaction & Concurrency Control

Query Processing

Index