This article consists of 5 pages and 1169 words.
In order to have full access to this article, please email us on thedocumentco@hotmail.co.uk

DATA WAREHOUSES
Introduction:

A data warehouse (DW) refers to an amalgamation of tools which are used to assist the employee of the information sectors, specifically managers, analysts and supervisors to take swift action as it deals with collecting and presenting all the information related to an entity at the correct place and time so as to make the correct choice with the correct amount of monetary involvement.

Other systems such as the online transaction processing (OLTP) that was previously used is unsuitable for providing access to data as well as to provide solutions to decision making (Jarke, 2000).

Data warehousing is different from the operating systems with regards to the fact that it involves the usage of many different types of operating systems and its processing in order to integrate and display the appropriate results.

Although there are certain data warehouses that are software copies of the operating system itself (and therefore ineffective), it has been determined that data warehouses have a different type of requirements, customers, and configuration than operating systems (Kimball & Ross, 2002).

This essay explores warehouses and their rationale, structure and usage briefly in order to define the need for high functioning data warehouses.

Rationale:

The reasons for using data warehouses are more than it being just a different means of getting access to information.

A data warehouse is undoubtedly an efficient means of dealing with information for various employees of an organisation.

It is designed primarily in order to cumulate a set of information from different sources into one coherent arrangement which maintains the scrutiny as well as administrative processes in an organisation (Perkins, 2013).

The primary rationale for using data warehouses constitutes the fact that data warehousing provides accurate and cost-effective decisions in organisations with complex structures as it provides easily computed decisions in very little time.

It also improves the execution of decision making based on the information of the current amount of assets and liability a company possesses before taking prompt decisions. Data warehousing is one of the most intelligent ways through which business plans can be altered since they alarm of discrepancies in dealings mid-way with the overview of all integrated information (Wenz, 1996).

In an era of brutal competition amongst businesses, customer growth can only arise if the competition is duly tackled and the customers convinced that the product of the selling company is better …