Database Answers The Father of all Data Models
Home Ask a Question Best Practice Careers Contact Us Data Models Tutorials Search Site Map
  Welcome to our Tutorial on Master Data Management
 

INTRODUCTION :
This Tutorial is on Master Data Management for Law Enforcement.
It presents the Steps involved as Best Practice.

Topics covered in this Tutorial include Data Sources and Targets, mapping between them, Data Quality, Data Governance and Reference Data

I hope you find this Tutorial interesting and helpful.
Please email me and let me know.

These are the Steps in the Tutorial :-
  1. Agree the Scope of the Project
  2. Identify the Data Sources
  3. Determine the Target
  4. Specificy the Mapping between Sources and Target.
  5. Review Guidelines for managing Reference Data
  6. Address the Issue of Data Quality
  7. Ensure comliance with Data Governance
  8. Check that the MDM Data Model can provide data for Police Information Reports and the National Intelligence Model.
My starting-point is a list of relevant Data Models for Law Enforcement.
This is the MDM Police Data Model which is the Target
This shows hows data from a number of sources is integrated into one Generic Master Data Management Model.

Police MDM Data Model
1) ENTITY MAPPING SPECIFICATIONS :

Source Area Source Entity Target Entity Ref Data
Case Management Addresses Addresses  
Case Management Cases_Trials Events  
Case Management Organisations Organisations  
Case Management Incidents Events  
Case Management Officers Staff  
Case Management Address_Types   Ref
Case Management Incident_Outcomes   Ref
Case Management Incident_Status   Ref
Case Management Incident_Types   Ref
Case Management Ranks   Ref
Case Management Roles   Ref
Police Departments Addresses Addresses  
Police Departments Associates Associates  
Police Departments Departments Organisations  
Police Departments Incidents Events  
Police Departments Officers Staff  
Police Departments Address_Types   Ref
Police Departments Incident_Outcomes   Ref
Police Departments Incident_Status   Ref
Police Departments Incident_Types   Ref
Police Departments Ranks   Ref
Police Departments Roles   Ref
Prisons and Prisoners Associates Associates  
Prisons and Prisoners Offences Events  
Prisons and Prisoners Prisons Organisations  
Prisons and Prisoners Prison_Staff Staff  
Prisons and Prisoners Prisoners Persons  
Prisons and Prisoners Staff Staff  
Prisons and Prisoners Gender   Ref
Prisons and Prisoners Offence_Category   Ref
Prisons and Prisoners Probation_Status   Ref
Prisons and Prisoners Staff_Roles   Ref
Traffic Cops and Tickets Addresses Addresses  
Traffic Cops and Tickets Officers Staff  
Traffic Cops and Tickets Tickets Documents  
Traffic Cops and Tickets Vehicles Vehicles  
Traffic Cops and Tickets Violaters Persons  
Traffic Cops and Tickets Violations Events  
Traffic Cops and Tickets Document_Types   Ref
Traffic Cops and Tickets Payment_Methods   Ref
Traffic Cops and Tickets Ranks   Ref
Traffic Cops and Tickets Ticket_Status   Ref
Traffic Cops and Tickets Vehicle_Types   Ref
2) REFERENCE DATA :
    Each Data Source will have its own sets of Reference Data.
    These have to be mapped to a common set of Data, which in turn is subject to corporate Data Governance.
MDM Reference Data
3) CASE MANAGEMENT :


Case Management Model Reference Data Comment
Addresses    
Cases_Trials    
Organisations    
People    
Address_Types Ref  
Organisation_Types Ref  
Roles Ref  
Trial_Outcomes Ref  
Trial_Status Ref  
Case Management Data Model
Police Departments Data Model
4) POLICE DEPARTMENTS DATA MODEL


Police Department Model Reference Data Comment
Addresses    
Associates    
Departments    
Incidents    
Officers    
Address_Types Ref  
Incident_Outcomes Ref  
Incident_Status Ref  
Incident_Types Ref  
Ranks Ref  
Roles Ref  
5) PRISONS AND PRISONERS :


Prisons and Prisoners Model Reference Data Comment
Associates    
Offences    
Prisons    
Prison_Staff    
Prisoners    
Staff    
Gender Ref  
Offence_Category Ref  
Probation_Status Ref  
Staff_Roles Ref  
Prisons and Prisoners Data Model
Tracking Evidence
6) TRACKING EVIDENCE :


Tracking Evidence Model Reference Data Comment
Addresses    
Associates    
Departments    
Incidents    
Officers    
Address_Types Ref  
Incident_Outcomes Ref  
Incident_Status Ref  
Incident_Types Ref  
Ranks Ref  
Roles Ref  
7) TRAFFIC COPS AND TICKETS :


