数据库内部 - 从哪里开始？ [英] Database Internals - Where to Begin?

问题描述

所以让我们说，你想学习一些关于数据库内部的东西。什么是最好的源代码看看？

我在另一天和一个好友谈论这个问题，他推荐：

计算机编程艺术第3卷：排序和搜索

什么其他书籍可以帮助我了解所有的文件IO和内存问题，页面，锁定等....

解决方案

教科书：Ramakrishnan和Gehrke的数据库管理系统。

或者：数据库系统架构，Hellerstein，Stonebraker，和Hamilton。

生产代码： PostgreSQL

（我喜欢PG代码比SQLite更好，它更完整，我认为，更好的组织。SQLite是真棒的它的作用，但有很多它

额外点数： Readings in Database Systems，4th edition Hellerstein编辑。

So lets say that you want to learn some stuff about database internals. What's the best source code to look at? the best books to buy?

I was talking about this with a buddy the other day and he recommended:
Art of Computer Programming, Volume 3: Sorting and Searching

What other books would help me learn about all the File IO and memory issues, pages, locking, etc.... ?

解决方案

Textbook: Database Management Systems by Ramakrishnan and Gehrke.

Or: Architecture of a Database System by Hellerstein, Stonebraker, and Hamilton.

Production Code: PostgreSQL

(I like the PG code better than SQLite , it's far more complete and, I think, better organized. SQLite is awesome for what it does, but there is a lot it doesn't take on).

Extra Credit: Readings in Database Systems, 4th edition edited by Hellerstein.

这篇关于数据库内部 - 从哪里开始？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！