blocks|key|1363000|text|要了解数据库实现，SQLite源代码非常容易理解。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1363001|与SQLite相比，PostgreSQL是一款编写得非常好的软件，它的复杂性更高。|1363002|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

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.

blocks|key|1363055|text|我和一位同事从Database+in+Depth:+Relational+Theory+for+Practitioners非常低级的东西中得到了大量的信息，但听起来这就是你要找的东西。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1363056|entityMap|0|LINK|mutability|MUTABLE|url|https://rads.stackoverflow.com/amzn/click/com/0596100124^0|7|1I|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

A colleague and I got a great deal of information out of <a href="https://rads.stackoverflow.com/amzn/click/com/0596100124" rel="nofollow noreferrer" rel="nofollow noreferrer">Database in Depth: Relational Theory for Practitioners</a> Very low level stuff but it sounds like that is the sort of thing you are looking for.

blocks|key|1578405|text|关于驱动Microsoft+SQL+Server+2005%2B的SQLOS。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1578406|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

<a href="http://blogs.msdn.com/slavao/articles/441058.aspx" rel="nofollow noreferrer">Here's an interesting read</a> about SQLOS, which drives Microsoft SQL Server 2005+.

blocks|key|1363212|text|请确保您获得的内容涵盖了关系代数和关系微积分。如果您没有基本的理论背景，那么深入研究数据库的内部原理是没有意义的。除此之外，任何一本大学风格的数据库教科书都可能足够了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1363213|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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.

blocks|key|1578481|text|如果你真的是认真的，尽管这是已故伟大的吉姆·格雷和路透社的一篇艰难的读物：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1578482|事务处理、概念和技术|1578483|再说一次，如果是认真的，不要为其他任何事情烦恼..它超越了这个世界，当然也超越了国际商业机器公司或甲骨文公司对mySQL的追逐。|1578484|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

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..

blocks|key|1363334|text|教科书:+Ramakrishnan和Gehrke的Database+Management+Systems。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1363335|或者:赫勒斯坦、斯通布雷克和汉密尔顿的Architecture+of+a+Database+System。|1363336|产品代码：PostgreSQL|1363337|(与SQLite相比，我更喜欢PG代码，它更完整，我认为也更有条理。SQLite在它所做的事情上很棒，但有很多东西是它不能承担的)。|1363338|额外内容：Readings+in+Database+Systems,+4th+edition由海勒斯坦编辑。|1363339|entityMap|0|LINK|mutability|MUTABLE|url|http://pages.cs.wisc.edu/~dbbook/|1|https://rads.stackoverflow.com/amzn/click/com/1601980787|2|http://www.postgresql.org/|3|https://rads.stackoverflow.com/amzn/click/com/0262693143^0|P|R|0|0|J|X|1|0|5|A|2|0|0|5|15|3|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@$A|10|B|11|1|12]]|C|$]]|$1|D|3|E|5|6|7|13|8|@]|9|@$A|14|B|15|1|16]]|C|$]]|$1|F|3|G|5|6|7|17|8|@]|9|@$A|18|B|19|1|1A]]|C|$]]|$1|H|3|I|5|6|7|1B|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|1C|8|@]|9|@$A|1D|B|1E|1|1F]]|C|$]]|$1|L|3|-4|5|6|7|1G|8|@]|9|@]|C|$]]]|M|$N|$5|O|P|Q|C|$R|S]]|T|$5|O|P|Q|C|$R|U]]|V|$5|O|P|Q|C|$R|W]]|X|$5|O|P|Q|C|$R|Y]]]]

Textbook: <a href="http://pages.cs.wisc.edu/~dbbook/" rel="noreferrer">Database Management Systems</a> by Ramakrishnan and Gehrke.

Or: <a href="https://rads.stackoverflow.com/amzn/click/com/1601980787" rel="noreferrer" rel="nofollow noreferrer">Architecture of a Database System</a> by Hellerstein, Stonebraker, and Hamilton.

Production Code: <a href="http://www.postgresql.org/" rel="noreferrer">PostgreSQL</a>

(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: <a href="https://rads.stackoverflow.com/amzn/click/com/0262693143" rel="noreferrer" rel="nofollow noreferrer">Readings in Database Systems, 4th edition</a> edited by Hellerstein.

blocks|key|1578580|text|关于数据库内部的深入信息，这里有一个关于SQL+Server2008的资源：http://www.amazon.com/Microsoft%25C2%25AE-SQL-Server%25C2%25AE-2008-Internals/dp/0735626243|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1578581|entityMap|0|LINK|mutability|MUTABLE|url|https://rads.stackoverflow.com/amzn/click/com/0735626243^0|12|2B|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

In depth information about internals is database specific, here's a source on SQL Server 2008:
<a href="https://rads.stackoverflow.com/amzn/click/com/0735626243" rel="nofollow noreferrer" rel="nofollow noreferrer">http://www.amazon.com/Microsoft%C2%AE-SQL-Server%C2%AE-2008-Internals/dp/0735626243</a>

blocks|key|1578611|text|不是每个人都喜欢他的风格，但我发现Joe+Celko在解释驱动SQL数据库的基于集合的逻辑方面做得很好。如果你已经有一些SQL的经验，你应该阅读SQL+for+Smarties。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1578612|entityMap|0|LINK|mutability|MUTABLE|url|https://rads.stackoverflow.com/amzn/click/com/1558605762^0|20|G|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

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 <a href="https://rads.stackoverflow.com/amzn/click/com/1558605762" rel="nofollow noreferrer" rel="nofollow noreferrer">SQL for Smarties</a>.

blocks|key|1578666|text|看看赫克托尔·加西亚-莫利纳，杰弗里·D·乌尔曼，詹妮弗·D·维多姆的Database+Systems:+The+Complete+Book+by。它特别介绍了DBMS的内部结构。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1578667|SquareCog的答案也包含了明智的建议；我没有看过提到的两本书(尽管亚马逊称《石破者》的《架构》一书只有136页，这似乎有点轻量级)。|1578668|entityMap|0|LINK|mutability|MUTABLE|url|http://www.amazon.com/Database-Systems-Complete-Book-GOAL/dp/product-description/0130319953^0|Z|Z|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

Take a look at <a href="http://www.amazon.com/Database-Systems-Complete-Book-GOAL/dp/product-description/0130319953" rel="nofollow noreferrer">Database Systems: The Complete Book</a> 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).

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: 
<a href="https://rads.stackoverflow.com/amzn/click/com/0201896850" rel="noreferrer" rel="nofollow noreferrer">Art of Computer Programming, Volume 3: Sorting and Searching</a>

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

Database Internals - Where to Begin?

SQL数据库

SQL Server

PostgreSQL

数据库

SQLite

因此，假设您想学习一些关于数据库内部的知识。最值得一看的源代码是什么？最值得买的书是什么？前几天我和一个朋友谈到这件事，他建议说：还有哪些书可以帮助我了解所有的文件IO和内存问题、页面、锁定等……？

问数据库内部-从哪里开始？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问数据库内部-从哪里开始？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问数据库内部-从哪里开始？
EN