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 d...
| Main Authors: | , , |
|---|---|
| Format: | Conference or Workshop Item |
| Language: | English English |
| Published: |
AIP Publishing
2024
|
| Subjects: | |
| Online Access: | http://umpir.ump.edu.my/id/eprint/42515/1/030009_1_5.0213934.pdf http://umpir.ump.edu.my/id/eprint/42515/7/Design%20and%20Implementation%20of%20Public%20Data%20Warehouse%20-Intro.pdf |
| _version_ | 1825815893939060736 |
|---|---|
| author | Nurul Farhanah, Isha Nor Azuana, Ramli Qistina Batrisyia, Azman Shah |
| author_facet | Nurul Farhanah, Isha Nor Azuana, Ramli Qistina Batrisyia, Azman Shah |
| author_sort | Nurul Farhanah, Isha |
| collection | UMP |
| description | 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. |
| first_indexed | 2024-09-25T03:52:52Z |
| format | Conference or Workshop Item |
| id | UMPir42515 |
| institution | Universiti Malaysia Pahang |
| language | English English |
| last_indexed | 2024-09-25T03:52:52Z |
| publishDate | 2024 |
| publisher | AIP Publishing |
| record_format | dspace |
| spelling | UMPir425152024-09-06T07:30:47Z http://umpir.ump.edu.my/id/eprint/42515/ Design and implementation of public data warehouse Nurul Farhanah, Isha Nor Azuana, Ramli Qistina Batrisyia, Azman Shah QA75 Electronic computers. Computer science 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. AIP Publishing 2024 Conference or Workshop Item PeerReviewed pdf en http://umpir.ump.edu.my/id/eprint/42515/1/030009_1_5.0213934.pdf pdf en http://umpir.ump.edu.my/id/eprint/42515/7/Design%20and%20Implementation%20of%20Public%20Data%20Warehouse%20-Intro.pdf Nurul Farhanah, Isha and Nor Azuana, Ramli and Qistina Batrisyia, Azman Shah (2024) Design and implementation of public data warehouse. In: AIP Conference Proceedings. 4th International Conference On Applied & Industrial Mathematics and Statistic 2023 (ICoAIMS 2023): Mathematics and Statistics for Technological Society , 22–24 August 2023 , Pahang, Malaysia. pp. 1-10., 3128 (030009). ISBN 978-0-7354-4957-2 (Published) https://doi.org/10.1063/5.0213934 |
| spellingShingle | QA75 Electronic computers. Computer science Nurul Farhanah, Isha Nor Azuana, Ramli Qistina Batrisyia, Azman Shah Design and implementation of public data warehouse |
| title | Design and implementation of public data warehouse |
| title_full | Design and implementation of public data warehouse |
| title_fullStr | Design and implementation of public data warehouse |
| title_full_unstemmed | Design and implementation of public data warehouse |
| title_short | Design and implementation of public data warehouse |
| title_sort | design and implementation of public data warehouse |
| topic | QA75 Electronic computers. Computer science |
| url | http://umpir.ump.edu.my/id/eprint/42515/1/030009_1_5.0213934.pdf http://umpir.ump.edu.my/id/eprint/42515/7/Design%20and%20Implementation%20of%20Public%20Data%20Warehouse%20-Intro.pdf |
| work_keys_str_mv | AT nurulfarhanahisha designandimplementationofpublicdatawarehouse AT norazuanaramli designandimplementationofpublicdatawarehouse AT qistinabatrisyiaazmanshah designandimplementationofpublicdatawarehouse |