7 ms·
Readings in Database Systems, 5th Edition (2015)
- 0xFFC 9y agoIs this new edition? What have been changed?
- muramira 9y agoYesterday, https://news.ycombinator.com/item?id=15428526 https://news.ycombinator.com/item?id=15428526 hit number 1 on HN. Having read the two books, I strongly believe that they not only complement each other, but also must be required reading for any data engineer.
- trollopTheJope 9y agolol, this book is being shilled to death because one of the examples used is a (very superficial) analysis of twitter's scaling problem. try the art of computer systems performance analysis for a real treatment.
- StavrosK 9y agoIs there an epub of this?
- fizixer 9y agoDoes it have something along the lines of building your own RDBMS from scratch? (If not, any recommendations?) edit: google search has potentially promising results, https://www.google.com/search?q=build+your+own+rdbms https://www.google.com/search?q=build+your+own+rdbms
- jasonwatkinspdx 9y agoI have a copy of https://www.amazon.com/gp/product/0130402648 https://www.amazon.com/gp/product/0130402648 and while I don't think it'll win any "best textbook ever" awards it presents all the basic concepts in a straightforward if somewhat simple way.
- hackermailman 9y agoThis course does, has lectures on youtube http://15721.courses.cs.cmu.edu/spring2017/ http://15721.courses.cs.cmu.edu/spring2017/
- makmanalp 9y agoThis book is more about different types of tradeoffs you can make in terms of your system design. I'd recommend looking at grad databases courses instead, e.g: - http://db.cs.cmu.edu/courses/ http://db.cs.cmu.edu/courses/ - http://daslab.seas.harvard.edu/classes/cs165/ http://daslab.seas.harvard.edu/classes/cs165/ - http://daslab.seas.harvard.edu/classes/cs265/ http://daslab.seas.harvard.edu/classes/cs265/
- fizwhiz 9y agoI really wish this class (or the Harvard class referenced below) were offered as a MOOC w/ some certification. I rarely find classes around OS/databases offered as MOOCs, which is a pity because those are the things I'd love to spend time on.
- makmanalp 9y agoPart of the problem is that doing a decent MOOC takes a TON of preparation and effort, much more so than a regular class. The professor who runs the class (Stratos Idreos) has a billion things that he's working on, so turning it unto a MOOC would require some outside support, probably. That said, releasing the videos might be a possibility, I'll ask and see. I believe Andy Pavlo's class has videos online already. The other part is that in the Harvard classes specifically, the class discussion is a huge part of the class.
- makmanalp 9y agoWhile this is a seminal work, I definitely wouldn't approach this like I would approach a textbook: it's definitely not meant to be friendly introductory material. That said, once you have a bit of background, it's a goldmine of a survey. You'll notice that each section is a short, few-page long introduction, but the bulk of the material is in the papers themselves, which can be significantly tougher to read. Though it's great that the summaries are friendly and help you contextualize the papers. My tip is to read papers starting with the introduction, and then the conclusion, and then decide if you want to dive into the rest of the paper to track down the evidence for specific claims.
- CalChris 9y agoIt's organized as the most likely papers that you'd read in a graduate level database seminar. Readings in Computer Architecture is the same.
- godelmachine 9y agoHi Chris, I searched far and wide for a PDF / soft copy of Readings in Computer Architecture. I searched for the same thing 6 months ago, but to no avail. Would you kindly provide a PDF or a soft copy? Sincerely,
- Fundlab 9y agoHow about your local library?
- godelmachine 9y agoI live in Pune right now. Can't think of any such library. Libraries here aren't equipped well with such technical subjects.
- CalChris 9y agoGo onto Amazon and get the TOC. Take that to Google Scholar.
- zzzcpan 9y agoRedbook is too biased, there is just too much perspective from RDBMS people, which is not relevant in modern distributed environments or even outright incorrect. Redbook inspired list by Christopher Meiklejohn [1] is a better alternative, or Aphyr's course outline [2]. [1] https://github.com/cmeiklejohn/cmeiklejohn.github.io/blob/master/_posts/2013-07-12-readings-in-distributed-systems.markdown https://github.com/cmeiklejohn/cmeiklejohn.github.io/blob/ma... [2] https://github.com/aphyr/distsys-class https://github.com/aphyr/distsys-class
- elvinyung 9y ago(Disclaimer: I work at Databricks.) RDBMS techniques are absolutely relevant in modern distributed environments. It has become increasingly clear that MapReduce is too low-level a programming model for query processing, so modern distributed dataflow systems are increasingly hybridizing with RDBMS-like interfaces and optimizations (e.g. Spark dataframes).
- zzzcpan 9y agoI agree, but you have to look at RDBMS from distributed systems perspective.
- makmanalp 9y agoFor OP's benefit, here are some excerpts from the red book that agree with that premise: > Google MapReduce set back by a decade the conversation about adaptivity of data in motion, by baking blocking operators into the execution model as a fault-tolerance mechanism. It was nearly impossible to have a reasoned conversation about optimizing dataflow pipelines in the mid-to-late 2000’s because it was inconsistent with the Google/Hadoop fault tolerance model. In the last few years the discussion about execution frameworks for big data has suddenly opened up wide, with a quickly-growing variety of dataflow and query systems being deployed that have more similarities than differences http://www.redbook.io/ch7-queryoptimization.html http://www.redbook.io/ch7-queryoptimization.html Also see Stonebraker's comment at the bottom here: http://www.redbook.io/ch5-dataflow.html http://www.redbook.io/ch5-dataflow.html edit: To be more charitable, Mapreduce's main concern was fault tolerance (and recovery) and massive scalability, at the cost of all else. Since it's so simple, you could have subtasks die, disappear, and yet you can just respawn them and keep on chugging through the query. You also don't think too hard about job allocation. It's easy to build and use, easy to reason about. You can throw more computers at it when you have a spike of jobs, and it scales fairly predictably. Not many people were really running infrastructure and jobs at the scale google did, and that's quite different from the traditional "data warehouse" style application, and so it wasn't entirely unjustified. The other benefit, of course, is that you can perform arbitrary computation, which is quite different from most RDBMSes which often don't have great UDF support or are frequently highly restricted and, frankly, horrific to deal with. Of course, they quickly found that "no query optimization" is sort of an extremist and unproductive position, and that you can have a bit of either or both cakes as needed.
- alexnewman 9y agoEveryone I have met who have worked a long time in the database industry considers stonebreaker to be - Overrated - Overly Self Promoting - Mostly not credible That being said I love his work and his history. The red book is super famous. What gives?
- alexnewman 9y agoI should say I have been writing production databases for almost 10 years. The people I talked to have more than 20 years exp
- alexnewman 9y agoalso sorry for the last name pun
- StavrosK 9y agoWhat's the pun?
- rbetts 9y agoStonebraker is quite down to earth to work with - he cares about practical ideas and systems that can be plausibly constructed. You can decide if one of the primary collaborators of Ingres, Postgres, Streambase, Vertica, VoltDB, Tamr... is over-rated. Certainly a number of commercial efforts didn't find great commercial success but the technology he participated in pioneering has found its way into almost every modern database system in use.
- deleted 9y ago[deleted]
- bambu 9y agoNot credible? Stonebraker is a Turing Award winning MIT professor who's worked in the database industry for ~50 years. Ask your friends what gives
- frankmcsherry 9y ago