45,30 €*
Versandkostenfrei per Post / DHL
Lieferzeit 1-2 Wochen
Every chapter includes a set of exercises that show how to apply the theoretical ideas in practice, provide additional information, or ask you to prove some simple theoretical result. If you’re a database professional familiar with the relational model, and have more than a passing interest in database design, this book is for you.
Questions this book answers include:
* Why is Heath’s Theorem so important?
* What is The Principle of Orthogonal Design?
* What makes some JDs reducible and others irreducible?
* Why does dependency preservation matter?
* Should data redundancy always be avoided? Can it be?
Databases often stay in production for decades, and careful design is critical for avoiding subtle errors and processing problems over time. If they’re badly designed, the negative impacts can be incredibly widespread. This gentle introduction shows you how to use important theoretical results to create good database designs.
Every chapter includes a set of exercises that show how to apply the theoretical ideas in practice, provide additional information, or ask you to prove some simple theoretical result. If you’re a database professional familiar with the relational model, and have more than a passing interest in database design, this book is for you.
Questions this book answers include:
* Why is Heath’s Theorem so important?
* What is The Principle of Orthogonal Design?
* What makes some JDs reducible and others irreducible?
* Why does dependency preservation matter?
* Should data redundancy always be avoided? Can it be?
Databases often stay in production for decades, and careful design is critical for avoiding subtle errors and processing problems over time. If they’re badly designed, the negative impacts can be incredibly widespread. This gentle introduction shows you how to use important theoretical results to create good database designs.
C.J. Date has a stature that is unique within the database industry. C.J. is a prolific writer, and is well-known for his best-selling textbook: An Introduction to Database Systems (Addison Wesley). C.J. is an exceptionally clear-thinking writer who can lay out principles and theory in a way easily understood by his audience.
- Dedication
- Preface
- SETTING THE SCENE
- Chapter 1: Preliminaries
- Chapter 2: Prerequisites
- FUNCTIONAL DEPENDENCIES, BOYCE/CODD NORMAL FORM, AND RELATED MATTERS
- Chapter 3: Normalization: Some Generalities
- Chapter 4: FDs and BCNF (Informal)
- Chapter 5: FDs and BCNF (Formal)
- Chapter 6: Preserving FDs
- Chapter 7: FD Axiomatization
- Chapter 8: Denormalization
- JOIN DEPENDENCIES, FIFTH NORMAL FORM, AND RELATED MATTERS
- Chapter 9: JDs and 5NF (Informal)
- Chapter 10: JDs and 5NF (Formal)
- Chapter 11: Implicit Dependencies
- Chapter 12: MVDs and 4NF
- Chapter 13: Additional Normal Forms
- ORTHOGONALITY
- Chapter 14: The Principle of Orthogonal Design
- REDUNDANCY
- Chapter 15: We Need More Science
- APPENDIXES
- Primary Keys Are Nice but Not Essential
- Redundancy Revisited
- Historical Notes
- Answers to Exercises
Medium: | Taschenbuch |
---|---|
Inhalt: |
XIII
260 S. |
ISBN-13: | 9781449328016 |
ISBN-10: | 1449328016 |
Sprache: | Englisch |
Einband: | Kartoniert / Broschiert |
Autor: | Date, Chris J |
Hersteller: |
O'Reilly Media
O'Reilly Media, Inc. |
Maße: | 234 x 179 x 25 mm |
Von/Mit: | Chris J Date |
Erscheinungsdatum: | 22.05.2012 |
Gewicht: | 0,454 kg |
C.J. Date has a stature that is unique within the database industry. C.J. is a prolific writer, and is well-known for his best-selling textbook: An Introduction to Database Systems (Addison Wesley). C.J. is an exceptionally clear-thinking writer who can lay out principles and theory in a way easily understood by his audience.
- Dedication
- Preface
- SETTING THE SCENE
- Chapter 1: Preliminaries
- Chapter 2: Prerequisites
- FUNCTIONAL DEPENDENCIES, BOYCE/CODD NORMAL FORM, AND RELATED MATTERS
- Chapter 3: Normalization: Some Generalities
- Chapter 4: FDs and BCNF (Informal)
- Chapter 5: FDs and BCNF (Formal)
- Chapter 6: Preserving FDs
- Chapter 7: FD Axiomatization
- Chapter 8: Denormalization
- JOIN DEPENDENCIES, FIFTH NORMAL FORM, AND RELATED MATTERS
- Chapter 9: JDs and 5NF (Informal)
- Chapter 10: JDs and 5NF (Formal)
- Chapter 11: Implicit Dependencies
- Chapter 12: MVDs and 4NF
- Chapter 13: Additional Normal Forms
- ORTHOGONALITY
- Chapter 14: The Principle of Orthogonal Design
- REDUNDANCY
- Chapter 15: We Need More Science
- APPENDIXES
- Primary Keys Are Nice but Not Essential
- Redundancy Revisited
- Historical Notes
- Answers to Exercises
Medium: | Taschenbuch |
---|---|
Inhalt: |
XIII
260 S. |
ISBN-13: | 9781449328016 |
ISBN-10: | 1449328016 |
Sprache: | Englisch |
Einband: | Kartoniert / Broschiert |
Autor: | Date, Chris J |
Hersteller: |
O'Reilly Media
O'Reilly Media, Inc. |
Maße: | 234 x 179 x 25 mm |
Von/Mit: | Chris J Date |
Erscheinungsdatum: | 22.05.2012 |
Gewicht: | 0,454 kg |