Databases and Transaction Processing: An Application-Oriented Approach

First I need to explain my background: I only knew a little about databases and SQL in general, but I knew the topic was rather complex and very broad. Since I wanted to understand how transactions are implemented I decided to find a book on them and stumbled upon this book; I am glad I did.Do I now understand how transactions are implemented? Not 100%, but certainly a great deal more so than before I read this books' chapters on transactions. Indeed, I am far more equiped to work with transactions because this book helped me understand what is going on "under the hood". While it wasn't "code level" details, it certainly satisfied this novices' thirst for a general understanding of transaction implementation plus it piqued my curiousity to go on and learn more about transactions as written by the likes of Gray.Further, I have been given a nice introduction to Database Theory and the topic of Entity Relationships - an entire study of how best to design our data, which before hand I was completely unaware of!Two chapters seemed rather difficult and one of the authors was kind enough to suggest I study Susanna Epp's fine "Discrete Mathematics with Applications" before heading back into foray of DB theory.So, all and all, I found this book a delight and well worth working through.

Database and Transaction Processing by Philip M. Lewis, et al. is written as a multi-purpose textbook and practical reference guide for software engineers. One can use this book both as an undergraduate introductory course in database theory and design, as an advanced graduate-level course in databases, or as a graduate level course in transaction processing. Being outside of the academia, but still needing a foundational theoretical (but not necessarily formal or overly detailed) reference, I was impressed on the ability of the authors to present concise and useful practical facts. Some other textbooks suffer from overwrought attention to topics in database normalization, correctness proves, and such - this one gives a lot of practical advise in optimization, distributed databases and issues of concurrency control and transaction processing. Chapters are organized in a self-contained fashion, so with a bit of background in databases, reader can just read a chapter in isolation if she is interested in a topic. In summary, a very useful book.

Talk about credibility...Jim Gray, who won the 1998 Turing Award for his work in database and TP, is quoted on the back cover saying "This is a great book. This is the book I wish I had written."