Based on the Artech House classic "ANSI SQL Data Modeling and Structure Processing", this expanded and updated book offers database professionals an essential tool for utilizing the ANSI SQL outer join operation to perform simple or complex hierarchical data modeling and structure processing. The book provides programmers with a comprehensive review of the outer join operation, its powerful syntax and semantics, and new features and capabilities. This revised resource introduces several important new concepts such as relationship and hierarchical integration at the hierarchical processing level, multipath hierarchical automatic XML query processing, dynamic structured data processing using automatic metadata maintenance, and advanced data transformations. The book shows how to tap the full power of data structure extraction technology and explores previously unknown SQL capabilities for improving performance.
Michael M. David is the founder and CTO of Advanced Data Technologies, Inc. He has been a staff scientist and lead XML architect for NCR/Teradata and their representative to the SQLX Group. He has researched, designed, and developed commercial query languages for heterogeneous hierarchical and relational databases for over twenty-five years.
Part I: The Basics of the Relational Join Operation - The Standard Join Operation. Standard SQL Join Types and Their Operation. Natural Joins.; Part II: Outer Join Data Modeling and Structured Processing - Data Structure Review. Outer Join Does Data Modeling.; Part III: New Capabilities Based on Outer Join Data Modeling - Data Structure Extraction (DSE) Technology. Outer Join Advanced Capabilities. Outer Join Optimization. Hierarchical Relational Processor Prototype. Object/Relational Interface. Nonrelational SQL-Based Universal Data Access.; Part IV: Advanced Data Structure Processing Capabilities - Advanced Lower Structured Linking. Dynamic Structure Combining by Joining, Mashups, and Association. Dynamically Increasing Data Value and Flexibility. Variable Data Structure Generation. Semantically Controlled Data Structure Automatic Processing of Remote Dynamic Structured Data.