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."
It’s hard to believe that it’s already 2017. But with the new year comes new challenges, new opportunities—and, of course—new software projects. One of the most important questions beginner, intermediate, and advanced coders all have to answer before they begin their next project is wh...
The explosion of new web/cloud/IoT-based applications and the data they generate are transforming our world right before our eyes. In this rush to adopt these new technologies, organizations are often ignoring fundamental questions concerning who owns the data and failing to ask for pe...
The cloud competition for database hosts is fierce. How do you evaluate a cloud provider for your database platform? In his session at 18th Cloud Expo, Chris Presley, a Solutions Architect at Pythian, gave users a checklist of considerations when choosing a provider. Chris Presley is a...
Some people worry that OpenStack is more flash then substance; however, for many customers this could not be farther from the truth. No other technology equalizes the playing field between vendors while giving your internal teams better access than ever to infrastructure when they need...
It is ironic, but perhaps not unexpected, that many organizations who want the benefits of using an Agile approach to deliver software use a waterfall approach to adopting Agile practices: they form plans, they set milestones, and they measure progress by how many teams they have engag...
In his keynote at 19th Cloud Expo, Sheng Liang, co-founder and CEO of Rancher Labs, discussed the technological advances and new business opportunities created by the rapid adoption of containers. With the success of Amazon Web Services (AWS) and various open source technologies used t...