Data Warehouse - Transfer Procedure with Virtual Warehouse

Abstract: view over functioning data warehouse is recognized as virtual warehouse. It is informal to construct virtual warehouse. Constructing a virtual warehouse involves extra volume on functioning database servers. A data warehouse is not ever fixed; it develops the commercial increases. The commercial develops, its desires retain altering and consequently data warehouse must be intended to drive with these alterations. Later data warehouse system requirements to be elastic. The transport process is an optional of the combined request growth method accepted for the transfer of a data warehouse. The backup and recovery procedures may develop difficulty; consequently it is optional to achieve this action within distinct stage. It is mentioned not to practice these access tools when the database is being considerably improved. A data warehouse attends as single portion of plan-execute-assess "closed-loop" response scheme for the initiative organization. Keywords: Data, Data warehouse, procedure, process, virtual warehouse