Cargando…
The art of SQL /
For all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data. Database performance has become a major headache, and most IT departments believe that developers should...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, Calif. :
O'Reilly,
2006.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- 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; Laying Plans; The Relational View of Data; The Importance of Being Normal; Step 1: Ensure Atomicity; Step 2: Check Dependence on the Whole Key; Step 3: Check Attribute Independence; To Be or Not to Be, or to Be Null; Qualifying Boolean Columns; Understanding Subtypes; Stating the Obvious; The Dangers of Excess Flexibility; The Difficulties of Historical Data; Design and Performance.
- Processing FlowCentralizing Your Data; System Complexity; The Completed Plans; Waging War; Query Identification; Stable Database Connections; Strategy Before Tactics; Problem Definition Before Solution; Stable Database Schema; Operations Against Actual Data; Set Processing in SQL; Action-Packed SQL Statements; Profitable Database Accesses; Closeness to the DBMS Kernel; Doing Only What Is Required; SQL Statements Mirror Business Logic; Program Logic into Queries; Multiple Updates at Once; Careful Use of User-Written Functions; Succinct SQL; Offensive Coding with SQL.
- Discerning Use of ExceptionsTactical Dispositions; The Identification of "Entry Points"; Indexes and Content Lists; Making Indexes Work; Indexes with Functions and Conversions; Indexes and Foreign Keys; Multiple Indexing of the Same Columns; System-Generated Keys; Variability of Index Accesses; Maneuvering; The Nature of SQL; SQL and Databases; SQL and the Optimizer; Limits of the Optimizer; Five Factors Governing the Art of SQL; Total Quantity of Data; Criteria Defining the Result Set; Size of the Result Set; Number of Tables; Joins; Complex queries and complex views; Number of Other Users.
- FilteringMeaning of Filtering Conditions; Evaluation of Filtering Conditions; Buyers of Batmobiles; More Batmobile purchases; Lessons to be learned from the Batmobile trade; Querying Large Quantities of Data; The Proportions of Retrieved Data; Terrain; Structural Types; The Conflicting Goals; Considering Indexes as Data Repositories; Forcing Row Ordering; Automatically Grouping Data; Round-Robin Partitioning; Data-Driven Partitioning; The Double-Edged Sword of Partitioning; Partitioning and Data Distribution; The Best Way to Partition Data; Pre-Joining Tables; Holy Simplicity.
- The Nine SituationsSmall Result Set, Direct Specific Criteria; Index Usability; Query Efficiency and Index Usage; Data Dispersion; Criterion Indexability; Small Result Set, Indirect Criteria; Small Intersection of Broad Criteria; Small Intersection, Indirect Broad Criteria; Large Result Set; Self-Joins on One Table; Result Set Obtained by Aggregation; Simple or Range Searching on Dates; Many Items, Few Historical Values; Using subqueries; Using OLAP functions; Many Historical Values Per Item; Current Values; Result Set Predicated on Absence of Data; Variations in Tactics; Tree Structures.