Data Warehousing and Data Mining
Your database has been a hit. You have been called back to the customer’s headquarters and they want a detailed report and plan how to convert the mass amounts of data into profitable information. They have heard of data warehouses and data mining, but they want you to provide an executive overview and a plan with specifics on how they will take their environment to the next level with the implementation of a data warehouse and data mining infrastructure. Write a 6-8 page paper in which you:
Provide an executive overview that addresses the following:
Explain the benefits and current trends of data warehousing and data mining.
Provide two (2) examples of quality companies successfully using a data warehouse to support your answer.
Outline the architecture, models and views used in the data warehouse.
Discuss optimization techniques specific to data warehousing and data mining.
Assume that the company has accumulated 20TB of data and that 20% per year growth is expected in the size of the Data Warehouse. Recommend a solution for this scenario with respect to software, hardware and network requirements.
Create a diagram using Visio, Microsoft Paint, or other graphical creation utility of your choosing to illustrate the conceptual data feeds into and out of the data warehouse. Note: The graphically depicted solution is not included in the required page length.