(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).
Take a look at Database Systems: The Complete Book by by Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer D. Widom. It is specifically about the internals of the DBMS.
The answer by SquareCog also contains sensible suggestions; I've not looked at the two books mentioned (though the Stonebreaker "Architecture" book is only 136 pages according to Amazon, which seems a tad lightweight).
并不是每个人都喜欢他的风格，但我发现 Joe Celko 在解释驱动 SQL 数据库的基于集合的逻辑方面做得很好。 如果您已经有一点 SQL 经验，您应该阅读聪明人的 SQL。
Not everybody likes his style, but I find that Joe Celko does a fine job of explaining the set-based logic that drives SQL databases. If you already have a little SQL experience under your belt, you should read SQL for Smarties.
Make sure that whatever you get covers relational algebra and relational calculus. No point delving into database internals if you don't have the basic theoretical background. Past that, any college style databases textbook will probably suffice.
发布评论
评论（9）
教科书：Ramakrishnan 和 Gehrke 的数据库管理系统。
或者：数据库系统架构，作者：Hellerstein、Stonebraker 和 Hamilton。
生产代码： PostgreSQL
（与 SQLite 相比，我更喜欢 PG 代码，它更完整，而且我认为更好SQLite 的功能非常出色，但还有很多功能没有实现）。
额外学分：数据库系统读物，第四版，由 Hellerstein 编辑。
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.
如果你真的很认真，虽然很难读已故的伟大的吉姆·格雷和路透写的《
事务处理、概念和技术》
，但如果你很认真，就不要为其他任何事情烦恼......它超出了这个世界，而且肯定超出了这个世界mySQL 被 IBM 或 Oracle 追赶..
If you are really serious, and although a tough read none other by the late and great Jim Gray and Reuter:
Transaction Processing, Concepts and Techniques
Again if serious, do not bother with anything else.. it's out of this world and certainly out of mySQL chasing by IBM or Oracle..
SQLite 源代码非常适合了解数据库实现。
PostgreSQL 是一个写得非常好的软件，比 SQLite 复杂度更高。
The SQLite source is very approachable to learn about database implementations.
PostgreSQL is a very well written piece of software, with higher complexity than SQLite.
我和一位同事从深度数据库：从业者的关系理论中获得了大量信息 非常低级的东西，但听起来这就是您正在寻找的东西。
A colleague and I got a great deal of information out of Database in Depth: Relational Theory for Practitioners Very low level stuff but it sounds like that is the sort of thing you are looking for.
看看数据库系统：完整的书 作者：Hector Garcia-Molina、Jeffrey D. Ullman、Jennifer D. Widom。 它特别涉及 DBMS 的内部结构。
SquareCog的回答也包含了明智的建议； 我没有看过提到的两本书（尽管根据亚马逊的说法，Stonebreaker“架构”书只有 136 页，这似乎有点轻量）。
Take a look at Database Systems: The Complete Book by by Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer D. Widom. It is specifically about the internals of the DBMS.
The answer by SquareCog also contains sensible suggestions; I've not looked at the two books mentioned (though the Stonebreaker "Architecture" book is only 136 pages according to Amazon, which seems a tad lightweight).
这里有一篇关于 SQLOS 的有趣读物，它驱动 Microsoft SQL Server 2005+。
Here's an interesting read about SQLOS, which drives Microsoft SQL Server 2005+.
有关内部结构的深入信息是特定于数据库的，以下是 SQL Server 2008 的来源：
http://www.amazon.com/Microsoft%C2%AE-SQL-Server% C2%AE-2008-内部/dp/0735626243
In depth information about internals is database specific, here's a source on SQL Server 2008:
http://www.amazon.com/Microsoft%C2%AE-SQL-Server%C2%AE-2008-Internals/dp/0735626243
并不是每个人都喜欢他的风格，但我发现 Joe Celko 在解释驱动 SQL 数据库的基于集合的逻辑方面做得很好。 如果您已经有一点 SQL 经验，您应该阅读聪明人的 SQL。
Not everybody likes his style, but I find that Joe Celko does a fine job of explaining the set-based logic that drives SQL databases. If you already have a little SQL experience under your belt, you should read SQL for Smarties.
确保您获得的任何内容都涵盖关系代数和关系微积分。 如果您没有基本的理论背景，那么深入研究数据库内部结构是没有意义的。 除此之外，任何大学风格的数据库教科书可能就足够了。
Make sure that whatever you get covers relational algebra and relational calculus. No point delving into database internals if you don't have the basic theoretical background. Past that, any college style databases textbook will probably suffice.