Joint ECE/Eurostat/OECD Meeting on the Management of Statistical Information Systems (MSIS)
Download
1 / 16

Keywords to describe the PC-Axis family are: - PowerPoint PPT Presentation


  • 368 Views
  • Uploaded on

Joint ECE/Eurostat/OECD Meeting on the Management of Statistical Information Systems (MSIS) Geneva, 17-19 May 2004 Topic (iii): Open source and software consortia in statistics The PC-Axis Software Family a ”Consortium” for output databases Lars Nordbäck [email protected]

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Keywords to describe the PC-Axis family are:' - LeeJohn


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Slide1 l.jpg

Joint ECE/Eurostat/OECD Meeting on the Management of Statistical Information Systems (MSIS)

Geneva, 17-19 May 2004

Topic (iii): Open source and software consortia in statistics

The PC-Axis Software Family a ”Consortium” for output databases

Lars Nordbäck

[email protected]


Keywords to describe the pc axis family are l.jpg
Keywords to describe the PC-Axis family are: Statistical Information Systems (MSIS)

  • Dissemination of statistics online (PX-Web or PX-Web components) and off line (PC-Axis Main module)

  • Dynamic tables – pivot function (PX-Web and PC-Axis Main module)

  • Conversion to different file formats (PX-Web and PC-Axis) i.e. Excel, Lotus, txt, etc. and for PC-Axis only Gesmes/TS (and XML when a DTD is available)

  • Output database (PC-Axis database and/or SQL database)

  • Many dimensional Matrices/Cubicles/Boxes (PC-Axis files and SQL database)

  • Metadata rich data model in SQL and in the PC-Axis file format

  • Windows (PC-Axis) and Internet (PX-Web)


Keywords continued l.jpg
Keywords (continued) Statistical Information Systems (MSIS)

  • PC-Axis files in a catalogue structure forms a PC-Axis database and is accessed without using SQL (PC-Axis Main module and PX-Web)

  • SQL-extension (Sybase/Oracle/MS-SQL-Server) for a SQL database structured according to the common macro meta data model (PC-Axis SQL and in some cases PX-Web components and PC-Axis/PX-Batch components in Internet User Interface to a macro database)

  • Grouping facilities (PC-Axis and PX-Web)

  • Graphs (PX-iGraph)

  • Maps (PX-Map and PX-iMap)

  • Production of PC-Axis files from different sources (PC-Axis SQL, PX-Batch, PX-Make, PX-Edit and the Australian SuperStar/SuperCross)

  • Tables direct from a SQL or a PC-Axis database inserted into MS-Word or MS-Excel (PX-Publ)


Pc axis main module l.jpg
PC-Axis main module Statistical Information Systems (MSIS)

  • Text

  • Text

  • Text


Pc axis file format l.jpg
PC-Axis file format Statistical Information Systems (MSIS)


Px map l.jpg
PX-Map Statistical Information Systems (MSIS)

  • Text

  • Text

  • Text


Px make l.jpg
PX-Make Statistical Information Systems (MSIS)

  • Text

  • Text

  • Text


Px edit l.jpg
PX-Edit Statistical Information Systems (MSIS)

  • Text

  • Text

  • Text


Slide9 l.jpg

PX-Web, disseminating dynamic tables on Internet Statistical Information Systems (MSIS)

The same way of accessing statistics from a lot of different Statistical Offices


Px web dynamic table l.jpg
PX-Web dynamic table Statistical Information Systems (MSIS)

  • Text

  • Text

  • Text


Px imap l.jpg
PX-iMap Statistical Information Systems (MSIS)

  • Text

  • Text

  • Text


Px web application generator l.jpg
PX-Web application generator Statistical Information Systems (MSIS)

  • Text

  • Text

  • Text


Pc axis sql macro l.jpg
PC-Axis SQL Macro Statistical Information Systems (MSIS)

  • Text

  • Text

  • Text


Px publ l.jpg
PX-Publ Statistical Information Systems (MSIS)

  • Text

  • Text

  • Text


The function of the pc axis consortium l.jpg
The function of the PC-Axis “consortium” Statistical Information Systems (MSIS)

  • Statistics Sweden as the leading country managing the cooperation

  • The PC-Axis International Reference Group for all parties outside Sweden using PC-Axis as a dissemination tool

  • A Nordic kernel for cooperation in the output database area where Denmark, Norway and Sweden are using the same data model

  • A Swedish user group for the use of PX-Web applications in other organisations in Sweden

  • An internal user group at Statistics Sweden

  • A board where some of the main end users are consulted concerning the development of Sweden’s Statistical Database

  • A steering committee for the Data Base Project at Statistics Sweden, where PC-Axis constitutes one of the important ingredients


Slide16 l.jpg

Countries using the PC-Axis family software Statistical Information Systems (MSIS)

Europe: Croatia, Denmark, Estonia, Finland, Ireland, Iceland, Latvia, Lithuania, Norway, Slovenia, Spain, Sweden and UN/ECE in Geneva

Asia: Taiwan, The Philippines

Afrika: Algeria, Kuwait, East Africa Community, Namibia, Uganda, South Africa

South America: Bolivia and Brazil

Discussions with Slovakia and Tanzania


ad