A RELATIONAL DATABASE APPROACH TO EVALUATING CRIME-RELATED KPIs.

Autor: Hristoski, Ilija, Rendevski, Nikola
Předmět:
Zdroj: International Scientific Conference on Security & Euroatlantic Perspectives of the Balkans Police Science & Police Profession; 2016, p159-170, 12p
Abstrakt: Key performance indicators (KPIs) are a cornerstone of the contemporary quality management, especially performance measurement. They are aimed at supporting professionals in various segments all over the world in making the best decisions for thegrowth of their operations and activities. The assessment and evaluation of crimerelated KPIs are, consecutively, crucial parts of any security organizations that opt to cope with modern challenges successfully. Having minded the fact that all effective organizations fund their =know-how' on the analysis of vast amount of data being stored in databases, in this paper, we consider the usage of relational databases as a platform suitable for evaluating crime-related KPIs. The approach we propose is based on a proposed Entity-Relational (E-R) diagram and a corresponding relational database schema, a physically implemented resulting database, and development of SQL scripts that cover the most important crime-related KPIs. Such practical approach can serve as a solid basis for implementation within current relational databases, which are already in use, as well as for further improvements and inclusion of more sophisticated crime-related KPIs. [ABSTRACT FROM AUTHOR]
Databáze: Complementary Index