Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL

Front Cover
Morgan Kaufmann, Jan 22, 2008 - Computers - 384 pages
Perfectly 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.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Chapter 1 SQL is Declarative Not Procedural
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

Chapter 9 Temporal Tables
155
Chapter 10 Scrubbing Data with Non1NF Tables
191

Other editions - View all

Common terms and phrases

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).

About the author (2008)

Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards.

Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas.

He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.

Bibliographic information