Explore BrainMass
Share

Data warehouse and business intelligence

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Data warehouse and business intelligence

In preparing a response, you may wish to think about questions such as:

What are the differences among database and data warehouse?
What are the data warehouse technologies?
Relationship between data warehouse and business intelligence

© BrainMass Inc. brainmass.com October 25, 2018, 7:54 am ad1c9bdddf
https://brainmass.com/education/learning-teaching/data-warehouse-business-intelligence-519517

Solution Preview

BUILDING AND EVOLVING DATA WAREHOUSING AND BUSINESS INTELLIGENCE ARTEFACTS: THE CASE OF SYSCO. By: O'Leary, Daniel E. Intelligent Systems in Accounting, Finance & Management. Oct-Dec2011, Vol. 18 Issue 4, p195-213. 19p
http://www.exforsys.com/tutorials/data-warehousing/how-does-a-data-warehouse-differ-from-a-database.html
What are the differences among database and data warehouse?

Fundamental differences exist between data warehouses and databases. The most fundamental difference is that databases emphasize a single application with this application typically predicated upon transactions. When and if data is analyzed, it will be done within a single domain or multiple domains. Databases include separate units such as payroll and inventory with each system focusing upon one subject and these systems do not deal with other areas. This is the significant difference that separates data warehouses from databases as they deal with multiple domains simultaneously.

The data warehouse can find connections between multiple subject areas because it deals with multiple applications simultaneously. Therefore, as opposed to databases, the data warehouse can detail how a company is performing as a whole giving a complete picture of the entire operational system as opposed to individual systems being assessed with databases. The data warehouse also has the capability to support the analysis of trends, and data warehouses are not volatile. Therefore, information that is stored in data warehouses doesn't change as much as that stored in common databases. Because it deals with multiple subject areas, the data warehouse finds connections between them. This allows the data warehouse to show how the company is performing as a ...

Solution Summary

The expert prepares a response for data warehouse and business intelligence.

$2.19
See Also This Related BrainMass Solution

Using Twitter to Gain Business Intelligence

Do you agree that a business can use Twitter to gain business intelligence? How many companies do you think are aware of Twitter and exactly how they can use it to gain BI? How do you think Twitter uses a data warehouse? How do you think companies store Twitter information? How would a company use Twitter in a data mart? How would a company use cubes to analyze Twitter data?

this just about 350 words

View Full Posting Details