The Relational Model for Database Management: Version 2 (Hardcover)

by E. F. Codd (Author)

Editorial Reviews

Product Description
Written by the originator of the relational model, this book covers the practical aspects of the design of relational databases. The author defines twelve rules that database management systems need to follow in order to be described as truly relational and then gives the motivation behind these rules. This book is a perfect resource for students and professionals in the field. 0201141922B04062001

Product Details

• Hardcover: 538 pages
• Publisher: Addison Wesley Publishing Company (April 1990)
• Language: English
• ISBN-10: 0201141922
• ISBN-13: 978-0201141924
• Product Dimensions: 9.6 x 6.7 x 1.1 inches
• Shipping Weight: 1.9 pounds
• Average Customer Review: 4.0 out of 5 stars See all reviews (1 customer review)
• Amazon.com Sales Rank: #618,494 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

12 of 14 people found the following review helpful:

4.0 out of 5 stars From the creator of relational databases, November 11, 2002

By	Gary Sprandel (Frankfort, Kentucky) - See all my reviews (REAL NAME)

Dr. Codd, an IBM researcher, first developed the relational data model in 1970 (eg., A relational model of data for large shared data banks: 1970 Communications of the ACM Vol 136:377-387) and spawned a whole industry. In this 1990 book, Codd introduces "Version 2", where he collects a number of his ideas and extends his model. This book is not about specific database package or about SQL (Except for a chapter entitled "Serious Flaws in SQL"), but rather about the concepts behind relational databases. Codd sets the standard and goals that, as yet, no vendor completely delivers. His emphasize on corrective steps for duplicate rows, should not be ignored by vendors.

This is not an easy book to read, with some of his own notation (For example "And clearly S \ U / T = T \ U / S"), but he presents an understanding of the basis of the relational model. The chapter on "Missing information" and his 4 valued logic, with Missing-but-applicable and Inapplicable presents a richer understanding than the usual "Null" concept. His chapter on "View updatability" is helpful for those who has gotten the message "Recordset is not updateable". Fabian Pascal and C.J. Date have reviewed the relational model in articles available online as well as in a Date's recent book "The Database Relational Model: A Retrospective Review and Analysis." Codd challenges the alternatives to the relational model to present a clearly worked out model. With XML going strong, it will be important to develop mathematical underpinnings.