Bayerisches Staatsministerium für Umwelt, Gesundheit und Verbraucherschutz Development of a Web-Service for the DIOXIN- Database of Germany Federal Environmental

Bayerisches Staatsministerium

für Umwelt, Gesundheit

und Verbraucherschutz

Development of a Web-Service for the

DIOXIN- Database of Germany

Federal Environmental Agency Berlin / G. Knetsch

Bavarian State Ministry of the Environment, Public Health and Consumer

Protection / E. Weihs

deborate GmbH / R. Pöschel

EnviroInfo 2004, 18th International Symposium, October 21st to 23rd 2004,

CERN Genf, Switzerland




AgendaAgenda• Political backgroundPolitical background

• Concept of the realization Concept of the realization

• Conclusion and OutlookConclusion and Outlook

• Technical approachesTechnical approaches

• Special approachesSpecial approaches

• Prototyping of the Web-Service Prototyping of the Web-Service

• Political backgroundPolitical background




• Commission of 37Commission of 37thth Conference of Environment Conference of Environment Ministers of Germany in 1991 to the DIOXIN Ministers of Germany in 1991 to the DIOXIN Working Group (Federal-Länder joint working Working Group (Federal-Länder joint working group)group)

• POP-Convention (2002) and obligations of POP-Convention (2002) and obligations of reporting (EEA, UN/ECE, EU)reporting (EEA, UN/ECE, EU)

• 44thth Conference of Ministers of Europe in Conference of Ministers of Europe in Århus „Environment for Europe“ (1998) and the Århus „Environment for Europe“ (1998) and the Admendment of the Environmental Information Admendment of the Environmental Information Act Act




AgendaAgenda






• Special approachesSpecial approaches • Special approachesSpecial approaches




• Cooperation with the Federal Office of Cooperation with the Federal Office of Consumer Protection and Food Safety (BVL) Consumer Protection and Food Safety (BVL) and the Federal Institute for and Risk and the Federal Institute for and Risk Assessment (BfR) (link between environment Assessment (BfR) (link between environment and health)and health)

• Documentation of meta-data and analytic data for Documentation of meta-data and analytic data for the evaluation and assessment of the state of the evaluation and assessment of the state of environment environment

• Cooperation with the Federal Laender (mainly Cooperation with the Federal Laender (mainly data producer and supplier of monitoring data producer and supplier of monitoring programmes)programmes)




• Transfer, evaluation and access to these Transfer, evaluation and access to these environmental and health data via a Web-environmental and health data via a Web-application (Data sharing)application (Data sharing)

• Documentation of validated time series (Quality Documentation of validated time series (Quality assurence of the DIOXIN-Database) assurence of the DIOXIN-Database)

• Profile specific data requests to the Web-Profile specific data requests to the Web-Service of different user groups (data producer Service of different user groups (data producer and provider, special user and public)and provider, special user and public)




• Data Shering requires cooperation with partners Data Shering requires cooperation with partners involved in technological research and „cutting- involved in technological research and „cutting-edge“ projectsedge“ projects

„„Experience Sharing“Experience Sharing“

• Cooperation with Cooperation with Bavarian State Ministry of the Bavarian State Ministry of the Environment, Public Health and Consumer Environment, Public Health and Consumer Protection (Agreement of Cooperation)Protection (Agreement of Cooperation)




AgendaAgenda






• Technical approachesTechnical approaches• Technical approachesTechnical approaches




Target:Target:

• Sharing of the DIOXIN-Database via modern Sharing of the DIOXIN-Database via modern technologies of Internet (XML)technologies of Internet (XML)

Federal States (Laender) and institutes as datenprovider with sharedFederal States (Laender) and institutes as datenprovider with shared mode to the data mode to the data

Public user with limited access to the databasePublic user with limited access to the database

Professional user (poweruser) with shared mode to aggregated dataProfessional user (poweruser) with shared mode to aggregated data

• Technological optimizing and Technological optimizing and „modernisation“ of the functionalities of the „modernisation“ of the functionalities of the existing Client-Server-applicationexisting Client-Server-application




Consinderation of the UBA-Styleguides and Consinderation of the UBA-Styleguides and guidelines of securityguidelines of security

