OLTP stands for Online Transaction Processing and OLAP stands for Online Analytics Processing.
You can categorize IT systems into two, OLTP systems provide the source data to the data warehouse, whereas OLAP systems help in analyzing it. This will help in understanding Redshift vs. other databases in general.