Vol.13, No.1, February 2024.                                                                                                                                                                               ISSN: 2217-8309

                                                                                                                                                                                                                        eISSN: 2217-8333

TEM Journal

TECHNOLOGY, EDUCATION, MANAGEMENT, INFORMATICS

Association for Information Communication Technology Education and Science

Data Warehouse Design for Firefighters Operational at the DKI Jakarta Fire Department

Harco Leslie Hendric Spits Warnars, Laurens Spits Warnars, Arief Ramadhan, Teddy Siswanto, Antoine Doucet

© 2024 Svetlana Drobyazko, published by UIKTEN. This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 License. (CC BY-NC-ND 4.0)

Citation Information: TEM Journal. Volume 13, Issue 1, Pages 365-374, ISSN 2217-8309, DOI: 10.18421/TEM131-38, February 2024.

Received: 20 September 2023.

Revised:   29 December 2023.
Accepted: 19 January 2024.
Published: 27 February 2024.

Abstract:

This paper proposed two models of data warehouse schema for the fire department of DKI Jakarta, where the 1st model contains six tables consisting of 3 fact and 3-dimensional tables, and the 2nd model only contains three fact tables. The 2nd model denormalises the 1st model, where the number of tables is less than the 1st model, where at the end of the day, the 2nd model will reduce the join table process, which increases the SQL performances. These two models have been recognised as fact constellation schema with more than one fact table and sharing dimension and sub-dimension tables. The database resources were collected from http://data.jakarta.go.id under the Fire and Rescue Service Agency. Those two data warehouse schema models were developed based on a report sector list, a report on Hydrants list, and vehicle register reports. This paper proposes to support Automatic Identification Systems (AIS) research, particularly implementing the data warehouse concept.

Keywords –Data warehouse fire department, Data warehouse firefighters, data warehouse fire brigade, fact constellation fire department, Fact constellation firefighters.

-----------------------------------------------------------------------------------------------------------

Full text PDF >  

-----------------------------------------------------------------------------------------------------------