Quantity:

More Buying Choices

26 used & new from �21.65

Have one to sell? Sell yours here

Share your own customer images

Search inside this book

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

This title is part of our Up to 35% Off 1000s of Textbooks offer.

Frequently Bought Together

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

This item: Applied Mathematics for Database Professionals (Expert's Voice) by L & Koppelaars, T de Haan
In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
Database in Depth: Relational Theory for Practitioners: The Relational Model for Practitioners by C. Date
In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
Logic and Databases: The Roots of Relational Theory by C.J. Date
Usually dispatched within 1 to 3 weeks.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions

Customers Who Bought This Item Also Bought

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

by C.J. Date

�17.45

Forecasting Oracle Performance

by C Shallahamer

�33.72

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

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)

Would you like to update product info or give feedback on images?

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

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

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

What Do Customers Ultimately Buy After Viewing This Item?

	55% buy the item featured on this page: Applied Mathematics for Database Professionals (Expert's Voice) 5.0 out of 5 stars (3) �33.99
	16% buy Troubleshooting Oracle Performance, Hardback 5.0 out of 5 stars (1) �44.12
	11% buy Cost-Based Oracle Fundamentals: v. 1 (Expert's Voice in Oracle) 5.0 out of 5 stars (10) �37.52
	10% buy Database in Depth: Relational Theory for Practitioners: The Relational Model for Practitioners 3.8 out of 5 stars (5) �13.78

Explore similar items

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:

Create your own review

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

By	Se�nMacGC "Se�nMacGC" (Ireland) - See all my reviews

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

› See all 3 customer reviews...

.jsOffDisplayBlock { display: block; } .jsOffDisplayInline { display: inline; } .jsOffVisibility { visibility: visible; } .jsOnDisplayBlock { display: none; } .jsOnDisplayNoneBlock { display: block; } .jsOnDisplayNoneInline { display: inline; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; } .jqOnDisplayBlock { display: none; } .jqOnDisplayInline { display: none; } .jqOnVisibility { visibility: hidden; } .jqOnDisplayNoneBlock { display: block; } .jqOnDisplayNoneInline { display: inline; }