The ECA Statistical Data management platform Statistical Database

The ECA Statistical Data management platform Statistical Database Application Demonstration of the Prototype model for ECA Statistical Database March 2009 Molla HUNEGNAW Statistician African Centre for Statistics October 2009 Economic Commission for Africa (ECA) Statistical Databases: A short review 1

Contents • • • Background The ECA Statistical Database Objective Platform Components Ongoing developments Statistical Databases: A short review Slide: 2

Background Database dealing with micro level data management l l l Huge data size Highly sensitive Raw data Database dealing with aggregated data l l l Less sensitive Dissemination Processed data Statistical Databases: A short review 3

Background Statistical Databases Dev. Info l Country. Stat l World Bank Live Database l CRIS l The ECA Statistical Database l Several organizations have in-house statistical systems l… l Statistical Databases: A short review 4

The ECA Statistical Database Objectives To create a central database system to manage all socio-economic data on African region at ECA l To create a corporate platform at ECA for statistical data management l To provide easy access to statistical data to users l - concepts and definitions 5

The ECA Statistical Database Features A web-enabled application l A database system that could be customized as a platform l Can be configured to stand-alone, LAN, and Internet versions l Facilitates textual data management l Bilingual l Statistical Databases: A short review 6

The ECA Statistical Database The Development platform Dot Net Framework 2. 0 l Microsoft SQL Server 2000 l Active Server Pages (ASP. NET) l Extensible Markup Language (XML) l Statistical Databases: A short review 7

The ECA Statistical Database System requirements l Server Hardware l Software l l Client Hardware l Software l l “Peopleware” l Knowledge and Skill of backend software Statistical Databases: A short review 8

The ECA Statistical Database Purposes Data production l Data dissemination l Report production l Statistical Databases: A short review 9

Data models Time-series data Documents • Periodicity • Title • Annual • Area • Description • Quarterly • Partner • Link/File • Monthly • Value • Document type • Note • Keywords • Data status • Category • …. • Theme • Coverage • Area Statistical Databases: A short review 10

The ECA Statistical Database Components l Data management l Manage data l Online/Public l End Statistical Databases: A short review access users 11

Data management Administration Metadata Data manager Data publish Statistical Databases: A short review 12

Data management: Administration User management New users l Modify user details l Delete users l Roles Access roles (Compiler, Approver, administrator) l Domain roles (Assign countries/Areas, Assign sectors) l Reports Statistical Databases: A short review 13

Administration: Security model Roles l l l Users Username Password Compiler Approver Administrator Sectors l User will be assigned to one or more sectors Areas l User will be assigned to one or more areas Statistical Databases: A short review 14

Data management: Metadata Secteurs Indicateurs Unités Pays Partenaires Statut de données Fournisseurs de données Apostille Année Glossaire …. Statistical Databases: A short review 15

Data management: Data manager Compilation Data entry (grid, batch) l Documents and resources l Define tables l Publish Data l Documents and resources l Tables l Statistical Databases: A short review 16

Data collection Data sources Website, Online databases l CDs l Publications l Data collection mission l Data providers l Countries, Sub-regional, Regional and International organizations Statistical Databases: A short review 17

Login Statistical Databases: A short review 18

Administration Users, roles, assignments, activity logs, etc Statistical Databases: A short review 19

Metadata definitions Statistical Databases: A short review 20

Data manager Data entry, publish… Statistical Databases: A short review 21

Data access Browse Search Data presentation formats Download Statistical Databases: A short review 22

Data access: Browse data by sector l by country l by periods l Browse documents and resources by type of resources l by title of resources l Statistical Databases: A short review 23

Data access: Search Quick search Basic search Advanced search Statistical Databases: A short review 24

Data access: Data formats Tabular Charts Maps Statistical Databases: A short review 25

Data access: Downloads Excel CSV XML Statistical Databases: A short review 26

Data access opening page Statistical Databases: A short review 27

Tabular presentation Statistical Databases: A short review 28

Tabular presentation Statistical Databases: A short review 29

Chart Statistical Databases: A short review 30

Charts Statistical Databases: A short review 31

Ongoing developments and plans Moving to “Smart Client” components for data collection and validation l l l Offline data collection Validation and validation More robust data production module Data exchange l l l Web services SDMX, RSS Towards to Programmable web Geo-spatial presentations Analytical components l Aggregation, derivation Exploring Web 2. 0 Statistical Databases: A short review 32

Thank you Statistical Databases: A short review 33