Traffic Cops and Tickets Reference Data Comment
Addresses    
Officers    
Tickets    
Vehicles    
Violaters    
Violations    
Document_Types Ref  
Payment_Methods Ref  
Ranks Ref  
Ticket_Status Ref  
Vehicle_Types Ref  
Traffic Cops and Tickets

8) DRAFT FIELD LEVEL MAPPING SPECIFICATIONS
These Specifications have been partially completed to provide guidelines.

Source Area Source Entity Source Field Field Validation Field Transformation Target Entity Target Field
Case Management Addresses line_1_building     Addresses  
Case Management Addresses line_2_street     Addresses  
Case Management Addresses line_3_area     Addresses  
Case Management Addresses city     Addresses  
Case Management Addresses zip_postcode     Addresses  
Case Management Addresses state_county     Addresses  
Case Management Addresses country   ISO Country Codes Addresses  
Case Management Cases_Trials trial_outcome_code Mandatory Map to Target Ref Data Events  
Case Management Cases_Trials trial_status_code Mandatory Map to Target Ref Data Events  
Case Management Cases_Trials trial_start_date > Jan 1/2000 Copy Events event_start_date
Case Management Cases_Trials trial_end_date Not Mandatory Copy Events event_end_date
Case Management Cases_Trials expected_duration N/A Copy Events other_data
Case Management Incidents       Events  
Case Management Organisations organisation_name Mandatory Copy Organisations organisation_name
Case Management People first_name Mandatory Copy Staff first_name
Case Management People middle_name Not Mandatory Copy Staff middle_name
Case Management People last_name Mandatory Copy Staff last_name
Case Management People date_of_birth Not Mandatory Copy Staff date_of_birth
Case Management People gender Not Mandatory Copy Staff gender
Police Departments Addresses       Addresses  
Police Departments Associates       Associates  
Police Departments Departments       Organisations  
Police Departments Incidents       Events  
Police Departments Officers       Staff  
Prisons and Prisoners Associates       Associates  
Prisons and Prisoners Offences       Events  
Prisons and Prisoners Prisons       Organisations  
Prisons and Prisoners Prison_Staff       Staff  
Prisons and Prisoners Prisoners       Persons  
Prisons and Prisoners Staff       Staff  
Traffic Cops and Tickets Addresses       Addresses  
Traffic Cops and Tickets Officers       Staff  
Traffic Cops and Tickets Tickets       Documents  
Traffic Cops and Tickets Vehicles       Vehicles  
Traffic Cops and Tickets Violaters       Persons  
Traffic Cops and Tickets Violations       Events  
REFERENCE DATA ...
Source Area Source Field Target Field
Case Management Address_Types Address_Types
Case Management Incident_Outcomes Event_Outcomes
Case Management Incident_Status Event_Status
Case Management Incident_Types Event_Types
Case Management Ranks Job_Titles
Case Management Roles Staff_Types
Police Departments Address_Types Address_Types
Police Departments Incident_Outcomes Event_Outcomes
Police Departments Incident_Status Event_Status
Police Departments Incident_Types Event_Types
Police Departments Ranks Job_Titles
Police Departments Roles Staff_Types
Prisons and Prisoners Gender Gender
Prisons and Prisoners Offence_Category Event_Types
Prisons and Prisoners Probation_Status Event_Status
Prisons and Prisoners Staff_Roles Staff_Types
Traffic Cops and Tickets Document_Types Document_Types
Traffic Cops and Tickets Payment_Methods Payment_Methods
Traffic Cops and Tickets Ranks Job_Titles
Traffic Cops and Tickets Ticket_Status Document_Status
Traffic Cops and Tickets Vehicle_Types Vehicle_Types

Here are two screenshots of the Salesforce Law Enforcement Application.

Screenshot 1 - Upper half of the page :-

screen 1 of Salesforce Law Enforcement Application
Screenshot 2 - Lower half of the page :-

screen 2 of Salesforce Law Enforcement Application

PLEASE EMAIL ME
  • During this short Tutorial,we have covered the following Topics :-
    1. An Approach to MDM
    2. Creating a Data Dictionary
    3. Mapping from Sources to the Target MDM Data Model.
    4. Reference Data
  • I hope you have found this Tutorial interesting and useful.
  • I would be pleased to have your comments with your questions or suggestions.

    Good luck with your first MDM Project !

    Barry Williams
    Principal Consultant
    Database Answers Ltd.
    London, England

Home Ask a Question Best Practice Careers Contact Us Data Models Tutorials Search Site Map

© DatabaseAnswers.org 2010