A Frame Work for Data Warehouse for Nigerian Police Force: A Way of Ensuring National Security

Abstract

Security is presently a major challenge in Nigeria today, Nigerians and non- Nigerians are killed on daily basis and in their numbers. Since the advent of the present democratic dispensation, new forms of violent crimes have become common; these include kidnapping for ransom, pipeline vandalization, Boko Haram bombings, rape, political violence and more. Though the government claims to be on top of the situation, the problem persists. This work attempts to propose a frame work for integration of criminal databases from different state police databases to form a data warehouse for easy access and analysis of criminal data for necessary actions. Data integration involves combining data residing in different sources to form a data warehouse there by providing users with a unified view of these data. Data Integration Technologies have experienced explosive growth in the last few years, and data warehousing has played a major role in the integration process.

Key words: National Security, Data integration, Data Warehousing, Star Schema, Data Mart