OLAP vs. OLTP

  • The data in a transactional database (OLTP) is normalized for update efficiency.
  • Transactional queries join several normalized tables and are slow (as opposed to pre-joined, de-normalized analytical tables).
  • Transactional databases are tuned for one specific application, and it is not productive to use them for analytical queries.
  • The analytical database (OLAP) can be specifically tuned for the analytical queries and ETL processing.
Advertisements