booksreddit.com:Information Modeling and Relational Databases

Information Modeling and Relational Databases, Second Edition (The Morgan Kaufmann Series in Data…

359

Information Modeling and Relational Databases, Second Edition, provides an introduction to ORM (Object-Role Modeling)and much more. In fact, it is the only book to go beyond introductory coverage and provide all of the in-depth instruction you need to transform knowledge from domain experts into a sound database design. This book is intended for anyone with a stake in the accuracy and efficacy of databases: systems analysts, information modelers, database designers and administrators, and pro…

More details

Most upvoted comment

Top rated programming books on Reddit rank no. 21

How to waste CPU and kill your disk by scaling 100 million inefficiently(r/programming)

First don’t think of this as “DBA” stuff – you’re a developer, you need to know database technology, period. Read this rant by Dennis Forbes in response to Digg’s CTO’s complaints about databases it’s very reminiscent of TFA.

Read Data and Reality by the late William Kent (here’s a free copy) and get a fundamental understanding of “information” vs. “data”. Then read Information Modeling and Relational Databases to pickup a couple practical approaches to modeling (ER & OR). Now read The Datawarehouse Toolkit to learn dimensional modeling and when to use it. Practice designing effective models, build some production databases from scratch, inherit some, revisit your old designs, learn from your mistakes, write lots and lots and lots of SQL (if you want to get tricky with SQL I suggest to pickup Celko’s SQL for smarties – it’s like the Hacker’s Delight for SQL).

Many strange models you may encounter in the wild are actually optimizations. Some are premature, some outright stupid, and some brilliant, if you want to be able to tell one from the other then you’re going to dive deep into internals. Do this generically with Modern Information Retrieval and Managing Gigabytes then for specific RDBMSs Pro SQL Server Internals, PostgreSQL Internals, Oracle CORE, etc.

Reflect on how awesome practically every modern RDBMS is as a great technological achievement for mankind and how wonderful it is to be standing on the shoulders of giants. Roll your eyes a little bit whenever you overhear another twenty-something millenial fresh CS graduate who skipped every RDBMS elective bleat about NoSQL, Mongo, whatever. Try not to fly into murderous rage when another loud-mouthed know-nothing writes at length about how bad RDBMS technology is when they couldn’t be bothered to learn the most basic requisite skills and knowledge to use one competently.

More details about a book.

Permalink : /r/programming/comments/4m64lb/how_to_waste_cpu_and_kill_your_disk_by_scaling/

Additional Information

Subreddits

programming

Number Of Links

1

Sum Of Upvotes

84

Amazon Price

$57.97

Book Binding

Hardcover

Type Code

ABIS_BOOK

Book Author

Terry Halpin

Book Edition

2

Book Publisher

Morgan Kaufmann

Book On Amazon

Information Modeling and Relational Databases, Second Edition (The Morgan Kaufmann Series in Data…

Post Title

How to waste CPU and kill your disk by scaling 100 million inefficiently

Reddit Gold

1

Post Permalink

/r/programming/comments/4m64lb/how_to_waste_cpu_and_kill_your_disk_by_scaling/

More details