Reference no: EM13330667
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.
- Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements: •& nbsp;Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
•Include a cover page containing the title of the assignment, the student's name, the professor's name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
•Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams/charts must be imported into the Word document before the paper is submitted. The specific course learning outcomes associated with this assignment are:
•Demonstrate the basic mechanisms for accessing relational databases from various types of application development environments.
•Summarize the difference between on-line transaction processing (OLTP) and online analytic processing (OLAP), and their relationship among business intelligence, data warehousing and data mining.
•Summarize how database systems support enterprise and web-based applications.
•Use technology and information resources to research issues in database systems.
•Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.
|
Conduct internet searches to find the information described
: Conduct Internet searches to find the information described in one of the activities below. Write a brief report summarizing your research results. Be sure to document your sources, using the APA format. Submit the report to your instructor.
|
|
Define what is the mole fraction of each gas
: A mixture of Ar and N2 gases has a density of 1.439 g/L at STP. What is the mole fraction of each gas. Express your answers using four significant figures. Enter your answers numerically separated by a comma.
|
|
What is the mass of the faster locomotive
: Two toy locomotives approach each other along the same line, and upon collision both stop dead still. What is the mass of the faster locomotive
|
|
Compute e and h for the gas expansions
: A 1.50 mole sample of an ideal gas is allowed to expand adiabatically and reversibly to twice its orignal volume. In the expansion the temperature dropped from 296ºK to 239ºK. Calculate ?E and ?H for the gas expansions
|
|
Discuss optimization techniques specific to data warehousing
: Demonstrate the basic mechanisms for accessing relational databases from various types of application development environments.
|
|
With what speed does the hockey player recoil
: A 72- kg ice hockey player standing on a frictionless sheet of ice throws a 6.2- kg bowling ball horizontally with a speed of 3.1 m/s
|
|
Explain an antacid tablet containing magnesium hydroxide
: An antacid tablet containing magnesium hydroxide instead of calcium carbonate was dissolved in 10 mL of 0.2893 M HCL. 10 mL of this solutions was tritated to endpoint with 25.20 mL of 0.1007 M NaOH. How much magnesium hydroxide was in the antacid ..
|
|
How did you deduce which spot corresponded to 2-naphthol
: How did you deduce which spot corresponded to 2-naphthol on yourTLC plate that analyzed the reaction mixture at 10, 30, and 60 minutes. Did your TLC analysisindicate the presence of any 2-naphthol remaining atthe end of the 60-minute reaction time..
|
|
Compute the work done by the force of gravity
: A block of mass 2.50 kg is pushed 2.40 m along a frictionless horizontal table by a constant 16.0 N force directed 25.0° below the horizontal. Determine the work done by the force of gravity
|