Data Warehouse
According to VISUAL-BASIC.NET (2001), a data warehouse is a collection of data marts representing historical data from different operations in the company.
BENEFITS
VISUAL-BASIC.NET (2001) mentioned few of the benefits of creating a data warehouse as follows:
1. Data warehouses are designed to perform well with aggregate queries running on large amounts of data
2. The structure of data warehouses is easier for end users to navigate, understand and query against unlike the relational databases primarily designed to handle lots of transactions
3. Data warehouses enable queries that cut across different segments of a company's operation. E.g. production data could be compared against inventory data even if they were originally stored in different databases with different structures
4. Queries that would be complex in very normalized databases could be easier to build and maintain in data warehouses, decreasing the workload on transaction systems
5. Data warehousing is an efficient way to manage and report on data that is from a variety of sources, non uniform and scattered throughout a company
6. Data warehousing is an efficient way to manage demand for lots of information from lots of users
7. Data warehousing provides the capability to analyze large amounts of historical data for nuggets of wisdom that can provide an organization with competitive advantage
This article provides other terms related to data warehouse by VISUAL-BASIC.NET.
Need for Data Warehouse?
Despite the benefits that a data warehouse give, not all organizations will need to create one. Gary Holmes (2001) mentioned that organizations may want to ask themselves some of the questions such as: Is building a data analysis system an appropriate use of scarce resources in a soft economy? Does your organization have the experience to do it successfully? These questions will be answered differently by each organization.
He continued that if one could increase revenue, cut costs, or improve your market position by using data analysis capabilities, an investigation is certainly justified.
This article will shows more about implementing a successful data warehouse by Gary Holmes.
To add on, this article (Four Ways to Build a Data Warehouse) shows the 4 approaches in building a data warehouse. It also mentioned about the benefits and downside of each of the approaches.
Online Analytical Processing (OLAP)
Found this image from MicroStrategy website about OLAP. I thought it was pretty clear and easy to understand.
According to VISUAL-BASIC.NET (2001), a data warehouse is a collection of data marts representing historical data from different operations in the company.
BENEFITS
VISUAL-BASIC.NET (2001) mentioned few of the benefits of creating a data warehouse as follows:
1. Data warehouses are designed to perform well with aggregate queries running on large amounts of data
2. The structure of data warehouses is easier for end users to navigate, understand and query against unlike the relational databases primarily designed to handle lots of transactions
3. Data warehouses enable queries that cut across different segments of a company's operation. E.g. production data could be compared against inventory data even if they were originally stored in different databases with different structures
4. Queries that would be complex in very normalized databases could be easier to build and maintain in data warehouses, decreasing the workload on transaction systems
5. Data warehousing is an efficient way to manage and report on data that is from a variety of sources, non uniform and scattered throughout a company
6. Data warehousing is an efficient way to manage demand for lots of information from lots of users
7. Data warehousing provides the capability to analyze large amounts of historical data for nuggets of wisdom that can provide an organization with competitive advantage
This article provides other terms related to data warehouse by VISUAL-BASIC.NET.
Need for Data Warehouse?
Despite the benefits that a data warehouse give, not all organizations will need to create one. Gary Holmes (2001) mentioned that organizations may want to ask themselves some of the questions such as: Is building a data analysis system an appropriate use of scarce resources in a soft economy? Does your organization have the experience to do it successfully? These questions will be answered differently by each organization.
He continued that if one could increase revenue, cut costs, or improve your market position by using data analysis capabilities, an investigation is certainly justified.
This article will shows more about implementing a successful data warehouse by Gary Holmes.
To add on, this article (Four Ways to Build a Data Warehouse) shows the 4 approaches in building a data warehouse. It also mentioned about the benefits and downside of each of the approaches.
Online Analytical Processing (OLAP)
Found this image from MicroStrategy website about OLAP. I thought it was pretty clear and easy to understand.
2 different OLAP analysisI have learnt from this week lecture about types of dimension (Parent-child, Type 1, Type 2 and Type 3), designing of a data warehouse by choosing the right schema, steps in designing the data warehouse and different types of OLAP.
No comments:
Post a Comment