Advanced standard SQL dynamic structured data modeling and hierarchical processing / Michael M. David, Lee Fesperman.Material type: TextSeries: Artech House computing libraryCopyright date: ©2013Description: 1 online resource (xxvi, 379 pages) : illustrationsContent type: text Media type: computer Carrier type: online resourceISBN: 1608075346; 9781608075348Subject(s): SQL (Computer program language) | Data structures (Computer science) | COMPUTERS -- Programming Languages -- SQL | Data structures (Computer science) | SQL (Computer program language)Genre/Form: Electronic books. | Electronic books. Additional physical formats: Print version:: Advanced standard SQL dynamic structured data modeling and hierarchical processing.DDC classification: 005.75/65 LOC classification: QA76.73.S67 | D38 2013Online resources: Click here to access online
|Item type||Current library||Collection||Call number||Status||Date due||Barcode||Item holds|
"This revised and updated edition of Advanced ANSI SQL data modeling and structure processing ..."--Preface.
Includes bibliographical references (pages 361-364) and index.
Print version record.
"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."
Advanced Standard SQL Dynamic Structured Data Modeling and Hierarchical Processing; Contents; Preface; Introduction; Part I: The Basics of the RelationalJoin Operation; 1 Relational Join Introduction; 1.1 Standard Inner Join Review; 1.2 Problems with Relational Join Processing; 1.3 Outer Join Review; 1.4 Problems with Previous Outer Join Syntax; 1.5 Conclusion; 2 The Standard SQL Join Operation; 2.1 Standard SQL Join Syntax; 2.2 Standard SQL Join Operation; 2.3 Standard SQL Join Does Not Follow the Cartesian Product Model; 2.4 Determining Standard SQL Join Associativity and Commutativity.
2.5 What Outer Join Commutativity Is2.6 What Outer Join Associativity Is; 2.7 Hierarchictivity in Addition to Associativity and Commutativity; 2.8 Conclusion; 3 Standard SQL Join Types and Their Operation; 3.1 FULL Outer Join; 3.2 One-Sided Outer Join; 3.3 INNER Join; 3.4 CROSS Join; 3.5 UNION Join; 3.6 Intermixing Join Types; 3.7 Conclusion; 64.