Denormalization guidelines for base and transaction tables
Douglas B. Bock, John F. Schrage · ACM SIGCSE Bulletin · 2002
This article outlines heuristic guidelines for denormalizing transaction tables in relational databases. Denormalization as a process seeks to improve the response time for data retrieval while maintaining good system performance for row insertions, updates, and deletions. These guidelines apply especially for client-server environments where response time for on-line, transaction-processing systems is critical to end-user satisfaction and productivity.