An Efficient Approach for DW Design and DM in Crime Data Set
International Journal of Science and Research (IJSR)

International Journal of Science and Research (IJSR)
www.ijsr.net | Open Access | Fully Refereed | Peer Reviewed International Journal

ISSN: 2319-7064

Research Paper | Information Technology | Iraq | Volume 4 Issue 7, July 2015

An Efficient Approach for DW Design and DM in Crime Data Set

Kadhim B. S. Aljanabi

Data Warehouse (DW) represents the repository of data on which Data Mining (DM) techniques are applied to discover valuable knowledge. DM represents a wide range of tasks and techniques that represent the core of what is known as Knowledge Discovery in Database (KDD). Crime Analysis is an important application of DM, where data from different applications and sources are analyzed to extract and predict knowledge concerning crimes and criminals aiming to prevent and avoid crime occurrences. This paper presents a solution for DW design in three different models (Star, Snow flake and Galaxy) and a model for classifying the data sets related to crimes, offences and criminals aiming to predict some knowledge explaining the crimes trends, criminal groups, and related features. The result from this paper tends to help specialists in discovering patterns and trends, making forecasts, finding relationships and possible explanations, mapping criminal networks and identifying possible suspects. Different DW models were suggested since each model has its own advantages in data analysis by providing better mining algorithms performance. Data Mining techniques are used to analyze the logged data. One of the most common and effective DM technique is Classification. The classification is based mainly on grouping the crimes according to the type, location, time and other attributes, and grouping criminals according to their age, job, income, education, history and other attributes. Using different DW models showed efficient analysis process in both normalized and data reduction disciplines in both Snowflake and Galaxy DW models. Free data available on the Internet from some police departments are the source of the data about the crimes and the criminals and they were used to create and test the proposed framework, and then these data were preprocessed to get clean and accurate data using different preprocessing techniques (cleaning, missing values and removing inconsistency). The preprocessed data were stored in three different DW models to find out different crime and criminal classes, groups, and clusters. WEKA mining software and Microsoft Excel were used to analyze the given data. Decision Tree and Rule Base Algorithms were used for classifying and predicting the crimes, criminals and offences groups.

Keywords: Data Warehouse, Data Mining, Classification, Association, Clustering

Edition: Volume 4 Issue 7, July 2015

Pages: 328 - 333

Share this Article

How to Cite this Article?

Kadhim B. S. Aljanabi, "An Efficient Approach for DW Design and DM in Crime Data Set", International Journal of Science and Research (IJSR), https://www.ijsr.net/search_index_results_paperid.php?id=SUB156264, Volume 4 Issue 7, July 2015, 328 - 333

129 PDF Views | 111 PDF Downloads

Download Article PDF



Similar Articles with Keyword 'Data Warehouse'

Informative Article, Information Technology, Nigeria, Volume 2 Issue 4, April 2013

Pages: 468 - 473

A Superficial Expos of Data Warehousing: An Intrinsic Component of Modern Day Business Intelligence

Oyerinde, O.D, Adekunle, A. Y, Ebiesuwa, O.O

Share this Article

Research Paper, Information Technology, India, Volume 4 Issue 4, April 2015

Pages: 3141 - 3144

Interrelated Document Warehouse Report Visualization

V. Vivek, N. J. Subashini

Share this Article

Research Paper, Information Technology, Iraq, Volume 4 Issue 7, July 2015

Pages: 328 - 333

An Efficient Approach for DW Design and DM in Crime Data Set

Kadhim B. S. Aljanabi

Share this Article

Research Paper, Information Technology, Congo, Volume 6 Issue 9, September 2017

Pages: 905 - 908

A Conceptual Model for Multidimensional Data Intended for Decision-making in a Health/Medical Structure

Lobo Minga Bertin

Share this Article

Research Paper, Information Technology, India, Volume 8 Issue 2, February 2019

Pages: 1054 - 1058

Data Analyser GUI

Hardik Goel, Tushar Ahuja

Share this Article

Similar Articles with Keyword 'Data Mining'

Research Paper, Information Technology, India, Volume 4 Issue 4, April 2015

Pages: 1076 - 1079

Parallelizing Coherent Rule Mining Algorithm on CUDA

Aditya A. Davale, Shailendra W. Shende

Share this Article

Research Paper, Information Technology, India, Volume 3 Issue 5, May 2014

Pages: 1488 - 1491

Combined Mining Approach and Pattern Discovery in ?Online Shopping Application?

Kamble Jayshree Raghunath

Share this Article

Research Paper, Information Technology, India, Volume 3 Issue 5, May 2014

Pages: 1670 - 1673

Class Association Rules based Feature Selection for Diagnosis of Dravet Syndrome

