Data warehouse Essay Example | Topics and Well Written Essays - 2000 words

information warehouse - Essay Exampleehouse is a silo of selective information gathered from multiple data sources that is coming from varied sources and forming an all-inclusive database by filtering the old and new data based on business logic and the read of the organization. info memory is the concept of using data from the data warehouse for further processing and beatting business intelligence information in an organization. In a data warehouse the flow of data and information has to be continuous, systematic and structured in a manner so that decision makers at every level in the organization can do data mining, query the data to get desired answers, systematically use it for further processing in their decision support system. Data warehousing is an information technology based system that integrates data from other business processes and business occurrence, filters and stores it in a systematic manner and allows the business verticals to use these data or information e ffectively.Data warehouses are traditionally setup to update the operational data on a daily basis. There will be search engines, queries and filters inbuilt into the data warehouse system. That is why it is also termed as operational data stores.Data warehousing is one of the basic requirements for implementing an effective Enterprise Resources Planning (ERP) or Manufacturing Resources Planning (MRP) in some(prenominal) organisation. The success of any business strategy system and tools are dependent on the maximum ascendancy over the data or information flow. The control over the business data is possible by the maintenance of a centralized data store. A centralized data store can be readily accessed by the management and various departments for effective decision making and planning the operational schedule. An perfect MRP system will provide the managers and departments with updated stock information and activity schedules that help in formulating effective toil strategies in addition to facilitating improved visibility of