top | item 21793270

Database Internals

305 points| pointy_hat | 6 years ago |databass.dev

38 comments

order

playing_colours|6 years ago

This is a very good book! Recently, I am very happy with a number of more foundational data books from O’Reilly:

Designing Data-Intensive Applications https://dataintensive.net/

Streaming Systems http://shop.oreilly.com/product/0636920073994.do

and this one.

zarkov99|6 years ago

Both of those are fantastic, data intensive in particular I think is the best book I have ever read from O'Reilly. Glad to hear this one is as good.

burlesona|6 years ago

If you wanted to build your own database (to learn how), is Database Internals the better book, or DDIA?

chrisseaton|6 years ago

I've been reading this book for the last few days - it is way above what you expect these days for a technical book from a popular publisher in terms of its description of underlying data structures and algorithms. It's also easy to read. The depth of a text book with the approachability of a typical working programmer's book.

elamje|6 years ago

The topical overview certainly sounds interesting, but sounds extremely similar to Designing Data Intensive Applications which also covers modern DB internals.

What’s the sell here?

libraryofbabel|6 years ago

There is some overlap, but they complement each other. This one (Database Internals) has much more of a technical deep dive on storage engines, especially B-tree implementation details.

If I was mentoring someone learning this stuff, I'd advise reading Designing Data Intensive Applications first, which is certainly the best for giving the big picture, and follow up with this one for more detail on certain topics.

Given the previous dearth of books on this important subject, I think it's wonderful that we have two.

jolmg|6 years ago

The preface is also available in the preview. It goes in further detail about the scope of the book. There's also the table of contents.

I haven't seen the book you mentioned, so I can't comment on that.

HappyJoy|6 years ago

Database Design and Implementation by Edward Sciore implements a fully working relational database from buffer manager up to parser and beyond. It's very much in the spirit of Tanenbaum's OS book.

Here's the landing page for the book's implementation: http://www.cs.bc.edu/~sciore/simpledb/intro.html

Unfortunately, I don't think the book is in print anymore.

abhinaba1|6 years ago

I am reading this book for the past few days. Very well written!

_y5hn|6 years ago

Grey text on white background => almost unreadable on my screen and I don't usually have problems with low contrast.

ifesdjeen|6 years ago

Author here. Thanks for the heads up, it did look a bit bleak on the mobile. Increased the font size, made grey much more dark, and increased heading sizes. Hope it's easier to read now!

mesaframe|6 years ago

In past few days I've heard so many praises and also I have heard so much criticism about Database Books in general.

What makes this book so much better?

zzzcpan|6 years ago

It depends on your goal.

Database internals books are not worth reading if you want to work on implementing real world database engines. You are better off checking out internals and documentation of various implementations and also research papers in that field. And you would be doing your own research anyway.

But if you are just starting out in programming, it's probably as good book as any to learn something new and practical about algorithms and data structures.

alfiedotwtf|6 years ago

Nice. This is the book I've been wishing someone wrote for a long time. Finally! Insta-buy.

commandersaki|6 years ago

Is this a full fee paid course for on campus students?

Because if it is, I would be miffed and feel short changed to be told to watch youtube lectures on my own time. I value face to face time and interactivity with my professor or lecturer. If this is a heavily discounted course due to the crippled way it is taught then I have no issue.

From the syllabus:

CS144 is taught using a combination of lectures and videos. In previous years, it was entirely “flipped”; i.e. all the lecture material was taught by videos. This year things are different and we are going to mix things up: Some weeks, including the first week, will be based on recorded videos that you are required to watch in your own time. We will call these Video Weeks. Other weeks, including the second week, are based entirely on in-class lectures, and you don’t need to watch any videos. We will call these Lecture-only Weeks. So why mix things up? We are teaching this way because we have found that some of the material (e.g. the basic principles you learn in week 1) are most efficiently learned by watching videos - the concepts are fairly simple and the material is descriptive; a video is a more efficient use of your time. Other material, such as when you learn about congestion control in week 4, is best learned in person, interactively in a lecture.

jrockway|6 years ago

The fee you pay for college courses is for the piece of paper saying you passed the course.

Those that don't need the piece of paper can learn for free. Who can complain about that!

mesaframe|6 years ago

Did you post this on wrong thread or you didn't care to open the posted link?