1 / 15

Implementation of PC-Axis Solution in UNECE

Explore how the UN ECE implemented PC-Axis software, development approaches, collaboration through Open Source, and future plans. Learn about the savings in performance and tools for statisticians. Join the international collaboration and the future developments in data dissemination systems.

dvick
Download Presentation

Implementation of PC-Axis Solution in UNECE

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Implementation of PC-Axis Solution in UNECE UNECE Workshop on Developing Data Dissemination Systems – Geneva, 12 May 2007

  2. Contents • How UNECE implemented PC-Axis • Software development approaches • Collaboration through Open Source • Plans for Future

  3. Why UNECE adopted PC-Axis • Lack of resources – 1,5 persons/year • PC-Axis advantages: • Rich in features • User-friendly • Flexible structure • Strong support network of users – 30 other statistical organizations

  4. UNECE Metadata Input Application

  5. What software UNECE develops • Metadata Input Application • PX-Web Update Server • Time Series Computation Language

  6. Savings through performance! 1. Java as development platform • Richer features compared to Microsoft tools • Plenty of free ready-to-use open source projects: • eKit - visual HTML designer • translatrix - translation tool • Swabunga - spell checker • javacc - compiler compiler • dom4j - library to process XML • Highlighter - HTML, SQL, TSSL syntax coloring • csvReader/Writer - data import

  7. Savings through performance! 2. Developer’s Performance • Shift work to statisticians • Develop tools for statisticians • Rapid development framework: • Toolkit for developer • Runtime code extension • Automatic data validation for simple cases • Integrated application security

  8. Savings through performance! Example of using Open Source project Visual HTML Designer Spell checker

  9. Savings through performance! 3. Statistician’s Performance • SQL code generators for data mapping • Visual Data Mapping Designer • Visual HTML Designer • TSSL – Time Series Computation Language

  10. TSSL example to calculate country shares

  11. Savings through performance! • What can TSSL do: • As simple as writing sentences in English • Reaches compression 1:20 compared to SQL • Reduces development time from WEEKS to HOURS • Has Integrated Development Environment • Export data to PC-Axis • Can be used as analytical tool 3. Statisticians develop calculations

  12. Shortly about UNECE applications • Unified user interface • Object-oriented approach vs. record-oriented • English and Russian user interfaces • Extends standard PC-Axis database model: • “Hot” PX-Web update • Automatic metadata (time and value) generation • Visual Data Mapping Designer • Visual HTML Designer • Time Series Computation Language

  13. International Collaboration • UNECE applications are FREE • New Zealand and Guatemala joins UNECE software development project • They may start contributing later!

  14. Plans for Future • Develop End-to-End UNECE applications: • Data import • Validation • Processing • Calculation • Imputation • Dissemination • Develop online analytical tool • Organize Open Source community to unite efforts

  15. Thank you for listening! Questions?

More Related