An Optimal Warehouse Design for Crime Dataset
International Journal of Advanced Trends in Computer Science and Engineering · 2020
Data science and analytics represent one of the most emerging fields nowadays.Collecting, storing and analyzing the data are challenging issues in the field since they require the most advanced techniques and technologies.Data Warehouse and Data Marts represent some solutions for collecting, storing and accessing the data.Good Warehouse design leads to better analysis results.Among different application fields of the data, crime data is an important and complex discipline that contains a number of complex relationships between its contents, a wide range of applications and its crucial importance.The aim of the work in this paper is building an optimal Data warehouse for crime dataset using real crime data collected from the internet.Among the different DW modules available in this field galaxy module is used in this work.The data warehouse will support the decision-making process for lawmaker and police departments by understanding crime subjects, and statistics that allow them to track actions, foretell the probability of occurring crimes and efficiently use supplies which are inverted in this paper.The proposed design of the DW shows more reliability, better storing and accessing capabilities and lower anomalies among the other designs.The proposed design was supported with a crime database design to remove heterogonous of the data and to apply some preprocessing issues from which they require data is extracted, transformed and loaded (ETL) into the warehouse.Finally, more than six million high quality, clean, and preprocessed of crime records data are available for the researchers.