Data Mining & Warehousing

What are general optimization techniques for the efficient computation of data cubes?

The following are general optimization techniques for the efficient computation of data cubes. Technique One (sorting, hashing, and grouping)— Sorting, …

The Data warehouse used some tools. What are the functions?

Data warehouse systems use back-end tools and utilities to populate and refresh their data. These tools and facilities include the …

Describe the recommended approach for data warehouse development.

A recommended method for the development of data warehouse systems is to implement the warehouse in an incremental and evolutionary …

Discuss the role of metadata in the data warehouses.

Metadata is to the data warehouse what the card catalog is to a traditional library. It serves to identify the …

What is the architectural component of a data warehouse?

Various architectural components of a data warehouse are shown in fig. 2.11 and explained below — Load Manager The load …

Discuss data warehouse functions and explain the data flow within the data warehouse.

Data warehouse function and data flow within the data warehouse is as follows 1. Extract and Load Data Data. extraction …

A concept hierarchy defines a sequence of mappings from a set of – low-level concepts to higher-level, more general concepts. …

Write a comparison between Online-analytical processing and online transaction processing | OLAP vs OLTP

Comparison between OLTP and OLAP systems are as follows – OLAP vs OLTP Feature OLTP OLAP Full form Online transaction …

Differentiate between Data warehouse and operational database.

The major task of online operational database systems is to perform online transaction and query processing. These systems are called …

A data warehouse is built on Historical data and is not guaranteed to be up-to-date information”. Comment.

The data warehouse is designed for strategic decision support and is largely built up from the database that makes up …