Data Warehouse Paper
Dana Presley
Database Concepts
DBM/380
Esmaail Nikjeh
October 9, 2006
Data Warehouse Paper
Databases have become a part of everyday operations at most companies and organizations. Databases have given these businesses the ability to manage information for use in a structured manner and have improved their overall operations. One problem has developed due to the creation of many different databases within the same organization or company. These businesses have numerous databases within their computer systems, but the data in these databases is not linked or associated to any of the other databases within the businesses. Over the years, they have developed a lot of stand alone database management systems for their various divisions. Businesses have realized that they could bring all this data from the various parts of their organization into one consolidated, structured area of storage that could provide them with a lot of valuable statistical and decision-making information. A tool that does this is the data warehouse. A data warehouse is basically a storage area where all an organization's information or data is stored and managed in a manner that will allow all users in the organization to use that data in their decision-making process. The following paragraph will provide a brief overview into the reasons data warehouses exist, along with the advantages data warehouses provide.
Data warehouses were developed in the late 1980's. During this time companies were just staring to realize that basic databases of operating systems were not able to meet their total needs when it came to the management of information (Data warehouse, 2006). There are many reasons why ...