Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQLPerfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity.This book will change the way you think about the problems you solve with SQL programs.. Focusing on three key table-based techniques, Celko reveals their power through detailed examples and clear explanations. As you master these techniques, you'll find you are able to conceptualize problems as rooted in sets and solvable through declarative programming. Before long, you'll be coding more quickly, writing more efficient code, and applying the full power of SQL - Filled with the insights of one of the world's leading SQL authorities - noted for his knowledge and his ability to teach what he knows - Focuses on auxiliary tables (for computing functions and other values by joins), temporal tables (for temporal queries, historical data, and audit information), and virtual tables (for improved performance) - Presents clear guidance for selecting and correctly applying the right table technique |
Contents
| 1 | |
Chapter 2 Hardware Data Volume and Maintaining Databases | 29 |
Chapter 3 Data Access and Records | 37 |
Chapter 4 Lookup Tables | 51 |
Chapter 5 Auxiliary Tables | 65 |
Chapter 6 Views | 87 |
Chapter 7 Virtual Tables | 117 |
Chapter 8 Complicated Functions via Tables | 137 |
Chapter 11 Thinking in SQL | 215 |
Chapter 12 Group Characteristics | 235 |
Chapter 13 Turning Specifications into Code | 255 |
Chapter 14 Using Procedure and Function Calls | 273 |
Chapter 15 Numbering Rows | 287 |
Chapter 16 Keeping Computed Data | 297 |
Chapter 17 Triggers for Constraints | 301 |
Chapter 18 Procedural and Data Driven Solutions | 323 |
Other editions - View all
Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL Joe Celko No preview available - 2008 |
Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL Joe Celko No preview available - 2008 |
Common terms and phrases
algorithm article_id base table CASCADE CHECK constraint check digit CHECK OPTION clause COBOL code_type col_x compute constraints CREATE TABLE CREATE VIEW cursor data element data type data warehouse database DECLARE DEFAULT defined DELETE derived table disk Don Quixote Dorothy Gale end_date error event_time example EXISTS SELECT file system Foobar FOREIGN KEY GROUP gtin guest_name implementation INSERT INTEGER NOT NULL INTERVAL Joe Celko look lookup table media_type Mediumpay nested NULL CHECK NULL PRIMARY KEY OLAP OLTP parameter partition perfect hashing function Personnel PersonnelSkills physical predicate problem procedural code programming language proprietary query RDBMS recursive REPLACE result rules schema SELECT DISTINCT seq_nbr Sequence sequential simple skill_code2 skill_code4 solution SQL engine SQL product SQL programmer SQL Server Standard SQL start_date statement storage string swap syntax tape temporal temporary tables TIMESTAMP trigger unique UPDATE user_id VARCHAR WidgetInventory zero
Popular passages
Page 15 - Red, green, and blue are three primary additive colors (individual components are added together to form a desired color) and are represented by a three-dimensional, Cartesian coordinate system (Figure 3.1).