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

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

Author(s): Harco Leslie Hendric Spits Warnars, Laurens Spits Warnars, Arief Ramadhan, Teddy Siswanto, Antoine Doucet
Subject(s): Environmental interactions
Published by: UIKTEN - Association for Information Communication Technology Education and Science
Keywords: Data warehouse fire department; Data warehouse firefighters; data warehouse fire brigade; fact constellation fire department; Fact constellation firefighters

Summary/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.

  • Issue Year: 13/2024
  • Issue No: 1
  • Page Range: 365-376
  • Page Count: 12
  • Language: English
Toggle Accessibility Mode