140 likes | 280 Views
Cotrix , SDMX and EXL Rome , 28 March 2013 Erik van Ingen - FAO. Cotrix. Cotrix , a VocBench based multi-user environment: Ingestion and sharing code lists Managing the life cycle of a code Translate code lists Establish mappings between code lists
E N D
Cotrix, SDMX and EXL Rome, 28March 2013 ErikvanIngen - FAO
Cotrix Cotrix, a VocBench based multi-user environment: • Ingestion and sharing code lists • Managing the life cycle of a code • Translate code lists • Establish mappings between code lists • Support meta data harmonization in the fisheries data work-flows • Its model is inspired by SDMX, SKOS, GSIM and InfoSTAT (Bank of Italy) • Hosted on https://github.com/cotrix
Importing • From • CSV • SDMX • SKOS • dynamically from SPARQL endpoint • Anywhere through configurable importers
Managing • The version of the codelist • The notion of a CodeBag (collection of Codelists) and its version • The validityPeriod of each code (Sudan splits in North and South Sudan)
Publishing I through publication channels: • publicationchannel can be local (CSV export or REST interface) • publicationchannel is configurable, it can export to any system • publicationchannel can be an external SDMX Registry, SKOS repository or SPARQL endpoint
Publishing II a publication channel can be local or remote
Publishing III Immediate requirements • Cotrix needs to manage and publish the ASFIS and FaoMajorAreacodelists • These codelists are needed for the SEIF project, new SDMX DSD's are waiting for it
Status • http://cotrix-web.appspot.com/ • FAO Statistical Working System project would like to use and participate in Cotrix. They want a configuration with Oracle/PostgreSQL • Go here to see the meeting reports https://github.com/cotrix/cotrixrep/wiki/Meeting • The VocBench team accepted our DAO pattern. Once configuration will be with the VocBench and Semantic Turkey (from Rome Torvergata University)
Cotrix Future • End of April 2013: release version 0.1 • Codelist matching • Version difference reports • Concept management • Linking with vocabulary management • Research on handing over workflow to Activiti BPM Platform • Fine tuning Agile development process • May is the month to show the demo to FIPS and start involving them • Ton is leaving the project end of April, major blow
SDMX I • Ambition is to support SDMX 2.0 and SDMX 2.1 with OpenSDMX and SdmxSource in iMarine and data.fao.org (FAO data) • iMarine OLAP architecture is very similar to data.fao.org • There could be great synergies between the 2 projects, placing OpenSDMX in between • We are about to loose our patience with SdmxSource (Metadata Technology) • Planned visit to the Metis meeting in Geneve in May 2013 to learn more about GSBPM and GSIM and to talk with the SDMX community
SDMX II • SDMX-JSON is gong well. Dreaming about using this, bringing SDMX to R, Excel, R, MATLAB, SAS, SPSS, STATA and GAMS • Codelist management is on track. Now we can work on datastructure management, mapping and alignment!
EXL • The request for EXL is out. Bank of Italy received it, waiting for response. • Beginning of April there will a telco with the SDMX TWG in order to discuss EXL in SDMX.