Fundamentals of Database Systems (5th Edition)

Fundamentals of Database Systems (5th Edition)
by Ramez Elmasri, Shamkant B. Navathe

Fundamentals of Database Systems (5th Edition)
List Price: $138.00
Our Price: $66.00
You Save: $72.00 (52%)
Availability: Usually ships in 1-2 business days
Buy Used: from $25.42 (click here)
Category: Book
See more book details and other editions


or

Book Summary Information

Author: Ramez Elmasri, Shamkant B. Navathe
Edition: Hardcover
Audio: English (Unknown); English (Original Language); English (Published)
Published: 2006-03-17
ISBN: 0321369572
Number of pages: 1168
Publisher: Addison Wesley
Accessories:

Book Reviews of Fundamentals of Database Systems (5th Edition)

Book Review: The right balance
Summary: 4 Stars

It's always refreshing to see a book with such a nice balance of theory and practice: the topic of databases is so huge that even an introduction of this size merely scratches the surface. I had a previous 'on-the-run' experience of SQL querying before tackling this book, but I've always felt that something was deeply missing. Studying this book, and the classical literature it references, began to make everything crystal-clear! The text does not shy away from explaining core theoretical concepts, which was essential in understanding why every topic was the way it is. Thankfully, there were also a great number of examples following any newly presented formalization or theory, making the material very approachable.

The discussions were relatively self-contained, leading to an uninterrupted understanding flow: topics like topological sorting, total order, complete set of algebraic operations, soundness and completeness, axioms, BNF, btrees, and hashes were very briefly explained throughout the text as the need arose. On another topic, the 'selected bibliography' sections at the end of each chapter were simply superb, making this guide an _excellent_ secondary source to the field literature.

The book was generally rigorous, but it had a noticeable number of un-proven sprinkled statements in-between. Thinking about and proving such statements made the study very stimulating; in fact, the concepts sticked much better that way cause of the extra mental effort invested! Examples of stated, but un-proven, topics included: classical relational algebra's recursive queries infeasibility (Ch-6: Relational algebra), some presented techniques for optimizing I/O performance of the nested-loop join (Ch-15: query optimization), 'conflict serializability' of two-phase locking (Ch-18: Concurrency control), various properties of the two-phase locking variants (Ch-17: Transaction theory, and Ch-18), deadlock avoidance of various presented locking protocols (Ch-18), and so on. Depending on your time and focus, it may be an advantage or a disadvantage.

I reserve one star for _two_ important reasons: (1) the book is very pricy; no matter how good the book is, reading the field's original literature was essential for context and deeper understanding; with such a price, Pearson should've attached a CD-ROM covering the most important cited papers; in fact, something like SIGMOD Anthology two DVD-ROMs (covering most of DB research in the past 3 decades) is an essential complement to the text, especially for those of us with no access to complete libraries. (2) some chapters, particulalry chapter 12 and chapters 25-30, feels like being there to fill more paper; their different tone is noticeable and irritating.

Finally, it's important to note that this review is only based on a careful study of the _5th_ edition Parts 1 through 5 (IMHO, the book heart), covering mainly the relational model, SQL, conceptual modeling, DB deisgn, normalization, low-level data storage, query optimization, transaction processing, and concurrency control. The rest of the book (object databases and emerging research) was skimmed, so this review is not very representative of such parts. All in all, this book was a very worthwhile investment.

Summary of Fundamentals of Database Systems (5th Edition)

Clear explanations of theory and design, broad coverage of models and real systems, and an up-to-date introduction to modern database technologies result in a leading introduction to database systems.

 

With fresh new problems and a new lab manual, students get more opportunities to practice the fundamentals of design and implementation. More real-world examples serve as engaging, practical illustrations of database concepts. The Fifth Edition maintains its coverage of the most popular database topics, including SQL, security, data mining, and contains a new chapter on web script programming for databases.

Databases Books

