Available options are listed below:
Practical Issues in Database Management: A Reference for the Thinking Practitioner (Out of print)
| AUTHOR | Stacie Parillo; Pascal, Fabian |
| PUBLISHER | Addison-Wesley Professional (05/23/2000) |
| PRODUCT TYPE | Paperback (Paperback) |
Databasics clearly explains the key concepts users and database professionals need to understand in order to build well-designed databases that answer business questions accurately and efficiently. Fabian Pascal, one of the industry's leading experts, identifies ten critical, recurring issues that both database users and vendors often fail to address appropriately. Pascal demonstrates why understanding these fundamentals is so important, providing detailed examples and solutions designed to help users escape the key pitfalls of database development. Among the topics covered: unstructured data and complex data types; business rules and enforcing data integrity; keys; duplicates; normalization; entity subtypes and supertypes; data hierarchies and recursive queries; redundancy; quota queries; and how to handle missing information. Along the way, Pascal offers no-holds-barred assessments of how well current SQL implementations and commercial products address each issue. Databasics, in short, is a complete guide to building databases right the first time, so they don't have to be rebuilt later. For all DBAs, developers, managers, and end-users that need to understand the best ways to design and implement database systems.
--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
Databasics clearly explains the key concepts users and database professionals need to understand in order to build well-designed databases that answer business questions accurately and efficiently. Fabian Pascal, one of the industry's leading experts, identifies ten critical, recurring issues that both database users and vendors often fail to address appropriately. Pascal demonstrates why understanding these fundamentals is so important, providing detailed examples and solutions designed to help users escape the key pitfalls of database development. Among the topics covered: unstructured data and complex data types; business rules and enforcing data integrity; keys; duplicates; normalization; entity subtypes and supertypes; data hierarchies and recursive queries; redundancy; quota queries; and how to handle missing information. Along the way, Pascal offers no-holds-barred assessments of how well current SQL implementations and commercial products address each issue. Databasics, in short, is a complete guide to building databases right the first time, so they don't have to be rebuilt later. For all DBAs, developers, managers, and end-users that need to understand the best ways to design and implement database systems.