Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Practical Issues in Database Management: A Reference for the Thinking Practitioner 1st Edition

4.1 out of 5 stars 18 customer reviews
ISBN-13: 078-5342485554
ISBN-10: 0201485559
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$29.45 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$33.98 On clicking this link, a new layer will be open
More Buying Choices
15 New from $16.50 36 Used from $0.01
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Consumer Reports
Access expert, unbiased product reviews from web or app. Learn more
$33.98 FREE Shipping. Usually ships within 1 to 3 weeks. Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Editorial Reviews

From the Back Cover

"The aim of this book is to provide a correct and up-to-date understanding of--and appreciation for--the practical aspects of crucial, yet little-understood core database issues. It identifies and clarifies certain fundamental concepts, principles, and techniques that persistently trouble users and vendors. It assesses the treatment of those issues in SQL (both the standard and commercial implementations) and gives specific guidance and practical advice on how to deal with them (and how not to). It covers, carefully and thoroughly, several particularly tricky and misunderstood topics--complex data types, missing information, data hierarchies, quota queries, and so forth--in a succinct and concise form for the busy database practitioner."

--C. J. Date

Three decades ago relational technology put the database field on a sound, scientific foundation for the first time. But the database industry--vendors, users, experts, and the trade press--has essentially flouted its principles, focusing instead on a "cookbook," product-specific approach, devoid of conceptual understanding. The consequences have been costly: DBMS products, databases, development tools, and applications don't always perform up to expectation or potential, and they can encourage the wrong questions and provide the wrong answers.

Practical Issues in Database Management is an attempt to remedy this intractable and costly situation. Written for database designers, programmers, managers, and users, it addresses the core, commonly recurring issues and problems that practitioners--even the most experienced database professionals--seem to systematically misunderstand, namely:

  • Unstructured data and complex data types
  • Business rules and integrity enforcement
  • Keys
  • Duplicates
  • Normalization and denormalization
  • Entity subtypes and supertypes
  • Data hierarchies and recursive queries
  • Redundancy
  • Quota queries
  • Missing information
Fabian Pascal examines these critical topics thoroughly, comparing the severe costs of mishandling them to the practical benefits of implementing the correct solutions. With an emphasis on both principles and practice, Practical Issues in Database Management employs real-world examples to provide an assessment of current technology--SQL and the DBMS products based on it--and, whenever possible, offers concrete recommendations and workarounds. With the insight provided by Practical Issues in Database Management , you will be in a far better position to evaluate specific products, exploit their capabilities, and avoid their deficiencies.

0201485559B04062001

About the Author

Fabian Pascal is an independent industry analyst, consultant, author, and lecturer specializing in database management. He is the author of two previous books, Understanding Relational Databases and SQL and Relational Basics, and has contributed extensively to many industry publications.

0201485559AB04062001

NO_CONTENT_IN_FEATURE

New York Times best sellers
Browse the New York Times best sellers in popular categories like Fiction, Nonfiction, Picture Books and more. See more

Product Details

  • Paperback: 288 pages
  • Publisher: Addison-Wesley Professional; 1 edition (June 2, 2000)
  • Language: English
  • ISBN-10: 0201485559
  • ISBN-13: 978-0201485554
  • Product Dimensions: 7.3 x 0.6 x 9.1 inches
  • Shipping Weight: 1.1 pounds (View shipping rates and policies)
  • Average Customer Review: 4.1 out of 5 stars  See all reviews (18 customer reviews)
  • Amazon Best Sellers Rank: #2,013,467 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

Format: Paperback
Contains discussions on widely misunderstood, but vitally important, database issues. Considers how things should be according to relational theory, what goes wrong in practice due to failing to understand these fundamental concepts, and provides practical recommendations/workarounds where possible. A bridge between theory and practice. A concise and straightforward read, although to gain maximum benefit you should already have a reasonable understanding of relational databases.
Some of the main points are as follows. Relational databases can support data types of arbitrary complexity ("objects") - but we need DBMS vendors to implement the means to provide such support. Use declarative integrity constraints when possible. Avoid tables that allow duplicate rows - ensure all tables have a primary key (may require a surrogate key). Avoid redundant data. Ensure your database is normalized - avoids numerous problems. Resist the temptation to denormalize. Recognise entity supertypes/subtypes and how to implement as tables. Minimize use of nulls whenever possible. Also discusses climbing trees and quota queries. Separate chapters discuss all these points in detail.
A constant theme throughout the book is how poorly SQL and commercial DBMSs support relational concepts, and the numerous problems this causes. Personally, I believe there is little that most application/database developers can do about this, other than suffer what gets "inflicted" upon us. Pascal urges us to pressurise DBMS vendors to provide better relational support.
This book is firmly of the view that "relational is right". If you agree, you will probably like this book. Most of the references are to C.J Date's writings.
Read more ›
2 Comments 36 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I came to this book with high hopes after having read much of Fabian Pascal's writing on the Web, which is very specific in calling out the many weaknesses of contemporary database practice and much less specific when it comes to strategies for dealing with those weaknesses. Unfortunately, the writing in this book is much like his writings online.

Pascal is clearly a seasoned professional and also someone who understands the relational model well. However, his frustration with the current state of the art bleeds over into this book, and is unhelpful. I now very clearly understand that SQL is incapable of dealing with a truly relational view of data, and that SQL (and by extension almost all contemporary DBMSes) is flawed and illogical in many ways, but there's only so much that I, as a database designer and software developer, can do with that information. In many cases, only a change in phrasing would have been necessary: I think the book would have been much more useful if it had been written prescriptively, as a "style guide" or best practices manual (DON'T use NULL. DO normalize your relations to at least 3NF) with his impassioned critiques of current technology provided as rationales for his guidelines.

Also, there's more than a whiff of the amateur to the presentation in this book. Aside from the baffling reprints of web pages included as appendices to the first chapter, he recycles exhortations across chapters and reuses the same examples over and over (down to the same explanatory text), without necessarily explaining what's different about this usage from all the others. Add to that a large, wide text face and the book, not particularly long at 256 pages, starts to feel significantly padded.

Most interested parties would be much better served by C.J.
Read more ›
1 Comment 20 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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.
Comment 7 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
This may be the most practical database book I will ever read. While it is not wriiten for the complete novice, I would say it is important as a good second book to read (an excellent first book would be Access Database Design and Programming by Steven Roman, or Sams Teach Yourself SQL in 10 Minutes by Ben Forta), after you have developed a rudimentary understanding of SQL. After working with SQL in any DBMS, you will begin to run accross some of the problems he addresses in his book - inconsistent treatment of nulls, duplicate information, etc. Each chapter stands on its own, making it valuable as a reference guide, and in many instances he provides SQL workarounds for problems brought on by...SQL. Although he does lay blame at feet of current DBMS vendors for not fully implementing the relational model, he addresses the fundamental lack of knowledge on the part of practitioners. By far the best chapter is the one on normalization, particularly his discussion on the fourth and fifth normal forms.
Comment 6 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews