OLTP vs. OLAP Defined

When a database is primarily used for analytics, dashboards, and historical reporting they are referred to as OLAP systems. The primary difference between the two is not the underlying database software or even the data model. Instead, it’s how they are used.