Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    What I'm Giving | November 29, 2014

    Neil Patrick Harris: IMG Neil Patrick Harris: What I'm Giving



    At Powell's, we feel the holidays are the perfect time to share our love of books with those close to us. For this special blog series, we reached... Continue »

    spacer

On Order

$45.50
New Trade Paper
Currently out of stock.
Add to Wishlist
available for shipping or prepaid pickup only
Qty Store Section
- Local Warehouse Database- Design

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

by

Practical Issues in Database Management: A Reference for the Thinking Practitioner Cover

 

Synopses & Reviews

Publisher Comments:

"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

Book News Annotation:

The aim of this work is to provide a correct and up-to-date understanding of the practical aspects of crucial, yet little- understood core database issues. The author identifies fundamental concepts, principles, and techniques and assesses the treatment of those issues in SQL (both the standard and commercial implementations) and gives advice on how to deal with them. Topics covered include complex data types, missing information, data hierarchies, and quota queries.
Annotation c. Book News, Inc., Portland, OR (booknews.com)

Synopsis:

A comprehensive text for anyone wanting to learn how to effectively interact with database technology. The book identifies and clarifies certain fundamental concepts, principles and techniques that users (and vendors) seem to have persistently recurring trouble with.

Synopsis:

""

""""

""

""

""

""

""

""

""

""

""

"

""


Synopsis:

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.

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

Table of Contents

Foreword.

Preface.

1. Careful What You Wish For: Data Types and Complexity.

The Issue.

Fundamentals.

“Simple” Types.

System-Defined Types.

User-Defined Types.

Data Type Support.

On Type “Atomicity.”

“Complex” Types.

Practical Implications.

Relational Domains versus Object Classes.

Database Design.

Relational Structure versus Object Manipulation.

DBMS Implementation.

“Domains.”

“Universal” DBMSs.

Conclusion and Recommendations.

Appendix 1A: Possible Representations for Image Types.

Appendix 1B: Graphics File Follies.

Appendix 1C: Biometric Tools Ready to Take Off.

Appendix 1D: Search Engine Failures.

Appendix 1E: “Complex” Types and Operators: An Internet Illustration.

Appendix 1F: Java and Database Synergy.

2. The Rule of Rules: Integrity.

The Issue.

Fundamentals.

Business Rules.

Integrity Constraints.

Domain Constraints.

Column Constraints.

Table Constraints.

Database Constraints.

Database Correctness.

Base versus Derived Constraints.

Integrity Enforcement.

Integrity Rules.

DBMS Support.

Practical Implications.

SQL and Integrity.

Domain Rules.

Column Rules.

Table and Database Rules.

Procedural Support.

Conclusion and Recommendations.

Appendix 2A: A Note on SQL's OVERLAPS Operator.

3. A Matter of Identity: Keys.

The Issue.

Fundamentals.

Simple versus Composite Keys.

Natural versus Surrogate Keys.

Candidate versus Primary Keys.

Foreign Keys.

Referential Integrity and Primary Keys.

DBMS Support.

Practical Implications.

SQL and Keys.

Conclusion and Recommendations.

4. Don't Get Duped by Dupes: Duplicate Rows.

The Issue.

Fundamentals.

Determining Entity Types.

“Hidden” Information.

A Relational Bonus.

Practical Implications.

SQL and Duplicates.

Duplicate Removal.

Countability.

Addressability.

Correctness and Interpretability of Results.

Essential Order and Performance Optimization.

Conclusion and Recommendations.

Appendix 4A: Duplicate Removal in SQL.

Appendix 4B: Language Redundancy and Duplicates.

5. The Key, the Whole Key, and Nothing but the Key: Normalization.

The Issue.

Fundamentals.

Repeating Groups.

First Normal Form.

Column Dependencies.

Functional Dependencies.

Second Normal Form.

Third Normal Form.

Multivalued Dependencies.

Fourth Normal Form.

Join Dependencies.

Fifth Normal Form.

Practical Implications.

SQL and Multivalued Columns.

“Denormalization” and Performance.

Conclusion and Recommendations.

6. Neither Distinct nor the Same: Entity Supertypes and Subtypes.

The Issue.

Fundamentals.

Entity Types, Attributes, and Relationships.

A Special Case.

DBMS Support.

Practical Implications.

Multikey References.

SQL Subtables and Supertables.

Conclusion and Recommendations.

7. Climbing Trees in SQL: Data Hierarchies.

The Issue.

Fundamentals.

Nodes and Links.

“Explode” Queries.

Recurring Nodes.

Practical Implications.

SQL and Trees.

Conclusion and Recommendations.

8. Not Worth Repeating: Redundancy.

The Issue.

Fundamentals.

Duplicate Rows.

Within-Table Duplicates.

Cross-Table Duplicates.

Entity Subtypes and Supertypes.

Column Dependencies.

Functional Dependencies.

Dependency on Part of the Key.

Indirect Dependency.

Multivalued Dependencies.

Join Dependencies.

Derived Information.

Redundancy Control.

Denormalized Designs.

Derived Information.

Practical Implications.

SQL and Keyless Tables.

SQL and Cross-Table Duplicates.

SQL and “Denormalization.”

SQL and Derived Information.

Conclusion and Recommendations.

9. Will SQL Come to Order: Quota Queries.

The Issue.

Fundamentals.

Ambiguities.

The Declarative Solution.

Practical Implications.

SQL and Quota Queries.

Conclusion and Recommendations.

10. What You Don't Know Can Hurt You: Missing Information.

The Issue.

Fundamentals.

Meaningless Assertions.

Empty Assertions.

Missing Information as Metadata.

DBMS Support.

Many-Valued Logic.

Practical Implications.

SQL NULLs.

NULLs and 4VL.

NULLs and 3VL.

2VL and Metadata.

Conclusion and Recommendations.

Index. 0201485559T04062001

Product Details

ISBN:
9780201485554
Author:
Pascal, Fabian
Publisher:
Addison-Wesley Professional
Location:
Boston :
Subject:
Database Management - General
Subject:
Database management
Subject:
Data Modeling & Design
Subject:
Database design
Copyright:
Edition Number:
1
Edition Description:
Trade paper
Series Volume:
1999-209486
Publication Date:
May 2000
Binding:
TRADE PAPER
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Yes
Pages:
288
Dimensions:
9 x 7.3 x 0.6 in 517 gr

Other books you might like

  1. The Pragmatic Programmer: From... New Trade Paper $47.25

Related Subjects

Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Software Management

Practical Issues in Database Management: A Reference for the Thinking Practitioner New Trade Paper
0 stars - 0 reviews
$45.50 Backorder
Product details 288 pages Addison-Wesley Professional - English 9780201485554 Reviews:
"Synopsis" by , A comprehensive text for anyone wanting to learn how to effectively interact with database technology. The book identifies and clarifies certain fundamental concepts, principles and techniques that users (and vendors) seem to have persistently recurring trouble with.
"Synopsis" by , ""

""""

""

""

""

""

""

""

""

""

""

"

""


"Synopsis" by , 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.
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.