Shop now Shop now Shop now Up to 70% off Fashion Shop All Amazon Fashion Cloud Drive Photos Amazon Fire TV Subscribe and Save Shop now Shop Fire Shop Kindle Shop now Shop now Shop now
Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Vi... and over 2 million other books are available for Amazon Kindle . Learn more

Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Start reading Joe Celko's Thinking in Sets on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

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

Joe Celko
3.0 out of 5 stars  See all reviews (2 customer reviews)
Price: £20.99 Eligible for FREE UK Delivery Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Want it Tuesday, 16 Feb.? Choose Express delivery at checkout. Details
‹  Return to Product Overview

Table of Contents

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

‹  Return to Product Overview