| ||||||||||||||||||||
 Trade In this Item for up to £14.05
Trade in Applied Mathematics for Database Professionals (Expert's Voice) for an Amazon.co.uk gift card of up to £14.05, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product 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
- Logic: Introduction
- Set Theory: Introduction
- Some More Logic
- Relations and Functions
- Tables and Database States
- Tuple, Table, and Database Predicates
- Specifying Database Designs
- Specifying State Transition Constraints
- Data Retrieval
- Data Manipulation
- Implementing Database Designs in Oracle
- Summary and Conclusions
About the Author
Toon Koppelaars studied computer science at the University of Technology in Eindhoven, The Netherlands. He is a long-time Oracle technology user, having used the Oracle database and tools software since 1987, version 4. During his career he has been involved in both application development (terminal/host in the early days, GUI client/server later on, and J2EE nowadays), as well as database administration. Within the data modeling area, the formal specification and robust implementation of data integrity rules (a.k.a. business rules) is one of his special interest areas. He is currently employed as an IT architect at Centraal Boekhuis B.V., a well known Oracle shop in The Netherlands. As such he is responsible for technical application architectures with special focus on areas such as scalability, performance and maintainability of application code. He is also a frequent presenter at Oracle related conferences. Recently he has both won the Editor's Choice Award as well as Best Speaker Award of the ODTUG-Now! Conference.
Concordance
Front Cover | Copyright | Table of Contents | Excerpt | Index
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
If you're interested in the theory of databases, you'll love the whole book. If you tend to discard theoretical books by saying "yes, but what practical use is it?" you should still love Chapter 11; and to get the best from Chapter 11, you need to read Chapter 7; and to make chapter 7 easy to read you ought to work your way through the first six chapters.
A database is nothing if the content is not correct so, ideally, we have constraints to make sure that data literally cannot exist in the database unless it is correct.
We have tuple constraints (rules about the values in a single row - for example in an employee table with columns job_grade and salary, the value of salary can only exceed 30,000 if the job_grade is higher than `E'); we have table constraints (rules that restrict the collection of rows in a table - for example, only one employee can have the job-title `CEO'); we have database constraints (rules that restrict the data in one table based on data existing in other tables - for example an order can only be created in the orders table for a product that exists in the products table); finally we end up with "state transition" constraints (rules about how the data may change - for example, an employee may only become a senior vice president if they are currently a vice president).
The authors take us step by step through the expanding scope of constraints showing how to specify constraints as statements of formal logic starting, in fact, with types - the specification for the legal values that an attribute (column) can take.
The whole thing is a clear and brilliant presentation of what you are really trying to achieve when designing a database and creating the supporting code. Then, in chapter 11, the authors take you from logic to code - presenting six models for coding up constraint management using Oracle-specific examples.
The six models range from the simplest (with maximum impact from serialisation and locking issues) to complex (with the minimum necessary serialisation and locking). The examples, and explanation of the issues, give you a wonderful insight into how difficult it is to enforce data correctness even from "inside" the database, and should be mandatory reading for all developers who want to ensure that their programs don't generate inconsistent, or incomplete, data.
Summary: Some people will find the symbolic logic heavy going, but everyone who has to deal with designing or coding an Oracle database ought to read chapter 11 and do their best to read chapter 7.
This well written and well structured book takes the reader gently through rudimentary relations and sets in Part I, to the more complex database-related aspects in Part II, and finally culminating in Part III where the theoretical is applied to the practical - in this case through Oracle, but will equally apply to any of the major Database Management System (DBMS) vendors.
Although the reader is taken `gently' through the learning process, I believe that any experience in Formal System Specification would be a great help to the reader, similarly with any degree of knowledge of relations and sets. With no knowledge of either of these then the curve may not be so `gentle', but what can be assured, however, is that the exercises are well enough designed to bring the knowledge levels up appropriately as the book progresses.
Conversely, what probably isn't of great assistance is a high degree of proficiency with SQL, with its manifold attendant shortcomings and deficiencies. The difficulty here arises where the reader will tend to approach it logically from an SQL perspective (with the perhaps now instinctive mental workarounds), where this book approaches from a much more logically complete, theoretically sound, and neutral angle.
That said, however, there is much of value in this book for the seasoned SQL practitioner, if only to alert as to how incomplete the current DBMS offerings are, how this (potentially) compromises data integrity on several levels (tuple, table, database), how to avoid those same shortcomings, and on how to exploit the maximum declarative constraining from those same DBMSes in their current incarnations. For the not so seasoned, it will lay a solid, sound theoretical basis that will serve very well throughout a career with databases.
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
