Skip to main content

Industries  >  Government  >  Solutions  >  

Crime information warehouse solution from IBM
Executive summary Department view Technical details
The issues
Greater predictive analysis and data mining
Are fragmented systems creating problems for your department? Do reporting and analysis require knowledge of complicated databases and programming languages? Your department needs a better way to produce statistics and research crime trends. The IBM Crime Information Warehouse solution enables the quick and easy retrieval of information—permitting officers or crime analysts to spend their time gaining insight rather than dealing with complex data access issues.

The benchmark
Established methodology and experience
What sets the IBM Crime Information Warehouse solution apart from the competition?
  • Builds upon the proven reliability of IBM DB2® Data Warehouse to provide local public safety teams with instant access to the most up-to-date information available.
  • Leverages on-line analytical processing (OLAP) to dynamically slice-and-dice data across relevant dimensions—location, date, signal, incident priority, offender-victim relationship, domestic violence relation and call for service holding time.
  • Uses intranet-based tool sets—no software needed and virtually zero maintenance on user machines.
  • Leverages the proven experience and intellectual capital IBM has gained through many successful data warehouse implementations.

The components
A foundation for virtually unlimited analyses
The IBM Crime Information Warehouse solution supports OLAP functionality, crime statistics dashboards and integration of mapping, graphics and case information on the screen. Components can include:
  • IBM DB2 Data Warehouse Enterprise Edition—provides innovative self-managing and self-tuning capabilities, dramatically reducing time and costs associated with managing database servers. Components within DB2 Data Warehouse can include:
    • IBM DB2 Universal Database™—automates key maintenance activities based on business policies, reducing deployment and management costs.
    • IBM DB2 Data Warehouse Manager—automatically creates and populates data warehouse and data marts with the most current information.
    • IBM DB2 Cube Views—dramatically improves online analytic processing (OLAP) query performance and accelerates OLAP deployments.
    • IBM WebSphere® Information Integrator—gives organizations integrated access to information, whether it resides in diverse source systems or across a variety of operating environments.
    • IBM DB2 Intelligent Miner Modeling/Visualization/Scoring—helps you identify and extract high-value business intelligence from your data assets.
    • IBM DB2 Query Patroller—proactively and dynamically controls the flow of queries against your DB2 database.
    • IBM DB2 Office Connect—simplifies the deployment and distribution of reports.
  • IBM WebSphere Portal Server—delivers a single point of personalized interaction with applications, content, processes and people.
  • IBM WebSphere Application Server—provides a high-performance and extremely scalable transaction engine.
  • Cognos® ReportNet™ and PowerPlay™—provides enterprise business intelligence reporting and analysis tools.
  • ESRI®—delivers GIS mapping and visualization tools, including ArcIMS™.

The implementation
Provide timely access
Proven in several large metropolitan police departments, the IBM Crime Information Warehouse solution provides rapid development with less risk. We implemented the solution at one of our country’s largest and most diverse police jurisdictions, which was able to:
  • Consolidate data from various source systems into an integrated information environment.
  • Store cleansed and validated information.
  • Leverage a single source for reporting.
  • Increase the efficiency of the report generation and information discovery process.

The cost of ownership
Rapid deployment means less risk
The IBM Crime Information Warehouse solution adds an integrated information repository to your existing operating environment, enabling you to achieve greater analysis and decision making capabilities. No need to start with an entirely new environment. Your department retains the investment in your core operational crime systems and adds considerable functionality through the addition of the informational layer.
  • Multi-tiered architecture provides a robust scalable environment.
  • Open platform choices—including Linux™.
  • Browser-based environment supports easy deployment and requires zero-footprint on the user’s machine.

Next steps
 
Questions about this solution? Contact an IBM Government specialist.