260 likes | 297 Views
Workshop on Statistical Organization and Management for SADC Member States Luanda, 2-6 December 2006 --------- by Awa Thiongane UNECA/ACS. Contents. Types of Statistical Databases Micro level Statistical Databases The ECA Statistical Database Features of the ECA Statistical Database
E N D
Workshop on Statistical Organization and Management for SADC Member StatesLuanda, 2-6 December 2006---------by Awa ThionganeUNECA/ACS Statistical Databases: A short review
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
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
Statistical Databases • DevInfo • CountryStat • World Bank Live Database • CRIS/UNAIDS • StatBase • Several Agencies have their own statistical systems
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
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)
Important features of StatBase • Production/Development environment • Web enabled • User-friendliness and learning curve • Multi-user functionality • Document management feature • Scope • Import/Export
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,…)
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
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) –
StatBase Components: • Data management • Online/Public access
Data management component • Administration • Metadata • Searching • Report production • Data manager • Compile, approve
StatBase Online Access/Public use component • Features: • Metadata • Browse • Search • Export • Interactivity • One stop-shop • Time-series data and related information and services
Administration • Security (users, roles, access levels)
Metadata • Metadata definitions
Data manager • Data entry, approval…