What is the difference between OLTP and OLAP systems?
- A OLTP handles many small transactions; OLAP handles large analytical queries
- B OLTP is for reporting
- C OLAP is normalised for writes
- D They are the same
Answer
OLTP handles many small transactions; OLAP handles large analytical queries
OLTP is normalised and optimised for writes. OLAP is denormalised, often column-oriented, and holds history.





