Purchase Solution

Data warehouse and business intelligence

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution

Solution Summary

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

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 provided by:
Education
  • Associates of Arts , Lone Star Community College
  • Bachelor of Science , Sam Houston State University
  • Masters of Science, Kaplan University
  • Masters of Science , Kaplan University
Recent Feedback
  • "Thank you however I have two questions: 1.) where in this passage is the actual problem statement? 2.) if you used references can you please provide them? This is great work and I am so grateful. "
  • "Thank you very much"
  • "excellent analysis"
  • "graet job very helpful"
  • "Thank you, excellent and very detailed."
Purchase this Solution


Free BrainMass Quizzes
Early Childhood Developmental Milestones

Recognizing early childhood developmental milestones in the five capacities (cognitive, communication, social-emotional, adaptive, and physical development) is important for any person who will be working with children. Reminder: Children are individuals. This information is a generally accepted guide of expected development, but some infants may progress faster or slower.

DIR/Floortime Model for Education Introduction

This brief quiz will provide a basic overview of the DIR/Floortime Model. Understanding this model is important for teachers, therapists, parents, and caregivers.

Interview Questions Prospective Teachers Should Consider

Teacher candidates might consider these questions before application and interviews.

Autism

Do you know all about autism? Find out with this quiz.

DIR/Floortime Model for Therapy

This quiz provides a brief introduction to the DIR/Floortime Model for therapy. This process focuses on meeting a child at his or her developmental level and then extending learning.