Explain the benefits and current trends of data warehousing

Assignment Help Database Management System
Reference no: EM13332299

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:

a. Explain the benefits and current trends of data warehousing and data mining.

b. Provide two (2) examples of quality companies successfully using a data warehouse to support your answer.

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

Reference no: EM13332299

Questions Cloud

What is the velocity of the combined system of two wagons : Wile E. Coyote and the Roadrunner are fictional cartoon characters. The premise of the cartoon is that Wile E. Coyote unsucessfully tries to catch the very fast, What is the velocity of the combined system of two wagons
Inspirational leader in your selected organization : Who is the most inspirational leader in your selected organization? What are the particular leadership characteristics that make them inspirational? In general, are the leaders of your selected organization trusted? If so, how have they developed tha..
Explain and begin precipitation of baf2 : Hello everyone, I was wondering if someone could assist me in this problem. The problems says "We have 500 mL of a solution with Ba^(2+)=0.10M. How many grams of LiF must be added to begin precipitation of BaF2
Find with what minimum average speed must he move : The lob in tennis is an effective tactic when your opponent is near the net. It consists of lofting the ball over his head, forcing him to move quickly away from the net, With what minimum average speed must he move
Explain the benefits and current trends of data warehousing : Summarize the difference between online transaction processing (OLTP) and online analytic processing (OLAP), and their relationship among business intelligence, data warehousing, and data mining.
Explain the reactant side of the total ionic equation : Given the reactant side of the total ionic equation for the neutralization reaction of potassium hydroxide KOH with hydrochloric acid HCl, write the total ionic equation
Determine her initial velocity both magnitude and direction : A diver springs upward from a board that is three meters above the water. Determine her initial velocity, both magnitude and direction
Describe some of the potential abuses marketers : Describe some of the potential abuses marketers could make of their understanding of customer buyer behavior. What is the marketer's ethical responsibility with respect to these opportunities for abuse?
Explain raising the temperature of the container : Assume that you have 1.65g of nitroglycerin in a 614.0 mL steel container at 20.0 C and 1.00 atm pressure. An explosion occurs, raising the temperature of the container and its contents to 425 C

Reviews

Write a Review

 

Database Management System Questions & Answers

  Create the primary key and foreign keys using a uml class

In order to move forward, the local university will need to develop a data model that will retain student records and perform various data extract transform and load (ETL) processes.

  Create a use case diagram for osceolas operations

Use MS Visio to create a use case diagram for question 1, a selected class diagram for question 2, and a sequence diagram for question 3.

  Explain issues to convert relationship for new cardinality

Using example of vehicles and drivers, explain issues to convert relationship for new cardinality including new relationships and attributes for the tables.

  Explain normal form is denormalized table

Which field or fields cause a table to no longer be in third normal form? In which normal form is denormalized table?

  Write problems and issues related with internet databases

Write down some of problems and issues related with internet databases? Consider security, performance, architecture issues.

  Create a database.

Create a database.

  Write names and e-mail addresses from database

Suppose a database has tables given below. Write the names and e-mail addresses for all customers who have had stove repair which cost more than $50.

  Implementation of virtual private databases

SQL implements VPD using the VIEW object while Oracle10g provides specific functions for row-level security and fine-grained access.

  Hsada systems analysis and design

Determine and confirm client business expectations and needs and determine and apply appropriate development methodologies

  Compare and contrast the advantages of servlets of cgi

Describe the following CLI's and Database Gateways and Describe their architecture, components and challenges.

  Construct a query that can be used on a report

Construct a query that can be used on a report for determining how many days the customer's invoice will require payment if total amount due is within 45 days. Provide a copy of your working code as part of the paper.

  What is required to define a well-posed learning problem

Write an algorithm called \Find-G" to nd a maximally-general consistent hypothesis. You can assume the data will be noise-free and that the target concept is in the hypothesis space.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd