Title: Information versus intelligence: construction and analysis of an open source relational database of worldwide extremist activity

Authors: William C. Hale

Addresses: College of Criminal Justice, Sam Houston State University, Huntsville, TX 77341–2296, USA

Abstract: This study built and assessed the feasibility of an open source relational database capable of investigating 21st century terrorism. Data were collected over a two-year period from 1 January 2003 to 31 December 2004 and consisted of 7802 worldwide terrorist incidents. Although specific details about each incident were collected, analyses were primarily directed towards more general categories of variables, including the incident itself, geographical location, group involvement, individual involvement, and injuries and deaths. Although the literature on terrorism has grown exponentially since the 9/11 attacks, most of the research lacks a comprehensive database approach. This research, on the other hand, offers a more comprehensive approach through the identification of group and individual relationships, the ability to link a large number of variables, and provides the organisation and structure required to investigate valuable patterns and trends.

Keywords: terrorism; intelligence; open source information; OSINF; relational database; extremist activity; emergency management; information technology; group relationships; individual relationships; relational DBMS; terrorist incidents; information systems; information management; data mining; collaboration.

DOI: 10.1504/IJEM.2006.011297

International Journal of Emergency Management, 2006 Vol.3 No.4, pp.280 - 297

Published online: 14 Nov 2006 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article