by admin | Jun 7, 2015 | sem3
data warehousing architecture In this chapter, we will discuss the business analysis framework for the data warehouse design and architecture of a data warehouse. Business Analysis Framework The business analyst get the information from the data warehouses to measure...
by admin | Jun 7, 2015 | sem3
data warehouse system processes We have a fixed number of operations to be applied on the operational databases and we have well-defined techniques such as use normalized data, keep table small, etc. These techniques are suitable for delivering a solution. But in case...
by admin | Jun 7, 2015 | sem3
data warehousing delivery process A data warehouse is never static; it evolves as the business expands. As the business evolves, its requirements keep changing and therefore a data warehouse must be designed to ride with these changes. Hence a data warehouse system...
by admin | Jun 7, 2015 | sem3
data warehousing terminologies In this chapter, we will discuss some of the most commonly used terms in data warehousing. Metadata Metadata is simply defined as data about data. The data that are used to represent other data is known as metadata. For example, the...
by admin | Jun 7, 2015 | sem3
data warehousing concepts What is Data Warehousing? Data warehousing is the process of constructing and using a data warehouse. A data warehouse is constructed by integrating data from multiple heterogeneous sources that support analytical reporting, structured and/or...
by admin | Jun 7, 2015 | sem3
Data Warehouse Applications Data Warehouse Applications As discussed before, a data warehouse helps business executives to organize, analyze, and use their data for decision making. A data warehouse serves as a sole part of a plan-execute-assess...
