Practical Issues in Database Management: A Reference for the Thinking Practitioner
||Author: Fabian Pascal|
List Price: $39.95
Our Price: Click to see the latest and low price
Publisher: Addison-Wesley Pub Co (23 May, 2000)
Sales Rank: 112,654
Average Customer Rating: 4.38 out of 5
Customer ReviewsRating: 2 out of 5
Understanding Relational Databases, once again
Giving this book only 2 starts only because of its title. It is not what it claims to be.
This book title should be "Understanding Relational Databases, once again" (borrowed from 1st book by Fabian).
It is not for experienced database professionals by any means.
In case you have never heard of normalization or relational algebra this book will help you to avoid many mistakes with database design.
The relational principles are practical. No argument there. But in real world there are other issues like available RDBMS features, performance, deadlines. It is not a problem that this book does not address them as its scope is different. The problem that it mentions these issues as something having less importance comparing to relational theory guidelines. Following this approach can ruin your design as surely as violating normalization principles.
In case you have already had an understanding of relational theory this book is waste of money.
Samples are oversimplified. Try to implement supertype-subtype sample with the inheritance level about 5 and see how your design will perform. Many very useful designs are simply not mentioned. For example only "explosion" design is considered for tree implementation.
Rating: 5 out of 5
On the money...
Fabian is on the money. Jeff Unsel (above), you're a perfect example of the problem. Get out of IT and try selling cars or something.
Rating: 5 out of 5
Could be better, but not much
Ever wondered why is it so difficult to put rich data into the relational model, or why so much of database logic keeps being badly manipulated by application programs instead of by DBMS? Ever felt SQL was too verbose, or complex, or illogical, and simply arbitrarily limited? Mr Pascal helps us organise our grips against current DBMSs and hope for a better future.
This book analyses common database problems every professional with more than a few months in the field has already faced, and relentlessly trace them to failures in SQL implementations or in the SQL language itself. A real mind-opener in the current state of the field, where from press to shop everything is dominated by vendors but few true critics survive.
· Foundation for Object / Relational Databases: The Third Manifesto
· An Introduction to Database Systems, Eighth Edition
· The Database Relational Model: A Retrospective Review and Analysis: A Historical Account and Assessment of E. F. Codd's Contribution to the Field of Database Technology
· Temporal Data & the Relational Model