In contrast to OLTP databases, OLAP databases are intended to support analytical processing of data whereas OLTP databases are designed to support daily operations (transactions). A process called ETL ...

Online analytical processing (OLAP) databases are purpose-built for handling analytical queries. Analytical queries run on online transaction-processing (OLTP) databases often take a long time to ...