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

3.88 avg rating
( 32 ratings by GoodReads )
 
9780123741370: Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann Series in Data Management Systems)

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. It is 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. It 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). It presents clear guidance for selecting and correctly applying the right table technique.

"synopsis" may belong to another edition of this title.

About the 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.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Joe Celko
Published by Morgan Kaufmann (2008)
ISBN 10: 0123741378 ISBN 13: 9780123741370
New Paperback Quantity Available: > 20
Seller
Travel-Bookshop
(Hertfordshire, United Kingdom)
Rating
[?]

Book Description Morgan Kaufmann, 2008. Paperback. Book Condition: New. Brand new books and maps available immediately from a reputable and well rated UK bookseller - not sent from the USA; despatched promptly and reliably worldwide by Royal Mail; Bookseller Inventory # GLO02139780123741370

More Information About This Seller | Ask Bookseller a Question

Buy New
9
Convert Currency

Add to Basket

Shipping: 4.10
From United Kingdom to U.S.A.
Destination, Rates & Speeds

2.

Joe Celko
Published by ELSEVIER SCIENCE TECHNOLOGY, United States (2008)
ISBN 10: 0123741378 ISBN 13: 9780123741370
New Paperback Quantity Available: 1
Seller
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description ELSEVIER SCIENCE TECHNOLOGY, United States, 2008. Paperback. Book Condition: New. 234 x 190 mm. Language: English . Brand New Book. 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. Bookseller Inventory # AA59780123741370

More Information About This Seller | Ask Bookseller a Question

Buy New
18.04
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

3.

Joe Celko
Published by Morgan Kaufmann (2008)
ISBN 10: 0123741378 ISBN 13: 9780123741370
New Softcover Quantity Available: 1
Seller
Book Deals
(Lewiston, NY, U.S.A.)
Rating
[?]

Book Description Morgan Kaufmann, 2008. Book Condition: New. Brand New, Unread Copy in Perfect Condition. A+ Customer Service! Summary: Table of Contents Preface xvii 1 SQL Is Declarative, Not Procedural 1.1 Different Programming Models 1.2 Different Data Models 1.2.1 Columns Are Not Fields 1.2.2 Rows Are Not Records 1.2.3 Tables Are Not Files 1.2.4 Relational Keys Are Not Record Locators 1.2.5 Kinds of Keys 1.2.6 Desirable Properties of Relational Keys 1.2.7 Unique But Not Invariant 1.3 Tables as Entities 1.4 Tables as Relationships 1.5 Statements Are Not Procedures 1.6 Molecular, Atomic, and Subatomic Data Elements 1.6.1 Table Splitting 1.6.2 Column Splitting 1.6.3 Temporal Splitting 1.6.4 Faking Non-1NF Data 1.6.5 Molecular Data Elements 1.6.6 Isomer Data Elements 1.6.7 Validating a Molecule 2 Hardware, Data Volume, and Maintaining Databases 2.1 Parallelism 2.2 Cheap Main Storage 2.3 Solid-State Disk 2.4 Cheaper Secondary and Tertiary Storage 2.5 The Data Changed 2.6 The Mindset Has Not Changed 3 Data Access and Records 3.1 Sequential Access 3.1.1 Tape-Searching Algorithms 3.2 Indexes 3.2.1 Single-Table Indexes 3.2.2 Multiple-Table Indexes 3.2.3 Type of Indexes 3.3 Hashing 3.3.1 Digit Selection 3.3.2 Division Hashing 3.3.3 Multiplication Hashing 3.3.4 Folding 3.3.5 Table Lookups 3.3.6 Collisions 3.4 Bit Vector Indexes 3.5 Parallel Access 3.6 Row and Column Storage 3.6.1 Row-Based Storage 3.6.2 Column-Based Storage 3.7 JOIN Algorithms 3.7.1 Nested-Loop Join Algorithm 3.7.2 Sort-Merge Join Method 3.7.3 Hash Join Method 3.7.4 Shins Algorithm 4 Lookup Tables 4.1 Data Element Names 4.2 Multiparameter Lookup Tables 4.3 Constants Table 4.4 OTLT or MUCK Table Problems 4.5 Defi nition of a Proper Table 5 Auxiliary Tables 5.1 Sequence Table 5.1.1 Creating a Sequence Table 5.1.2 Sequence Constructor 5.1.3 Replacing an Iterative Loop 5.2 Permutations 5.2.1 Permutations via Recursion 5.2.2 Permutations via CROSS JOIN 5.3 Functions 5.3.1 Functions without a Simple Formula 5.4 Encryption via Tables 5.5 Random Numbers 5.6 Interpolation 6 Views 6.1 Mullins VIEW Usage Rules 6.1.1 Effi cient Access and Computations 6.1.2 Column Renaming 6.1.3 Proliferation Avoidance 6.1.4 The VIEW Synchronization Rule 6.2 Updatable and Read-Only VIEWs 6.3 Types of VIEWs 6.3.1 Single-Table Projection and Restriction 6.3.2 Calculated Columns 6.3.3 Translated Columns 6.3.4 Grouped VIEWs 6.3.5 UNIONed VIEWs 6.3.6 JOINs in VIEWs 6.3.7 Nested VIEWs 6.4 Modeling Classes with Tables 6.4.1 Class Hierarchies in SQL 6.4.2 Subclasses via ASSERTIONs and TRIGGERs 6.5 How VIEWs Are Handled in the Database System 6.5.1 VIEW Column List 6.5.2 VIEW Materialization 6.6 In-Line Text Expansion 6.7 WITH CHECK OPTION Clause 6.7.1 WITH CHECK OPTION as CHECK( ) Clause 6.8 Dropping VIEWs 6.9 Outdated Uses for VIEWs 6.9.1 Domain Support 6.9.2 Table Expression VIEWs 6.9.3 VIEWs for Table Level CHECK( ) Constraints 6.9.4 One VIEW per Base Table 7 Virtual Tables 7.1 Derived Tables 7.1.1 Column Naming Rules 7.1.2 Scoping Rules 7.1.3 Exposed Table Names 7.1.4 LATERAL() Clause 7.2 Common Table Expressions 7.2.1 Nonrecursive CTEs 7.2.2 Recursive CTEs 7.3 Temporary Tables 7.3.1 ANSI/ISO Standards 7.3.2 Vendors Models 7.4 The Information Schema 7.4.1 The INFORMATION_SCHEMA Declarations 7.4.2 A Quick List of VIEWS and Their Purposes 7.4.3 DOMAIN Declarations 7.4.4 Defi nition Schema 7.4.5 INFORMATION_SCHEMA Assertions 8 Complicated Functions via Tables 8.1 Functions without a Simple Formula 8.1.1 Encryption via Tables 8.2 Check Digits via Tables 8.2.1 Check Digits Defi ned 8.2.2 Error Detection versus Error Correct. Bookseller Inventory # ABE_book_new_0123741378

