Hacker Newsnew | past | comments | ask | show | jobs | submitlogin
Readings in Database Systems, 5th Edition (redbook.io)
189 points by timf on Dec 8, 2015 | hide | past | favorite | 34 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


OT

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?


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.



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.


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.


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


[flagged]


Religious flamewars are not welcome on Hacker News.


OK. I thought one could point out that science and mathematics do not belong to the religious realm because they are rooted in reason and the evidence of the senses, not faith.

I highly recommend "The Aristotle Adventure: A Guide to the Greek, Arabic, & Latin Scholars Who Transmitted Aristotle's Logic to the Renaissance" -- http://amazon.com/dp/0964471493

I also think the history of the Diophantine equations is fascinating, all the way to their rediscovery during the Renaissance, and the impact this had on the modern development of analysis, symbolic notation, geometry, and complex numbers. It took more than one thousand years to go from Diophantus to suddenly Bachet, Fermat, and Descartes.


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.


[flagged]


> the fact that you can today type on a keyboard posting on the internet

Perhaps you have heard of 'algebra', 'algorithm', 'algorism', 'positional system', etc. perhaps not., Perhaps you will comprehend the connection, then again perhaps not.

BTW are leftists primarily christian ? Otherwise the 'self hatred' part would require some out of body experience.

EDIT: Apologies HN for feeding the troll, hadn't checked his/her comment history before.


algebra exists since babylonian or egyptian era. but if you want to give credit for it to someone that fits better your agenda than a disapeared civilisation then I will consent to it. Leftists obviously are not pro christians. they are anti-religion as long as the religion is christian and in the majority. when the religion is a minority then it is a religion of peace that has invented everything from the wheel to the space shuttles.


You've been posting many inflammatory comments about politics and religion to HN. That's an abuse of this site, so please stop.


[flagged]


Whoa, you should know better than to break the HN guidelines so badly. This entire comment is personal insults and should have been edited down to nothing.


Sadly, guilty as charged.





Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: