Description |
1 online resource (xxvi, 379 pages) : illustrations. |
|
text file |
Series |
Artech House computing library
|
|
Artech House computing library.
|
Note |
"This revised and updated edition of Advanced ANSI SQL data modeling and structure processing ..."--Preface. |
Bibliography |
Includes bibliographical references (pages 361-364) and index. |
Summary |
"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 |
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. |
Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
Subject |
SQL (Computer program language)
|
|
SQL (Computer program language) |
|
Data structures (Computer science)
|
|
Data structures (Computer science) |
Genre/Form |
Electronic books.
|
Added Author |
Fesperman, Lee.
|
|
David, Michael M.
Advanced ANSI SQL data modeling and structure processing.
|
Other Form: |
Print version: David, Michael M. Advanced standard SQL dynamic structured data modeling and hierarchical processing. Boston : Artech House, ©2013 9781608075331 1608075338 |
ISBN |
1608075346 (electronic book) |
|
9781608075348 (electronic book) |
|
9781608075331 |
|
1608075338 |
|