title: Differences between OLAP and OLTP databases
body: <p>What are the key differences between OLAP and OLTP databases.
  Specifically in terms of implementation (rather than use cases).</p>
  
  <p>OLAP is of course primarily used for reporting while OLTP is used for handling transactions.</p>
  
  <p>I understand that OLAP databases are optimized for read over write, and that OLAP databases contain more denormalised data.</p>
  
  <p>What other characteristics set the two apart?</p>