Description

 *******************************************************************************

        Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual

*******************************************************************************


-------------------------------------------------------------------------------

                              General Information

-------------------------------------------------------------------------------

Type.................: Ebook

Part Size............: 8,092,779 bytes





-------------------------------------------------------------------------------

                               Post Information

-------------------------------------------------------------------------------

Posted by............: ~tqw~


-------------------------------------------------------------------------------

                                 Release Notes

-------------------------------------------------------------------------------

Joe Celko has looked deep into the code of novice SQL programmers and found a 

consistent and troubling pattern. These programmers have not changed their 

approach from writing code for a procedural language, like C, to a declarative 

language--which is what SQL is. As a result they are not fully using the power 

and capability inherent in SQL and that translates into writing more code than 

they need to write, more complex code than is needed, and ultimately lower 

productivity.


Thinking in sets reveals the conceptual shift these programmers need to make. 

Through detailed examples and clear explanations, Joe enables readers to 

concepualize database problems as rooted in sets and solvable through 

declarative programming techniques. The book focuses on three main table-based 

SQL techniques that not only demonstrate this set characteristic of SQL but also 

dramatically simplify application development. For each table type--auxillary, 

temporal and virrual--Joe teaches not only the new kind of thinking required to 

use them effectively but also how to choose the right table technique to apply 

and why.


Table Of Contents


Table of Contents Preface xvii

1 SQL Is Declarative, Not Procedural

2 Hardware, Data Volume, and Maintaining Databases

3 Data Access and Records 

4 Lookup Tables 

5 Auxiliary Tables 

6 Views 

7 Virtual Tables 

8 Complicated Functions via Tables 

9 Temporal Tables 

10 Scrubbing Data with Non-1NF Tables 

11 Thinking in SQL 

12 Group Characteristics 

13 Turning Specifications into Code 

14 Using Procedure and Function Calls 

15 Numbering Rows 

16 Keeping Computed Data 

17 Triggers for Constraints 

18 Procedural and Data Driven Solutions 

   Index 


Product Details


    * ISBN: 0123741378

    * ISBN-13: 9780123741370

    * Format: Paperback, 362pp

    * Publisher: Elsevier Science & Technology Books

    * Pub. Date: January 2008


-------------------------------------------------------------------------------

                                 Install Notes

-------------------------------------------------------------------------------

Adobe Acrobat Reader