| |
|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9910814780503321 |
|
|
Autore |
David Michael M. |
|
|
Titolo |
Advanced standard SQL dynamic structured data modeling and hierarchical processing / / Michael M. David, Lee Fesperman |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Boston : , : Artech House, , ©2013 |
|
[Piscataqay, New Jersey] : , : IEEE Xplore, , [2013] |
|
|
|
|
|
|
|
|
|
ISBN |
|
|
|
|
|
|
Descrizione fisica |
|
1 online resource (406 p.) |
|
|
|
|
|
|
Collana |
|
Artech House computing library |
|
|
|
|
|
|
Altri autori (Persone) |
|
FespermanLee |
DavidMichael M |
|
|
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
SQL (Computer program language) |
Data structures (Computer science) |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
"This revised and updated edition of Advanced ANSI SQL data modeling and structure processing ..."--Pref. |
|
|
|
|
|
|
|
|
Nota di bibliografia |
|
Includes bibliographical references (pages 361-364) and index. |
|
|
|
|
|
|
Nota di contenuto |
|
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. |
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. |
|
|
|
|
|
|
|
|
Sommario/riassunto |
|
"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." |
|
|
|
|
|
|
2. |
Record Nr. |
UNICAMPANIAVAN00113775 |
|
|
Autore |
Quirk, Thomas J. |
|
|
Titolo |
Excel 2013 for engineering statistics : a guide to solving practical problems / Thomas J. Quirk |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
|
|
|
|
Titolo uniforme |
Excel 2013 for engineering statistics : a guide to solving practical problems |
|
|
|
|
|
|
|
Descrizione fisica |
|
XV, 248 p. : ill. ; 24 cm |
|
|
|
|
|
|
Soggetti |
|
62-XX - Statistics [MSC 2020] |
62P25 - Applications of statistics to social sciences [MSC 2020] |
97-XX - Mathematics education [MSC 2020] |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Nota di contenuto |
|
This is the first book to show the capabilities of Microsoft Excel to teach engineering statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical engineering problems. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or |
|
|
|
|
|
|
|
|
|
|
if you are wary of computers, this is the right book for you.
Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in engineering courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2013 for Engineering Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work.
Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand engineering problems. Practice problems are provided at the end of each chapter with their solutions in an Appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned. |
|
|
|
|
|
| |