Database management systems

What Hacker News says

1. flashgordonDec 2023
   Another book I found very useful (though this DI book is more modern) is Raghu Ramakrishnan Database Management Systems book.
   thread
2. joker3Oct 2019
   The database course I took covered that a bit. We used https://www.amazon.com/Database-Management-Systems-Raghu-Ram.... It's not the most up-to-date text (although it was when I was in school), but it's probably still the best source for the basics of relational database theory and implementation.
   thread
3. ggaughanNov 2018
   I found this one very good and easy to read:

   https://www.amazon.co.uk/Database-Management-Systems-Raghu-R...

   thread
4. chudiAug 2015
   for databases this is pretty good:

   http://www.amazon.com/Database-Management-Systems-3rd-Editio...

   for Oses http://williamstallings.com/OS/OS6e.html

   cheers

   thread
5. ucee054May 2013
   I don't think this is true at all ... you use the same query irrespective of the size of the data in the tables. So the size of the datasets is irrelevant except for surfacing performance problems.

   In the example you gave you shouldn't have problems if you put the right index on the table.

   What really causes the opacity is either (a) the complexity of the query or (b) the guy writing the clearly doesn't know how to write declarative code, so he tries to write eg procedural code in SQL, with cursors and triggers and other horrors.

   If you are in scenario (a) and you really do need to do something complex, I'd pick SQL over VB to do it in any day - the non-declarative style leads to huge code with side effects are more opportunities for bugs to creep in.

   If you are in scenario (b), the guy writing the queries really needs to read this: http://www.amazon.com/Database-Management-Systems-Raghu-Rama...

   Show morethread
6. marcuaJun 2009
   The notes for each day have a list of readings, including papers and readings from two books.

   The canonical undergrad textbook is "Database Management Systems" by Ramakrishnan and Gehrke. I've often been confused by papers we read and gone to this book for a foundation before jumping back into the paper. There are a _lot_ of chapters I haven't read (namely the first few on ER diagrams, etc.), but the chapters on storage/indexing/query evaluation/transaction management/normalization are good if you read them a few times.

   The graduate-level book is called "The Red Book" (http://redbook.cs.berkeley.edu/), and is a great source of foundational papers in the field. You can find most of the papers online, but the introduction gives you a good sense for the history and evolution of databases.

   I hope this helps!

   Show morethread