or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
26 used & new from £21.65

Have one to sell? Sell yours here
 
   
Applied Mathematics for Database Professionals (Expert's Voice)
 
 

Applied Mathematics for Database Professionals (Expert's Voice) (Hardcover)

by L & Koppelaars, T de Haan (Author)
5.0 out of 5 stars  See all reviews (3 customer reviews)
RRP: £43.49
Price: £33.99 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £9.50 (22%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Only 3 left in stock--order soon (more on the way).

Want guaranteed delivery by Thursday, November 12? Choose Express delivery at checkout. See Details
17 new from £27.10 9 used from £21.65

Special Offers and Product Promotions


Frequently Bought Together

Applied Mathematics for Database Professionals (Expert's Voice) + Database in Depth: Relational Theory for Practitioners: The Relational Model for Practitioners + Logic and Databases: The Roots of Relational Theory
Price For All Three: £65.22

Some of these items ship sooner than the others. Show details


Customers Who Bought This Item Also Bought

Database in Depth: Relational Theory for Practitioners: The Relational Model for Practitioners

Database in Depth: Relational Theory for Practitioners: The Relational Model for Practitioners

by C. Date
3.8 out of 5 stars (5)  £13.78
Logic and Databases: The Roots of Relational Theory

Logic and Databases: The Roots of Relational Theory

by C.J. Date
£17.45
Forecasting Oracle Performance

Forecasting Oracle Performance

by C Shallahamer
£33.72
Cost-Based Oracle Fundamentals: v. 1 (Expert's Voice in Oracle)

Cost-Based Oracle Fundamentals: v. 1 (Expert's Voice in Oracle)

by Jonathan Lewis
5.0 out of 5 stars (10)  £37.52
Troubleshooting Oracle Performance, Hardback

Troubleshooting Oracle Performance, Hardback

by Christian Antognini
5.0 out of 5 stars (1)  £44.12
Explore similar items

Product details

  • Hardcover: 376 pages
  • Publisher: APRESS ACADEMIC (27 Jun 2007)
  • Language English
  • ISBN-10: 1590597451
  • ISBN-13: 978-1590597453
  • Product Dimensions: 23.4 x 17.8 x 3 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon.co.uk Sales Rank: 399,432 in Books (See Bestsellers in Books)
  • See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
   Database Development opens new browser window
ApprovedDatabaseDevelopers.co.uk  -  Get free quotes from 4 leading UK Database Development companies 
   Need a Database? opens new browser window
DatabaseDev.ComputerWeekly.com  -  Choose the Right Database Developer Get Free Quotes from 4 suppliers 
   Glynn Consulting Ltd opens new browser window
www.glynnconsulting.co.uk  -  MS Access Database design to automate your business 
  
 

Product Description

Product Description

This book touches on an area seldom explored: the mathematical underpinnings of the relational database. The topic is important, but far too often ignored. This book is the only book to explain the underlying math in a way that’s accessible to database professionals. Just as importantly, if not more so, this book goes beyond the abstract by showing readers how to apply that math in ways that will make them more productive in their jobs. What’s in this book will “open the eyes” of most readers to the great power, elegance, and simplicity inherent in relational database technology.


About the Author

Lex de Haan studied applied mathematics at the University of Technology in Delft, The Netherlands. His experience with Oracle went back to the mid-1980s, version 4. He worked for Oracle Corporation from 1990 until 2004, in various education-related roles, ending up in Server Technologies (product development) as senior curriculum manager for the advanced DBA curriculum. In that role, he was involved in the development of Oracle9i and Oracle Database 10g. In March 2004, he decided to go independent and founded Natural Join B.V. From 1999 until his passing in 2006, he was involved in the ISO SQL language standardization process, as a member of the Dutch national body. He was also one of the founding members of the OakTable network.

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.


Inside This Book (Learn More)
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

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)
 
database
design
formal
sql
set-based logic
set theory
relational
programming
patterns
oracle
logic

Your tags: Add your first tag
 

What Do Customers Ultimately Buy After Viewing This Item?


 

Customer Reviews

3 Reviews
5 star:
 (3)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
5.0 out of 5 stars (3 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
11 of 11 people found the following review helpful:
5.0 out of 5 stars Theory improves practice, 17 Jan 2008
By J. P. Lewis (London, England, UK) - See all my reviews
(REAL NAME)   
If you're responsible for the design, correctness, or performance of any relational database system, whether you class yourself as a developer or DBA, you should read this book.

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.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
5 of 5 people found the following review helpful:
5.0 out of 5 stars A Very Valuable Volume on the Relational Model, 20 Dec 2007
This book from Lex de Haan (RIP) and Toon Koppelaars is a very welcome addition to those relatively few technical volumes to date that attempt to apply the rigours of a sound theoretical mathematical framework to the Relational Model, and the varied and various manifestations thereof.

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.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
5.0 out of 5 stars Excellent book, 4 Sep 2009
By Alistair Joy "PLP" (UK) - See all my reviews
(REAL NAME)   
Well written (if very technical). Would recommend if you are a database designer/developer, made me think about DB's from a different angle
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Only search this product's reviews



Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

   


Listmania!


Look for similar items by category


Look for similar items by subject


Feedback

Ad

Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.