Transcript The PC-Axis family

The PC-Axis family
A consortium for output databases
Presented by:
Ulrika Arver, Statistics Sweden
Statistics Sweden
What is PC-Axis…






2
Software platform for coherent, efficient and
user friendly dissemination of statistics.
Metadata rich
Windows, Internet and SQL extension
Dynamic multi dimensional tables
Easy conversion to several file formats
Includes whole spectrum of dissemination
products
Statistics Sweden
The software in the PC-Axis
family





3
PC-Axis main
module
PX-Web
PC-Axis SQL
PX-Batch
PX-Publ





PX-Make
PX-Edit
PX-iGraph
PX-Map
PX-iMap
Statistics Sweden
The PC-Axis file format
Plain ASCII
 Developed in harmony with the data
model in the Meta Database
 Very metadata rich
 Keywords in English
 Extension px

4
Statistics Sweden
Creating px-files
PX-Edit
 PX-Make
 Super cross
 TPL

5
Statistics Sweden
Main module cont.
6
Statistics Sweden
PX-Web
Server based database tool to
disseminate statistics as dynamic
tables on the Internet
 Requires a Microsoft Internet
Information Server
 Handles multiple language
 Options to customize

7
Statistics Sweden
8
Statistics Sweden
PX-Map & PX-iMap
→ PX-Map2
9
Statistics Sweden
The story of PC-Axis
Thesis on multidimensional matrices
by Dr. Bo Sundgren (70´s)
 Axis (80´s)
 PC-Axis (90´s)


Swedish Population Census (1990)
Relational output database (1997)
 PX-Web (1999)
 Ongoing development

10
Statistics Sweden
The consortium


Sweden managing the consortium
Nordic core - Sweden, Denmark and Norway






11
Develop the common Meta data model
International reference group
Swedish user group
Internal use group at Statistics Sweden
Internal group SSD
Steering committee for the Data Base project
at Statistics Sweden
Countries and organizations using PC-Axis
Statistics Sweden
Europe: Croatia, Denmark, Estonia, Finland,
Ireland, Iceland, Latvia, Lithuania, Norway,
Greenland, Republic of Slovakia, Slovenia,
Spain and Sweden
Asia: Taiwan, The Philippines, Kuwait
Africa: Algeria, Mozambique, Namibia,
Uganda, South Africa, Tanzania
South America: Bolivia and Brazil
Organizations: UN/ECE, East African
Community, FAO (Kyrgyzstan, Ghana, Kenya)
12
3 good reasons to choose
PC-Axis
Statistics Sweden



13
Fast and easy
Cost efficient
Constant improvement and used by
all the developers
Statistics Sweden
More information
www.pc-axis.scb.se
Example
14