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

本文是小编为大家收集整理的关于数据库内部--从哪里开始?的处理/解决方法,可以参考本文帮助大家快速定位并解决问题,中文翻译不准确的可切换到English标签页查看源文。

问题描述

因此,可以说您想学习一些有关数据库内部内容的知识.最好的源代码是什么?最好的书?

我前几天正在和一个好友谈论这个问题,他推荐:
计算机编程的艺术,第3卷:分类和搜索

其他哪些书将帮助我了解所有文件IO和内存问题,页面,锁定等....?

推荐答案

教科书:数据库管理系统 ramakrishnan andgehrke.

or:数据库系统的体系结构 by Hellerstein,Stonebraker和Hamilton.

生产代码: postgresql

(我比sqlite更喜欢PG代码,它更完整,我认为,组织得更好.sqlite对它的作用真是太棒了,但是它没有很多).

>

额外的信用: database Systems中的读数A>由Hellerstein编辑.

其他推荐答案

如果您真的很认真,尽管艰难的读书是晚期和伟大的吉姆·格雷(Jim Gray)和路透(Reuter):

交易处理,概念和技术

再次认真,不要打扰其他任何事情.它是从这个世界上出来的,当然是由IBM或Oracle追逐的MySQL.

其他推荐答案

SQLite源非常容易了解数据库实现.

PostgreSQL是一件写得很好的软件,其复杂性比SQLite更高.

本文地址:https://www.itbaoku.cn/post/597429.html

问题描述

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.

其他推荐答案

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

其他推荐答案

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.