FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -OLAP consists of three data models: MOLAP, ROLAP, and HOLAP. These data models differ mainly in terms of data storage and technique. This article provides a comparison of these models to improve our understanding of OLAP in data warehousing.

Detailed explanation-2: -The source data for OLAP is Online Transactional Processing (OLTP) databases that are commonly stored in data warehouses. OLAP data is derived from this historical data, and aggregated into structures that permit sophisticated analysis. OLAP data is also organized hierarchically and stored in cubes instead of tables.

Detailed explanation-3: -Online analytical processing (OLAP) is a technology that organizes large business databases and supports complex analysis. It can be used to perform complex analytical queries without negatively affecting transactional systems.

Detailed explanation-4: -OLAP stands for Online Analytical Processing Server. It is a software technology that allows users to analyze information from multiple database systems at the same time. It is based on multidimensional data model and allows the user to query on multi-dimensional data (eg.