Enterprise Data Warehousing and Data Mining Coursework

Enterprise Data Warehousing and Data Mining - Coursework Example To this end data mining systems are used, are they all they could be and are they really the only way of sorting the chaff from the wheat? Keywords: data, mining, search, find, information, business intelligence. Implementing Data Warehousing To bring a data warehousing system into a company means first analyzing the situation that exists, the size of the organization, its present systems and what they can do to improve the problem without extra costs, it is quite likely there are professional statisticians in the company who simply need help to get their work done a little faster. To bring a new system into the company means ensuring there is a business need as that must always drive implementation so there must be an emphasised need such as competitors are getting products to the marketplace first. Stated by Davis (1994). Once it has been decided there is no choice, but to purchase, then a study of what applications are available in the marketplace must be done, a needs definition will give information on just what is needed from the new system, it may need to be custom built or modified such as has been done for the data mining tool now used by Jaeger. Stated by Grant (2008). With a large company there are going to be many demands from different groups for something that addresses their needs, but as a person responsible for buying the tool it is important it can answer as many differing demands as possible. The implementation often means a company must upgrade its present IT, its hardware, networks and PC’s may need replacement or upgrading, so the cost of implementation becomes more than just the cost of purchasing the new system. Thearling, (2003). Figure 1: Convergence of Three Technologies for Data Mining, Thearling (2003) Once the data warehouse is in place data mining can begin, but the two things are separate, data warehousing is not data mining. For data mining to go ahead it is probable that software for this role will have to be bought, and implemented after the warehousing system is in place, creating a time delay. Applications available include: Sybase IQ 15.3 -- this business intelligence/analytics and data warehouse focused relational database management product is now powered by a so-called "new generation" of shared everything Massively Parallel Processing (MPP) technology. Bridgwater (2011). Another application is that used by Jaeger's new loss prevention programme aims to change managers' behaviour by giving them the data they need to take action. Jaeger went to UK loss prevention specialist Oris, which has a strategic partnership with product identity and shrink management company Checkpoint Systems. Oris also supplied IDM Systems' Oracle-based LossManager data mining application. Data from its electronic point of sale system lets Jaeger identify the source of losses, integrate information from other applications such as RFID and CCTV, monitor investigations, and provide action alerts for managers. "From data mining we knew that 84% of goods stolen were taken from near doors, despite 70% of our [more than 120] stores having tagging," Hearn said. Stated by Grant (2008). Benefits of a Data Warehousing System Data warehousing can be very useful in the right situation, it can give just the information needed from all