Practical Issues in Database Management

More about the book

This book clearly explains essential concepts for users and database professionals to create well-designed databases that effectively address business questions. Fabian Pascal, a leading expert in the field, identifies ten critical issues that both users and vendors often overlook. He emphasizes the importance of grasping these fundamentals, providing detailed examples and solutions to help users avoid common pitfalls in database development. Key topics include unstructured data, complex data types, business rules, data integrity, keys, duplicates, normalization, entity subtypes and supertypes, data hierarchies, recursive queries, redundancy, quota queries, and managing missing information. Pascal also critically assesses how current SQL implementations and commercial products tackle these issues. This comprehensive guide aims to ensure that databases are built correctly the first time, preventing the need for costly rebuilds later. It serves as an invaluable resource for DBAs, developers, managers, and end-users seeking to understand the best practices in designing and implementing database systems.