
Advanced ANSI/SQL Data Modeling and Structures
Michael M. David(Author)
Artech House Publishers
Published on 1. August 1999
Book
Hardback
266 pages
978-1-58053-038-5 (ISBN)
Description
This volume is a tool for utilizing the ANSI/ISO SQL outer join operation, and a guide to using this operation to perform simple or complex data modelling. It provides a look at the outer join operation, its powerful syntax, and features and capabilities that can be developed based on the operation's data modelling capacity. The author demonstrates how to tap into the power of data structure extraction technology that gathers data structure meta information naturally embedded in ANSI/ISO SQL outer join specifications. He also addresses existing SQL capabilities for improving performance, saving coding time, simplifying design, and reducing debugging time. The book also supplied critical review of the semantics of data structures; tells you how to perform multi-table outer joins and how to combine relational structures with hierarchical structures; and describes how to establish a default database standard or framework for data modelling.
More details
Edition
Unabridged edition
Language
English
Place of publication
Norwood
United States
Target group
Professional and scholarly
Edition type
Unabridged edition
Dimensions
Height: 152 mm
Width: 229 mm
ISBN-13
978-1-58053-038-5 (9781580530385)
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
Person
Michael David is a principal at CompuAid in Santa Monica, California. He has been a consulting staff scientist with Teradata Corp., a senior software designer at Sterling Software's Answer Division, and has been designing commercial database tools and utilities for over fifteen years.
Content
Introduction to relational joints; the SQL-92 join operation; determining SQL-92 join associativity and commutativity; SQL-92 join types and their operation; natural joins; outer join data modelling and structure processing; data structure review; outer join does data modelling; outer join data modelling related capabilities; importance of SQL's inherent data structure processing ability; efficient client/server data structure processing; coding data modelling outer join statements; SQL3 and data modelling; what makes the ANSI outer join unique for data modelling; data structure extraction (DSE) technology; outer join advanced capabilities; outer join optimization; nested relational processing prototype; object relational interface; data modelling outer join generator; advanced lower structure linking; non-relational SQL-based universal data access.