Advanced ANSI SQL Data Modeling and Structure Processing

0.0

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.

0.0

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.