1 / 19

Database Structure Review

Database Structure Review. Manar Soliman, UNICEF Rajesh Sharma, DevInfo Support Group Workshop on Building Country Capacity to Maintain a Central Repository of Data Amman 13 – 15 March 2007. Standards to be considered in building a template.

emerald-mills
Download Presentation

Database Structure Review

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. Database Structure Review Manar Soliman, UNICEF Rajesh Sharma, DevInfo Support Group Workshop on Building Country Capacity to Maintain a Central Repository of Data Amman 13 – 15 March 2007

  2. Standards to be consideredin building a template • Sector, Class, IUS to be consistent with global DBs structure • Template to include only indicators with data • Structure definition to be unique/not repetitive, clear & significant • Indicators not to be defined by subgroups, dates or background information • MDG indicators and Goals to be imported from global DB • Use of one language at the same session and adopt full translation • Apply same format and run spell checking on the template content • Link institutions and conventions to relevant indicators • Census data can be stored in a separate database

  3. Indicators are linked to irrelevantsectors & classes

  4. Database contains indicatorswith no data

  5. Sectors, classes & indicatorsare repetitive

  6. Indicators’ names are not clear/significant

  7. Defining indicators by subgroups

  8. Defining indicators by dates*

  9. Defining indicators by background information*

  10. MDG indicators are not recognised as global*

  11. MDG Goals are not recognised as global

  12. Two languages in the same session

  13. Over reporting of language usage

  14. Spelling mistakes & different format

  15. Unidentified conventions with relevant indicators

  16. Census data can be stored in a separate DB

  17. Institutions are linked with irrelevant indicators

  18. How to implement changesStep-by-step • Produce database summary report • Use the relevant spreadsheets (e.g. “Sector” in DI5.0/ “Indicator” & “IUS” in DI4.0) • Complete the list with suggested/modified structure • Review the suggested structure and spell check • Export DB to spreadsheets and reflect agreed changes • Create a new template reflecting all the changes • Import relevant MDG indicators and MDG goals • Import from global DBs relevant sectors, classes, IUSs • Review the new template with the list • Import modified spreadsheets to the new template

  19. Example of review sheet

More Related