Book Subjects
Most talked about in Databases Books
Mining for Gold on The Internet: How to Find Investment and Financial Information on the Internet ImageMining for Gold on The Internet: How to Find Investment and Financial Information on the Internet
by Mary Ellen Bates
McGraw-Hill Companies; Published: 2000-05-30; Paperback; Book
Best price: $20.46
Price in other shops: $26.95
Building XML Applications ImageBuilding XML Applications
by Simon St.; Cerami, Ethan Laurent
McGraw-Hill Companies; Published: 1999; Paperback; Book
Introduction to Data Communications and Local Area Networking Technology ImageIntroduction to Data Communications and Local Area Networking Technology
by Eduardo da Silva
HarperCollins Publishers Ltd; Published: 1986-08-28; Paperback; Book
Data Analysis Using SQL and Excel ImageData Analysis Using SQL and Excel
by Gordon S. Linoff
Wiley; Published: 2007-10-01; Paperback; Book
Best price: $27.16
Price in other shops: $45.00
Fundamentals of Database Systems (5th Edition) ImageFundamentals of Database Systems (5th Edition)
by Ramez Elmasri, Shamkant B. Navathe
Addison Wesley; Published: 2006-03-17; Hardcover; Book
Best price: $66.00
Price in other shops: $138.00
An Introduction to Database Systems (8th Edition) ImageAn Introduction to Database Systems (8th Edition)
by C.J. Date
Addison Wesley; Published: 2003-08-01; Paperback; Book
Best price: $74.93
Price in other shops: $169.00
Pragmatic ADO.NET: Data Access for the Internet World ImagePragmatic ADO.NET: Data Access for the Internet World
by Shawn Wildermuth
Addison-Wesley Professional; Published: 2002-11-15; Paperback; Book
Best price: $5.20
Price in other shops: $54.99
SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL ImageSQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL
by Michael J. Hernandez, John L. Viescas
Addison-Wesley Professional; Published: 2000-08-31; Paperback; Book
Best price: $42.00
Price in other shops: $59.99
Microsoft Office Access 2003 QuickSteps ImageMicrosoft Office Access 2003 QuickSteps
by John Cronan, Virginia Anderson, Brenda Bryant Anderson
McGraw-Hill Osborne Media; Published: 2004-03-01; Paperback; Book
Best price: $2.70
Price in other shops: $19.99
Database Systems Concepts ImageDatabase Systems Concepts
by Henry F. Korth, Abraham Silberschatz, S. Sudarshan
Osborne/McGraw-Hill,U.S.; Published: 2001-08; Hardcover; Book
Similar Books and other products
Introduction to the Theory of Computation ImageIntroduction to the Theory of Computation
by Michael Sipser
Course Technology; Published: 2005-02-15; Hardcover; Book
Best price: $110.00
Price in other shops: $179.95
Computer Networks (5th Edition) ImageComputer Networks (5th Edition)
by Andrew S. Tanenbaum, David J. Wetherall
Prentice Hall; Published: 2010-10-07; Hardcover; Book
Best price: $87.00
Price in other shops: $132.00
Data and Computer Communications (9th Edition) ImageData and Computer Communications (9th Edition)
by William Stallings
Prentice Hall; Published: 2010-08-13; Hardcover; Book
Best price: $102.00
Price in other shops: $147.00
Operating System Concepts Essentials ImageOperating System Concepts Essentials
by Abraham Silberschatz, Peter B. Galvin, Greg Gagne
Wiley; Published: 2010-11-23; Paperback; Book
Best price: $61.88
Database System Concepts ImageDatabase System Concepts
by Abraham Silberschatz, Henry Korth, S. Sudarshan
McGraw-Hill Science/Engineering/Math; Published: 2010-01-27; Hardcover; Book
Best price: $88.97
PHP and MySQL Web Development (4th Edition) ImagePHP and MySQL Web Development (4th Edition)
by Luke Welling, Laura Thomson
Addison-Wesley Professional; Published: 2008-10-11; Paperback; Book
Best price: $27.99
Price in other shops: $54.99
Concepts of Programming Languages (9th Edition) ImageConcepts of Programming Languages (9th Edition)
by Robert W. Sebesta
Addison Wesley; Published: 2009-04-02; Hardcover; Book
Best price: $76.94
Price in other shops: $126.00
Operating System Concepts ImageOperating System Concepts
by Abraham Silberschatz, Peter B. Galvin, Greg Gagne
Wiley; Published: 2008-07-29; Hardcover; Book
Best price: $71.34
Oracle 10g Programming: A Primer ImageOracle 10g Programming: A Primer
by Rajshekhar Sunderraman
Addison Wesley; Published: 2007-05-01; Paperback; Book
Best price: $24.70
Price in other shops: $54.00
Computer Networking: A Top-Down Approach (5th Edition) ImageComputer Networking: A Top-Down Approach (5th Edition)
by James F. Kurose, Keith W. Ross
NA; Addison Wesley; Published: 2009-03-31; Hardcover; Book
Best price: $85.00
Price in other shops: $132.00