PCAXIS in CBS Croatia

1
PC-AXIS in CBS CroatiaPresented by Dubravko
krlec, IT Assistant Director
2
Some facts about Croatia

• Independent since 1991.
• 56 594 km2
• 1 185 islands, rocks and reefs
• Coastline 5 835,3 km
• Population 4 437 460
• Capital Zagreb population 779 000
• GDP per capita 9 266 Euro
• Average monthly net earnings 4.139 kn (560 Euro)
• Unemployment rate 17,2

3
Some facts about CBS

• 370 employees
• 7 sectors
• No regional offices
• 2 locations in Zagreb connected through optical
  link
• Every employee PC, Internet connection and
  e-mail adress
• gt 200 surveys

4

Windows 2003 network (340 Workstations)
Storage EMC2 Symetrics
Mainfeame IBM 9672 R31
OS/390 CICS, PLI, Universe etc.
OCR
Printing subsystem
5
More facts about CBS

• Host PL/I
• Server platform Windows2003
• Clients Windows XP Professional, Office
  2000/XP/2003
• DB Microsoft SQL Server 2000
• Development MS VB 6.0 .net, BLAISE, SAS, TPL
  (new)
• Dissemination PC-Axis
• Data capture IBM IFP
• Coding ACTR (Automated Coding by Text
  Recognition)
• DB Design Sybase PowerDesigner, Rational Rose
• Metadata management runSoftware Bridge (in
  development for classifications)

6
Main IT goals

• Move from the mainframe to the client server
• environment
• Construction of a statistical DATABASE
• Development of central metadata repository

ENABLE STATISTICIANS TO PRODUCE SURVEYS
INDEPENDENTLY
STATISTICAL TOOLBOX
7
CBS/SCB-SIDA Project

• Development of Central Meta Data Repository and a
  Public Macro Data Base at the Cental Bureau of
  Statistics of Croatia
• Started in February 2002.
• Expected to finish in 2005.

8
Current situation in use

• CROMETA 1
• The first version of meta database (SQL 2000)
• INVENTORY
• Application for collecting statistical metadata
  in CROMETA
• BRIDGE
• Software managing classifications
• METADATA DRIVEN APPLICATIONS
• Justice Survey, Industry, Trade...

9
Current situation in development

• CENTRAL METADATA REPOSITORY
• - using the Neuchatel terminology model (model
  formed by statistitians from Switzerland, Sweden,
  Norway and Denmark)
• - integrating the specifics of
• BridgeNA ClassE
• CROMETA 1
• PC-AXIS
• METADATA DRIVEN DATA ENTRY (Justice Surveys
  Prototype)
• GENERATOR
• PUBLIC MACRO DATABASE

10
PC AXIS

• Acquired in 2003. as the strategic tool for data
  dissemination
• The aim is to integrate PC-AXIS as part of the
  permanent solution for the new integrated
  statistical information system

11
PC-AXIS - preparations

• Translations of main modules to Croatian
• Translations of help files
• Translations of manuals
• Preparing data for PX-MAP module
• Inserting Croatian maps
• Adjusting PX-WEB and PX-iMap

12
(No Transcript)
13
PX-MAP - Counties
14
PX-MAP - Municipalities
15
PX-MAP - Settlements
16
Inserting of Croatian maps
17
PX-WEB
18
PX-WEB
19
Agricultural Census 2003.

• Published in December 2003. on CD WEB
• Booklet on PC-AXIS usage
• Success!

20
Retrospect population censuses since 1857
NEW

• Big tables
• 10 000 footnotes
• Maps down to settlements

Vital statistics births and deaths since 1964
21
PC-Axis SQL

• CBS starting with macro
• prototype implementation
• connected to central metadata repository
• integrated in database system
• automated solution (in relation to PX-files
  created with PX-Make and PX-Edit)

22

• MetaData
• texts
• classifications
• different
• languages
• organisation
• information
• footnotes,etc.

Agregated data (macro data)
Micro data register
Agregated data (macro data)
Agregated data (macro data)
Agregated data (macro data)
PC-Axis
PC-Axis tables
23
Prototypes Justice Surveys, Agricultural census
and Foreign Trade Import/export

• Big demand
• Millions of rows

24
Foreign trade
25
CBS Public macro data base

• Enables any user to access, browse and retrieve
  the public macro data through the central
  metadata repository
• Different formats should be supported Excel,
  PC-Axis, text files etc.
• Public macro data should support viewing of data
  in all languages defined by the underlaying
  central metadata repository

26
CBS Public macro data base
27
CBS Public macro data base
28
Future plans

• To retrieve data for PC-AXIS directly from the MS
  SQL databases
• To automatically update the data of PC-AXIS
  databases from the central metadata repository
• To automatically add new surveys to the PC-AXIS
  databases making the results availible directly
  through the dissemination tool
• To provide publications on CD-s using PC-AXIS
• To use PX-Web on the CBS website
• To fully integrate PC-AXIS in the future
  statistical information system
• Producing PX files with TPL

29
Problems
30
Thank you for your attentionPresentation
performed byDubravko krlecCentral Bureau of
Statistics of CroatiaTel 385 (0)1 48 18
781Fax [phone]E-mail
dskrlec_at_dzs.hr
31
Afternoon

• Meeting at 6 p.m. at the entrance of Hotel
  Dubrovnik sightseeing with a guide old town
• 8 p.m. Dinner at Katedralis restaurant
  Bakaceva street on the way from Jelacic square
  to the chatedral

32
Worth seeing

• Picasso and Dora Maar paintings and photographs
  Klovicevi dvori, Jezuitski trg, Old Town
• 7000 years of Persian culture Mimara museum
  Roosevelt trg, close to the Opera house

33
Good restaurants

• Boban Italian - same street as Hotel Dubrovnik
• Cantinetta Nikole Tesle street just arround
  the corner from Hotel Dubrovnik
• Blato Dalmatian Masarykova street does not
  look great, but great seafood
• Asia Chinese Augusta enoe street
• Dubravkin put, Dubravkin put b.b. seafood,
  expensive
• Makronova macrobiotic Ilica 72