R o s e t t a enhancing data quality by standardisation of data electronic exchange
Download
1 / 25

R O S E T T A ENHANCING DATA QUALITY BY STANDARDISATION OF DATA ELECTRONIC EXCHANGE - PowerPoint PPT Presentation


  • 104 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' R O S E T T A ENHANCING DATA QUALITY BY STANDARDISATION OF DATA ELECTRONIC EXCHANGE' - jeremy-duffy


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
R o s e t t a enhancing data quality by standardisation of data electronic exchange

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


Introduction
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


1996 data quality improvement
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


The eapcct consumer product format
The EAPCCT Consumer Product Format

Herbert Desel & Martin Ganzert


Eapcct newsletter april 1996
EAPCCT-Newsletter April 1996

Herbert Desel & Martin Ganzert


Eapcct product information form
EAPCCT-Product Information Form

Herbert Desel & Martin Ganzert


Guidelines for product information form
Guidelines for Product Information Form

Herbert Desel & Martin Ganzert


Guidelines for product information form ii
Guidelines for Product Information Form II

Herbert Desel & Martin Ganzert




Eapcct product information form ii
EAPCCT-Product Information Form II

Herbert Desel & Martin Ganzert


Experience
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


Recent developments
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


Research project tdi www tdi network org
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


Tdi advantage for industry
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


Rosetta
ROSETTA

Herbert Desel & Martin Ganzert


Tdi data acquisition and data transfer
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


Tdi data acquisition and data transfer1
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


Rosetta file structure for a technically interested audience
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


Tdi project s work
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


Rosetta format description basics
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


Rosetta document type definition dtd
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


Rosetta dtd cont
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


Further technical information
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


Conclusion
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


ad