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 BI systems and Data Science solutions.  In addition to his consultancy practice he has also acted as an expert witness in cases of patent infringement and for the police in cases of computer fraud.


    He is a well-recognised commentator on the computer world.  He is a regular contributor to The Register, has written numerous white papers and also 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 has developed several of the company's courses (data science and big data course, database analysis and design, MDX, Dimensional modelling) and teaches them all.

    On the academic side, Mark is the emeritus Professor of Analytics at the University of Dundee where he designed and runs a Masters course in Data Science.  There he also works with the prestigious Lamond labs. applying BI and Data Science to proteomics

    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.