Scalable Distributed Data Warehouse System: Higher Educational Institutions Data Warehouse System

This study attempted to develop a data grid model for a distributed data warehouse using response time, throughput and bandwidth as major characteristics of the system. The model was simulated and evaluated. This was with a view to introducing the concepts of Service-Oriented Architecture (SOA), Web services and semantics into the development of distributed data warehouse. A distributed data warehouse model was formulated using SOA and Web services concept in order to implement the scalable data-grid model. This architecture was modelled as a Binary Tree model. The model was designed using Unified Modeling Language. An interface for the integration of the various data sources to the model was developed in Java Persistence API. The model Web services were created using Java and published using Web Services Description Language (WSDL). The system was simulated using Java programming language. The simulation parameters used in the design were number of clients (ranging from 100 to 1000), response time (measured in milliseconds), throughput and bandwidth consumption (measured in kilobits per seconds).