OLTP
OLTP stands for Online Transactional Processing. Records in an OLTP database such as MySQL or Postgres are stored in a row-based fashion.
OLAP
OLAP stands for Online Analytical Processing. Records in an OLAP database such as Snowflake are stored in a column-based fashion.
OLAP or analytics is not about creating or changing data (like in OLTP), but rather the creation and derivation of metrics and understanding of data