Advanced Standard SQL Dynamic Structured Data Modeling and Hierarchical Processing
Published in March 2013
Book
Hardback
380 pages
978-1-60807-533-1 (ISBN)
Description
Based on the Artech House classic "ANSI SQL Data Modeling and Structure Processing", this expanded and updated book offers database professionals 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 programmers 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. The book shows how to tap the full power of data structure extraction technology and explores previously unknown SQL capabilities for improving performance.
More details
Edition
Unabridged edition
Language
English
Place of publication
Norwood
United States
Target group
Professional and scholarly
Edition type
Unabridged edition
ISBN-13
978-1-60807-533-1 (9781608075331)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
E-Book
01/2013
1st Edition
Artech House
€120.99
Available for download
Persons
Michael M. David is the founder and CTO of Advanced Data Technologies, Inc. He has been a staff scientist and lead XML architect for NCR/Teradata and their representative to the SQLX Group. He has researched, designed, and developed commercial query languages for heterogeneous hierarchical and relational databases for over twenty-five years.
Content
Part I: The Basics of the Relational Join Operation - The Standard Join Operation. Standard SQL Join Types and Their Operation. Natural Joins.; Part II: Outer Join Data Modeling and Structured Processing - Data Structure Review. Outer Join Does Data Modeling.; Part III: New Capabilities Based on Outer Join Data Modeling - Data Structure Extraction (DSE) Technology. Outer Join Advanced Capabilities. Outer Join Optimization. Hierarchical Relational Processor Prototype. Object/Relational Interface. Nonrelational SQL-Based Universal Data Access.; Part IV: Advanced Data Structure Processing Capabilities - Advanced Lower Structured Linking. Dynamic Structure Combining by Joining, Mashups, and Association. Dynamically Increasing Data Value and Flexibility. Variable Data Structure Generation. Semantically Controlled Data Structure Automatic Processing of Remote Dynamic Structured Data.