BY
ABSTRACT
Governmentagencies have all sorts of data related to crime in Malaysia. Unfortunately, until now there is no efficient way for related officers to analyze the data. Web-based analysis of crime data is important, as it will shed some light on certain patterns or trends of crime. This project is intended to provide an efficient computerized system for the police to analyze the crime data. The underlying technology of this project is data warehousing. Data for data warehouse will be extracted from the Online Transaction Processing (OPL) by Data Transformation Services concept. Data for data analysis will be extracted from the data warehouse into Online Analytical Processing (OLAP), which contains the component of Common Object Model (COM) and Active Server Pages (ASP). The COM is used to help to fetch data from SQL Server to pass it to ASP. It is merely used to encapsulate all the functions that are required to retrieve the result due to Multidimensional Expression (MDX) from data warehouse. OLAP tools will focus on providing multi-dimensional data analysis, which is superior to SQL in computing summaries and breakdowns along many dimensions. Data mining and OLAP are related facets of a new generation of intelligence information extraction and management tools
Full
Text Source:
B.Sc.(Hons.)
in Computer Science
April
2001
Number:
43