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.