Practical Issues in Database Management: A Reference for the Thinking Practitioner, 1st edition
Unfortunately, this item is not available in your country.
"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
- Normalization and denormalization
- Entity subtypes and supertypes
- Data hierarchies and recursive queries
- Quota queries
- Missing information
Table of contents
1. Careful What You Wish For: Data Types and Complexity.
2. The Rule of Rules: Integrity.
3. A Matter of Identity: Keys.
4. Don't Get Duped by Dupes: Duplicate Rows.
5. The Key, the Whole Key, and Nothing but the Key: Normalization.
6. Neither Distinct nor the Same: Entity Supertypes and Subtypes.
7. Climbing Trees in SQL: Data Hierarchies.
8. Not Worth Repeating: Redundancy.
9. Will SQL Come to Order: Quota Queries.
10. What You Don't Know Can Hurt You: Missing Information.
Published by Addison-Wesley Professional (May 23rd 2000) - Copyright © 2000