Practical Issues in Database Management

This book addresses the core, commonly recurring issues and problems that even the most experienced database professionals-seem to systematically misunderstand, including: unstructured data and complex datatypes, business rules and integrity enforcement, data hierarchies and recursive queries, redundancy. 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, this book employs numerous examples to provide an assessment of current technology-SQL and the DBMS products based on it-and, whenever possible, offers concrete recommendations and workarounds.