|
|
Author: sukumar Natarajan
 |
Total Articles: 1 |
Total Views: 1081
City: Thanjavur |
State: Tamilnadu
About Me: |
Articles by sukumar Natarajan:
-
Tha Basic Concepts of Data Warehousing
Data warehouse is a process for assembling and managing data from various sources for the purpose of gaining of the single detailed view of an enterprise. The primary aims in building a data warehouse are to provide a single version of the truth about the enterprise information and to provide good performance for enterprise analysis to manipulate, animate and synthesize enterprise information. It may be a central enterprise-wide data warehouse for use by all the decision makers in the enterprise or it may consist of a number of smaller data warehouses is often called Data marts or Local data warehouse. A data warehouse is a place for, whereas data warehousing describes the process of defining, populating, and using a data warehouse. A data warehouse may be built as a centralized, a data warehouse with data marts is a distributed data warehouse depending on needs of an enterprise. On the other-hand, it is suitable for a large international organization with offices in several countries. Data warehousing is a relatively new technology that involves a number of steps. Data warehouses and on-line analytical processing (OLAP) tools have become essential elements of decision support systems. Traditionally, data warehouses are refreshed periodically by extracting, transforming, cleaning and consolidating data from several operational data sources. The data in the warehouse is then used to generate reports, or to rebuild multidimensional (data cube) views of the data for on-line querying and analysis.
- Category:
Technology
|
|
