Database System Concepts

I do not agree with those people who have been reviewing badly this book on the false accusation that it does not comply with actual SQL syntax.First of all, the book focuses first on explaining SQL language as a Standard, as it is formalized in several revisions through the years.Second, probably to cover some deficiency of the earlier editions, the author spent some time explaining how different commercial versions of SQL differ slightly in their implementation. New sections were added in this 6th edition to highlight the way mySQL, Oracle SQL and other dialects implement certain constructs through slight language changes.Last but not least - as the title reads - this is a book on Database "CONCEPTS" which means that its describes (and very well indeed) the concepts behind the definition of a DBMS and it does it from both a theoretical and practical standpoint.The perfect fruition of this book comes from its study side by side with practical assignments on some implementation of SQL. Since the book focuses on SQL Standard, rather than sticking with one specific implementation, the savvy student should acquaint oneself with the Reference Guide of the SQL implementation of his/her (or the teacher's) choice, and get to study on an actual database system.What I think is missing is an appendix to collect into a single place some BNF charts of the most common implementations, or a table to quickly lookup the differences among these dialects of SQL, so that the students can get an initial reference to jump start into using some DBMS in practice.One last important thing: this book exists in two versions. The hardcover is considerably more expensive than the paperback, but the quality of the paper, the ink and the fonts used make a big difference in the fruition of the book. Their ISBNs differ. Beware that there are many resellers that ship the paperback after receiving an order for a hardcover. These resellers try to get away with the excuse that the text is the same between versions. Indeed, if economy is more important to you than the quality of the print, then the paperback is a good way to save money, because there is a big difference in value between the two ISBNs.But if you pay the price for hardcover and get a paperback they you have been the victim of a "bait-n-switch" fraud. I was one of those victims, so I reported the reseller to Amazon, which forced that reseller to pay a refund.

Very poor quality of the book. The book was advertised as being in good shape. However, it is literally almost falling apart. If I didn't really need this book for this period I would have definitely returned it because of poor quality.The company has tried to resolve the issue by sending a partial refund. A neat solution!

Received in perfect condition. I thought it was funny that it came saran wrapped, with a label on it that said something along the lines "cannot be sold / returned if seal is broken" since it is a hard cover book? Didn't really concern me though, just thought it was odd.

It is most likely cheaper than the bookstore. Buy it.

As a comprehensive text on concepts related to database system is certainly performs as a survey of the topic. At 1268 pages (1349 if you include appendices and glossary) the authors touch on all the important topics including SQL, database design, specialty databases, architectures, transaction and more. It’s frankly amazing how much time and how many words they wasted explaining concepts that could have been more clearly, rapidly, and efficiently covered in less text.For example, chapter eight covers relational database design. It’s a relatively straight-forward topic about functional dependencies and the authors choose to combine definition and example with use mathematics equations, abstract variables instead of easy to follow English. A topic which should be a fast read becomes a tedious endeavor. The omission of clear explainations for every mathematic formula plagues much of computer science writing and this text makes little effort to inoculate it’s readers from its ravaging effects. Perhaps in the next edition, the authors will choose to include the name, pronunciation, and meaning for each symbol used. Small efforts like this allow readers to flow through a chapter’s concepts without becoming tripped up at each formula. Then after understanding the ideas, the reader can go back and study the formula in greater detail.Combine the above with the generally obtuse sentence structures this text sucks the life out of the subject matter which is a shame because the University dataset it uses in appendix A has so much potential. Take for example, “It turns out that, this algorithm may take an amount of time quadratic in the size of F.” A simple rewording of this sentence and others would speed up the amount of time you spend reading each chapter.The only good parts of this text are the truly “advanced” topics but it’s a shame this text chooses to pad its contents with an obfuscated rehashing of the more elementary database concepts. The hardback version is a good quality and the paper and ink are smooth and clear. I also like the way it highlights key terms in blue.

This book is great. I am taking a database class for College now and this book is the reason I am doing so well!

One of the best books around for Database/SQL learning.For the guy who asked where I purchased the Kindle editionhttps://www.amazon.com/gp/aw/s/ref=is_s?k=database+systems+concepts+#twister-secondary-view_1506883947098

Great, good quality low price!

According to me book is amazing, it is the one of the best books to study database.Thanks to Amazon, to provide such a excellent master piece at low price.About product condition - very good.If you're preparing for GATE, this book will be at the top choice.Top books according to me, to study DBMS are -1. Korth2. Raghu RamaKrishnan3. Ramez ElmasrjNPTEL video lectures can be the good option to get good knowledge about the subject.

The sixth edition of Database System Concepts is popularly considered to be one of the cornerstone texts of database education. The basic and fundamental concepts are presented in an intuitive manner and are designed to help students begin working with databases as soon as possible.The book commences with a basic introduction, which discusses fundamental topics like Database Languages, Database Users and Administrators, Database Design, and Data Storage and Querying. Then, the book is segregated into ten sections. Relational Databases, System Architecture, Speciality Databases, and Transaction Management are a few. Chapters like Object-Relational Mapping, Relevance Ranking Using Terms, and Distributed Data Storage are discussed in detail. This edition also provides a revised coverage of SQL, with greater attention to variants of SQL in actual systems and SQL features. There is also new material on support vector machines and validation of classifiers.The text supplied in this book emphasizes applications, practical issues, and implementation, coupled with comprehensive coverage of the key theoretical concepts in a clear manner. Algorithms and concepts are presented in a general setting, while they are not tied to any database system, in particular, annotations and variations specific to particular database systems are provided. The only prerequisites to getting the most out of the book are a familiarity with computer organization, basic data structures, and a high-level programming language.This sixth edition of Database System Concepts was published by Tata McGraw - Hill Education in 2013, and it is available in paperback.Key Features:This edition contains a new running example of a university database, which is more motivating and intuitive for students.More complex design tradeoffs in the database-design chapters are illustrated in this edition.About The AuthorsAbraham Silberschatz is an Israeli computer scientist and author. He procured his Ph.D. in computer science from the State University of New York (SUNY) at Stony Brook. Henry F Korth is a professor of computer science and engineering at Lehigh University. He procured his Ph.D. from Princeton University. S Sudarshan is an Indian professor and head of the department of computer science and engineering at IIT, Bombay. His primary research area is database systems, and he is a member of the Board of Trustees of the VLDB Foundation.

It is an great book for a person who really want to learn DBMS and it is complete enough.it has Euclid example of common sense to understand DBMs and As well as detailed coding for the pratical implementation ..if preparing for Gate it is an epic book and watch anyone lecture for full understanding ....

The book was allright with the standard of 1950s. Not really awkward but quality is not too great.All of highlighted word is badly copied to grey color.

Everything is good but book was already used by someone and its pages were dirty