SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Paperback)

Bill Karwin

SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Paperback)
  • 出版商: Pragmatic Bookshelf
  • 出版日期: 2010-08-03
  • 售價: $1,220
  • 貴賓價: 9.5 折 $1,159
  • 語言: 英文
  • 頁數: 328
  • 裝訂: Paperback
  • ISBN: 1934356557
  • ISBN-13: 9781934356555
  • 相關分類: SQL、Design Pattern 、資料庫

    • 立即出貨 (庫存=1)

買這商品的人也買了...

商品描述

Bill Karwin has helped thousands of people write better SQL and build stronger relational databases. Now he's sharing his collection of antipatterns--the most common errors he's identified in those thousands of requests for help.

Most developers aren't SQL experts, and most of the SQL that gets used is inefficient, hard to maintain, and sometimes just plain wrong. This book shows you all the common mistakes, and then leads you through the best fixes. What's more, it shows you what's behind these fixes, so you'll learn a lot about relational databases along the way.

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.

商品描述(中文翻譯)

Bill Karwin幫助了成千上萬的人改善SQL寫作和建立更強大的關聯式資料庫。現在他分享了他收集到的反模式集合 - 這些是他在這些數千個求助請求中所確定的最常見錯誤。

大多數開發人員並不是SQL專家，而且大部分使用的SQL都是效率低下、難以維護，有時甚至是錯誤的。這本書向您展示了所有常見的錯誤，然後引導您進行最佳修復。更重要的是，它向您展示了這些修復背後的原理，因此您將在這個過程中學到很多關於關聯式資料庫的知識。

本書的每一章都幫助您識別、解釋和修正一個獨特且危險的反模式。書中的四個部分根據邏輯資料庫設計、物理資料庫設計、查詢和應用程式開發將這些反模式進行分類。

很有可能您的應用程式的資料庫層已經存在諸如「索引散彈槍」、「無鍵入」、「對未知的恐懼」和「意大利麵查詢」等問題。本書將幫助您和您的團隊找到它們。更好的是，它還會向您展示如何修復這些問題，以及如何避免未來出現這些和其他問題。

《SQL反模式》讓您有機會深入了解SQL專家的策略。現在，您可以一勞永逸地消除這些常見的資料庫錯誤。

無論您使用哪個平台或程式語言，無論您是初級程式設計師還是博士，SQL反模式都會向您展示如何設計和建立資料庫，如何撰寫更好的資料庫查詢，以及如何像專家一樣將SQL程式設計與應用程式整合。您還將學習到最佳和最新的全文檢索技術，如何設計抵抗SQL注入攻擊的程式碼，以及其他成功的技巧。

類似商品