Abstract
In recent years, the process of obtaining information from historical data has gained importance. Data mining and warehousing techniques are used to extract useful data from aggregated data making information retrieval easy and accurate for future predictions. This project involves the design and implementation of a Data mining tool to analyze the information in XML format of the crimes that have occurred on different university campuses in the United States. The main aim of this tool is to extract data stored in separate XML documents and to provide summarized information that will help students in determining the safety level of a campus before accepting an admission. The tool will also act as a source of information for the non-student users like police officers in determining the crime rate across campuses and help them in implementing necessary measures to reduce the crime rate to ensure campus safety. The aggregated dataset is obtained from the U.S department of education website. This data contains both the on campus and off campus crimes that have been reported across various university campuses every year. The tool provides users with statistical data as well as different types of charts for analysis. The tool also provides the results obtained from Apriori algorithm in the form of association rules, which is a pattern that states when an event occurs, another event occurs with certain probability. The main tasks involved in this tool include creation of the database schema, importing of data in XML format into the database, development of SQL stored procedures using XQuery, plotting of charts, identifying use case scenarios for different crime reports and the implementation of the Apriori algorithm. The front end of the tool is a web application developed in C#.net using a three-tier architecture pattern and the back end database is implemented using Microsoft SQL Server.