Based on the Artech House classic ANSI SQL Data Modeling and Structure Processing, this expanded and updated book offers you 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 you 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.
Featuring more than 230 illustrations, the book shows you how to tap the full power of data structure extraction technology that gathers data structure meta information naturally embedded in ANSI SQL specifications. You discover existing, but previously unknown, SQL capabilities for improving performance. The book explains how to perform multitable outer joins and combine relational structures with hierarchical structures. Moreover you learn how to establish a default database standard for hierarchical data modeling and structure processing.
Contents: Part I: The Basics of the Relational Join Operation Relational Join Introduction. 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. Outer Join Modeling Related Capabilities. More about Outer Join 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. Automatic Multipath Hierarchical Structure Operations. Variable Data Structure Generation. Semantically Controlled Data Structure Transformations. Automatic Processing of Remote Dynamic Structured Data. SQL Hierarchical XML Processor Operation. SQL Hierarchical XML Processor Examples.