EIONET / DG SOER
Ministry of Ecology and Sustainable
Development
November 2006
Water Directorate
Data managementfor SOE in France
René LalementWIS-France Taskforce
EIONET / DG SOER
Ministry of Ecology and Sustainable
Development
November 2006
Water Directorate
Data management
Multiple data producers (12 competent authorities, 6 water agencies, 4 specialised institutes, 150 laboratories, ... )
Multiple data bases
Common uses -> needs for• interoperability• reliability• comparability• sustainability
Solved by a common reference framework (« Sandre » framework)
EIONET / DG SOER
Ministry of Ecology and Sustainable
Development
November 2006
Water Directorate
Common reference framework
• Extensive data dictionaries and data models
• Reference datasets
• Data exchange formats: EDI frames then XML
• Metadata: business md, then regular ISO 19115
• Data services: for reference datasets (web services: SOAP, REST) and monitoring results (2007)
See www.sandre.eaufrance.fr
EIONET / DG SOER
Ministry of Ecology and Sustainable
Development
November 2006
Water Directorate
Data dictionary
What is a “sample” ?
Conceptual interoperability (or human interoperability)
At discursive level:
• Definition • Rules and constraints on participating processes and actors• Components
EIONET / DG SOER
Ministry of Ecology and Sustainable
Development
November 2006
Water Directorate
Data dictionary
What is a sample ?
EIONET / DG SOER
Ministry of Ecology and Sustainable
Development
November 2006
Water Directorate
Reference dataset
What substance does CAS number 15972-60-8 refer to ?
Binding tables: • international level: ISO, ESTAT, CAS, ...• national level: Sandre,...
For : RBD, waterbodies, monitoring stations, UWWTP, ...
EIONET / DG SOER
Ministry of Ecology and Sustainable
Development
November 2006
Water Directorate
Data model
From discursive to formal level: • conceptual diagram (or UML class diagram)• does not capture everything
then • XML schema for exchange scenario
syntactic interoperability (or human aided machine interoperability: allows for a common data repository)
then • Web services (with XML payload)
EIONET / DG SOER
Ministry of Ecology and Sustainable
Development
November 2006
Water Directorate
<xs:element name="Echantillon" maxOccurs="unbounded"> <xs:complexType> <xs:sequence> <xs:element name="RefEchantillonCommanditaire" type="sa_lab:RefEchantillonCommanditaire" minOccurs="0"/> <xs:element name="RefEchantillonPrel" type="sa_lab:RefEchantillonPrel" minOccurs="0"/> <xs:element name="RefEchantillonLabo" type="sa_lab:RefEchantillonLabo" minOccurs="0"/> <xs:element name="DateReceptionEchant" type="sa_lab:DateReceptionEchant" minOccurs="0"/> <xs:element name="Laboratoire"> <xs:element name="Contact" minOccurs="0">...</xs:element>
EIONET / DG SOER
Ministry of Ecology and Sustainable
Development
November 2006
Water Directorate
Service oriented architecture
One data portal may give access to multiple service providers.
One service providers may supply data to multiple data portals.
EIONET / DG SOER
Ministry of Ecology and Sustainable
Development
November 2006
Water Directorate
Quality assurance & control
• Accreditation (ISO 17025) of laboratories is mandatory, including inter-lab comparisons
• By the French accreditation body or any European equivalent body
• Extended accreditation audits check additional requirements (LoQ, ...) from FR/EU regulations
• Analyses must be done under the accreditation conditions
• Analytic performances and traceability of results are implemented in the data exchange scenario