Data integration-a case study

Assignment Help Basic Computer Science
Reference no: EM131223030

Data Integration: A Case Study

Companies integrated their data to gain business insights and eliminate risks. While individual databases can answer specific questions and show the state of a business unit, this is sometimes insufficient to make an enterprise-wide decision. The integration of all the enterprise data allows a complete depiction of the current state of the enterprise. Each case is unique, but the integration of data must provide cost-effective extraction and make transformation and flow of data between sources throughout the organization similar. When integrating data, you must pay careful attention to completeness, latency, accuracy, management, and ownership.

According to the case study, Teradata needs to prioritize its research and development commitments. In order to do this they must have all the information available and accurate. This requires integrating data from many sources both internal and external.

For this Discussion, consider and answer each of the following questions:

  1. Into which logical subject areas should the data be grouped? Consider the subject areas (customer, product, order) used for the Wheeler case described in your reading and determine a similar set of subject areas required for Teradata.
  2. Can your subject areas be considered independent components, thus allowing a single process for data integration to be defined? That is, if you define an ETL process for one subject area, can it be used for all?
  3. Is the data clean? At what point will you validate the quality of the data?
  4. How frequently must the data be loaded into the data warehouse? Is it the same for each component?

Reference no: EM131223030

Questions Cloud

What is the weighted average cost of debt : HI5002 Finance for Business -  What is the weighted average cost of debt for Harvey Norman using the book-value weights and the market-value weights? Does it make a difference in this case if you use book-value weights or market-value weights?
Determine the effective interest rate : Devon Harris Company sells 10% bonds having a maturity value of $2,741,000 for $2,543,396. The bonds are dated January 1, 2014, and mature January 1, 2019. Interest is payable annually on January 1. Determine the effective interest rate:
What is a practical defense against the worm you cited : 1. If you were a malware designer, would you rather use TCP or UDP to distribute a malicious payload and why? 2. Give an example of an Internet worm. What vulnerability does the worm you cited exploit? What were the attack effects of the worm you c..
Unrealized gain-loss are reflected on the balance sheet : If the company’s intention is to turn around the investment and generate a short term profit, then this is considered the asset is a srading Security and is reflected on the Income Statement; unrealized gain/loss are reflected on the Balance Sheet as..
Data integration-a case study : Companies integrated their data to gain business insights and eliminate risks. While individual databases can answer specific questions and show the state of a business unit, this is sometimes insufficient to make an enterprise-wide decision. The ..
Assess this tax structure using diamond-merles production : The value-added tax system requires all goods to be sold at a price that includes tax. Any firm purchasing a good to use as an input can reclaim the tax it has paid. Assess this tax structure using the Diamond-Merles Production Exigency Lemma.
Choosing a data integration type : In the Application Assignment in Unit 2, you created a database for your small retail store. Though business has been good, you decide to merge your company with another small store to lower prices and increase sales.
Can decisions be made without considering ethical issues : In your own mind, does ethics frame, shape, guide or serve as the baseline to good decision making? Can decisions be made without considering ethical issues? If so when and why?
Complete optimal solution to linear programming problem : Find the complete optimal solution to this linear programming problem. Graph to show each constraint and the feasible region. Provide graph on separate page. What is the optimal value of the objective function?

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Main topics and issues

If Susan chooses a client/server architecture, what issues must she consider? Prepare a checklist for her that includes the main topics and issues she should consider.

  Explain distributed file system

Explain Distributed File System (DFS) and give its key processes. Please reply as soon as possible?

  Implement a class of min heaps using an array

Implement a class of min heaps using an array. Name your class Array Min Heap.

  Describe the manner in which to protect virtual networks

Describe the manner in which to protect virtual networks, including software-based switches and network configurations, which are part of the virtual environment and allow virtual machines on the same host to communicate efficiently within a data ..

  Limitations of cloud computing

Provide your opinion on whether or not a non-Apple device user should have the ability to use iCloud. Explain whether or not this points to the limitations of cloud computing. Determine whether businesses should consider iCloud in their cloud comp..

  Performance improvement models

Analyze one performance improvement model, such as plan-do-check-act, rapid cycle improvement, Six Sigma, or benchmarking. In your assignment, discuss the following:

  Find an encryption utility onyour system

Read its documentation and experiment with it. Measure how fast it is able to encrypt and decrypt data. Are these two rates the same? Try to compare these timing results using different key sizes; for example, compare single-DES with triple-DES.

  What presentation issues on this machine have to be addresse

What presentation issues on this machine have to be addressed for it to exchange integer and string data with the rest of the world

  Write a c program that swaps the first column of a matrix

Write a C program that swaps the first column of a matrix with the last column

  Executive brief on writing secure software or j2ee

Create a PowerPoint presentation on Writing Secure Software, or J2EE for your supervisor. Your supervisor wants you to present information to the top level executives as it relates to securing the company's web-based applications that generate rev..

  What you understand by knowledge management

Define software project team management in your own words. What motivation techniques are available to motivate the project team? Explain in brief what you understand by knowledge management.

  Perform insert using binomial queues

Give an algorithm to build a binomial queue of N elements, using at most N - 1 comparisons between elements.  Propose an algorithm to insert M nodes into a binomial queue of N elements in O(M + log N) worst-case time. Prove your bound. Write an ef?ci..

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