1 / 26

Statistical Database Management for Effective Decision Making Workshop

Learn about different types of statistical databases, features of ECA Statistical Database, and important features of other similar databases. Gain insights on data storage, management, and access for informed decision-making.

rdugan
Download Presentation

Statistical Database Management for Effective Decision Making Workshop

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. 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

More Related