04333nam 2200637 450 991079227970332120230126210734.01-60807-534-6(CKB)2560000000147667(OCoLC)880437604(CaPaEBR)ebrary10857831(SSID)ssj0001182080(PQKBManifestationID)12532383(PQKBTitleCode)TC0001182080(PQKBWorkID)11147214(PQKB)11068804(Au-PeEL)EBL3002029(CaPaEBR)ebr10857831(OCoLC)929147000(CaBNVSL)mat09101036(IEEE)9101036(MiAaPQ)EBC3002029(EXLCZ)99256000000014766720200730d2013 uy engurcnu||||||||txtccrAdvanced standard SQL dynamic structured data modeling and hierarchical processing /Michael M. David, Lee FespermanBoston :Artech House,©2013.[Piscataqay, New Jersey] :IEEE Xplore,[2013]1 online resource (406 p.) Artech House computing library"This revised and updated edition of Advanced ANSI SQL data modeling and structure processing ..."--Pref.1-60807-533-8 Includes bibliographical references (pages 361-364) and index.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."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."Artech House computing library.SQL (Computer program language)Data structures (Computer science)SQL (Computer program language)Data structures (Computer science)005.7565David Michael M.947257Fesperman Lee1575068David Michael M947257CaBNVSLCaBNVSLCaBNVSLBOOK9910792279703321Advanced standard SQL dynamic structured data modeling and hierarchical processing3851750UNINA