1 / 15

Efficient Migration Approaches and Tools for Stat Suite

Explore various methods and tools for successful migration presented by experts. Detailed agenda includes scenarios, tools presentation, breakout sessions, and open discussions for conclusions.

katrinap
Download Presentation

Efficient Migration Approaches and Tools for Stat Suite

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. Migrating to the .Stat Suite Different approaches and tools available to assist in the migration Prepared and presented by Edgardo Greising (ILO) Gyorgy Gyomai (OECD)

  2. Agenda • Presentation of scenarios & tools • Breakout session: one group per scenario (30 min) • Groups’ presentations (5 min each) • Open discussion and conclusions

  3. Migration Scenarios • Existing system is SDMX-capable or the Data Model is “close” to SDMX IM • A Database exists but requires re-modelling • No Database. Diversity of data sources

  4. Existing SDMX capabilities • Cubes may require re-modelling • Load first, transform in DLM • Transform off-line and upload definitive structures • Harmonization • Transitional solution for visualization • Toolkit [Which tools to use in the process for structure design, concepts recoding]

  5. Data Model is “close” to SDMX IM • Add SDMX capabilities  Go to previous case • Cubes will require re-modelling: • Transform off-line and upload the new structures • Harmonization • Toolkit [Which tools to use in the process for structure design, concepts recoding]

  6. Non-SDMX database • Questions to ponder • Spacing [How many Dotstat spaces to maintain?] • Timing [Timescale and steps for the migration] when considering timing issues like skills building, data model development, migration planning come to play • Toolkit [Which tools to use in the process for structure design, data-flow (re)-routing?]

  7. No structured database – ‘blank page’ • Similar to the non-SDMX database • Bigger emphasis on knowledge acquisition, steeper learning curve • Fewer spacing dilemmas, and less ‘rugged edge’ • Toolkit [Which tools to use in the process for structure design, data-flow (re)-routing?]

  8. SMART SDMX Registry Structural Metadata SMART DATACONVERSION DATA REPORTING DSD Dataset Dataset Dataset Microdata LMIS UPLOAD LMI ANALYSIS Aggregated Data NRP PROJECT

  9. DSD Constructor Load & Edit a DSD Upload concepts SDMX Registry Codelist DSD DSD Upload Code lists Manual entry

  10. Excel2CSV Add-in Excel2CSV Add-in

  11. All together DSD CONSTRUCTOR DSD SMART Excel2csv DATA REPORTING PROJECT

  12. Excel Domain Modeler – with SDMX generator • https://github.com/OECDSTD/sdmx-matrix-generator

  13. Eurostat Data Structure Wizard • An SDMX artefact editor • Persisting locally or providing a frontend for and SDMX registry • The user needs to have an understanding of the relationship between the different objects • However user-friendly UI, no need to directly manipulate the SDMX syntax

  14. EDD scripting (Excel Data Description)

  15. Some powertools to consider • ILO plugin for Dotstat • Eurostat SDMX-RI plugin to Dotstat (with Mapping Assistant) • ISTAT Meta-manager

More Related