Designing a Data Warehouse for Cyber Crimes
 

Il-Yeol Song
College of Information Science and Technology
Drexel University
song@drexel.edu

John D. Maguire
College of Information Science and Technology
Drexel University

Ki Jung Lee
College of Information Science and Technology
Drexel University

Namyoun Choi
College of Information Science and Technology
Drexel University

Xiaohua Hu
College of Information Science and Technology
Drexel University

Peter Chen
Department of Computer Science
Louisiana State University

ABSTRACT

One of the greatest challenges facing modern society is the rising tide of cyber crimes. These crimes, since they rarely fit the model of conventional crimes, are difficult to investigate, hard to analyze, and difficult to prosecute. Collecting data in a unified framework is a mandatory step that will assist the investigator in sorting through the mountains of data. In this paper, we explore designing a dimensional model for a data warehouse that can be used in analyzing cyber crime data. We also present some interesting queries and the types of cyber crime analyses that can be performed based on the data warehouse. We discuss several ways of utilizing the data warehouse using OLAP and data mining technologies. We finally discuss legal issues and data population issues for the data warehouse.