Advanced ANSI SQL Data Modeling and Structure Processing

Front Cover
Artech House, 1999 - Computers - 244 pages
This volume is a tool for utilizing the ANSI/ISO SQL outer join operation, and a guide to using this operation to perform simple or complex data modelling. It provides a look at the outer join operation, its powerful syntax, and features and capabilities that can be developed based on the operation's data modelling capacity. The author demonstrates how to tap into the power of data structure extraction technology that gathers data structure meta information naturally embedded in ANSI/ISO SQL outer join specifications. He also addresses existing SQL capabilities for improving performance, saving coding time, simplifying design, and reducing debugging time. The book also supplied critical review of the semantics of data structures; tells you how to perform multi-table outer joins and how to combine relational structures with hierarchical structures; and describes how to establish a default database standard or framework for data modelling.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

The Basics of the Relational
1
The ANSI SQL Join Operation
11
ANSI SQL Join Types and Their Operation
23
Natural Joins
37
Outer Join Data Modeling
49
Outer Join Does Data Modeling
67
Outer Join Data ModelingRelated Capabilities
81
New Capabilities Based on Outer Join
107
Outer Join Optimization
131
Hierarchical Relational Processor Prototype
143
ObjectRelational Interface
153
Nonrelational SQLBased Universal Data Access
161
Miscellaneous Data Modeling Topics
171
Data Modeling Outer Join Generator
185
Summary
201
Copyright

Outer Join Advanced Capabilities
117

Common terms and phrases

About the author (1999)

Michael David is a principal at CompuAid in Santa Monica, California. He has been a consulting staff scientist with Teradata Corp., a senior software designer at Sterling Softwares Answer Division, and has been designing commercial database tools and utilities for over fifteen years.

Bibliographic information