1 / 21

CPSI Data Warehouse “The key to security information”

ESCI – CPSI final symposium 4/5 march 2010 Marcel de wit (Sogeti Netherlands). CPSI Data Warehouse “The key to security information”. Topics. Why is there a need for a DWH What are the requirements How can questions be answered How does the DWH look like. Topics.

jeanine
Download Presentation

CPSI Data Warehouse “The key to security information”

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ESCI – CPSI final symposium 4/5 march 2010 Marcel de wit (Sogeti Netherlands) CPSI Data Warehouse“The key to security information”

  2. Topics • Why is there a need for a DWH • What are the requirements • How can questions be answered • How does the DWH look like

  3. Topics Why is there a need for a DWH What are the requirements How can questions be answered How does the DWH look like

  4. The need for a DWH Validation • Separate sources • A lot of data • Multiple purposes Registered crime Perceived security Media Intervention Culture Public opinion Analysis Reporting • Manageability ? • Transparency ?

  5. The need for a DWH • Integration by uniformity and conformation Registered crime Perceived security Media Intervention Culture Public opinion Data Warehouse Validation Analysis Reporting

  6. Topics Why is there a need for a DWH What are the requirements How can questions be answered How does the DWH look like

  7. Requirement (1/3): Usability • Scalability Local Regional National • Exportability Excel SPSS Data Warehouse • Reliability

  8. Requirement (2/3): Integrability Time Facts Registered crime Perceived survey Media Intervention Culture Public opinion Crimetheme Geography Mediasource Questionnaire Security theme

  9. Requirement (3/3): Analysability … Age Gender Dwellings Income Foreigner Time Geo- graphy Crime theme Media source Security theme Question- naire Year Month Day Country Region City Neighborh. Crime theme Offence Media- source Security- theme Paragraph Question Answer Registered crime Perceived survey Media Culture Intervention Public opinon

  10. Topics Why is there a need for a DWH What are the requirements How can questions be answered How does the DWH look like

  11. Answering questions (1/3) How do the different media sources publish on discrimination issues related to each other? Year Month Day Country Region City Neighborh. Crime theme Offence Media- source Security- theme Paragraph Question Answer Registered crime Perceived survey Media Culture Intervention Public opinon

  12. Answering questions (2/3) Feel people more safe since camera’s have been placed? Year Month Day Country Region City Neighborh. Crime theme Offence Media- source Security- theme Paragraph Question Answer Registered crime Perceived survey Media Culture Intervention Public opinon

  13. Answering questions (3/3) Age Gender Which differences in demographic characteristics can be detected between actual and perceived security? … Age Gender Dwellings Income Foreigner Year Month Day Country Region City Neighborh. Crime theme Offence Media- source Security- theme Paragraph Question Answer Registered crime Perceived survey

  14. Topics Why is there a need for a DWH What are the requirements How can questions be answered How does the DWH look like

  15. Presentation (1/5): Tabular The media sources with the no. of publications on all security themes (grouped - sorted):

  16. Presentation (2/5): Statistic The % respondents feeling safe per neighborhood (ranked down):

  17. Presentation (3/5): Trend analysis The no. of actual crimes over the period nov’08 – jun’09:

  18. Presentation (4/5): Graphical 5.132 2.562 2.965 5.590 1.486 3.411 5.057 2.729 4.123 2.697 The no. of published articles over the period feb-jun 2009 per security theme: Discrimination Man made disasters Drugs War conflict Violence vandalism Economic downturn Terrorism Natural disasters Several Property crime

  19. Presentation (5/5): Geographical No. of people feeling unsafe: Neighborhood: Perception: 13% Actual: 11% Inhabitants: 5078 City: Perception: 35% Actual: 14% High Medium Low

  20. Summary The CPSI Data Warehouse is: • A proven methodology for integrating several data sources • A scalable and flexible solution • The platform for information The key to security information

  21. Result driven marcel.de.wit@sogeti.nl

More Related