DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
OLAP
|
|
|
OLAT
|
|
|
OLTP
|
|
|
OLTA
|
Detailed explanation-1: -Online Analytical Processing (OLAP) is a category of software that allows users to analyze information from multiple database systems at the same time. It is a technology that enables analysts to extract and view business data from different points of view.
Detailed explanation-2: -OLAP (online analytical processing) is a computing method that enables users to easily and selectively extract and query data in order to analyze it from different points of view.
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: -It should not be confused with OLAP as the two are not the same. A data warehouse is an archive while OLAP is one of the technologies that analyze and evaluate its stored information. In a data warehouse, OLAP allows for fast querying and analysis of data from different perspectives.
Detailed explanation-5: -Explanation: The full form of OLAP is Online Analytical Processing. It is an interactive system that gives various features to analysts. 2. Data that can be modelled as dimension attributes and measure attributes are called