1 / 25

R O S E T T A ENHANCING DATA QUALITY BY STANDARDISATION OF DATA ELECTRONIC EXCHANGE

R O S E T T A ENHANCING DATA QUALITY BY STANDARDISATION OF DATA ELECTRONIC EXCHANGE. Herbert Desel 1 & Martin Ganzert 2 1 Poison Centre GIZ-Nord, Göttingen, 2 Poison Centre Munich, Munich, Germany. Introduction.

jeremy-duffy
Download Presentation

R O S E T T A ENHANCING DATA QUALITY BY STANDARDISATION OF DATA ELECTRONIC EXCHANGE

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. R O S E T T AENHANCING DATA QUALITY BY STANDARDISATION OF DATA ELECTRONIC EXCHANGE Herbert Desel1 & Martin Ganzert2 1Poison Centre GIZ-Nord, Göttingen,2Poison Centre Munich, Munich, Germany Herbert Desel & Martin Ganzert

  2. Introduction • High quality consumer product data is an important information source for every poison centre’s work. • To achieve high data quality continous work on data is necessary • in companies • and in poison centres. • Experience: Data exchange is critical interface • standardisation is important for data quality (validity) Herbert Desel & Martin Ganzert

  3. 1996: Data quality improvement • EAPCCT and several European industry organisations (AIS:FIFE:FEA) worked on European harmonisation of data structures for exchange of consumer product data • and published: Herbert Desel & Martin Ganzert

  4. The EAPCCT Consumer Product Format Herbert Desel & Martin Ganzert

  5. EAPCCT-Newsletter April 1996 Herbert Desel & Martin Ganzert

  6. EAPCCT-Product Information Form Herbert Desel & Martin Ganzert

  7. Guidelines for Product Information Form Herbert Desel & Martin Ganzert

  8. Guidelines for Product Information Form II Herbert Desel & Martin Ganzert

  9. Herbert Desel & Martin Ganzert

  10. Herbert Desel & Martin Ganzert

  11. EAPCCT-Product Information Form II Herbert Desel & Martin Ganzert

  12. Experience Since 1996, • the harmonised format has been frequently used in Europe and • became the accepted standard for consumer product data exchange • data collections in European poison centres are frequently used as valuable tool for daily work • and may be used in future … Herbert Desel & Martin Ganzert

  13. Recent developments Meanwhile, … • changes in the market of consumer products have become faster, • with increasing computer power in PCs and companies • increasing opportunities of secure electronic data exchange • the need for an electronic data exchange is rising. Herbert Desel & Martin Ganzert

  14. Research Project TDIwww.tdi-network.org • a computer network is constructed that allows quick exchange of product data between • companies and poison centres and even between • poison centres and other poison centres Herbert Desel & Martin Ganzert

  15. TDI : Advantage for industry C1 the company serves one poison centres the „primary centre“ serves other poison centres PC1 … in an electronic way PC PC PC PC PC All PCs should be able to read all data and identify the data origin (“electronic endorsement”) This is realised using a standardized electronic data format Herbert Desel & Martin Ganzert

  16. ROSETTA Herbert Desel & Martin Ganzert

  17. TDI - Data Acquisition and Data Transfer • Product data is collected using the EAPCCT format • ROSETTA is used to transfer data between different computer systems Herbert Desel & Martin Ganzert

  18. TDI - Data Acquisition and Data Transfer ROSETTA is used to describe all data for transfer between different computer systems control data is included in an automatic way product data is collected according to the EAPCCT format company data is added (important for identification of authorship) control data Herbert Desel & Martin Ganzert

  19. ROSETTA file structure for a technically interested audience ROSETTA file (whole) data file - logistics product data (0, 1, or more products) • internal reference: • product linked to at least one company indicating • authorship • producer • distributor company addressesand identification numbers (one address per package mandatory) external reference lists(2) of addresses maintained by national institutions valuesofquality parameters - evaluation Herbert Desel & Martin Ganzert

  20. TDI Project‘s Work • The ROSETTA format has been designed. • ROSETTA was tested using … ROSETTA data package TDI EMIL a newly developed data acquisition program (EMIL) and an import programme connected to the TDI project's local databases Herbert Desel & Martin Ganzert

  21. ROSETTA Format Description - Basics • The data format “XMLROSETTA”was developed • using XML “language rules” (meta format) to describe the structural elements • this enables easy description of the format • and formal check of data quality • with standard tools freely available • by the data sender or by PC Herbert Desel & Martin Ganzert

  22. ROSETTA – Document Type Definition (DTD) <!-- ====================================================================== --> <!-- Rosetta XML V1.2 DTD Draft of 04.09.2002 Author: M. Ganzert --> <!-- ====================================================================== -> <!--rosetta_1.2_english_extended.dtd--> <!ELEMENT rosetta (file,product*,adress+,evaluation)> <!ELEMENT file (logistics_of_file)> <!ELEMENT logistics_of_file (rosetta_version_sender_system,sender,file_created)> <!ELEMENT rosetta_version_sender_system (rosetta_version,constants_version,system_name,system_version)> <!ELEMENT rosetta_version (#PCDATA)> <!ELEMENT constants_version (#PCDATA)> <!ELEMENT system_name (#PCDATA)> <!ELEMENT system_version (#PCDATA)> <!ELEMENT sender (sender_reference_type,sender_id)> <!ELEMENT sender_reference_type (#PCDATA)> <!ELEMENT sender_id (#PCDATA)> <!ELEMENT file_created (file_timestamp)> Herbert Desel & Martin Ganzert

  23. ROSETTA – DTD (cont.) <!ELEMENT product (identification_of_product,physical_chemical_properties?,legal_data,packaging?,general_data,category?,product_document_version,constituent+)> <!ELEMENT identification_of_product (logistics_of_product,name_date_numbers,manufacturer,distributor)> <!ELEMENT logistics_of_product (type_of_product_format,product_id_of_author)> <!ELEMENT type_of_product_format (#PCDATA)> <!ELEMENT product_id_of_author (#PCDATA)> <!ELEMENT name_date_numbers (product_name,release_date,article_number?,ubanr_product?,ean_list?)> <!ELEMENT product_name (#PCDATA)> <!ELEMENT release_date (#PCDATA)> <!ELEMENT article_number (#PCDATA)> <!ELEMENT ubanr_product (#PCDATA)> <!ELEMENT ean_list (#PCDATA)> ... ... ... Herbert Desel & Martin Ganzert

  24. Further technical information The complete ROSETTA format is published on the project's website • www.tdi-network.org for easy access by everybody interested. An additional monograph • “ROSETTA - rules for application” in German is available from the project’s German language website Herbert Desel & Martin Ganzert

  25. Conclusion: • Requirements for electronic product data exchange (using the EAPCCT format) between independent institutions have been fulfilled by ROSETTA • ROSETTA is prepared international data exchange. Herbert Desel & Martin Ganzert

More Related