Download
workshop on statistical organization n.
Skip this Video
Loading SlideShow in 5 Seconds..
Contents PowerPoint Presentation

Contents

13 Vues Download Presentation
Télécharger la présentation

Contents

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Workshop on Statistical Organization and Management for SADC Member StatesLuanda, 2-6 December 2006---------by Awa ThionganeUNECA/ACS Statistical Databases: A short review

  2. Contents Types of Statistical Databases Micro level Statistical Databases The ECA Statistical Database Features of the ECA Statistical Database Important features Other similar databases Statistical Databases: A short review

  3. Types of Statistical Databases • Database dealing with micro level data management • Huge data size • Highly sensitive • Storage intensive • Row data • Database dealing with aggregated data • Less sensitivity • Dissemination • Processed data • Important for decision making

  4. Statistical Databases • DevInfo • CountryStat • World Bank Live Database • CRIS/UNAIDS • StatBase • Several Agencies have their own statistical systems

  5. Important features

  6. The ECA Statistical Database • Creating a central database system to manage all macro time-series • To create a corporate platform for ECA statistical data management • To support SROs, countries in statistical data management • Provide easy access to statistical information/data to end users

  7. The ECA Statistical Database • Developed using the latest technologies • Asp.net, SQL, HTML, Dotnet framework • Requires readily available software • Runs on windows 2000 (professional/server), XP professional, Internet explorer, SQL server (MSDE/ SQL server express/SQL server 2000) – server side • Runs on windows 9x and later, any standard browser – client side • Installation/update is made only once and at a central location • Access to the application is through a browser (URL)

  8. Important features of StatBase • Production/Development environment • Web enabled • User-friendliness and learning curve • Multi-user functionality • Document management feature • Scope • Import/Export

  9. StatBase Features • All types of macro-level time-series data • Define main sectors, sectors • Includes a generic structure that allows management of any type of indicators • Allows storage, retrieval and dissemination of national, sub national (up to four levels in addition to cities/town) and periodicity (annual, quarterly and monthly) • Parameter driven application • Define metadata (countries, admin zones, year, partners, units,…)

  10. StatBase Features (contd.) • A centralized database system • Uses latest relational database technology • Complete scalability for any size of data and number of users • facilitate textual data management • Web-based application

  11. StatBase (Development and piloting) • Development started in June 2004 • Several seminars and consultations meetings conducted • The application has been piloted in two locations outside ECA: • Economic Community of West African States (ECOWAS) where the database has been installed, customized and staff trained • ECA SRO – EA - DRC NSO • Training workshop of NSOs’ staff • EA countries (Bujumbura, May 2006) • ECOWAS (Togo, July 2006) –

  12. StatBase Components: • Data management • Online/Public access

  13. Data management component • Administration • Metadata • Searching • Report production • Data manager • Compile, approve

  14. StatBase Online Access/Public use component • Features: • Metadata • Browse • Search • Export • Interactivity • One stop-shop • Time-series data and related information and services

  15. StatBase demo

  16. Login

  17. Administration • Security (users, roles, access levels)

  18. Metadata • Metadata definitions

  19. Data manager • Data entry, approval…

  20. Online Access opening page

  21. Metadata

  22. Browse

  23. Searching

  24. Reporting

  25. Documents and resources

  26. Thank you