Data warehousing and storage systems Essay Example | Topics and Well Written Essays - 500 words

Data warehousing and storage systems - Essay Example These types of warehouses help in attaining different range and level of storage of data in a computing device. A data warehouse is useful because it can maintain replica of information from the source. This architectural convolution provides the prospect to alleviate the problem of database isolation level lock conflict in operation processing systems that is caused by long or large running attempts and queries related to analysis in the processing database of transaction (Silvers, 2008). The uses of data warehousing is not just limited to one prospect it also helps in compressing data into a single source from multiple sources so that only one query engine can be used. Data warehousing increases the efficiency of working and it improves the data quality by maintaining data history accurately even when the source transaction is unable to keep the record. It helps in keeping information secure and also updates if any alteration is done on any data. This is very important because stor age of data should always be in a secured mode in order to avoid isolation of information. The concept of data warehousing was brought forward in the later part of 1980, in order to deliver an architectural model for flow of information from operational systems to decision support systems (Becker, 2002). Data warehouses in order to obtain analytical access patterns are optimized. They involve in selecting specific fields of function unlike operational systems that use a common type of access pattern. Due to these differences analytical databases get benefited from column-oriented data base management system and operational database get benefited from row-oriented data base management system. Operational systems only maintain a picture or frame of business related information however data warehouses maintain the entire history that is implemented from ETL processes. The evolution of data warehousing in organization use is very sophisticated. There are mainly four levels of warehouses.