Paper Topic:

Data Warehouseing

Running Head : Data Warehousing

Name

University

Course

Tutor

Date

Introduction

A data warehouse is a term used to describe the electronically stored data of an organization . These warehouses are important in helping an organization analyze and report on all of the organization data . It is a process that aims at storing data but it also aims at retrieving extracting , transforming , analyzing and managing all the data of a company or organization . Thus in general a data warehouse can be described as a business extraction tool that extracts

loads and analyzes data . These data warehouses are very vital in the management of a company 's transactions

The concept of a data warehouse consists of several layers the operational database layer which comprises the main source of data or information for the data warehouse , the informational access layer which comprises all the data that has been accessed to prepare for analyzing and reporting , data access layer which acts as the link between informational and access layers and the metadata layer which acts as the directory for the data (Westerman , 2001

Planning for Data Warehouse

Construction of a data warehouse should be a well planned process to ensure maximum outputs . The manager should realize that constructing of a data warehouse requires the same planning as the construction of any other computer application . A manager should also involve the users or the people who are going to be using the application in the planning process because they can help determine the scope of the...

6 pages

43.0 KB

Free sing-up