The Development of Data Warehouse to Support Data Mining Technique for Traffic Accident Prediction

Abstract

Traffic accidents are one of the major health problems that cause serious death in the world and ranks 9th in the world. Traffic accidents in Indonesia ranks 5th in the world. One effort to improve traffic safety is to design traffic accident prediction models. Prediction models will utilize accident-related data in traffic through data mining processing. The data warehouse offers benefits as a basis for data mining. Building an effective data warehouse requires knowledge and attention to key issues in database design, data acquisition and processing, as well as data access and security. This study is the first step in the development of data mining accidents based prediction system. The output of this initial stage is the design of data warehouses that can provide periodic and incidental data to the data mining process, especially in the prediction of accidents. The method used to design data warehouse is Entity Relationship Diagram (ERD).