information technology is the answer of the industrial world to the demand for data processing and communication facilities are fast and cheap (through space and time). Information technology can also be said as a technology related to data processing into information and the process of channelling the information within the boundaries of space and time. Data Warehouse is a collection of data that support management decision-making that has subject-oriented, integrated, time-variant and non-volatile. Data warehouses are a storage of historically oriented subject data organized to be accessible in a form ready for analysis.
Anatomy of Data Warehouse
Data warehouse consists of three basic types of systems, namely:
Functional Warehouse Data
The functional data warehouse is built on the information needs of each part of the company's business functions. Data warehouse functional is an approach used to build a data warehouse system with a low investment cost.
Centralized Warehouse Data
The centralized data warehouse is built from operational data collected in a data storage centre used by users to build their own functional Data Warehouse. Most organizations build and maintain a single centralized data warehouse environment. This arrangement makes sense for the following reasons:
Distributed Data Warehouse
Companies that have branches spread across the globe require information covering not only the local area but also the global territory. Global data warehouse requires integrated information from centralized data warehouse where information is collected. In addition, there is another need for separate data warehouses in each branch company. In this case, a distributed data warehouse is required. Three types of distributed data warehouses:
Anatomy of Data Warehouse
Advertisement
Functional Warehouse Data
The functional data warehouse is built on the information needs of each part of the company's business functions. Data warehouse functional is an approach used to build a data warehouse system with a low investment cost.
Centralized Warehouse Data
The centralized data warehouse is built from operational data collected in a data storage centre used by users to build their own functional Data Warehouse. Most organizations build and maintain a single centralized data warehouse environment. This arrangement makes sense for the following reasons:
- Data in integrated warehouses between companies and integrated images are used only at headquarters.
- The company operates on a centralized business model.
- The volume of data in the data warehouse is like a single centralized storage area.
- Although data can be integrated and distributed across diverse local areas, the data would be impractical to access.
Distributed Data Warehouse
Companies that have branches spread across the globe require information covering not only the local area but also the global territory. Global data warehouse requires integrated information from centralized data warehouse where information is collected. In addition, there is another need for separate data warehouses in each branch company. In this case, a distributed data warehouse is required. Three types of distributed data warehouses:
- Geographically distributed data warehouses comprise local data warehouses and global data warehouses.
- Data warehouses are distributed in many processors, logically there is one data warehouse but there are physically many data warehouses that are interconnected.
- Data warehouses that grow in uncoordinated sources.
No comments