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."
Enterprises are fast realizing the importance of integrating SaaS/Cloud applications, API and on-premises data and processes, to unleash hidden value. This webinar explores how managers can use a Microservice-centric approach to aggressively tackle the unexpected new integration ...
There's no doubt that the Internet of Things is driving the next wave of innovation. Google has spent billions over the past few months vacuuming up companies that specialize in smart appliances and machine learning. Already, Philips light bulbs, Audi automobiles, and Samsung was...
In a world of ever-accelerating business cycles and fast-changing client expectations, the cloud increasingly serves as a growth engine and a path to new business models. Dynamic clouds enable businesses to continuously reinvent themselves, adapting their business processes, thei...
The 5th International DevOps Summit, co-located with 17th International Cloud Expo – being held November 3-5, 2015, at the Santa Clara Convention Center in Santa Clara, CA – announces that its Call for Papers is open.
Born out of proven success in agile development, cloud comput...
The OpenStack cloud operating system includes Trove, a database abstraction layer. Rather than applications connecting directly to a specific type of database, they connect to Trove, which in turn connects to one or more specific databases. One target database is Postgres Plus Cl...