This 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 studies the outer join operation, its powerful syntax, and features and capabilities that can be developed.

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.

Introduction to relational joints
the SQL-92 join operation
determining SQL-92 join associativity and commutativity
SQL-92 join types and their operation
natural joins
outer join data modelling and structure processing
data structure review
outer join does data modelling
outer join data modelling related capabilities
importance of SQL's inherent data structure processing ability
efficient client/server data structure processing
coding data modelling outer join statements
SQL3 and data modelling
what makes the ANSI outer join unique for data modelling
data structure extraction (DSE) technology
outer join advanced capabilities
outer join optimization
nested relational processing prototype
object relational interface
data modelling outer join generator
advanced lower structure linking
non-relational SQL-based universal data access.