Readings in Database Systems, 5th Edition | Hacker News Reader

Readings in Database Systems, 5th Edition

redbook.io

189 pointstimf34 comments

For an interesting overview of the current landscape in database development, checkout this awesome interview[0] featuring Michael Stonebraker (one of the co-authors of this book). Hands down my favorite podcast episode!

[0] - http://www.se-radio.net/2013/12/episode-199-michael-stonebra...

Stonebraker recently gave a talk at my school on where he thinks databases are headed in the future[0]. Definitely worth a watch.

[0] https://www.youtube.com/watch?v=KRcecxdGxvQ&feature=youtu.be

I just watched the whole video and this made me giggle a bit:

NoSQL Means: - No SQL (2012) - Not only SQL(2014) - Not yet SQL (2015)

I think it's gonna be "No more NoSQL" in 2016.

Perhaps. Meanwhile, I'm waiting for the NoHTML, NoCSS and NoJS equivalents :)

    > I'm waiting for the NoHTML, NoCSS and NoJS equivalents

Jade, SASS, and CoffeeScript? :D

http://www.dbms2.com/2008/02/16/stonebraker-database-taxonom..., from 2008, may provide some historical context.

Anyhow, I saw this only after hitting my alcohol tolerance for the night, so I haven't made it all the way through on a first read. That said:

1. Mike writes confusingly about MapReduce. In one place he calls it a "data model". That's wildly incorrect. In another he says that Hadoop was introduced as a MapReduce clone. That's a more minor error, mainly in product naming.

2. Mike also oversells the success to date of columnar analytic RDBMS. That said, he's at least directionally correct. But Oracle and Teradata (specifically in its classical row-based mode) aren't dead yet.

3. I think Mike slightly misinterprets what's going on with SparkSQL. It's not directly in the analytic RDBMS category, and those who try to use it as such often give up. Rather, there are data processing pipelines, and SQL is used in certain necessary and high-volume steps.

Awesome, this is also a good read on databases: http://db.cs.berkeley.edu/papers/fntdb07-architecture.pdf

Thanks for the link, its the second link of the first chapter in the red book. I wonder if it would be possible to find links to all the cited papers. Will look around and post back.

Edit: I downloaded all the papers and added them to a single folder - http://nindalf.com/redbook

If I should replace or remove any of the pdfs there, please let me know.

Thanks!

I went through Sciore's book [0] while learning about relational database internals. As part of his book, the author also developed a minimal database system named SimpleDB [1] in Java. I can safely say that its source code is very easy to understand. Though the book is not free, SimpleDB is.

[0]: http://eu.wiley.com/WileyCDA/WileyTitle/productCd-EHEP000711...

[1]: http://www.cs.bc.edu/~sciore/simpledb/intro.html

Thanks for sharing this! I had been looking for something like this for a long time.

Sadly, the book has a ridiculous price.

Gladly, the course notes from the author is freely available. The book closely follows it:

http://goggle-db.googlecode.com/files/DATABASE_in_Java.pdf

My father introduced me to Jung's Red Book [1] many years ago; it is a truly fascinating psychology book.

[1]https://en.wikipedia.org/wiki/The_Red_Book_(Jung)

Now in EPUB and kindle, too. https://unglue.it/work/153041/

I love people who provide free scientific material for college student (or overall everybody). I am in religious country and I am ex-Muslim . In my perspective , if I were to choose prophet for humanity , I would choose people who educate people (or provide education material -books , papers, etc- for people) freely .

p.s. no offence . I am not saying people who selling their books are bad guys, not at all . I am just saying people who provide free material in my opinion are doing something incredible to humanity .

update : When I am saying "educate people* , I absolutely mean science.

Isn't science and things like the invention of the scientific method and Arab numerals deeply rooted in the history of Islam?

Not at all.

Cite? Cause Al-Hassan Ibn Al-Haytham (Arab muslim), Al-Biruni (Persian muslim) and Ibn Sina (Persian muslim) among others played a big role in the development of the scientific method.[0]

[0] https://en.wikipedia.org/wiki/History_of_scientific_method#E...

What about this dude: https://en.wikipedia.org/wiki/Muhammad_ibn_Musa_al-Khwarizmi

I think https://en.wikipedia.org/wiki/Alhazen deserves to be better known and I am forever intrigued by Omar Khayam. Those so called "Dark ages" was a very Christian thing. At that time Islam was doing pretty well by many standards of modernity, better than most of Europe.

Despite being ex-Muslim (and being an atheist) I don't have (or care) any viable information about history.Specially about Islam's history.

History's a hell of a thing with lots of stuff to learn in it.

Arab numerals originate from India.

https://en.wikipedia.org/wiki/History_of_the_Hindu%E2%80%93A...

That's kind of a weird question to ask. You are implying that somehow Islam is responsible for "the invention of the scientific method and Arab numerals." I don't think that's the case at all... there is nothing in the holy books of any of the major religions that could really be called the scientific method or Arab numerals. Cheerleading because some particular scientist or mathematician had [insert nationality or religion here] is kind of silly.

> You are implying that somehow Islam is responsible for "the invention of the scientific method and Arab numerals." I don't think that's the case at all...

This much I agree with (though there may be a role of Islamic society in the development or spread of some key ideas, and Islam may contribute to that, calling Islam responsible for either the scientific method or the use of Arabic numerals is going farther than is supported.)

However, I must take issue with this as support of it:

> there is nothing in the holy books of any of the major religions that could really be called the scientific method or Arab numerals.

While some major religions (especially, the Abrahamic ones) may give particularly important roles to "holy books", none of them have a content limited to their respective holy books, even if some (or some branches within some) purport that the entire content of the religion is derived from or capable of being understood by understanding the appropriate holy book. (Particularly, many of the groups for whom such a belief is part of the content of the religion have a holy book which does not contain that claim about itself, making such a belief about the role of the holy book itself a part of the content of the religion that is not contained within the holy book.)

As such, the fact that something is not explicit in a religions holy book is not a basis for dismissing the responsibility or influence of the religion in that thing.

Arab numerals actually come from India. Fun fact: Arabic goes from right to left but their numbers go from left to right, because they were learnt from Sanskrit which is written from left to right.

Reply on news.ycombinator.com