Interface to the German Environmental Network Interface to the German Environmental Network (gein®) and the virtuell datakatalogue (vUDK)(gein®) and the virtuell datakatalogue (vUDK)

Use of Open-Source-SoftwareUse of Open-Source-Software

Admission to the data via the Internet under Admission to the data via the Internet under reconditions of the W3C-standard (XML-schema) reconditions of the W3C-standard (XML-schema)

Integration of existing tools (Statistic, Reporting-Integration of existing tools (Statistic, Reporting-Tool NetCharts)Tool NetCharts)

Generell conditions:




Technical components:•Processing language JavaProcessing language Java•Apache WebserverApache Webserver•Apache TOMCAT (Servlet Engine)Apache TOMCAT (Servlet Engine)•Apache Axis (Framework for Webservices)Apache Axis (Framework for Webservices)•Apache CASTOR (Mapping XML – relational Apache CASTOR (Mapping XML – relational database system)database system)•StrutsCX (XML supplement of frameworks Apache StrutsCX (XML supplement of frameworks Apache Struts)Struts)•Xalan / Xerces (XML-Parser)Xalan / Xerces (XML-Parser)•Log4J for applicationloggingLog4J for applicationlogging•DB-Server ORACLE 9iDB-Server ORACLE 9i




AgendaAgenda











Technical architecture of www-DioxinDB Technical architecture of www-DioxinDB

Internet

Webserver

Apache, Tomcat

Database-server

Firewall Firewall

DMZ Computer centre of the Umweltbundesamt

Data-ProviderSpecial UserPublic

Web-ServiceClient(App. Server)

TOMCAT, Xalan,Xerces, XPath, StrutsCX, etc.

AJP

gein®/vUDK

HTTPS

Web-Service

DatamappingXML – rel. DB

Apache Axis, CASTOR

SQL(JDBC)

XML(SOAP)

XML (SOAP)

Open source „area“Open source „area“ XML – „area“XML – „area“




Request to the application-serverRequest to the application-server

Multi-level architecture of www-DioxinDB Multi-level architecture of www-DioxinDB

Access via the Internet - HTTPS-protocol Access via the Internet - HTTPS-protocol

XML-Stylesheets trigger profile specific retrievalXML-Stylesheets trigger profile specific retrieval

XML-transformer produces profile specific HTML-XML-transformer produces profile specific HTML-page. page.




Screenshoots of the application (log-in)




Feeding meta-data via XML-StylesheetsFeeding meta-data via XML-StylesheetsData Transfer:

Up- and downloading of data via interfaces of XMLUp- and downloading of data via interfaces of XML




Retrieval criteria: compartiment, location, time Retrieval criteria: compartiment, location, time Data request:

Searching for monitoring programmes and data Searching for monitoring programmes and data producerproducer




Selected meta- data and analytic data of monitoring Selected meta- data and analytic data of monitoring programmes programmes

Data request results:




Web-Service of the DIOXIN-Database - example of data sharing or different user groups

Conclusion:

Setup of a harmonised, sound and current base of data for POPs

Updating and quality assurance at any time

Use of open source software and XML technology….

The Web-Service could be a part of the initiative of BundOnline 2005 as a online-service for the public.

Use of open source software and XML technology….

Open for the XML-FutureOpen for the XML-Future

Cost reductionCost reduction

Easy to realize Data intefaces for Easy to realize Data intefaces for differnt purposesdiffernt purposes

No platform dependencNo platform dependenc




Outlook:

Supply-side appropriation of environmental Supply-side appropriation of environmental informationinformation

Use the Web-Service for documentation of Use the Web-Service for documentation of international POP-monitoring projectsinternational POP-monitoring projects

English version English version

Increased cooperation and knowledge Increased cooperation and knowledge sharing with other communitiessharing with other communities




More information:

www.umweltbundesamt.de

portal „POP – DIOXINE“portal „POP – DIOXINE“

www.umweltministerium.bayern.de

www.deborate.de/dioxine

Poster Session on FridayPoster Session on Friday

Documents

Bayerisches Staatsministerium für Umwelt, Gesundheit und Verbraucherschutz Development of a Web-Service for the DIOXIN- Database of Germany Federal Environmental