Designing data warehouses for supply chain management

Data warehouses are used to support subject-oriented decision-making in a company. When a company joins a supply chain partnership to increase competitiveness, its data warehouse has to be re-designed. The design of data warehouses for supply chain partners has to take into account issues such as data schemas, duplication of data, data security, and homogeneity of data warehouses. This study proposes five approaches to designing data warehouses for supply chain partners: (I) a centralized data warehouse, (2) a coordinated data warehouse, (3) a distributed data warehouse, (4) a federated data warehouse, and (5) a heterogeneous data warehouse. Each approach has different features and provides a high level of data security.