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.
Advanced ANSI SQL Data Modeling and Structure Processing
and over one million other books are available for Amazon Kindle.
Learn more
FREE Two-Day Shipping for Students. Learn more |
| |||||||||||||||
Book Description
Editorial Reviews
About the Author
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.
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
2 of 7 people found the following review helpful:
4.0 out of 5 stars
A Must have for all serious data modellers,
This review is from: Advanced ANSI SQL Data Modeling and Structure Processing (Hardcover)
Ever since i read this book first in a library in Atlanta, I coudlnt hold myself but buy this book immediately the following week.Excellent description on data modelling, and has clear diagrams that are easy to understand. a must have for all serious sql data modelling guys and programmers..
0 of 5 people found the following review helpful:
4.0 out of 5 stars
Excellent book for data modelling,
This review is from: Advanced ANSI SQL Data Modeling and Structure Processing (Hardcover)
I got a chance to read this book from an library in atlanta, and guess what? The next week I went and bought this book. Has a very systematic approach, with good diagrams. A must for all serious data modellers and SQL programmers
Share your thoughts with other customers: Create your own review
|
|
Inside This Book
(learn more)
First Sentence:
In relational databases, data is stored in two-dimensional tables. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
table join order, structure meta information, outer join specification, join table order, object relational interface, sibling legs, data access frameworks, natural join types, process complex data structures, structure processing capabilities, substructure views, outer join views, structured data record, lower level linking, outer join statement, structure processing capability, outer join operation, intersecting data, model hierarchical data structures, link criteria, natural inner join, table reordering, clause filtering, different join types, optimization menu Key Phrases - Capitalized Phrases (CAPs): (learn more)
Null Null, Department Employee, Data Structure Review, More About Outer Join Data Modeling, Outer Join Advanced Capabilities, Ralph Mark, Dependent Figure, Mike Ron, Outer Join Data Modeling-Related Capabilities, Parent Box Name, Don Jane, Emp Prod, Department Department, Emp Occurs, Employee Join Table, Jason Active Mike, Jim Mary, Mary Dpnd Count, Mike Jim, Set Current Segment Definition New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
In relational databases, data is stored in two-dimensional tables. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
table join order, structure meta information, outer join specification, join table order, object relational interface, sibling legs, data access frameworks, natural join types, process complex data structures, structure processing capabilities, substructure views, outer join views, structured data record, lower level linking, outer join statement, structure processing capability, outer join operation, intersecting data, model hierarchical data structures, link criteria, natural inner join, table reordering, clause filtering, different join types, optimization menu Key Phrases - Capitalized Phrases (CAPs): (learn more)
Null Null, Department Employee, Data Structure Review, More About Outer Join Data Modeling, Outer Join Advanced Capabilities, Ralph Mark, Dependent Figure, Mike Ron, Outer Join Data Modeling-Related Capabilities, Parent Box Name, Don Jane, Emp Prod, Department Department, Emp Occurs, Employee Join Table, Jason Active Mike, Jim Mary, Mary Dpnd Count, Mike Jim, Set Current Segment Definition New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Citations (learn more)
This book cites 22
books:
See all 22 books this book cites
42
books
cite this book:
See all 42 books citing this book
- Distributed and Multi-Database Systems (The Artech House Computer Science Library) by Angelo R Bobak in Back Matter
- Metadata Management for Information Control and Business Success (Artech House Computing Library) by Guy V. Tozer in Back Matter
- Practical Guide to Software Quality Management (Artech House Computing Library) by John W. Horch in Back Matter
- Secure Electronic Transactions Introduction and Technical Reference (Computing Library) by Larry Loeb in Back Matter
- Data Quality For The Information Age (Artech House Computer Science Library) by Thomas C. Redman in Back Matter
See all 22 books this book cites
- Non-Repudiation in Electronic Commerce by Jianying Zhou in Back Matter
- How to Run Successful Projects in Web Time (Computing Library S.) by Fergus O'Connell in Back Matter
- Role-Based Access Control by David F. Ferraiolo in Back Matter
- A Guide to Software Configuration Management (Artech House Computer Library) by Alexis Leon in Back Matter
- Building Reliable Component-Based Software Systems by Ivica Crnkovic in Back Matter
See all 42 books citing this book
Books on Related Topics
(learn more)
|
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product).
|
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
Listmania!
So You'd Like to...
Look for Similar Items by Category
- Books > Computers & Technology > Computer Science > Modeling & Simulation
- Books > Computers & Technology > Databases > SQL
- Books > Computers & Technology > Programming > Algorithms > Data Structures
- Books > Computers & Technology > Programming > Languages & Tools
- Books > Computers & Technology > Programming > Software Design, Testing & Engineering
- Books > Computers & Technology > Software
- Books > New & Used Textbooks > Computer Science
