Copyright
Dedication
Preface
Why We Wrote This Book
Audience for This Book
Which Platform and Version?
Structure of This Book
Conventions Used in This Book
About the Code
Comments and Questions
Acknowledgments
Chapter 1. Pivot Tables
Section 1.1. Using a Pivot Table
Chapter 2. Sets
Section 2.1. Introduction
Section 2.2. The Students Example
Section 2.3. Implementing Set Difference
Section 2.4. Comparing Two Sets for Equality
Section 2.5. Implementing Partial Intersection
Section 2.6. Implementing Full Intersection
Section 2.7. Classifying Subsets
Section 2.8. Summarizing Classes of Sets
Section 2.9. Aggregating Aggregates
Section 2.10. Summarizing Aggregated Classes
Section 2.11. Including Nonaggregated Columns
Section 2.12. Finding the Top N Values in a Set
Section 2.13. Reporting the Size of a Set's Complement
Section 2.14. Finding the Complement of a Set
Section 2.15. Finding the Complement of a Missing Set
Section 2.16. Finding Complements of Sets with Different Universes
Section 2.17. Comparing a Set with Its Universe
Section 2.18. Dynamic Classification System
Chapter 3. Data Structures
Section 3.1. Types of Data Structures
Section 3.2. Working Example
Section 3.3. Finding Regions
Section 3.4. Reporting Region Boundaries
Section 3.5. Limiting Region Size
Section 3.6. Ranking Regions by Size
Section 3.7. Working with Sequences
Section 3.8. Working with Runs
Section 3.9. Cumulative Aggregates in Lists
Section 3.10. Implementing a Stack
Section 3.11. Implementing Queues
Section 3.12. Implementing Priority Queues
Section 3.13. Comparing Two Rows in an Array
Section 3.14. Printing Matrices and Arrays
Section 3.15. Transposing a Matrix
Section 3.16. Calculating a Matrix Trace
Section 3.17. Comparing Two Matrices for Size
Section 3.18. Adding and Subtracting Matrices
Section 3.19. Multiplying Matrices
Chapter 4. Hierarchies in SQL
Section 4.1. Types of Hierarchies
Section 4.2. Creating a Permission Hierarchy
Section 4.3. Changing Individual Permissions
Section 4.4. Adding New Individual Permissions
Section 4.5. Centralizing Authorization Logic
Section 4.6. Implementing General Hierarchies
Section 4.7. Traversing Hierarchies Recursively
Section 4.8. Manipulating Hierarchies Recursively
Section 4.9. Aggregating Hierarchies
Section 4.10. Preparing Multilevel Operations
Section 4.11. Aggregating Hierarchies Revised
Chapter 5. Temporal Data
Section 5.1. Introduction
Section 5.2. The Schedules Example
Section 5.3. Enforcing Granularity Rules
Section 5.4. Storing Out-of-Range Temporal Values
Section 5.5. Deriving the First and Last Dates of the Month
Section 5.6. Printing Calendars
Section 5.7. Calculating Durations
Section 5.8. Reporting Durations
Section 5.9. Querying Periods
Section 5.10. Querying Periods and Respecting Granularity
Section 5.11. Finding Available Periods
Section 5.12. Finding Common Available Periods
Section 5.13. Excluding Recurrent Events
Section 5.14. Excluding Nonrecurring Events
Section 5.15. Finding Continuous Periods
Section 5.16. Using Calendar Information with Periods
Section 5.17. Using Calendar Information with Durations
Chapter 6. Audit Logging
Section 6.1. Audit Logs
Section 6.2. The Warehouse Example
Section 6.3. Row-Level Logging
Section 6.4. Reporting Log Events
Section 6.5. Generating Current Snapshots
Section 6.6. Generating Time-Restricted Snapshots
Section 6.7. Undoing Table Changes
Section 6.8. Minimizing Audit-Log Space Consumption
Section 6.9. Online Account Balancing
Section 6.10. Activity-Level Logging
Section 6.11. Partitioning Large Log Tables
Section 6.12. Server Push
Chapter 7. Importing and Transforming Data
Section 7.1. Considerations When Importing Data
Section 7.2. Working Examples
Section 7.3. Importing External Data
Section 7.4. Importing Data into a Live System
Section 7.5. Importing with a Single Procedure
Section 7.6. Hiding the Import Procedure
Section 7.7. Folding Tables
Section 7.8. Pivoting Tables
Section 7.9. Joining Arrays with Tables
Section 7.10. Joining Arrays with Master Tables
Section 7.11. Joining Arrays with Multiple Master Records
Section 7.12. Extracting Master Records from Tables
Section 7.13. Generating Master Records Online
Section 7.14. Working with Duplicates
Chapter 8. Statistics in SQL
Section 8.1. Statistical Concepts
Section 8.2. The Light-Bulb Factory Example
Section 8.3. Calculating a Mean
Section 8.4. Calculating a Mode
Section 8.5. Calculating a Median
Section 8.6. Calculating Standard Deviation, Variance, and Standard Error
Section 8.7. Building Confidence Intervals
Section 8.8. Calculating Correlation
Section 8.9. Exploring Patterns with Autocorrelation
Section 8.10. Using a Simple Moving Average
Section 8.11. Extending Moving Averages
Appendix A. The T-Distribution Table
Colophon
Index
· · · · · · (收起)