Assignment 3 Business Intelligence and Data Warehouses

752 Words Nov 22nd, 2015 4 Pages
August 29, 2015 Business Intelligence and Data Warehouses

Student’s name:
Professor’s name:
Course title:

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
…show more content…
So, these two data are very different form each other. Difference between these are as follows: * Operational Database represent transaction while decision support data are snapshot of operational data at a given point of time. * Both are different in transaction type and transaction volume. * The degree of summarization in decision support data is very higher than operational data. * Decision support data are characterized by very large amounts of data in comparison to operational data.
3. Three examples in which databases could be used to support decision making in a large organizational environment
There are many example in which databases could be used to support decision making in a large organizational environment. Some of these examples are as follows: * Support decision making must be used large organizational environment. There is real time example of support decision making techniques is Facebook. Facebook has central database server which is divided into many small -2 database server. These sever will helps central server to process relative data and decisions to get correct result and fast result. * It is also used some big organization which are globally expand. It will used to help managers to get results with regions and then they can compared these support data with other regions to make decision which one is productive. So, it will help manager to take right decision on the basis facts. * It helps to make
Open Document