Denormalization guidelines for base and transaction tables

Abstract

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.