DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
query driven
|
|
|
integrated
|
|
|
less users
|
|
|
store current data
|
Detailed explanation-1: -OLAP facilitate interactive query and complex analysis for the users. OLAP allows users to drill down for greater details or roll up for aggregations of metrics along a single business dimension or across multiple dimension. OLAP provides the ability to perform intricate calculations and comparisons.
Detailed explanation-2: -OLTP involves short online transactions, while OLAP is characterized by large volumes of data. OLTP uses a relational database that handles multiple concurrent transactions, while OLAP employs a data warehouse, which consolidates multiple data sources for building an integrated multidimensional database.
Detailed explanation-3: -OLAP services are characterized by dynamic multidimensional analysis of consolidated enterprise data. OLAP is executed in a multiuser client/server mode and provides consistently fast response to queries, regardless of database size and complexity.