Downloads: 126 | Views: 271 | Weekly Hits: ⮙1 | Monthly Hits: ⮙1
Research Paper | Information Technology | Iraq | Volume 4 Issue 7, July 2015 | Popularity: 7.1 / 10
An Efficient Approach for DW Design and DM in Crime Data Set
Kadhim B. S. Aljanabi
Abstract: 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
Similar Articles
Downloads: 1 | Weekly Hits: ⮙1 | Monthly Hits: ⮙1
Research Paper, Information Technology, United States of America, Volume 13 Issue 7, July 2024
Pages: 792 - 796Enhancing Healthcare Operations with Predictive Length of Stay Models
Umamaheswara Reddy Kudumula
Downloads: 3 | Weekly Hits: ⮙1 | Monthly Hits: ⮙1
Research Paper, Information Technology, United States of America, Volume 12 Issue 4, April 2023
Pages: 1524 - 1530OCR and AI Augmented CRM Systems: A Novel Approach to Customer Data Mining and Analysis for Digital Transformation
Sharda Kumari, Avinash Malladhi
Downloads: 4 | Weekly Hits: ⮙2 | Monthly Hits: ⮙2
Informative Article, Information Technology, India, Volume 9 Issue 8, August 2020
Pages: 1566 - 1570Customer Segmentation and Personalization in Banking Services: Investigating the use of Big Data Analytics to Segment Banking Customers based on their Behavior, Demographics, and Preferences, and Leveraging these Insights to Personalize Banking Services and Marketing Campaigns
Sree Sandhya Kona
Downloads: 5 | Weekly Hits: ⮙1 | Monthly Hits: ⮙2
Research Paper, Information Technology, India, Volume 13 Issue 4, April 2024
Pages: 387 - 390Perspective of Digital Transformation in Rural India
Dr. Satish Patel
Downloads: 5 | Weekly Hits: ⮙1 | Monthly Hits: ⮙1
Informative Article, Information Technology, Sierra Leone, Volume 13 Issue 4, April 2024
Pages: 1457 - 1463Impact of Digital Financial Technology on Women in Sierra Leone. Case Study: Women in the Western Area of Sierra Leone
Sahr Alieu Musuyamasu, Mohamed Syed Fofanah