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
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
Similar Articles with Keyword 'Data Warehouse'
Informative Article, Information Technology, Nigeria, Volume 2 Issue 4, April 2013
Pages: 468 - 473A Superficial Expos of Data Warehousing: An Intrinsic Component of Modern Day Business Intelligence
Oyerinde, O.D, Adekunle, A. Y, Ebiesuwa, O.O
Research Paper, Information Technology, India, Volume 4 Issue 4, April 2015
Pages: 3141 - 3144Interrelated Document Warehouse Report Visualization
V. Vivek, N. J. Subashini
Research Paper, Information Technology, Iraq, Volume 4 Issue 7, July 2015
Pages: 328 - 333An Efficient Approach for DW Design and DM in Crime Data Set
Kadhim B. S. Aljanabi
Research Paper, Information Technology, Congo, Volume 6 Issue 9, September 2017
Pages: 905 - 908A Conceptual Model for Multidimensional Data Intended for Decision-making in a Health/Medical Structure
Lobo Minga Bertin
Research Paper, Information Technology, India, Volume 8 Issue 2, February 2019
Pages: 1054 - 1058Data Analyser GUI
Hardik Goel, Tushar Ahuja
Similar Articles with Keyword 'Data Mining'
Research Paper, Information Technology, India, Volume 4 Issue 4, April 2015
Pages: 1076 - 1079Parallelizing Coherent Rule Mining Algorithm on CUDA
Aditya A. Davale, Shailendra W. Shende
Research Paper, Information Technology, India, Volume 3 Issue 5, May 2014
Pages: 1488 - 1491Combined Mining Approach and Pattern Discovery in ?Online Shopping Application?
Kamble Jayshree Raghunath
Research Paper, Information Technology, India, Volume 3 Issue 5, May 2014
Pages: 1670 - 1673Class Association Rules based Feature Selection for Diagnosis of Dravet Syndrome
B. Dwarakanath, Dr. K Ramesh Kumar
Research Paper, Information Technology, India, Volume 3 Issue 6, June 2014
Pages: 1654 - 1660Privacy Preserving Protocol for Two-Party Classifier Over Vertically Partitioned Dataset Using ANN
Smitha Iddalgave, Sumana M
Research Paper, Information Technology, India, Volume 3 Issue 12, December 2014
Pages: 1896 - 1900Determining and Exploring Dimensions in Subspace Clustering for Value Decomposition
Saranya Sagambari Devi.S
Similar Articles with Keyword 'Classification'
Review Papers, Information Technology, India, Volume 3 Issue 8, August 2014
Pages: 1720 - 1722Particle Swarm Optimization- A Review on Algorithmic Rule, Application and Scope
Dr. G. M. Nasira, S. Radhimeenakshi
Research Paper, Information Technology, India, Volume 3 Issue 6, June 2014
Pages: 1654 - 1660Privacy Preserving Protocol for Two-Party Classifier Over Vertically Partitioned Dataset Using ANN
Smitha Iddalgave, Sumana M
Review Papers, Information Technology, India, Volume 3 Issue 11, November 2014
Pages: 2450 - 2454An Offline Filtering Agent for Website Analysis and Content Rating: A Review
Vrushali Sanjay Kharad, Prof. S. S. Kulkarni
Research Paper, Information Technology, India, Volume 4 Issue 4, April 2015
Pages: 2073 - 2076Healthcare Insurance Fraud Detection Leveraging Big Data Analytics
Prajna Dora, Dr. G. Hari Sekharan
M.Tech / M.E / PhD Thesis, Information Technology, India, Volume 4 Issue 6, June 2015
Pages: 1457 - 1462Churn Prediction in Cloud with Fuzzy Boosted Trees
Navneet Kaur, Naseeb Singh, Pawansupreet Kaur
Similar Articles with Keyword 'Association'
Research Paper, Information Technology, India, Volume 3 Issue 10, October 2014
Pages: 1896 - 1909Users Experience with E-Journal Features: A Research Survey of Aerospace Scientists and Engineers of Bangalore
R. Guruprasad, P. Marimuthu
Research Paper, Information Technology, India, Volume 4 Issue 4, April 2015
Pages: 1076 - 1079Parallelizing Coherent Rule Mining Algorithm on CUDA
Aditya A. Davale, Shailendra W. Shende
Research Paper, Information Technology, India, Volume 3 Issue 5, May 2014
Pages: 1488 - 1491Combined Mining Approach and Pattern Discovery in ?Online Shopping Application?
Kamble Jayshree Raghunath
Research Paper, Information Technology, India, Volume 3 Issue 5, May 2014
Pages: 1670 - 1673Class Association Rules based Feature Selection for Diagnosis of Dravet Syndrome
B. Dwarakanath, Dr. K Ramesh Kumar
Research Paper, Information Technology, India, Volume 4 Issue 6, June 2015
Pages: 753 - 755RFID Security and Privacy
Richa Mishra, Dr. Nitin Pandey
Similar Articles with Keyword 'Clustering'
Research Paper, Information Technology, India, Volume 5 Issue 7, July 2016
Pages: 1920 - 1924Improving Stability, Smoothing and Diversifying of Recommender Systems
Sagar Sontakke, Pratibha Chavan
Research Paper, Information Technology, India, Volume 3 Issue 12, December 2014
Pages: 1896 - 1900Determining and Exploring Dimensions in Subspace Clustering for Value Decomposition
Saranya Sagambari Devi.S
M.Tech / M.E / PhD Thesis, Information Technology, India, Volume 4 Issue 3, March 2015
Pages: 2441 - 2444Privacy-Preservation of Centralized and Distributed Social Network by Using L-Diversity Algorithm
Shankaranand, P. Rajasekar
Survey Paper, Information Technology, India, Volume 6 Issue 3, March 2017
Pages: 1403 - 1405Inverse Problem with Solution Using Data Mining
Ashmikumari Shah, Pooja Jardosh
M.Tech / M.E / PhD Thesis, Information Technology, India, Volume 3 Issue 7, July 2014
Pages: 1743 - 1746Hybrid Approach for Outlier Detection in High Dimensional Dataset
Rohini Balkrishna Gurav, Sonali Rangdale