LEADER 04333nam 2200637 450 001 9910792279703321 005 20230126210734.0 010 $a1-60807-534-6 035 $a(CKB)2560000000147667 035 $a(OCoLC)880437604 035 $a(CaPaEBR)ebrary10857831 035 $a(SSID)ssj0001182080 035 $a(PQKBManifestationID)12532383 035 $a(PQKBTitleCode)TC0001182080 035 $a(PQKBWorkID)11147214 035 $a(PQKB)11068804 035 $a(Au-PeEL)EBL3002029 035 $a(CaPaEBR)ebr10857831 035 $a(OCoLC)929147000 035 $a(CaBNVSL)mat09101036 035 $a(IEEE)9101036 035 $a(MiAaPQ)EBC3002029 035 $a(EXLCZ)992560000000147667 100 $a20200730d2013 uy 101 0 $aeng 135 $aurcnu|||||||| 181 $ctxt 182 $cc 183 $acr 200 10$aAdvanced standard SQL dynamic structured data modeling and hierarchical processing /$fMichael M. David, Lee Fesperman 210 1$aBoston :$cArtech House,$dİ2013. 210 2$a[Piscataqay, New Jersey] :$cIEEE Xplore,$d[2013] 215 $a1 online resource (406 p.) 225 1 $aArtech House computing library 300 $a"This revised and updated edition of Advanced ANSI SQL data modeling and structure processing ..."--Pref. 311 $a1-60807-533-8 320 $aIncludes bibliographical references (pages 361-364) and index. 327 $aAdvanced 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. 327 $a2.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. 330 $a"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." 410 0$aArtech House computing library. 606 $aSQL (Computer program language) 606 $aData structures (Computer science) 615 0$aSQL (Computer program language) 615 0$aData structures (Computer science) 676 $a005.7565 700 $aDavid$b Michael M.$0947257 701 $aFesperman$b Lee$01575068 701 $aDavid$b Michael M$0947257 801 0$bCaBNVSL 801 1$bCaBNVSL 801 2$bCaBNVSL 906 $aBOOK 912 $a9910792279703321 996 $aAdvanced standard SQL dynamic structured data modeling and hierarchical processing$93851750 997 $aUNINA