Reliant on large amounts of data for making

Assignment Help Business Management
Reference no: EM13918416

Businesses today are extremely reliant on large amounts of data for making intelligent business decisions. Likewise, the data warehouses are often structured in a manner that optimizes processing large amounts of data.

Write a two to three (2-3) page paper in which you:

1. Outline the main differences between the structure of a relational database optimized for online transactions versus a data warehouse optimized for processing and summarizing large amounts of data.

2. Outline the main differences between database requirements for operational data and for decision support data.

3. Describe three (3) examples in which databases could be used to support decision making in a large organizational environment.

4. Describe three (3) examples in which data warehouses and data mining could be used to support data processing and trend analysis in large organizational environment.

5. Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

 

1. Outline the main differences between the structure of a relational database optimized for online transactions versus a data warehouse optimized for processing and summarizing large amounts of data.

 

Optimization

 

Optimized for performing read-write operations of single point transactions. An OLTP database should deliver sub-second response times. Performing large analytical queries on such a database is a bad practice, because it impacts the performance of the system for clinicians trying to use it for their day-to-day work. An analytical query could take several minutes to run, locking all clinicians out in the meantime.

 

Optimized for efficiently reading/retrieving large data sets and for aggregating data. Because it works with such large data sets, an OLAP database is heavy on CPU and disk bandwidth. A data warehouse is designed to handle large analytical queries. This eliminates the performance strain that analytics would place on a transactional system.

 

Data Organization

 

An OLTP database structure features very complex tables and joins because the data is normalized (it is structured in such a way that no data is duplicated). Making data relational in this way is what delivers storage and processing efficiencies-and allows those sub-second response times.

 

In an OLAP database structure, data is organized specifically to facilitate reporting and analysis, not for quick-hitting transactional needs. The data is de-normalized to enhance analytical query response times and provide ease of use for business users. Fewer tables and a simpler structure result in easier reporting and analysis.

 

Reference no: EM13918416

Questions Cloud

Should nations use strategic trade policies : Dynamics and complexity: Do free trade agreements create uncertainties for companies' operations?
Its debt is in the form of zero-coupon bonds : Ichinomiya Company has a total value of $54 million. Its debt is in the form of zero-coupon bonds, which will mature in 4 years. The face value of bonds is $15 million. The riskless rate is 3.15% at present. The σ of Ichinomiya is 0.42. Find the debt..
Determined the market value of the investment securities : The following transactions pertain to Glass Imports for 2013:
Find the number of shares outstanding : Okazaki Company has $40 million face value zero-coupon bonds due in 9.5 years, and its σ is 0.371. The total market value of Okazaki Company is $230 million and the riskless rate is 2.9%. The stock of the company sells at $32 per share. Find the numb..
Reliant on large amounts of data for making : Businesses today are extremely reliant on large amounts of data for making intelligent business decisions. Likewise, the data warehouses are often structured in a manner that optimizes processing large amounts of data.
Find the value of a european put option : Toyohashi Co common stock has market price $85 per share and its sigma is 0.30. Find the value of a European put option, with an exercise price of $75 and expiring after 110 days, on the Toyohashi stock. The riskless rate is 3.5%
Compare the assumptions underlying arbitrage pricing theory : Compare the assumptions underlying Arbitrage Pricing Theory with those underlying the mean-variance Capital Asset Pricing Model. Which set of assumptions seems more realistic to you? Why?
Consider dividend policy-stock repurchases and stock splits : Consider dividend policy, stock repurchases, and stock splits. Discuss how investors may react differently if their company issues dividends or announces a stock split or stock repurchase. Feel free to include examples to illustrate your point.
What is the present value of these acquired tax loss : In September, 2008, the IRS changed tax laws to allow banks to utilize the tax loss carry forwards of banks they acquire to shield their future income from taxes. what is the present value of these acquired tax loss carry forwards given a cost of cap..

Reviews

Write a Review

 

Business Management Questions & Answers

  Ready made new product concepts is

A good outside source of "Ready Made New Product Concepts" is

  Product structure - best practice

Strategy, product structure, best practice - explain what is the significance of naming the three categories of strategies

  How does the article relate to real world applications

Discuss how you will apply what you have learned from the article in a professional setting. How does the article relate to real world applications?

  Evaluate costco''s strategy in terms of pricing

Make a response to the questions below about Costco Wholesale, Deliberate and evaluate Costco's strategy in terms of pricing, product selection and marketing and advertising strategy.

  Identify types of staffing models that apply to scenario

Identify two types of staffing models that could apply to your chosen scenario and determine which model would be best suited for efficiency, productivity, and possible future growth.

  Generational differences in workforce

Generational Differences in the Workforce - Challenges to Overcome the Gap and employee Absenteeism: On the verge of understanding, controlling, and measuring it

  Illustrate what is the after-tax cost of new debt

Investors are expected to pay $1,100 for the 12-year bond. Porky will pay $50 per bond in flotation costs. Illustrate what is the after-tax cost of new debt if the organization is in the 35% tax bracket?

  Analyze this scenario from the standpoint of law and of ethi

Analyze this scenario from the standpoint of law and of ethics: For years, Dr. Eddingfield, a licensed physician, had been the Hurley family doctor. When Hurley became dangerously ill, he sent a messenger to Dr. Eddingfield, who told the doctor of Hu..

  Show organizational management categories

Help a creating an organizational recommendation based on these categories/areas:

  Financial statement reviewselect an american

financial statement reviewselect an american corporation.visit its website and download the income statement statement

  For serious students management1 do you think service

for serious students management1. do you think service technology is likely to have a different influence on

  An organization going through change.

Choose an article from a business magazine about an organization going through change.

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