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.
Presented by Mark Whitehorn at SQLBits VI
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO

    Mark Whitehorn

    Mark Whitehorn specialises in the areas of data science and BI.  .


    Mark works with national and international companies, designing databases and BI systems.  In addition to his consultancy practice he has also acted as an expert witness for the police in cases of computer fraud.


    He is a well-recognised commentator on the computer world, publishing articles, white papers and eleven books on database and BI technology. The first one, Inside Relational Databases has been selling well since it was published in 1997 and is now in its third edition. It has also been translated into three languages. Another of his books FastTrack to MDX was co-written with the inventor of the language, Mosha Pasumansky. 

    Mark is also an associate with QA Ltd.  He developed the company's database analysis and design course as well as its data warehousing course and teaches both.

    On the academic side, Mark is a Professor at the University of Dundee where he designed and runs a Masters course in BI.  There he also works with the prestigious Lamond labs. applying BI to proteomics.  In addition he is a research associate at the University of Cambridge. There he is involved in an international research project analysing the hitherto unknown data that was available to Darwin before he wrote The Origin of Species. This group has used BI techniques to rewrite our understanding of how Darwin came to develop the theory of evolution.

    For relaxation he collects, restores and races historic cars which keeps him out of too much trouble. He only wears a tie under duress, doesn't possess a suit that fits and unashamedly belongs to the beard-and-sandals school of computing.
  • Video
    The video is not available to view online.