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
- Window-on-Data 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
Business Mathematics
Chapters and topics have been organized in a reader-friendly manner. Ample number of solved examples and …
book
A First Course in Applied Mathematics
This book details how applied mathematics involves predictions, interpretations, analysis, and mathematical modeling to solve real-world …
book
Beginning Mathematica and Wolfram for Data Science: Applications in Data Analysis, Machine Learning, and Neural Networks
Enhance your data science programming and analysis with the Wolfram programming language and Mathematica, an applied …
book
Stack Frames: A Look From Inside
Teaches you exactly how program memory content and organization is vital for computer security, especially Unix-like …