
Database in Depth
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions

Content
- Intro
- 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 Operators
- Restrict
- 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 Be Immediate
- 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 Variables
- Relational 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
- Index
System requirements
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.