Assignment 3: Business Intelligence and Data Warehouses
Assignment 3: Business Intelligence and Data Warehouses
Due Week 9 and worth 100 points
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:
Your assignment must follow these formatting requirements:
The specific course learning outcomes associated with this assignment are:
Click here to view the grading rubric for this assignment.
Assignment 3: Business Intelligence and Data Warehouses
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...Assignment 3: Business Intelligence and Data Warehouses
1. Differences between the structures of a relational database optimized for online transactions versus a data warehouse optimized for processing and summarizing large amounts of data Data Warehouse is a database which is designed to process for query and analysis rather than for transaction processing, and it is usually contains historical data derived from transaction data, but can include data from other sources while relational database optimized for online transaction which includes insertions, updates and deletion. Basically Data Warehouse is defined as a subject-oriented, non-volatile and time –variant collection of database which support management’s decisions. Data Warehouse is very distinct from online transaction systems. Some of distinctions are given below: One of main difference, a data warehouse you can do separate analysis workload form transaction workload which makes it very much read-oriented systems. They deal higher amount of volume in comparisons to online transaction database. They have a far higher amount of data reading versus writing and updating. This enables far better analytical performance and avoids impacting your transaction systems. A data warehouse system can ...
A+ - Thank you!
Thanks for the positive feedback!