Ebooks

Applied Mathematics for Database Professionals~tqw~ darksiderg

• 
• 
• Rate this torrent +  |  -

Torrent info

Torrent Files List

Torrent description

*******************************************************************************
Applied Mathematics for Database Professionals
*******************************************************************************

-------------------------------------------------------------------------------
General Information
-------------------------------------------------------------------------------
Type.................: Ebook
Part Size............: 2,987,704 bytes




-------------------------------------------------------------------------------
Post Information
-------------------------------------------------------------------------------
Posted by............: ~tqw~

-------------------------------------------------------------------------------
Release Notes
-------------------------------------------------------------------------------
Relational databases hold data, right? They indeed do, 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 technology's 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 you'll gain from this book. You'll learn to

* 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.

The math that you 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 what's in thisbook will take
your mastery of relational technology to heights you may not have thought
possible.

Table Of Contents

Foreword xv
About the Authors xvii
About the Technical Reviewers xix
Acknowledgments xxi
Preface xxiii
Introduction xxv
PART 1 The Mathematics
CHAPTER 1 Logic: Introduction 3
CHAPTER 2 Set Theory: Introduction 23
CHAPTER 3 Some More Logic 47
CHAPTER 4 Relations and Functions 67
PART 2 The Application
CHAPTER 5 Tables and Database States 91
CHAPTER 6 Tuple, Table, and Database Predicates 117
CHAPTER 7 Specifying Database Designs 139
CHAPTER 8 Specifying State Transition Constraints 185
CHAPTER 9 Data Retrieval 199
CHAPTER 10 Data Manipulation 221
PART 3 The Implementation
CHAPTER 11 Implementing Database Designs in Oracl 241
CHAPTER 12 Summary and Conclusions 305
PART 4 Appendixes
APPENDIX A Formal Definition of Example Database 311
APPENDIX B Symbols 333
APPENDIX C Bibliography 335
APPENDIX D Nulls and Three (or More) Valued Logic 337
APPENDIX E Answers to Selected Exercises 347
INDEX 367

Product Details

* ISBN: 1590597451
* ISBN-13: 9781590597453
* Format: Hardcover, 408pp
* Publisher: Apress L. P.
* Pub. Date: May 2007

-------------------------------------------------------------------------------
Install Notes
-------------------------------------------------------------------------------
Adobe Acrobat Reader

related torrents