Applied Mathematics for Database Professionals

By Lex deHaan , Toon Koppelaars

  • eBook Price: $45.99
  • Print Book Price: $64.99
Buy eBook Buy Print Book

Applied Mathematics for Database Professionals Cover Image

Applied Mathematics for Database Professionals introduces you to the logic and set theory that underlies relational database technology.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-59059-745-3
  • 376 Pages
  • User Level: Beginner to Advanced
  • Publication Date: June 18, 2007
  • Available eBook Formats: PDF

Related Titles

  • SQL Server T-SQL Recipes
  • Expert T-SQL Window Functions in SQL Server
  • Microsoft Azure
  • Introducing SQL Server
  • Expert SQL Server in-Memory OLTP
  • Extending SSIS with .NET Scripting
  • Pro PowerShell for Database Developers
  • Pro SQL Server Wait Statistics
  • Pro Oracle Fusion Applications
  • Expert Oracle Exadata
Full 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.

What you’ll learn

  • Become a better database designer. You'll make fewer mistakes, and your designs will be more flexible in response to changing data needs.
  • Use the expressive power of mathematics to precisely specify designs and business rules.
  • Communicate effectively about design using the universal language of mathematics.
  • Develop and write complex SQL statements with confidence.
  • Avoid pitfalls and problems from common relational bugaboos such as null values and duplicate rows.

Table of Contents

Table of Contents

  1. Logic: Introduction
  2. Set Theory: Introduction
  3. Some More Logic
  4. Relations and Functions
  5. Tables and Database States
  6. Tuple, Table, and Database Predicates
  7. Specifying Database Designs
  8. Specifying State Transition Constraints
  9. Data Retrieval
  10. Data Manipulation
  11. Implementing Database Designs in Oracle
  12. Summary and Conclusions
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

Please Login to submit errata.

No errata are currently published

Best-Sellers

    1. Expert T-SQL Window Functions in SQL Server

      $17.99

      View Details

    2. Pro T-SQL Programmer\'s Guide

      $41.99

      View Details

    3. The Definitive Guide to MongoDB

      $34.99

      View Details

    4. Beginning Apache Cassandra Development

      $34.99

      View Details