Data Warehousing :: essays research papers

The company implementing the Data warehouse is Sears Roebuck & Co. Sears is in the retail business selling ever thing from under garments to washing machines. The chief(prenominal) reason why the company is implementing the DW is because it wants to maximize the use of its information in its credit selective information warehouse. The prior application processed steps consecutive one processor at a time thus not using the multiprocessor capabilities of its machine to process the huge quantity of data. Mining of data was too slow and could only be performed once a year, which produced incorrect data for the Marketing department. Due to the meticulous process, other units of the company were veto from the data warehouse, which also cause dilemmas.Sears went to a consultant to solve the problem. The parcel chosen was the Torrent Systems Orchestrate Package. The reason for choosing this package is because the package check up on the needs of the company to a match. It allows the c ompany to convert its application from resultant to duplicate by partitioning the data across the processors and running multiple, parallel instances of the application. The benefits from implementing the Orchestrate package is, the new program would examine account attributes wish well purchasing behavior and payment history, causing more(prenominal) lucrative targeted trade campaigns and boosting sales and card balances. It will allow the job to be make at a fraction of the time of the prior system. In supplement the new system increased the number of credit card accounts from 16 million to 22 million.Overall, from doing this case study I have acquire that data mining and data warehouses are rattling important to all organizations especially very large organizations. DWs sustain to further organize and use the data of the company to its fullest, which allows companies to operate more smoothly and efficiently. I gained a greater knowledge of DWs and how they course and a re used by organizations.