Information and Knowledge Management www.iiste.org ISSN 2224-5758 (Paper) ISSN 2224-896X (Online) Vol.3, No.2, 2013 1 A Frame Work for Data Warehouse for Nigerian Police Force: A Way of Ensuring National Security Georgina N. Obunadike 1* Richard K. Tyokyaa 2 1. Department of Mathematical Sciences and IT, Federal University, Dutsin-ma, Katsina State, Nigeria. 2. Department of Mathematical Sciences and IT, Federal University, Dutsin-ma, Katsina State, Nigeria. * E-mail: nkoliobunadike@yahoo.com 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, 1. Introduction The Nigerian society is getting more and more insecure, more people are getting into crimes and they are getting more ruthless, desperate and sophisticated. In Nigeria of today especially 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. Public and private institutions are attacked and vandalized by gangs, even the United Nations building and the Nigerian Police Headquarters in Abuja were bombed and scores of people killed. Something needs to be done and that urgently. It is widely agreed that security should be the responsibility of all and sundry, not restricted to government, the Police force or security agencies (Otto and Ukpere, 2012). This work attempts to propose 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 and 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. Data warehousing is a collection of decision support technologies, aimed at enabling the knowledge worker (executive, manager, and analyst) to make better and faster decisions. The goal of data warehouses is to make the right information available at the right time. It involves bringing together disparate data from throughout an organization for decision-support purposes (Surajit and Dayal, 1997). The data warehouse concept was developed as IT professionals increasingly realized that the structure of data required for transaction reporting was significantly different from the structure required to analyze data. It was designed to contain summarized, historical views of data in production systems. This collection provides business users and decision-makers with a cross-functional, integrated, subject-oriented view of the enterprise. Data warehouse also known as OLAP (Online Analytical Processing), provides managerial users with meaningful views of past and present enterprise data. User-friendly formats, such as graphs and charts are frequently employed to quickly convey meaningful data relationships (Humphries, 1998). It is not possible to anticipate the information requirements of decision-makers for the simple reason that their needs depend on the business situation that they face. Decision-makers need to review enterprise data from different dimensions and at different levels of detail to find the source of a business problem before they can attack it. They likewise need information for detecting business opportunities to exploit (Humphries, 1998).