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 from a technical point of view. 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 :- Agree the Scope of the Project Identify the Data Sources Determine the Target Specificy the Mapping between Sources and Target. Review Guidelines for managing Reference Data Address the Issue of Data Quality Ensure comliance with Data Governance My starting-point is a list of 14 relevant Data Models. 1) 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   2) 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   3) POLICE GENERALIZED DATA MODEL This is a draft we produced a while ago. It is not a Data Source but we need to be sure that it is compatible with the MDM Target Data Model. Police Generalised Data Model Reference Data Comment Addresses     Incidents     Locations     Organisations     Persons     Physical Objects     Police Equipment     Vehicles     Address_Types Ref   Physical_Object_Types Ref   4) POLICE INFORMATION REPORTS : This is not a Data Source except that we need to be sure that the basic Entities are included in the Target MDM Data Model so that we can produce the required Reports. At this Stage, we show only the Entities with no Relationships and minimum Attributes. and specify only the Primary Key and one 'details' field that will be replaced later on.. Police Information reports Reference Data Comment Addresses     Associates     Crimes     Locations     Persons     Vehicles     Address_Types Ref   Crime_Categories 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   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   This is the MDM Police Model which is the Target 8) 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 9) 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. 10) 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     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 PLEASE EMAIL ME During this short Tutorial,we have covered the following Topics :- An Approach to MDM Creating a Data Dictionary Mapping from Sources to the Target MDM Data Model. 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 2009