ScholarMatic | 24/7 Homework Help

ScholarMatic Will Help You Write Your Essays and Term Papers

Answered » You can buy a ready-made answer or pick a professional tutor to order an original one.

Term paper: Data Warehousing and Data Mining

by | Nov 30, 2023 | questions

Term Paper:Data Warehousing and Data Mining

Due
Week 10 and worth 150 points

Your
database has been a hit. You have been called back to the customer’s
headquarters and they want a detailed report and plan of 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 six to eight (6-8) page paper in which you:

  1. Provide an
    executive overview that addresses the following:
    1. Explain
      the benefits and current trends of data warehousing and data mining.
    2. Provide
      two (2) examples of quality companies successfully using a data warehouse
      to support your answer.
    3. Outline
      the architecture, models, and views used in the data warehouse.
  2. Discuss
    optimization techniques specific to data warehousing and data mining.
  3. 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.
  4. 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.
  5. 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:

  • 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 online 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.

Grading
for this assignment will be based on answer quality, logic/organization of the
paper, and language and writing skills, using the following rubric.

Points:
150

Term
Paper:
Data Warehousing and Data Mining

Criteria

Unacceptable

Below 60% F

Meets Minimum Expectations

60-69% D

Fair

70-79% C

Proficient

80-89% B

Exemplary

90-100% A

1a.
Provide an executive overview that explains the benefits and current trends
of data warehousing and data mining.

Weight:
10%

Did
not submit or incompletely provided an executive overview that explained the
benefits and current trends of data warehousing and data mining.

Insufficiently
provided an executive overview that explained the benefits and current trends
of data warehousing and data mining.

Partially
provided an executive overview that explained the benefits and current trends
of data warehousing and data mining.

Satisfactorily
provided an executive overview that explained the benefits and current trends
of data warehousing and data mining.

Thoroughly
provided an executive overview that explained the benefits and current trends
of data warehousing and data mining.

1b.
Provide an executive overview that provides two (2) examples of quality
companies successfully using a data warehouse to support your answer.

Weight:
10%

Did
not submit or incompletely provided an executive overview that provided two
(2) examples of quality companies successfully using a data warehouse to
support your answer.

Insufficiently
provided an executive overview that provided two (2) examples of quality
companies successfully using a data warehouse to support your answer.

Partially
provided an executive overview that provided two (2) examples of quality
companies successfully using a data warehouse to support your answer.

Satisfactorily
provided an executive overview that provided two (2) examples of quality
companies successfully using a data warehouse to support your answer.

Thoroughly
provided an executive overview that provided two (2) examples of quality
companies successfully using a data warehouse to support your answer.

1c.
Provide an executive overview that outlines the architecture, models, and
views used in the data warehouse.

Weight:
10%

Did
not submit or incompletely provided an executive overview that outlined the
architecture, models, and views used in the data warehouse.

Insufficiently
provided an executive overview that outlined the architecture, models, and
views used in the data warehouse.

Partially
provided an executive overview that outlined the architecture, models, and
views used in the data warehouse.

Satisfactorily
provided an executive overview that outlined the architecture, models, and
views used in the data warehouse.

Thoroughly
provided an executive overview that outlined the architecture, models, and
views used in the data warehouse.

2.
Discuss optimization techniques specific to data warehousing and data mining.

Weight:
10%

Did
not submit or incompletely discussed optimization techniques specific to data
warehousing and data mining.

Insufficiently
discussed optimization techniques specific to data warehousing and data
mining.

Partially
discussed optimization techniques specific to data warehousing and data
mining.

Satisfactorily
discussed optimization techniques specific to data warehousing and data
mining.

Thoroughly
discussed optimization techniques specific to data warehousing and data
mining.

3.
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.

Weight:
20%

Did
not submit or incompletely recommended a solution for this scenario with
respect to software, hardware, and network requirements.

Insufficiently
recommended a solution for this scenario with respect to software, hardware,
and network requirements.

Partially
recommended a solution for this scenario with respect to software, hardware,
and network requirements.

Satisfactorily
recommended a solution for this scenario with respect to software, hardware,
and network requirements.

Thoroughly
recommended a solution for this scenario with respect to software, hardware,
and network requirements.

4.
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.

Weight:
25%

Did
not submit or incompletely created 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.

Insufficiently
created 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.

Partially
created 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.

Satisfactorily
created 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.

Thoroughly
created 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.

5.
3 references

Weight:
5%

No
references provided

Does
not meet the required number of references; all references poor quality
choices.

Does
not meet the required number of references; some references poor quality
choices.

Meets
number of required references; all references high quality choices.

Exceeds
number of required references; all references high quality choices.

6.
Clarity, writing mechanics, and formatting requirements

Weight:
10%

More
than 8 errors present

7-8
errors present

5-6
errors present

3-4
errors present

0-2
errors present

ScholarMatic: Explanation & Answer

Your ready answer from a verified tutor is just a click away for as little as $14.99


  

Click Order Now to get 100% Original Answer Customized to your instructions!

HOME TO CERTIFIED WRITERS

Why Place An Order With Us?

  • Certified Editors
  • 24/7 Customer Support
  • Profesional Research
  • Easy to Use System Interface
  • Student Friendly Pricing

Have a similar question?

PLAGIRAISM FREE PAPERS

All papers we provide are well-researched, properly formatted and cited.

TOP QUALITY

All papers we provide are well-researched, properly formatted and cited.

HIGHLY SECURED

All papers we provide are well-researched, properly formatted and cited.

ScholarMatic: Get Started

Assignment Writing Service

Feel safe and secure when placing an order on our portal!
Fruitful cooperation begins with solid guarantees, and we are professional enough to promise perfect results. Let’s get it started!