It focuses on how well the data is stored for better analysis and reporting of information by the analysts. There are tools that are used to move the data into the storage area and the intelligence tools ensure there is efficiency in delivery of services to the customers. The high changing technology is important for an organization since it integrates data for easier analysis and data reporting. It also assists organizations to get more information about the business, assists companies to meet the business requirements, demands of the customer and eventually helps a company to be at a competitive advantage over their competitors ( SCN Education BV 2001).
Most organizations gather their data from various sources such as; inventory management, online and sales services as the data has to go through the data Life cycle management so that it can be useful to the organization. The tools that are used in gathering the summarized data from various sources into the data warehouse are online analytical processing systems and the query tools. The tools are used in supporting adhoc analysis, inquiring and reporting of the data to the end-users without asking for assistance from the programmers while undertaking the required tasks in the appropriate manner (Witten & Frank 2000).
Data warehousing is easy to maintain and fast in generating reports. ...
avoid such delays then organizations would rather use a server that takes acceptable time which is cheaper and uses separate servers and therefore a data warehouse becomes an important tool that would be used to solve such a problem. In business models it can be used to speed up the querying and reporting processes that are appropriate for the transaction process. For example the Star Scheme model is not very appropriate for the transaction process as it normally slows down the process. Another example is the bit-Mapped index model that may speed up the process of transaction but slows down the reporting and querying process therefore a data warehouse becomes appropriate because it doesn't not interfere with the process in any way. For organizations that need to manage and transact large volumes of data it is appropriate to use this database as it helps in capturing data from different multiple and external sources (McDonald et al. 2002).
Challenges of warehousing
Data warehousing is important to any business organization but it faces challenges which every organization should be made aware of. Data warehouses store very old and historical information that may not be very useful to the organization in the current business environment. The high technological changes and a very high competitive world are some of the things that could render such data obsolete .A company structure could also be continuously changing such that the data in the organizations database may not be useful and therefore the top management may loose interest in analyzing such data (McDonald et al. 2002).
It could also be a very complicated process to a business because most organizations tend to institutionalize reports that are generated from these databases. If an organization does not have