Design and implementation of public data warehouse

There is a large amount of public data available that is spread across various sources. However, these public data is spread across different government bodies’ websites and repository platforms. Data must be collected and stored in a warehouse for utilization. Hence, this research is conducted to design and implement an appropriate data warehouse that is able to merge all public data from different government bodies and public websites in one data warehouse. This research started by locating relevant sources from various open data platforms such as Public Info Banjir and the Official Portal iDengue for community version 3.0. Then, significant data were collected such as river water level data, rainfall data, dengue locality cases and weather data. A public data warehouse was constructed using the bottom-up approach of the Kimball methodology. Following this, a galaxy schema model was identified to design the fact and dimension tables, which is then converted into a logical model. Finally, the structured data warehouse was developed. The public data warehouse, containing data such as water level, rainfall, dengue locality cases and weather data will be of great benefit to both government bodies and the public. For future study, the data warehouse enables the development of advanced analytics and predictive models, which helps to enhance decision-making and optimize infrastructure management in relation to flood mitigation efforts.