What is the key difference between OLTP and OLAP systems?
-
A
OLTP handles large analytical queries; OLAP handles transactional writes
-
B
OLTP is optimized for high-frequency, small transactional operations; OLAP is optimized for complex analytical queries over large datasets
-
C
OLTP stores unstructured data; OLAP stores structured data only
-
D
OLTP uses columnar storage; OLAP uses row-based storage