Question
We've been focusing on operational databases, often called online transaction processing (OLTP) systems. These OLTP systems handle the day-to-day business of the company and are accessed by multiple users simultaneously updating data in short transactions.
Business intelligence systems are sometimes called online analytical processing (OLAP) systems. These OLAP systems are used to create decisions and are characterized by few users submitting long running queries that do not update database to analyze the historic data of the company. What is some other dissimilarity between OLTP and OLAP systems? How are data warehouses alike or different from these two database models?