Used properly, normalisation brings huge advantages. It optimises storage (each piece of data is stored only once), it removes an entire class of update, insert and delete anomalies and it improves data integrity. What more could we ask for? Well, performance can be an issue. Normalised databases often have a reputation for poor performance. This talk will examine the role of normalisation on performance and focus on effective ways we can denormalise data and yet retain the data integrity that normalisation brings.
This talk compliments that by Tony Rogerson beautifully and will be given by Mark and Yasmeen Ahmed who works with him at the University of Dundee.