Database in depth relational theory for practitioners
This book sheds light on the principles behind the relational model, which is fundamental to all database-backed applications--and, consequently, most of the work that goes on in the computing world today. Database in Depth: The Relational Model for Practitioners goes beyond the hype and gets to t...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Beijing ; Sebastopol, California :
O'Reilly
[2005]
|
| Edición: | 1st edition |
| Colección: | Theory in practice (Sebastopol, Calif.)
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627083706719 |
Tabla de Contenidos:
- Table of Contents; Foreword; Preface; What Makes This Book Different?; Further Preliminaries; Conventions Used in This Book; Using Code Examples; Safari Enabled; Comments and Questions; Acknowledgments; Introduction; A Remark on Terminology; Principles, Not Products; A Review of the Original Model; Structural Features; Integrity Features; Manipulative Features; The Running Example; Model Versus Implementation; Properties of Relations; Relations Versus Relvars; Values Versus Variables; Summary; Exercises; Relations Versus Types; Domain-Constrained Comparisons; Data Value Atomicity
- So What's a Type?Scalar Versus Nonscalar Types; Summary; Exercises; Tuples and Relations; What's a Tuple?; Some Important Consequences; What's a Relation?; Further Important Consequences; Why Duplicate Tuples Are Prohibited; Why Nulls Are Prohibited; TABLE_DUM and TABLE_DEE; Summary; Exercises; Relation Variables; Updating Is Set-at-a-Time; More on Candidate Keys; More on Foreign Keys; More on Views; View Retrievals; View Updates; Miscellaneous Points; Relvars and Predicates; Relational Expressions; More on Relations Versus Types; Summary; Exercises; Relational Algebra; More on Closure
- The Original OperatorsRestrict; Project; Join; Intersect; Union; Difference; Cartesian Product; Divide; Which Operators Are Primitive?; Evaluating SQL Expressions; Extend and Summarize; Extend; Summarize; Group and Ungroup; Expression Transformation; Relational Comparisons; More on Relational Assignment; The ORDER BY Operator; Summary; Exercises; Integrity Constraints; Type Constraints; Selectors and THE_ Operators; Type Constraints Continued; Database Constraints; Example 1; Example 2; Example 3; Example 4; Example 5; Transactions; Why Database Constraint Checking Must BeImmediate
- But Doesn't Some Checking Have to Be Deferred?Multiple Assignment; Constraints and Predicates; Miscellaneous Issues; Summary; Exercises; Database Design Theory; The Place of Design Theory; Functional Dependencies and Boyce/Codd Normal Form; Nonloss Decomposition; But Isn't It All Just Common Sense?; 1NF, 2NF, 3NF; Join Dependencies and Fifth Normal Form; The Significance of 5NF; More on 5NF; Two Cheers for Normalization; Orthogonality; Some Remarks on Physical Design; Summary; Exercises; What Is the Relational Model?; The Relational Model Defined; Scalar Types; Relation Types
- Relation VariablesRelational Assignment; Relational Operators; Objectives of the Relational Model; Some Database Principles; The Relational Model Versus Others; What Remains to Be Done?; Implementation; Foundations; Higher-Level Abstractions; Higher-Level Interfaces; So What About SQL?; Summary; Exercises; A Little Bit of Logic; Propositions; Predicates; Quantification; Free and Bound Variables; More on Quantification; We Don't Need Both Quantifiers; Empty Ranges; Defining EXISTS and FORALL; Other Kinds of Quantifiers; Database Constraints; Queries; Some Equivalences; Summary
- Suggestions for Further Reading
