5An architectural approach that combines a collection of ind

5.An architectural approach that combines a collection of independent systems as part of an overall data warehousing environment, rather than integrating those systems in to a single data base, is called a (    ) data warehouse.

Solution

Query-Driven Approach

Traditional approach to integrate heterogeneous databases. This approach was used to build wrappers on top of multiple heterogeneous databases.

Process of Query-Driven Approach

When client is provided with the query, a metadata dictionary changes the query into an appropriate from for individual heterogeneous sites involved.

After mapping these queries are sent to the local query processor.

Result is included in global answer set.

An architectural approach that combines a collection of independent systems as part of an overall data warehousing environment, rather than integrating those systems in to a single data base, is called a (Query-Driven Approach ) in data warehouse.