Transcript ECA Statistical Database - United Nations Statistics Division

Workshop
on Statistical Organization and
Management for SADC Member
States
Luanda, 2-6 December 2006
--------by
Awa Thiongane
UNECA/ACS
Statistical Databases: A short review
Slide: 1
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
Slide: 2
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
Slide: 3
Statistical Databases
DevInfo
CountryStat
World Bank Live Database
CRIS/UNAIDS
StatBase
Several Agencies have their own statistical
systems
Slide: 4
Important features
Feature
DevInfo
Live
Database
CountryStat
CRIS
StatBase
Web enable
X
X
X
X
√
User-friendliness and learning
curve
√
√
√
√
√
Multi-user functionality
X
X
X
√
√
Document management feature
X
X
?
√
√
unlimited
Unlimited
Limited
Limited
Unlimited
√
√
√
√
√
Scope
Import/Export
Slide: 5
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
Slide: 6
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)
Slide: 7
Important features of StatBase
Production/Development environment
Web enabled
User-friendliness and learning curve
Multi-user functionality
Document management feature
Scope
Import/Export
Slide: 8
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,…)
Slide: 9
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
Slide: 10
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) –
Slide: 11
StatBase
Components:
 Data
management
 Online/Public access
Slide: 12
Data management component
Administration
Metadata
Searching
Report production
Data manager

Compile, approve
Slide: 13
StatBase
Online Access/Public use component
Features:





Metadata
Browse
Search
Export
Interactivity
One stop-shop

Time-series data and related information and
services
Slide: 14
StatBase demo
Slide: 15
Login
Slide: 16
Administration
Security (users, roles, access levels)
Slide: 17
Metadata
Metadata definitions
Slide: 18
Data manager
Data entry, approval…
Slide: 19
Online Access opening page
Slide: 20
Metadata
Slide: 21
Browse
Slide: 22
Searching
Slide: 23
Reporting
Slide: 24
Documents and resources
Slide: 25
Thank you
Slide: 26