Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL
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.
Chapter 2 Hardware Data Volume and Maintaining Databases
Chapter 3 Data Access and Records
Chapter 4 Lookup Tables
Chapter 5 Auxiliary Tables
Chapter 6 Views
Chapter 7 Virtual Tables
Chapter 8 Complicated Functions via Tables
Chapter 11 Thinking in SQL
Chapter 12 Group Characteristics
Chapter 13 Turning Specifications into Code
Chapter 14 Using Procedure and Function Calls
Chapter 15 Numbering Rows
Chapter 16 Keeping Computed Data
Chapter 17 Triggers for Constraints
Chapter 18 Procedural and Data Driven Solutions
Other editions - View all
algorithm arrival_date article_id barcode base table CASCADE CHAR check constraint check digit CHECK OPTION clause COBOL code_type col_x compute constraints COUNT CREATE TABLE CREATE VIEW cursor data element data type data warehouse database DECLARE DEFAULT defined DELETE dept_name derived table disk Don Quixote Dorothy Gale end_date error event_id event_name event_time example EXISTS SELECT Foobar FOREIGN KEY GROUP gtin guest_name hand_qty INSERT INTEGER NOT NULL Joe Celko look lookup table media_type NULL CHECK NULL PRIMARY KEY OLAP OLTP OUTER JOIN parameter parking_space partition perfect hashing function Personnel physical predicate problem programming language proprietary purchase_date query RDBMS REPLACE result rules schema seq_nbr Sequence sequential simple skill_code skill_code2 SPACES SQL engine SQL product SQL programmer Standard SQL start_date statement storage string SUBSTRING syntax tape temporary tables TIMESTAMP trigger unique UPDATE VARCHAR WidgetInventory zero