Advanced standard SQL dynamic structured data modeling and hierarchical processing / Michael M. David, Lee Fesperman.

"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 yo...

Full description

Saved in:
Bibliographic Details
Main Author: David, Michael M.
Other Authors: Fesperman, Lee
Format: eBook
Language:English
Published: Boston : Artech House, ©2013.
©2013
Series:Artech House computing library.
Subjects:
Online Access:Click for online access

MARC

LEADER 00000cam a2200000 a 4500
001 ocn877850592
003 OCoLC
005 20240809213013.0
006 m o d
007 cr |n|||||||||
008 140421s2013 maua ob 001 0 eng d
040 |a YDXCP  |b eng  |e pn  |c YDXCP  |d OCLCO  |d N$T  |d B24X7  |d COO  |d OCLCF  |d OCLCQ  |d E7B  |d STF  |d EBLCP  |d OCLCQ  |d DEBSZ  |d OCLCQ  |d AGLDB  |d MOR  |d CCO  |d PIFAG  |d ZCU  |d LIV  |d MERUC  |d OCLCQ  |d U3W  |d VTS  |d COCUF  |d NRAMU  |d ICG  |d OCLCQ  |d INT  |d VT2  |d OCLCQ  |d WYU  |d TKN  |d OCLCQ  |d DKC  |d AU@  |d OCLCQ  |d M8D  |d UKAHL  |d OCLCQ  |d K6U  |d OCLCO  |d OCLCQ  |d OCLCO  |d OCLCL  |d UEJ  |d OCLCQ 
016 7 |a 016417355  |2 Uk 
019 |a 876591337  |a 880437604  |a 889314084  |a 923567263  |a 929147000  |a 1055362610  |a 1066517108  |a 1081283989 
020 |a 1608075346  |q (electronic bk.) 
020 |a 9781608075348  |q (electronic bk.) 
020 |z 9781608075331 
020 |z 1608075338 
035 |a (OCoLC)877850592  |z (OCoLC)876591337  |z (OCoLC)880437604  |z (OCoLC)889314084  |z (OCoLC)923567263  |z (OCoLC)929147000  |z (OCoLC)1055362610  |z (OCoLC)1066517108  |z (OCoLC)1081283989 
050 4 |a QA76.73.S67  |b D38 2013 
072 7 |a COM  |x 051170  |2 bisacsh 
049 |a HCDD 
100 1 |a David, Michael M. 
245 1 0 |a Advanced standard SQL dynamic structured data modeling and hierarchical processing /  |c Michael M. David, Lee Fesperman. 
260 |a Boston :  |b Artech House,  |c ©2013. 
264 4 |c ©2013 
300 |a 1 online resource (xxvi, 379 pages) :  |b illustrations 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
490 1 |a Artech House computing library 
500 |a "This revised and updated edition of Advanced ANSI SQL data modeling and structure processing ..."--Preface 
504 |a Includes bibliographical references (pages 361-364) and index. 
588 0 |a Print version record. 
520 |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." 
505 0 |a 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. 
505 8 |a 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. 
650 0 |a SQL (Computer program language) 
650 0 |a Data structures (Computer science) 
650 7 |a COMPUTERS  |x Programming Languages  |x SQL.  |2 bisacsh 
650 7 |a Data structures (Computer science)  |2 fast 
650 7 |a SQL (Computer program language)  |2 fast 
700 1 |a Fesperman, Lee. 
700 1 |a David, Michael M.  |t Advanced ANSI SQL data modeling and structure processing. 
758 |i has work:  |a Advanced standard SQL dynamic structured data modeling and hierarchical processing (Text)  |1 https://id.oclc.org/worldcat/entity/E39PCH4db8jRVtT6MdThb7gMyd  |4 https://id.oclc.org/worldcat/ontology/hasWork 
776 0 8 |i Print version:  |a David, Michael M.  |t Advanced standard SQL dynamic structured data modeling and hierarchical processing.  |d Boston : Artech House, ©2013  |z 9781608075331  |z 1608075338 
830 0 |a Artech House computing library. 
856 4 0 |u https://ebookcentral.proquest.com/lib/holycrosscollege-ebooks/detail.action?docID=3002029  |y Click for online access 
903 |a EBC-AC 
994 |a 92  |b HCD