开发工具:
文件大小: 1mb
下载次数: 1
上传时间: 2010-05-01
详细说明： The Art of SQL Dedication Preface Why Another SQL Book? Audience Assumptions This Book Makes Contents of This Book Conventions Used in This Book Using Code Examples Comments and Questions Safari® Enabled Acknowledgments Chapter 1. Laying Plans Section 1.1. The Relational View of Data Section 1.2. The Importance of Being Normal Section 1.3. To Be or Not to Be, or to Be Null Section 1.4. Q ualifying Boolean Columns Section 1.5. Understanding Subtypes Section 1.6. Stating the Obvious Section 1.7. The Dangers of Excess Flexibility Section 1.8. The Difficulties of Historical Data Section 1.9. Design and Performance Section 1.10. Processing Flow Section 1.11. Centralizing Your Data Section 1.12. System Complexity Section 1.13. The Completed Plans Chapter 2. Waging War Section 2.1. Query Identification Section 2.2. Stable Database Connections Section 2.3. Strategy Before Tactics Section 2.4. Problem Definition Before Solution Section 2.5. Stable Database Schema Section 2.6. Operations Against Actual Data Section 2.7. Set Processing in SQL Section 2.8. Action-Packed SQL Statements Section 2.9. Profitable Database Accesses Section 2.10. Closeness to the DBMS Kernel Section 2.11. Doing Only What Is Required Section 2.12. SQL Statements Mirror Business Logic Section 2.13. Program Logic into Queries Section 2.14. Multiple Updates at Once Section 2.15. Careful Use of User-Written Functions Section 2.16. Succinct SQL Section 2.17. Offensive Coding with SQL Section 2.18. Discerning Use of Exceptions Chapter 3. Tactical Dispositions Section 3.1. The Identification of "Entry Points" Section 3.2. Indexes and Content Lists Section 3.3. Making Indexes Work Section 3.4. Indexes with Functions and Conversions Section 3.5. Indexes and Foreign Keys Section 3.6. Multiple Indexing of the Same Columns Section 3.7. System-Generated Keys Section 3.8. Variability of Index Accesses Chapter 4. Maneuvering Section 4.1. The Nature of SQL Section 4.2. Five Factors Governing the Art of SQL Section 4.3. Filtering Chapter 5. Terrain Section 5.1. Structural Types Section 5.2. The Conflicting Goals Section 5.3. Considering Indexes as Data Repositories Section 5.4. Forcing Row Ordering Section 5.5. Automatically Grouping Data Section 5.6. The Double-Edged Sword of Partitioning Section 5.7. Partitioning and Data Distribution Section 5.8. The Best Way to Partition Data Section 5.9. Pre-Joining Tables Section 5.10. Holy Simplicity Chapter 6. The Nine Situations Section 6.1. Small Result Set, Direct Specific Criteria Section 6.2. Small Result Set, Indirect Criteria Section 6.3. Small Intersection of Broad Criteria Section 6.4. Small Intersection, Indirect Broad Criteria Section 6.5. Large Result Set Section 6.6. Self-Joins on One Table Section 6.7. Result Set Obtained by Aggregation Section 6.8. Simple or Range Searching on Dates Section 6.9. Result Set Predicated on Absence of Data Chapter 7. Variations in Tactics Section 7.1. Tree Structures Section 7.2. Representing Trees in an SQL Database Section 7.3. Practical Implementation of Trees Section 7.4. Walking a Tree with SQL Section 7.5. Aggregating Values from Trees Chapter 8. Weaknesses and Strengths Section 8.1. Deceiving Criteria Section 8.2. Abstract Layers Section 8.3. Distributed Systems Section 8.4. Dynamically Defined Search Criteria Chapter 9. Multiple Fronts Section 9.1. The Database Engine as a Service Provider Section 9.2. Concurrent Data Changes Chapter 10. Assembly of Forces Section 10.1. Increasing Volumes Section 10.2. Data Warehousing Chapter 11. Stratagems Section 11.1. Turning Data Around Section 11.2. Querying with a Variable in List Section 11.3. Aggregating by Range (Bands) Section 11.4. Superseding a General Case Section 11.5. Selecting Rows That Match Several Items in a List Section 11.6. Finding the Best Match Section 11.7. Optimizer Directives Chapter 12. Employment of Spies Section 12.1. The Database Is Slow Section 12.2. The Components of Server Load Section 12.3. Defining Good Performance Section 12.4. Thinking in Business Tasks Section 12.5. Execution Plans Section 12.6. Using Execution Plans Properly Section 12.7. What Really Matters? PHOTO CREDITS About the Author Index ...展开收缩
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台，提供交流渠道，下载内容来自于网络，除下载问题外，其它问题请自行百度。
- 本站已设置防盗链，请勿用迅雷、QQ旋风等多线程下载软件下载资源，下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载，请稍后再次尝试；或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎，请到消费记录里找到下载记录反馈给我们，经确认后退回积分.
- 如下载前有疑问，可以通过点击"提供者"的名字，查看对方的联系方式，联系对方咨询.
