Essay about Data Warehousing

2843 Words 12 Pages
Data Warehouses

In the past decade, we have witnessed a computer revolution that was unimaginable. Ten to fifteen years ago, this world never would have imagined what computers would have done for business. Furthermore, the Internet and the ability to conduct electronic commerce have changed the way we are as consumers. One of the upcoming concepts of the computer revolution in the past ten years has been that of Data Warehousing. In the following pages, we will examine this concept in the broadest sense first looking at a brief history of how databases and data warehouses have unrolled. Then we will look at Data warehousing, what it is, its definition, etc. Secondly, we will focus in on how it coincides with
…show more content…
It is storage that facilitates easy locating of the required goods when an order needs to be picked for delivery to the customer, that is, when data is required by the end user. Data warehousing assembles and organizes data from the enterprise operations such as transaction systems (registers, online order systems, etc.) and stores the data in a format that business or technical people can analyze. The data warehouse is then made accessible through different means to those individuals in need of detailed information. The following diagram depicts the role a data warehouse plays in an order process system.
     There are many benefits to using the data warehouse for this business fashion. First, the information is non-volatile. This means that after the data is in the data warehouse, there are no modifications to be made to this information. For example, the order status doesn’t change, the inventory snapshot doesn’t change, and marketing doesn’t change. It is important to realize that once data is brought to the data warehouse, it should be modified only on rare occasions. It is very difficult, if not impossible, to maintain dynamic data in the data warehouse. Many data warehousing projects have failed miserably when they attempt to synchronize volatile data between the operational and data warehousing systems. Second, data put into a warehouse can be combined