FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -OLAP works with large amounts of data stored in a data warehouse. This data is not real-time but is synced to be as relevant as possible to the decision it will support. Techniques such as data mining and big data analytics are used to gather intelligence from all the data stored in the data warehouse.

Detailed explanation-2: -A data warehouse includes ETL(extraction, transformation, and loading), OLAP engine, other tools that manages the collection of data and deliver this data to business users. A data warehouse is an example of OLAP system. OLAP (Online analytical processing) system helps in analyzing the data.

Detailed explanation-3: -Data Warehouse is the example of OLAP system. OLTP stands for On-Line Transactional processing. It is used for maintaining the online transaction and record integrity in multiple access environments. OLTP is a system that manages very large number of short online transactions for example, ATM.

Detailed explanation-4: -What is OLAP? OLAP (for online analytical processing) is software for performing multidimensional analysis at high speeds on large volumes of data from a data warehouse, data mart, or some other unified, centralized data store.

Detailed explanation-5: -A data warehouse is a type of data management system that is designed to enable and support business intelligence (BI) activities, especially analytics. Data warehouses are solely intended to perform queries and analysis and often contain large amounts of historical data.