1 / 17

Health & Consumers DG SANCO Unit A.4 Information systems

Health & Consumers DG SANCO Unit A.4 Information systems. Web Services Exchange as concerns organisations. Contents . Background Objectives Functional overview Technical overview Current status. Background.

johnsonadam
Télécharger la présentation

Health & Consumers DG SANCO Unit A.4 Information systems

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. Health & Consumers DG SANCOUnit A.4 Information systems Web Services Exchange as concerns organisations TRACES Seminar Palermo

  2. Contents • Background • Objectives • Functional overview • Technical overview • Current status TRACES Seminar Palermo

  3. Background • TRACES DBs contain a plethora of reference data (countries, regions, cities, businesses…) • Many duplicates (e.g. Gothenburg, Göteborg, Goteborg…) • Constant clean-up operations ongoing in TRACES DBs • A better way is necessary TRACES Seminar Palermo

  4. Objective • One reference database, which is shared by multiple applications’ dedicated DBs • Responsibility for a certain type of data at the appropriate level • For purposes of TRACES, we will provide this for cities and for business organisations TRACES Seminar Palermo

  5. The Target Audience • The user will be a Member State Authority (central or regional) • Every MSA is responsible for managing its cities and businesses • An MSA can not add reference data to an area outside its area of authority TRACES Seminar Palermo

  6. Functionality offered • Secure connection • Query, view • Add • Delete • Download lists: • City – authority – GIS coordinates • businesses TRACES Seminar Palermo

  7. Accessing the exchange • Via web UI: allows for manual access to the webservices exchange • Via webservices API: allows for automated access to the webservices exchange TRACES Seminar Palermo

  8. Exchange Web UI Search cities Add a city Manage your requests Download list for offline processing Delete a city TRACES Seminar Palermo

  9. Some technical details • Submissions from Member States in pre-defined XML format • XSD schemas available for cities • Something on the internals: • Builds on DG SANCO’s “XMLGate” platform • XMLGate is the single entry point for Web services between Member States and SANCO • XMLGate is used by several SANCO applications (RASFF, ADNS…) TRACES Seminar Palermo

  10. Exchange request flow XML XML queue result result sync, update extract result update The processing is asynchronous, processing a request takes in the order of 15 minutes TRACES Seminar Palermo

  11. Handling business organisations • This is more a complicated case: • More fields • Duplicates and similarities are inevitable • Subject to frequent changes (start up, closure, change of activity…) • The exchange will need to handle all these aspects • Extensive pilot testing needed TRACES Seminar Palermo

  12. Handling businesses peculiarities • Abundance of businesses: • allow batch upload • Detect duplicates: Levenshtein’s distance for similarity calculation • Considering offline tool to allow MSA batch processing (e.g. of duplicates) • Linked to “SancoClean” TRACES Seminar Palermo

  13. Initial Load –synchronising the databases MSA reference DB TRACES reference DB Merge with approval number from MSA In TRACES not in MSA: inform In MSA not in TRACES: add TRACES Seminar Palermo

  14. Keeping the list up-to-date • Different options are possible: • Periodic upload (daily, weekly…): pattern will be similar to the ‘Initial load’ (but with a delta only) • Triggered upload (immediate for every added or modified business) • The Exchange will be able to handle both these scenarios TRACES Seminar Palermo

  15. TRACES interface • Creating a business will depend on: • Member State (“automated” or “non-automated”) • type of activity • Status “Prevalid” will no longer exist for an “automated” country • Depending on type of activity • A “non-automated” MSA can not create a business in an “automated” MS • An “automated” MSA can create a business in a “non-automated” MS TRACES Seminar Palermo

  16. Current status • Exchange for cities • exchange available for deployment • pending infrastructural adaptations • Target deployment: Q1 2010 • Exchange for businesses • development progressing • pilot run foreseen • still some unclear areas • Target pilot run: Q2 2010 TRACES Seminar Palermo

  17. Questions & Discussion TRACES Seminar Palermo

More Related