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 Internet of Things is clearly many things: data collection and analytics, wearables, Smart Grids and Smart Cities, the Industrial Internet, and more. Cool platforms like Arduino, Raspberry Pi, Intel's Galileo and Edison, and a diverse world of sensors are making the IoT a gre...
I recently attended and was a speaker at the 4th International Internet of @ThingsExpo at the Santa Clara Convention Center. I also had the opportunity to attend this event last year and I wrote a blog from that show talking about how the “Enterprise Impact of IoT” was a key them...
Apps and devices shouldn't stop working when there's limited or no network connectivity. Learn how to bring data stored in a cloud database to the edge of the network (and back again) whenever an Internet connection is available.
In his session at 17th Cloud Expo, Ben Perlmutte...
Culture is the most important ingredient of DevOps. The challenge for most organizations is defining and communicating a vision of beneficial DevOps culture for their organizations, and then facilitating the changes needed to achieve that. Often this comes down to an ability to p...
Microservices are a very exciting architectural approach that many organizations are looking to as a way to accelerate innovation. Microservices promise to allow teams to move away from monolithic "ball of mud" systems, but the reality is that, in the vast majority of organizatio...