Comments:
*******************************************************************************<br />
Applied Mathematics for Database Professionals<br />
*******************************************************************************<br />
<br />
-------------------------------------------------------------------------------<br />
General Information<br />
-------------------------------------------------------------------------------<br />
Type.................: Ebook<br />
Part Size............: 2,987,704 bytes<br />
<br />
<br />
<br />
<br />
-------------------------------------------------------------------------------<br />
Post Information<br />
-------------------------------------------------------------------------------<br />
Posted by............: ~tqw~<br />
<br />
-------------------------------------------------------------------------------<br />
Release Notes<br />
-------------------------------------------------------------------------------<br />
Relational databases hold data, right? They indeed do, but to think of a <br />
database as nothing more than a container for data is to miss out on the <br />
profound power that underlies relational technology. A far more powerful way of <br />
thinking lies in relational technology's foundation in the mathematical <br />
disciplines of logic and set theory.<br />
<br />
Databases contain truths or propositions describing some area of interest such <br />
as a business. Those truths are organized into sets. Operations from logic and <br />
set theory can be applied to existing sets of truths to derive new sets of <br />
truths. Applied Mathematics for Database Professionals introduces you to this <br />
way of thinking, to the logic and set theory that underlies relational database <br />
technology. All this may sound abstract now, but there are profound benefits <br />
from the deeper understanding you'll gain from this book. You'll learn to<br />
<br />
* Become a better database designer. You'll make fewer mistakes, and your <br />
designs will be more flexible in response to changing data needs.<br />
* Use the expressive power of mathematics to precisely specify designs and <br />
business rules.<br />
* Communicate effectively about design using the universal language of <br />
mathematics.<br />
* Develop and write complex SQL statements with confidence.<br />
* Avoid pitfalls and problems from common relational bugaboos such as null <br />
values and duplicate rows.<br />
<br />
The math that you learn in this book will put you above the level of <br />
understanding of most database professionals today. You'll better understand the <br />
technology and be able to apply it more effectively. You'll avoid data anomalies <br />
like redundancy and inconsistency. Understanding what's in thisbook will take <br />
your mastery of relational technology to heights you may not have thought <br />
possible.<br />
<br />
Table Of Contents <br />
<br />
Foreword xv<br />
About the Authors xvii<br />
About the Technical Reviewers xix<br />
Acknowledgments xxi<br />
Preface xxiii<br />
Introduction xxv<br />
PART 1 The Mathematics<br />
CHAPTER 1 Logic: Introduction 3<br />
CHAPTER 2 Set Theory: Introduction 23<br />
CHAPTER 3 Some More Logic 47<br />
CHAPTER 4 Relations and Functions 67<br />
PART 2 The Application<br />
CHAPTER 5 Tables and Database States 91<br />
CHAPTER 6 Tuple, Table, and Database Predicates 117<br />
CHAPTER 7 Specifying Database Designs 139<br />
CHAPTER 8 Specifying State Transition Constraints 185<br />
CHAPTER 9 Data Retrieval 199<br />
CHAPTER 10 Data Manipulation 221<br />
PART 3 The Implementation<br />
CHAPTER 11 Implementing Database Designs in Oracl 241<br />
CHAPTER 12 Summary and Conclusions 305<br />
PART 4 Appendixes<br />
APPENDIX A Formal Definition of Example Database 311<br />
APPENDIX B Symbols 333<br />
APPENDIX C Bibliography 335<br />
APPENDIX D Nulls and Three (or More) Valued Logic 337<br />
APPENDIX E Answers to Selected Exercises 347<br />
INDEX 367<br />
<br />
Product Details<br />
<br />
* ISBN: 1590597451<br />
* ISBN-13: 9781590597453<br />
* Format: Hardcover, 408pp<br />
* Publisher: Apress L. P.<br />
* Pub. Date: May 2007<br />
<br />
-------------------------------------------------------------------------------<br />
Install Notes<br />
-------------------------------------------------------------------------------<br />
Adobe Acrobat Reader
Add comment