Demonstration of the Prototype model for ECA Statistical Database

1
StatBase Regional Statistical Database

• Prototype model for ECA Statistical Database

• April 2005
• Statistics - ESPD

• Demonstration of the Prototype model for ECA
  Statistical Database

2
TOPICS

• Objectives and Scope
• Design methodology
• Development platforms
• Components
• Brief Demonstration
• Next steps

3
Objectives and Scope

• Creating a central database system to manage all
  macro time-series statistical data
• To create a corporate platform for ECA
  statistical data management
• Provide easy access to time series
  information/data to End users inside and outside
  ECA
• Support research and publications

4
Development/Production platform

• Interfacing languages ASP.NET/Java
  Script/HTML/XML
• Dot Net framework 1.1.
• Database management system SQL SERVER 2000
• Web Server Internet Information Server (IIS)
• Operating system Windows 2000/2003

5
User/Client requirement

• Browser software (Netscape 4 or Internet Explorer
  5)
• Window 9x and later / Linux

6
Design Steps/Methods

• Review existing practices
• Requirement identification
• Review of similar databases
• Literature review on the current trends in
  database development
• Model the database
• Development
• Testing and Feedback
• Implementation/Production

7
Development

• Web-enabled application
• Coding standard developed
• Breakdown of application
• User interface
• Business logic
• Data

8
Indicators Metadata Model
9
Time-Series Data Model
10
Data organization
Sub class

• Main areas
• Real sectors
• Social statistics
• .

• Indicators
• Population size by age
• Infant mortality rate

• Indicator sub classes
• (Indicator S Unit)
• Population size age 0-4 Female Thousands
• Population size - age 0-4 Male - Thousands

• Sectors
• Agriculture
• Population
• Gender
• Environment
• Health
• Trade
• .

Indicator
Unit
11
Sub-regional Classification
12
Metadata/Parameter
13
Data Security Model

• Roles
• Approver
• Administrator
• Compiler

• Sectors
• User will be assigned one or more sectors

14
Statistician Security
Compiler

• Sectors
• Agriculture
• Population
• Gender
• Environment
• Health
• Trade

Data entry
Approver
Administrator
Approval
Metadata
Administration
All
Report
Search
15
Related data models
16
The database models
17
Components

• Statistician component
• Online access/Public use

18
Statistician

• Modules
• Administration
• Metadata
• Preferences
• Searching
• Report
• Data manager

19
Take the URL and run! URL http//172.26.50.101/st
atBase
StatBase Regional Statistical Database
20
StatBaseOnline Online Access

• Features
• Metadata
• Browse
• Search
• Export
• Interactivity
• One stop-shop
• Time-series data and related information and
  services
• Read-only No data edition facility

21
Take the URL and run! URL http//172.26.50.101/st
atBaseonline
StatBaseOnline Regional Statistical Database
22
Next steps

• Testing
• Populating the database
• Metadata
• Time-Series data and related information
• Presentation components Graph, GIS
• Training
• Publishing on the production Server, etc

23
(No Transcript)
24
Thank you