Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann Series in Data Management Systems)

Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann Series in Data Management Systems)

By: Joe Celko (author)Paperback

1 - 2 weeks availability

£18.89 RRP £20.99  You save £2.10 (10%) & FREE Saver Delivery on orders over £20


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.

Create a review

About Author

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.


0. Introduction 1. SQL is Declarative, Not Procedural 1.1. Different Programming Model 1.2. Different Data Model 1.2.1. Tables are not Files 1.2.2. Rows are not Records 1.2.3. Columns are not Fields 1.2.4. Statements are not Procedures 1.3. Hardware Now Makes Handling Volume Data Easier 1.3.1. Parallelism - why it is best for sets 1.3.2. Cheap Main Storage 1.3.3. Cheaper Secondary Storage 2. Auxiliary Tables - define 2.1. Sequence Table 2.1.1. As Loop Replacement 2.1.2. From Recursive CTE 2.1.3. Display Functions 2.2. Basic Look-Up Tables - Display & Decode 2.2.1. Constant Tables 2.2.2. OTLT or MUCK Table Problems 2.3. Functions 2.3.1. Not All Functions are Computable (see calendar) Encryption via Tables Random Numbers 2.3.2. Join Parallelism can be faster than Computations 2.4. Interpolation for Unknown Values 2.4.1. Linear Interpolation 2.4.2. Non-Linear Interpolation (First and Second Deltas) 2.5. Check Digits via Tables 2.5.1. Weighted Summation Algorithm 2.5.2. Diherdal-5 Algorithm 2.6. Data Mining for Auxiliary Tables 2.6.1. Corky's BBQ Story 3. Temporal Tables 3.1. The Nature of Time - 3.1.1. Durations & Continuum, not Chronons 3.1.2. Granularity, not a True Continuum 3.2. State Transition Tables 3.3. ISO Half-Open Interval Model 3.3.1. Use of NULL for "Eternity" or "Now" 3.3.2. Temporal Table Constraints Primary Key + timestamp Preventing Overlapping Intervals 3.4. Consolidating Overlapping Intervals 3.4.1. Cursors 3.4.2. Triggers 3.4.3. OLAP and Recursive CTE Code 3.5. Calendar Tables 3.5.1. Basic Calendar Table 3.5.2. Other Temporal Data Table Tricks 3.6. Holiday Lists 3.7. Report Periods 3.7.1. Overlapping Periods 3.7.2. Self-Updating Views 3.8. History Tables 3.8.1. Basic History Table 3.8.2. Audit Trails are Kept outside of the Schema 4. Virtual Tables 4.1. Derived Tables 4.1.1. Column Naming Rules 4.1.2. Scoping Rules 4.2. CTE - Common Table Expressions 4.2.1. Recursive 4.2.2. Non-Recursive 4.3. Views 4.3.1. Basic Concepts 4.3.2. Nesting Levels 4.3.3. WITH CHECK OPTION 4.4. Temporary Tables - avoid them 4.4.1. ANSI/ISO Standards 4.4.2. Vendors Models 4.5. Schema Information Tables 4.5.1. ANSI/ISO Standards versus Vendors 4.5.2. Use in Code Generation 4.6 Materialized Views

Product Details

  • publication date: 27/02/2008
  • ISBN13: 9780123741370
  • Format: Paperback
  • Number Of Pages: 384
  • ID: 9780123741370
  • weight: 780
  • ISBN10: 0123741378

Delivery Information

  • Saver Delivery: Yes
  • 1st Class Delivery: Yes
  • Courier Delivery: Yes
  • Store Delivery: Yes

Prices are for internet purchases only. Prices and availability in WHSmith Stores may vary significantly