 ISBN 1-58053-038-9
Michael M. David
266 pages.
Copyright 1999.
Description
This new book is an essential tool for utilizing the ANSI/ISO SQL outer join operation, and an indispensable guide to using this operation to perform simple or complex data modeling. It provides a comprehensive look at the outer join operation, its powerful syntax, and new features and capabilities that can be developed based on the operation's data modeling capacity.
With Advanced ANSI SQL Data Modeling and Structure Processing you're able to tap the full power of data structure extraction technology that gathers data structure meta information naturally embedded in ANSI/ISO SQL outer join specifications. Plus, you learn of existing, but previously unknown SQL capabilities for improving performance, saving coding time, simplifying design, and reducing debugging time.
This book also:
This is an essential resource for DB administrators, designers, and programmers working with SQL. It includes a glossary of SQL terms, and figures and database views to help you approach and simplify real-world challenges of SQL.
Table of Contents
Introduction to Relational Joins. The SQL-92 Join Operation. Determining SQL-92 Join Associativity and Commutativity. SQL-92 Join Types and Their Operation. Natural Joins. Outer Join Data Modeling and Structure Processing. Data Structure Review. Outer Join Does Data Modeling. Outer Join Data Modeling Related Capabilities. Importance of SQL's Inherent Data Structure Processing Ability. Efficient Client/Server Data Structure Processing. Coding Data Modeling Outer Join Statements. SQL3 and Data Modeling. What Makes the ANSI Outer Join Unique for Data Modeling. Data Structure Extraction (DSE) Technology. Outer Join Advanced Capabilities. Outer Join Optimization. Nested Relational Processing Prototype. Object Relational Interface. Data Modeling Outer Join Generator. Advanced Lower Structure Linking. Non-Relational SQL-Based Universal Data Access.
Author Bio
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 Software's Answer Division, and has been designing commercial database tools and utilities for over fifteen years.
Sample Chapter
 Click here to see a sample chapter of this title.
Related Titles
Advanced Database Technology and Design ; Mario Piattini, Oscar Díaz, Editors
Multimedia Database Management Systems ; Guojun Lu
Data Modeling and Design for Today's Architectures ; Angelo R. Bobak
Distributed and Multi-Database Systems ; Angelo R. Bobak |
