Denormalisation –having your cake and eating it.
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.
Speaker focus
Dr. Mark Whitehorn specialises in database technology, data warehousing and OLAP and has written eleven books on these topics. He runs his own consultancy company which specialises in the above and is a mentor with Solid Quality Mentors. On the academic side he holds a research position at Cambridge University working on the application of multi-dimensional database techniques to understanding of how Darwin developed the theory of evolution. He is also a senior lecturer at Dundee University where he leads the teaching on the new Masters course in BI.
Other sessions from this conference