Cover for Joe Celko's Thinking in Sets

Joe Celko's Thinking in Sets

Auxiliary, Temporal, and Virtual Tables in SQL

A volume in The Morgan Kaufmann Series in Data Management Systems

Book2008

Author:

Joe Celko

Joe Celko's Thinking in Sets

Auxiliary, Temporal, and Virtual Tables in SQL

A volume in The Morgan Kaufmann Series in Data Management Systems

Book2008

 

Cover for Joe Celko's Thinking in Sets

Author:

Joe Celko

About the book

Browse this book

Book description

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 ... read full description

Browse content

Table of contents

Actions for selected chapters

Select all / Deselect all

  1. Full text access
  2. Book chapterAbstract only

    Chapter 1 - SQL Is Declarative, Not Procedural

    Pages 1-27

  3. Book chapterAbstract only

    Chapter 2 - Hardware, Data Volume, and Maintaining Databases

    Pages 29-35

  4. Book chapterAbstract only

    Chapter 3 - Data Access and Records

    Pages 37-49

  5. Book chapterAbstract only

    Chapter 4 - Lookup Tables

    Pages 51-63

  6. Book chapterAbstract only

    Chapter 5 - Auxiliary Tables

    Pages 65-85

  7. Book chapterAbstract only

    Chapter 6 - Views

    Pages 87-115

  8. Book chapterAbstract only

    Chapter 7 - Virtual Tables

    Pages 117-135

  9. Book chapterAbstract only

    Chapter 8 - Complicated Functions via Tables

    Pages 137-153

  10. Book chapterAbstract only

    Chapter 9 - Temporal Tables

    Pages 155-190

  11. Book chapterAbstract only

    Chapter 10 - Scrubbing Data with Non-1 NF Tables

    Pages 191-213

  12. Book chapterAbstract only

    Chapter 11 - Thinking in SQL

    Pages 215-233

  13. Book chapterAbstract only

    Chapter 12 - Group Characteristics

    Pages 235-254

  14. Book chapterAbstract only

    Chapter 13 - Turning Specifications into Code

    Pages 255-271

  15. Book chapterAbstract only

    Chapter 14 - Using Procedure and Function Calls

    Pages 273-285

  16. Book chapterAbstract only

    Chapter 15 - Numbering Rows

    Pages 287-296

  17. Book chapterAbstract only

    Chapter 16 - Keeping Computed Data

    Pages 297-300

  18. Book chapterAbstract only

    Chapter 17 - Triggers for Constraints

    Pages 301-321

  19. Book chapterAbstract only

    Chapter 18 - Procedural and Data-Driven Solutions

    Pages 323-347

  20. Book chapterNo access

    Index

    Pages 349-362

About the book

Description

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

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

Key Features

  • 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
  • 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

Details

ISBN

978-0-12-374137-0

Language

English

Published

2008

Copyright

Copyright © 2008 Elsevier Inc. All rights reserved

Imprint

Morgan Kaufmann

Authors

Joe Celko