B. Dwarakanath, Dr. K Ramesh Kumar

Share this Article

Research Paper, Information Technology, India, Volume 3 Issue 6, June 2014

Pages: 1654 - 1660

Privacy Preserving Protocol for Two-Party Classifier Over Vertically Partitioned Dataset Using ANN

Smitha Iddalgave, Sumana M

Share this Article

Research Paper, Information Technology, India, Volume 3 Issue 12, December 2014

Pages: 1896 - 1900

Determining and Exploring Dimensions in Subspace Clustering for Value Decomposition

Saranya Sagambari Devi.S

Share this Article

Similar Articles with Keyword 'Classification'

Review Papers, Information Technology, India, Volume 3 Issue 8, August 2014

Pages: 1720 - 1722

Particle Swarm Optimization- A Review on Algorithmic Rule, Application and Scope

Dr. G. M. Nasira, S. Radhimeenakshi

Share this Article

Research Paper, Information Technology, India, Volume 3 Issue 6, June 2014

Pages: 1654 - 1660

Privacy Preserving Protocol for Two-Party Classifier Over Vertically Partitioned Dataset Using ANN

Smitha Iddalgave, Sumana M

Share this Article

Review Papers, Information Technology, India, Volume 3 Issue 11, November 2014

Pages: 2450 - 2454

An Offline Filtering Agent for Website Analysis and Content Rating: A Review

Vrushali Sanjay Kharad, Prof. S. S. Kulkarni

Share this Article

Research Paper, Information Technology, India, Volume 4 Issue 4, April 2015

Pages: 2073 - 2076

Healthcare Insurance Fraud Detection Leveraging Big Data Analytics

Prajna Dora, Dr. G. Hari Sekharan

Share this Article

M.Tech / M.E / PhD Thesis, Information Technology, India, Volume 4 Issue 6, June 2015

Pages: 1457 - 1462

Churn Prediction in Cloud with Fuzzy Boosted Trees

Navneet Kaur, Naseeb Singh, Pawansupreet Kaur

Share this Article

Similar Articles with Keyword 'Association'

Research Paper, Information Technology, India, Volume 3 Issue 10, October 2014

Pages: 1896 - 1909

Users Experience with E-Journal Features: A Research Survey of Aerospace Scientists and Engineers of Bangalore

R. Guruprasad, P. Marimuthu

Share this Article

Research Paper, Information Technology, India, Volume 4 Issue 4, April 2015

Pages: 1076 - 1079

Parallelizing Coherent Rule Mining Algorithm on CUDA

Aditya A. Davale, Shailendra W. Shende

Share this Article

Research Paper, Information Technology, India, Volume 3 Issue 5, May 2014

Pages: 1488 - 1491

Combined Mining Approach and Pattern Discovery in ?Online Shopping Application?

Kamble Jayshree Raghunath

Share this Article

Research Paper, Information Technology, India, Volume 3 Issue 5, May 2014

Pages: 1670 - 1673

Class Association Rules based Feature Selection for Diagnosis of Dravet Syndrome

B. Dwarakanath, Dr. K Ramesh Kumar

Share this Article

Research Paper, Information Technology, India, Volume 4 Issue 6, June 2015

Pages: 753 - 755

RFID Security and Privacy

Richa Mishra, Dr. Nitin Pandey

Share this Article

Similar Articles with Keyword 'Clustering'

Research Paper, Information Technology, India, Volume 5 Issue 7, July 2016

Pages: 1920 - 1924

Improving Stability, Smoothing and Diversifying of Recommender Systems

Sagar Sontakke, Pratibha Chavan

Share this Article

Research Paper, Information Technology, India, Volume 3 Issue 12, December 2014

Pages: 1896 - 1900

Determining and Exploring Dimensions in Subspace Clustering for Value Decomposition

Saranya Sagambari Devi.S

Share this Article

M.Tech / M.E / PhD Thesis, Information Technology, India, Volume 4 Issue 3, March 2015

Pages: 2441 - 2444

Privacy-Preservation of Centralized and Distributed Social Network by Using L-Diversity Algorithm

Shankaranand, P. Rajasekar

Share this Article

Survey Paper, Information Technology, India, Volume 6 Issue 3, March 2017

Pages: 1403 - 1405

Inverse Problem with Solution Using Data Mining

Ashmikumari Shah, Pooja Jardosh

Share this Article

M.Tech / M.E / PhD Thesis, Information Technology, India, Volume 3 Issue 7, July 2014

Pages: 1743 - 1746

Hybrid Approach for Outlier Detection in High Dimensional Dataset

Rohini Balkrishna Gurav, Sonali Rangdale

Share this Article
Top