SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers) |  | Author: Bill Karwin
Publisher: Pragmatic Bookshelf
Category: Book
List Price: $34.95
Buy New: $22.49
as of 9/5/2010 09:40 CDT details
You Save: $12.46 (36%)
New (24) Used (8) from $22.49
Seller: pbshop
Rating:  7 reviews
Sales Rank: 68,221
Media: Paperback
Edition: 1
Pages: 300
Number Of Items: 1
Shipping Weight (lbs): 1.2
Dimensions (in): 8.9 x 7.5 x 1.1
ISBN: 1934356557
Dewey Decimal Number: 005
EAN: 9781934356555
ASIN: 1934356557
Publication Date: June 15, 2010
Availability: Usually ships in 1-2 business days
| |
| Features:
| • | ISBN13: 9781934356555 | | • | Condition: New | | • | Notes: BUY WITH CONFIDENCE, Over one million books sold! 98% Positive feedback. Compare our books, prices and service to the competition. 100% Satisfaction Guaranteed |
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
Each chapter in this book helps you identify, explain, and correct a unique and dangerous antipattern. The four parts of the book group the anti​patterns in terms of logical database design, physical database design, queries, and application development.
The chances are good that your application's database layer already contains problems such as Index Shotgun, Keyless Entry, Fear of the Unknown, and Spaghetti Query. This book will help you and your team find them. Even better, it will also show you how to fix them, and how to avoid these and other problems in the future.
SQL Antipatterns gives you a rare glimpse into an SQL expert's playbook. Now you can stamp out these common database errors once and for all.
Whatever platform or programming language you use, whether you're a junior programmer or a Ph.D., SQL Antipatterns will show you how to design and build databases, how to write better database queries, and how to integrate SQL programming with your application like an expert. You'll also learn the best and most current technology for full-text search, how to design code that is resistant to SQL injection attacks, and other techniques for success.
|
| Customer Reviews:
Showing reviews 1-5 of 7
 An excellent guide to Database Design tradeoffs July 9, 2010
HC Mitchell (Elkhart IN USA)
8 out of 8 found this review helpful
I recently got a new job and inherited a vast collection of SQL queries to maintain. Reading Karwin's book has been a tremendous help! Each chapter considers a particular design issue ("How can I store more than one value in a field?") and shows the most common, flawed method (the "antipattern"). He carefully explains the disadvantages, then usually shows several other ways to accomplish the same goal.
One of the things I like best about the book is that the analysis isn't black and white. Every methods has advantages and disadvantages, which Karwin carefully unpacks. He also reviews and clarifies relational theory as he goes: his discussion of "Null" is a masterpiece. In general, he favors solutions that don't subvert the basic principles of relational database theory.
This would not be a good book to try to learn SQL or Database theory from, but if you are just starting to get some real-world experience it is a Godsend. Highly Recommended.
A Very Useful and Entertaining Book July 30, 2010
Data Guy (Texas)
3 out of 3 found this review helpful
I have a vast collection of SQL books. If it was published in the last 10 or so years, I probably have a copy. Some of them are very good, but there are quite a few similar-looking SQL books, with a similar purpose and a similar look-and-feel. So it takes some doing for a new SQL book to rise above the chaff... but SQL Antipatterns by Bill Karwin manages to do so.
This is not yet another book on SQL syntax or style. SQL Antipatterns is something altogether unique. The book is designed to point out the common things that SQL developers do, that they shouldn't be doing. Each chapter assists the reader in identifying, explaining, and correcting dangerous practices - or antipatterns.
If you take the time to read through this thoughtful book I'm sure you'll recognize some of the antipatterns. Some of you will have done them yourself, whereas others of you probably will have worked to undo some of them.
OK, many of you are still likely to be wondering what exactly is an antipattern is, right? Well, I'll give you one of the examples from Karwin's book -- Jaywalking. This is the first antipattern covered in the book and it is one of my favorites (err, I mean least favorites, I think). Jaywalking is when developers store comma-separated lists in a database column instead of redesigning the database structure in a normalized fashion. Karwin calls this jaywalking because both this practice and actual jaywalking on a street are acts of "avoiding an intersection." Funny...
Each antipatterns is described along with a clear explanation as to why it is a bad practice and advice on building a better solution. Other antipatterns covered in the book are named almost as intriguingly, such as Pseudokey Neat-Freak, Keyless Entry, Magic Beans, See No Evil, and Metadata Tribbles.
The book is not just for unlearning what you shouldn't be doing, it can also be helpful for learning new and improved development techniques. Reading SQL Antipatterns can help you to learn about current technology for full-text search, how to design code that is resistant to SQL injection attacks, and many other techniques for success.
The book is very well-organized into four parts grouping the antipatterns into the following categories: logical database design, physical database design, queries, and application development.
SQL Antipatterns should become a useful tool for DBAs and database programmers to help them create well-designed databases and applications... and to help us eliminate these common errors from our database implementations.
If you want to improve quality of your SQL - buy this book. August 16, 2010
T. Souslin (Boston, MA USA)
1 out of 1 found this review helpful
Excellent book.
I was working on a database when i got this book, and upon finishing reading it the first time, i went through it again highlighting things i knew i was doing wrong and taking notes for going back through my code and changing it.
This book does assume that you are already using sql for your project and know what you are doing at least on this side of a database. Using MySQL as an example is also very convenient.
Overall, great book and if you wish to improve on structures of your queries - buy it.
Deals with problems related to both database's design and application developing August 24, 2010
Foti Massimo (Vezia (Switzerland))
1 out of 1 found this review helpful
I must admit that there was barely anything new to me in the book, but I have been in the field for quite a few years, dealing with many projects, so I had the "privilege" of seeing many horror stories. Still, I feel the book is valuable even for seasoned veterans. The main benefit is that the author organized and grouped the anti-patterns, each one is analyzed very well and contains some wise, unbiased suggestions. Each chapter stands on its own and can be read stand-alone.
The book is worth an extra star because it deals with problems related to both database's design and application developing; most book out there either cover one or the other.
This should be a mandatory reading for beginner DBAs and application developers, veterans may like it too, since it can help refreshing some concepts and can be used as a reference too.
Great Book For Learning Database Trouble Areas July 27, 2010
Daniel McKinnon (Tewksbury, MA USA)
Having been a database developer for nearly 10 years, I have learned the trouble areas that we can get into and wished that I had a resource like SQL Antipatterns: Avoiding the Pitfalls of Database Programming long ago.
From dealing with SQL injection to learning how to store data in a more logical way to many other goodies of database programming that will help you from falling on your face, this is a great text. It's also a niche market that I haven't seen in other SQL/database books in the past.
Keeping that in mind, this is by no means a SQL reference book. This is for the experienced database developer/admin that wants to improve their skillset, not learn how to write basic SELECT and UPDATE queries.
Great book!!
***** RECOMMENDED
Showing reviews 1-5 of 7
|
|
|
