Book description
Relational databases hold data, right? They do indeed, but to think of a database as nothing more than a container for data is to miss out on the profound power that underlies relational technology. A far more powerful way of thinking lies in relational technologys foundation in the mathematical disciplines of logic and set theory.
Databases contain truths or propositions describing some area of interest such as a business. Those truths are organized into sets. Operations from logic and set theory can be applied to existing sets of truths to derive new sets of truths. Applied Mathematics for Database Professionals introduces you to this way of thinking, to the logic and set theory that underlies relational database technology. All this may sound abstract now, but there are profound benefits from the deeper understanding youll gain from this book.
The math that you'll learn in this book will put you above the level of understanding of most database professionals today. You'll better understand the technology and be able to apply it more effectively. You'll avoid data anomalies like redundancy and inconsistency. Understanding whats in this book will take your mastery of relational technology to heights you may not have thought possible.
This book is reviewed and endorsed by C. J. Date and features a foreword by the same.
Table of contents
 Coverpage
 Titlepage
 Copyright
 Dedication
 Contents at a Glance
 Contents
 Foreword
 About the Authors
 About the Technical Reviewers
 Acknowledgments
 Preface
 Introduction

Part 1: The Mathematics
 Chapter 1: Logic: Introduction
 Chapter 2: Set Theory: Introduction
 Chapter 3: Some More Logic
 Chapter 4: Relations and Functions

Part 2: The Application
 Chapter 5: Tables and Database States
 Chapter 6: Tuple, Table, and Database Predicates
 Chapter 7: Specifying Database Designs
 Chapter 8: Specifying State Transition Constraints
 Chapter 9: Data Retrieval
 Chapter 10: Data Manipulation

Part 3: The Implementation

Chapter 11: Implementing Database Designs in Oracle
 Introduction
 WindowonData Applications
 Implementing Data Integrity Code
 Implementing Table Structures
 Implementing Attribute Constraints
 Implementing Tuple Constraints
 Table Constraint Implementation Issues
 Implementing Table Constraints
 Implementing Database Constraints
 Implementing Transition Constraints
 Bringing Deferred Checking into the Picture
 The RuleGen Framework
 Chapter Summary
 Chapter 12: Summary and Conclusions

Chapter 11: Implementing Database Designs in Oracle

Part 4: Appendixes
 Appendix A: Formal Definition of Example Database
 Appendix B: Symbols

Appendix C: Bibliography
 Original Writings That Introduce the Methodology Demonstrated in This Book
 Recommended Reading in the Area of the Underlying Mathematical Theories
 Seminal Writings That Introduce the General Theory of Data Management
 Recommended Reading on Relational Database Management
 Research Papers on Implementing Data Integrity Constraints and Related Subjects
 Previous Related Writings of the Authors
 Appendix D: Nulls and Three (or More) Valued Logic
 Appendix E: Answers to Selected Exercises
 Index
Product information
 Title: Applied Mathematics for Database Professionals
 Author(s):
 Release date: June 2016
 Publisher(s): Apress
 ISBN: 9781430203483
You might also like
book
Essential Algorithms, 2nd Edition
A friendly introduction to the most useful algorithms written in simple, intuitive English The revised and …
book
Good Math
Mathematics is beautifuland it can be fun and exciting as well as practical. Good Math is …
book
Art of Computer Programming, The: Volume 1: Fundamental Algorithms
&>The bible of all fundamental algorithms and the work that taught many of today's software developers …
book
High Performance Python, 2nd Edition
Your Python code may run correctly, but you need it to run faster. Updated for Python …