Virtual Warehouse

A virtual warehouse is created based on a set of views defined for an operational RDBMS. This warehouse type is relatively easy to build but requires excess computational capacity of the underlying operational database system. The users directly access operational data via middleware tools. This architecture is feasible only if queries are posed infrequently and usually is used as a temporary solution until a permanent data warehouse is develped.

Click Here for Data Warehousing and Data Mining Main Page