Transcript II. ICT Strategy in the Production, Dissemination of Official Statistics

Meeting on the Management of Statistical Information
Systems (MSIS 2010)
(Daejeon, Republic of Korea, 26-29 April 2010)
NIS ICT Strategy in the Production of Official
Statistics, Dissemination and Data warehouse
by Panhara OUKCHAY
Deputy Director of ICT Department, National Institute of Statistics,
Ministry of Planning, Cambodia
1
Content
I.
II.
Introduction
ICT Strategy in the Production, Dissemination of
Official Statistics
A. Standardized Network
B. Data Storage
C. Software
D. Dissemination
E. Data Warehouse
F. Backup
G. Staffing
III. Conclusion
2
I. Introduction
•
Decentralized statistical system: NIS compiles and
consolidates statistics provided by decentralized
offices and also collects primary data.
•
New recently reorganization of NIS (June 2009): To
meet the increasing demand of wide range of statistics
of good quality. ICT department is one of the news
department that just established.
•
The ICT Strategy for the NIS is very importance. There
exists a need for NIS to modernize and extend its ICT
to secure timely and accurate statistics serving
governmental and the public.
3
II. ICT Strategy in the Production,
Dissemination of Official Statistics
A. Standardized Network
- A new physical network design for NIS has been
elaborated.
- The servers type of the NIS Domain are:
1. Domain Controller
2. Database Servers
3. File Servers
4. Communication Servers
5. Backup Servers
6. Application Servers
4
II. ICT Strategy in the Production,
Dissemination of Official Statistics (con’t)
B. Data Storage
•
•
A Client/Server based DBMS like MS SQL Server: A few
factors to take into consideration on which DBMS to use:
- Data integrity – Security
- Performance
- Backup and Maintenance
- Data Warehousing
Microsoft SQL Server contains a complete storage solution for
an organization like NIS with the following components:
- Storage Engine
- Data Extraction, Transformation and Load (ETL) tools
- Data Mining
- Data Warehousing
- Strong Access Security System
5
II. ICT Strategy in the Production,
Dissemination of Official Statistics (con’t)
C. Software : The number of different software should be
minimized. Based on the fact that the software should
be recommended for the NIS:
-
Statistical software – Stata, SPSS
Tabulation and dissemination tools – SPSS, Excel
SuperCROSS, MS SQL Server, CAMInfo,...
Office software – Microsoft Office, Open Office (KH)
Software Development tools – VB6, VB.Net and
CSPro
Antivirus Software: Symantec Antivirus, Trend
Micro Antivirus Corporation Edition
6
II. ICT Strategy in the Production,
Dissemination of Official Statistics (con’t)
D. Data Dissemination: NIS is using tools below to
disseminate its products to all type to users:
- A Dynamic Website http://www.nis.gov.kh (May2009)
7
II. ICT Strategy in the Production,
Dissemination of Official Statistics (con’t)
- Censuses Results On-Line
8
II. ICT Strategy in the Production,
Dissemination of Official Statistics (con’t)
- The National Data Archive Software (NADA) and
Toolkit : (Web based application tool): Various surveys
documentation (Meta Data)
9
II. ICT Strategy in the Production,
Dissemination of Official Statistics (con’t)
- Statistical Data and Metadata Exchange (SDMX): NIS
is planning to implement the SDMX standards for
exchanging data and metadata.
- SuperCROSS (Data warehouse): this solution is very
useful within organization network especially all subject
matter teams (internal use). Later on in next step we
are planning to establish this into the government
network and and web as tabulation and dissemination
tool (SuperWEB).
10
II. ICT Strategy in the Production,
Dissemination of Official Statistics (con’t)
11
II. ICT Strategy in the Production,
Dissemination of Official Statistics (con’t)
- CAMInfo (the localized version of DevInfo)
12
II. ICT Strategy in the Production,
Dissemination of Official Statistics (con’t)
E. Data warehouse:
- DBMS : MS SQL Servers
- SuperSTAR families software suit (SuperCROSS,
SuperSERVER, SuperCHANNEL, SuperWEB,
SuperTABLE)
13
II. ICT Strategy in the Production,
Dissemination of Official Statistics (con’t)
F. Backup : Regular backup of server drives should be
carefully planned and reliable equipment using. A
network backup plan is always important to make a
plan for back up system.
- Types of Backup
. Normal Backup
. Copy Backup
. An incremental backup
. A Differential Backup
. A Daily backup
14
II. ICT Strategy in the Production,
Dissemination of Official Statistics (con’t)
G. Staffing : A statistical agency like NIS the ultimate goal is
to ensure IT competence on all levels in order to be selfreliant. Five areas of interest will be identified with different
demands on IT skills:
- Day-to-Day word processing and spreadsheet handling
- LAN operation and maintenance
- Database design, maintenance and administration
- Statistical tabulation and analysis
- In-House Application Development
15
III. Conclusion
- Statistical agencies must recognize that the ICT Strategy
needs to support the key priorities in the most cost-effective
manner and must also understand the risks and challenges
of ICT Strategy because it is a very importance role in its
production of official statistics.
- It is long-run strategy plan due the NIS has a very limit of
human resources, So capacity building for ICT staffs is
needed to be done through daily job and in-house training.
- All ICT staffs of NIS should have general knowledge of each
area but have near specialist competence in their own field
to achieve this goal substantial training within the ICT-field
is necessary.
16