yourfanat wrote: I am using another tool for Oracle developers - dbForge Studio for Oracle. This IDE has lots of usefull features, among them: oracle designer, code competion and formatter, query builder, debugger, profiler, erxport/import, reports and many others. The latest version supports Oracle 12C. More information here.
Italian Government Fights Crime With Technology Using a New Business and Location Intelligence System
The Department of Public Security of the Ministry of the Interior to Combat Crime Through the SIGR (Integrated System for the Georeferencing of Crimes) Platform, Developed by Iconsulting Using Oracle Business Intelligence and Geospatial Technology
Aiming at enhancing the enforcement actions taken to combat crime in the entire Italian territory, the Department of Public Security of the Italian Ministry of the Interior adopted an advanced business intelligence system based on Oracle Businesss Intelligence to produce detailed analysis of criminal events evaluating all the aspects of each crime (victim, author, geography, time, type, etc). The solution has been developed within the SIGR project (Integrated System for the Georeferencing of Crimes) with the support of Iconsulting, Oracle's Platinum Partner, which has in-depth expertise in the field of Business and Location Intelligence. Today the new system allows the Department of Public Safety to be quickly updated on the progress of cases and the Italian situation related to crimes.
At the beginning of 2012, the Department of Public Safety chose to adopt a single centralized tool to produce logical and structured analysis to support investigations, to obtain useful information and to combat crime over the whole of Italy. To achieve all of this, the Department of Public Safety decided to develop a solution beyond the traditional features of Business Intelligence, mainly used for business reporting and statistics.
To carry out the ambitious project, concluded in June 2012, the Italian Ministry of the Interior leveraged the consulting support of Iconsulting and Oracle's Business and Location Intelligence technologies, integrated with a library developed by Iconsulting through its Location Intelligence team. The result was a platform that adds to the traditional -- even advanced -- analysis of crimes, based on graphs and tables, also geolocation analysis used to locate crimes on a map.
Oracle Database and Oracle Spatial were implemented to better manage and integrate all data, geographical analysis and statistical data from the current investigation system. Moreover the system has leveraged Oracle Fusion Middleware MapViewer to add a cartographic view to the classic views (tabular and graphical) of crimes.
The Ministry of the Interior's platform enables three levels of analysis (related to geographical and vital data, related to crime type, real-time research), in order to meet different kinds of needs.
Already today, a group of Italian police officers are using the new system and their number will considerably increase over the next few months. The SIGR capability will allow the officers to analyze the existing information database of alphanumeric and geospatial data regarding crime at a national level.
The system is based on an intuitive, comprehensive and accurate interface, which considerably reduces the response times to queries.
In the future, thanks to the new solution, the Department of Public Safety will have the chance to produce predictive and proactive analysis that will manage Police resources more effectively, patrolling the streets which are more at risk or placing security guards in very critical areas. The system will allow research activities of danger patterns, using typical characteristics of crime (e.g. the time slot in which the highest number of crimes occur is between 1:00 and 3:00 am) and geospatial features of the territory (e.g. the proximity of points of interest, such as a nightclub).
"Oracle's mission is to provide public and private companies with technologies that allow them to enhance and transform their business while reducing IT complexity: the project carried out by the Italian Ministry of the Interior is an exemplary demonstration," said Pierfrancesco Di Giuseppe, Oracle Italy's Country Leader. "Oracle's technology enables a new way to combat crime for the Italian Ministry of the Interior, providing Police Forces with new intelligence arms to better understand crimes and those who commit them through a single and centralized system. This is an ideal project where technology serves our citizens and our communities."
The essence of data analysis involves setting up data pipelines that consist of several operations that are chained together – starting from data collection, data quality checks, data integration, data analysis and data visualization (including the setting up of interaction paths...
The IoT is changing the way enterprises conduct business.
In his session at @ThingsExpo, Eric Hoffman, Vice President at EastBanc Technologies, discuss how businesses can gain an edge over competitors by empowering consumers to take control through IoT. We'll cite examples such ...
As machines are increasingly connected to the internet, it’s becoming easier to discover the numerous ways Industrial IoT (IIoT) is helping to shape the business world. This is exactly why we have decided to take a closer look at this pervasive movement and to examine the desire ...
A strange thing is happening along the way to the Internet of Things, namely far too many devices to work with and manage. It has become clear that we'll need much higher efficiency user experiences that can allow us to more easily and scalably work with the thousands of devices ...
Enterprise networks are complex. Moreover, they were designed and deployed to meet a specific set of business requirements at a specific point in time. But, the adoption of cloud services, new business applications and intensifying security policies, among other factors, require ...