search for books and compare prices
Tables of Contents for Advanced ANSI SQL Data Modeling and Structure Processing
Chapter/Section Title
Page #
Page Count
Preface
xv
Introduction
xix
Part I: The Basics of the Relational Join Operation
1
48
Relational Join Introduction
3
8
Standard Inner Join Review
4
1
Problems With Relational Join Processing
5
1
Outer Join Review
6
1
Problems With Previous Outer Join Syntax
7
2
Conclusion
9
2
The ANSI SQL Join Operation
11
12
ANSI SQL Join Syntax
11
3
ANSI SQL Join Operation
14
3
ANSI SQL Join Does Not Follow the Cartesian Product Model
17
1
Determining ANSI SQL Join Associativity and Commutativity
18
1
What Outer Join Commutativity Is
19
1
What Outer Join Associativity Is
19
1
Hierarchictivity in Addition to Associativity and Commutativity
20
1
Conclusion
21
2
ANSI SQL Join Types and Their Operation
23
14
FULL Outer Join
23
3
One-Sided Outer Join
26
5
INNER Join
31
1
CROSS Join
32
1
UNION Join
32
1
Intermixing Join Types
33
1
Conclusion
34
3
Natural Joins
37
12
Explicit and Implicit Natural Joins
37
2
Multitable Natural Outer Joins
39
2
Natural One-Sided Outer Join
41
1
Natural FULL Outer Join
42
2
Natural Inner Joins
44
1
Intermixing Natural Join Types
45
1
Natural One-Sided Join Transformation
46
1
Conclusion
47
2
Part II: Outer Join Data Modeling and Structured Processing
49
58
Data Structure Review
51
16
The Power of Hierarchical Data Structures
51
2
Three-Tier Database Architecture
53
1
External and Internal Views
54
1
Conceptual View
54
1
Many-to-One and One-to-Many Relationships
55
1
Many-to-Many Relationships
55
2
Converting Network Structures to Hierarchical Structures
57
1
Relating Hierarchical Processing to Relational Processing
57
2
Physical Versus Logical Data Structures
59
1
Sibling Legs Query Semantics
60
2
Ordering of Data Structures Can Cause Their Restructuring
62
1
Data Structure Composition
63
1
Good Data Modeling Design Principles
64
1
Conclusion
65
2
Outer Join Does Data Modeling
67
14
SQL Data Modeling Using the Outer Join
67
3
ON Clause Data Modeling Join Condition Rules
70
2
Valid and Invalid ON Clause Data Modeling Examples
72
1
Valid and Invalid Data Modeling Results
73
1
Substructure Views
74
3
WHERE Clause Filtering With Data Structures
77
1
WHERE Clause Filtering With Substructures
77
2
Complex Data Modeling Example
79
1
Conclusion
79
2
Outer Join Data Modeling-Related Capabilities
81
12
Data Structure Filtering
81
2
Indirect Structure Linking
83
1
Nonhierarchical Join Type Support
83
4
Nonhierarchical Joining of Data Structures
87
3
Many-to-Many Data Modeling and Intersecting Data
90
1
Conclusion
91
2
More About Outer Join Data Modeling
93
14
Importance of SQL's Inherent Data Structure Processing Ability
93
1
Efficient Client/Server Data Structure Processing
94
1
Coding Data Modeling Outer Join Statements
94
1
Generation of Data Modeling Outer Join Statements
95
1
Hierarchical Data Structure Processing Empirical Proof
95
1
Hierarchical Control
96
1
Structure Control
97
1
Nonhierarchical Data Structure Processing Empirical Proof
98
1
Embedded Structured View Support Empirical Proof
99
2
Indirect Link Empirical Proof
101
1
SQL:1999 and Data Modeling
102
1
What Makes the ANSI Outer Join Unique for Data Modeling
103
1
Data Modeling With Old-Style Outer Joins
104
1
The New Role of the Inner Join Operation
105
1
Conclusion
105
2
Part III: New Capabilities Based on Outer Join Data Modeling
107
64
Data Structure Extraction (DSE) Technology
109
8
Extracting Data Structure Information From the Outer Join
109
1
DSE Example
110
1
Logical Table Example
111
1
Symmetric Linking of Data Structures Example
111
2
DSE Internal Logic
113
1
Why Vendors Need the DSE Technology
113
1
DSE Avoids Imposing Data Structures on SQL
114
1
Conclusion
115
2
Outer Join Advanced Capabilities
117
14
Database Navigation
117
1
Access Optimizations
118
1
Enterprise and Legacy Database Access
119
1
Open Database Access Interface
120
1
Seamless Value-Added Features
120
1
Data Warehouse Interface
121
1
Hierarchical Relational Processing
121
1
Object Relational Interface
122
1
View Update Capability
123
1
Multimedia Application Directory Support
124
3
Universal Data Access of Structured Data
127
1
The SQL XML Data Structure Connection
128
2
Conclusion
130
1
Outer Join Optimization
131
12
Join Table Reordering
131
1
Dynamic Shortening of the Access Path
132
1
Removal of Unnecessary Tables From Outer Join View
132
3
Increased Efficiency of Parallel Database Processing
135
1
Dynamic Rebuild to Pick Up New SQL Features
135
1
Optimization of Nonrelational SQL Interfaces
136
2
Applying Hierarchical Optimizations to Network Structures
138
1
Shifting ON Clauses to the WHERE Clause
139
2
Conclusion
141
2
Hierarchical Relational Processor Prototype
143
10
Hierarchical Relational Prototype Operation
144
1
Basic Data Modeling
144
2
Many-to-Many Relationships
146
1
Embedded Views
147
1
View Optimization
148
2
Conclusion
150
3
Object/Relational Interface
153
8
Standardized SQL Interface
153
1
Data Modeling and Structure Processing
154
1
Data Abstraction and Reusability
155
1
Data Inheritance
156
1
Database Navigation, Efficiency, and Nonrelational Access
157
1
Late Binding and Polymorphism
158
1
Plug and Play
159
1
Conclusion
160
1
Nonrelational SQL-Based Universal Data Access
161
10
Structured Record Overview
162
2
SQL Structured Data Access Basics
164
1
Internal Navigation and Mapping of Structured Data
165
2
SQL-Based Universal Data Access of Structured Data
167
1
Handling Multiple Structure Formats Within a File
168
1
Interfacing to Prerelational and Postrelational Data
168
1
The Importance of the View for Contiguous Data
168
2
Conclusion
170
1
Part IV: Miscellaneous Data Modeling Topics
171
32
Advanced Lower Structure Linking
173
12
Overview of Nonroot Lower Level Linking
173
1
Previous Nonroot Lower Level Linking Method
174
1
Semantics of Nonroot Lower Level Linking
174
2
Single Path Reference to Lower Structure
176
2
Multiple Path References to Lower Structure
178
2
Optimization Concerns for Nonroot Lower Level Linking
180
1
Using Lower Structure Linking With a View WHERE Clause
180
2
Restructuring the Data
182
1
Conclusion
183
2
Data Modeling Outer Join Generator
185
16
Product Overview
185
1
Operational Overview
186
2
Menu Overview
188
1
Adding a Structure Box
189
2
Specifying the Link Criteria
191
1
Specifying a Data Filter
192
1
Changing or Removing a Structure Box
193
1
Optimizing the Outer Join Statement and Data Structure
194
1
Saving, Retrieving, or Deleting a Stored Structure
195
2
Running the Outer Join Query
197
1
Loading the Database Data
198
1
Data Modeling Diagramming Symbols
199
1
Conclusion
200
1
Summary
201
2
Appendix A: Database Views Used in This Book
203
4
Notes on the Company Database Views
204
1
Notes on the Parts-Suppliers Views
205
2
Glossary
207
22
Bibliography
229
4
About the Author
233
2
Index
235