More Information About This Seller | Ask Bookseller a Question

Buy New
18.47
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

4.

Joe Celko
Published by ELSEVIER SCIENCE TECHNOLOGY, United States (2008)
ISBN 10: 0123741378 ISBN 13: 9780123741370
New Paperback Quantity Available: 1
Seller
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description ELSEVIER SCIENCE TECHNOLOGY, United States, 2008. Paperback. Book Condition: New. 234 x 190 mm. Language: English . Brand New Book. 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. Bookseller Inventory # AA59780123741370

More Information About This Seller | Ask Bookseller a Question

Buy New
18.49
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

5.

Joe Celko
ISBN 10: 0123741378 ISBN 13: 9780123741370
New Paperback Quantity Available: 1
Seller
LIMEROCK BOOKS INC.
(NEW CANAAN, CT, U.S.A.)
Rating
[?]

Book Description Paperback. Book Condition: New. This Book is in Good Condition; Customer Satisfaction Comes First.Delivery Time 4-12 days. 100% Money back Guaranteed!!!. Bookseller Inventory # 0123741378

More Information About This Seller | Ask Bookseller a Question

Buy New
16.36
Convert Currency

Add to Basket

Shipping: 3.17
Within U.S.A.
Destination, Rates & Speeds

6.

Joe Celko
Published by Morgan Kaufmann (2008)
ISBN 10: 0123741378 ISBN 13: 9780123741370
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description Morgan Kaufmann, 2008. Paperback. Book Condition: New. book. Bookseller Inventory # 0123741378

More Information About This Seller | Ask Bookseller a Question

Buy New
25.20
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

7.

Joe Celko
Published by Morgan Kaufmann Pub (2008)
ISBN 10: 0123741378 ISBN 13: 9780123741370
New Paperback Quantity Available: 2
Seller
Revaluation Books
(Exeter, United Kingdom)
Rating
[?]

Book Description Morgan Kaufmann Pub, 2008. Paperback. Book Condition: Brand New. illustrated edition. 384 pages. 9.25x7.25x0.75 inches. In Stock. Bookseller Inventory # __0123741378

More Information About This Seller | Ask Bookseller a Question

Buy New
21.07
Convert Currency

Add to Basket

Shipping: 6
From United Kingdom to U.S.A.
Destination, Rates & Speeds

8.

Joe Celko
Published by Morgan Kaufmann (2008)
ISBN 10: 0123741378 ISBN 13: 9780123741370
New Paperback Quantity Available: 1
Seller
Herb Tandree Philosophy Books
(Stroud, GLOS, United Kingdom)
Rating
[?]

Book Description Morgan Kaufmann, 2008. Paperback. Book Condition: NEW. 9780123741370 This listing is a new book, a title currently in-print which we order directly and immediately from the publisher. Bookseller Inventory # HTANDREE01196225

More Information About This Seller | Ask Bookseller a Question

Buy New
21
Convert Currency

Add to Basket

Shipping: 8
From United Kingdom to U.S.A.
Destination, Rates & Speeds

9.

Joe Celko
Published by Morgan Kaufmann (2008)
ISBN 10: 0123741378 ISBN 13: 9780123741370
New Paperback Quantity Available: 1
Seller
Herb Tandree Philosophy Books
(Stroud, GLOS, United Kingdom)
Rating
[?]

Book Description Morgan Kaufmann, 2008. Paperback. Book Condition: NEW. 9780123741370 This listing is a new book, a title currently in-print which we order directly and immediately from the publisher. Bookseller Inventory # HTANDREE0891962

More Information About This Seller | Ask Bookseller a Question

Buy New
21
Convert Currency

Add to Basket

Shipping: 8
From United Kingdom to U.S.A.
Destination, Rates & Speeds

10.

Joe Celko
Published by Morgan Kaufmann (2016)
ISBN 10: 0123741378 ISBN 13: 9780123741370
New Paperback Quantity Available: 1
Print on Demand
Seller
Ria Christie Collections
(Uxbridge, United Kingdom)
Rating
[?]

Book Description Morgan Kaufmann, 2016. Paperback. Book Condition: New. PRINT ON DEMAND Book; New; Publication Year 2016; Not Signed; Fast Shipping from the UK. No. book. Bookseller Inventory # ria9780123741370_lsuk

More Information About This Seller | Ask Bookseller a Question

Buy New
26.76
Convert Currency

Add to Basket

Shipping: 2.91
From United Kingdom to U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book