Progress and technical issues related to implementation of the Colombian BCH

jetmorebrisketΛογισμικό & κατασκευή λογ/κού

15 Αυγ 2012 (πριν από 5 χρόνια και 4 μήνες)

188 εμφανίσεις



26
-

April 2007, New Dheli




PILAR GALINDO

Software Developer


EMMA LUCIA RIVERA

Colombia BCH Manager




Alexander von Humboldt Institute

Bogotá, Colombia

Progress and technical issues related to

implementation of the Colombian BCH

CONTENT




BCH: Biosafety Project
-

WB
-
GEF
-
Colombian
Government



Colombia BCH advances



Constraints on making information available


Progress and technical issues related to

implementation of the Colombian BCH

“Capacity strengthening for the Implementation of the
Cartagena Protocol on Biosafety in Colombia”


Project components




Strengthening the legislative framework and operational mechanisms for
Biosafety management in Colombia.



Capacity strengthening and establishment of an operational system for risk
assessment and monitoring.




Establishment of the Biosafety Database System and BCH
Mechanism in Colombia.



Centers of Excellence for Research, Risk Assessment and Monitoring.


MAVDT, MADR,
MPS,
MCIT, DNP, ICA, INVIMA, COLCIENCIAS, CIAT,

IAvH





Ministry of Environment, Housing and Territorial Development


Ministry of Social Protection MPS

Ministry of Agriculture and Rural Development



Farming Colombian Institute

Ministry of Trade, Industry and Tourism



Institute for Monitoring Medicines and Foods

Ministry of External Relations (CP Focal Point)



International Center for Tropical Agriculture

Alexander von Humboldt Institute



National Department of Planning

Colombian Institute for the Development of Science and Technology





"Francisco Jose de Caldas”


BCH Component in the Project

WB
-
GEF
-
Colombian Government*


Progress and technical issues related to

implementation of the Colombian BCH

CONTENT




BCH Objective in the Project WB
-
GEF
-
Colombian
Government



Colombia BCH characteristics



Constraints on making information available



Colombian BCH

To choose the Nationals
Authorized Users for each
CNA

To establish infrastructure and human team.

AvHI as NFP

To design the web site and to define
services according to national needs

To establish alliance with other information
systems available in Colombia like CHM and BIS

To identify the available information and its
conditions

Activities done to put the Colombian BCH on line

To establish communication with Competent National
Authorities
-

CNA



Workshop in Curitiba

(March 2006)





Workshop in Colombia

(Aug 2006)







UNEP
-
GEF

Regional
specialist for Latin
-
American






Colombian BCH:
http://www.bch.org.co



-
Cartagena Protocol

-
Biosafety in Colombia

-
Competent National Authorities

-
National legislation

-
Projects

-
News

-
WB
-
GEF
-

project components

-
Researchers catalog

-
Content management


-
Among others…

What do we use on the development process?




Colombian BCH

Integrated Development Environment:
debugging, project management, building and
deploying

You can use also: NetBeans, JBuilder,
WebSphere Studio or JDeveloper

Graphic design tool to create web sites / Internet
applications

You can use also: FrontPage

Visual Data base administration: create backups,
administrate data bases, change tables and
attributes, establish relational rules, etc.

You can use also: MySQL, Sybase



Application server to run the application and
make it available through the web

Where the Colombian BCH runs?




Linux server with Red hat distribution


JBoss as Application server


PostgreSQL as Data base manager


JAVA as programming language: JSP and Servlets


JDBC access


AXIS Java API to use the WebService


Colombian BCH

Common Formats are currently available in Spanish, ready to
be used by the
Competent National Authorities

Human team:



Software developer



Coordinator



National Biosafety Project


Hardware infrastructure:


Server


PC for development and testing process


AvHI Data Center


Time:


1 year, 1/2


Resources needed

It was developed on Java using the Model View Controller pattern, where:



-

The
Controller

is in charge of receiving the entry events and to manage
the application flow. This delegates the HTTP requests to the proper
manager


-

The
Model

represent the BCH’s logic


-

The
View

is composed of JSPs, which shows the HTML forms and data



Colombian BCH

Application server

PostgreSQL

Data Base Connection

It works through Data Access Object (DAO) concept to:


To get and encapsulate the data source access, unlinking
the BCH logic from data


The DAO establishes the connection with the DB Manager
to get and keep the data


DAO allows:


To create reusable implementations


To give installation flexibility/configuration


To reduce the complexity of the BCH logic implementation


But…


It increases application design complexity, since it is
necessary to create more classes

Web Service comunication

It has established communication with Central BCH

set cla=C:/jboss
-
4.0.2/server/default/deploy/axis
-
1_4/lib/


1. java
-
cp %cla%/axis.jar;


%cla%/log4j
-
1.2.8.jar;


%cla%/saaj.jar;


%cla%/wsdl4j
-
1.5.1.jar;


%cla%/commons
-
logging
-
1.0.4.jar;


%cla%/commons
-
discovery
-
.2.jar;


%cla%/log4j.properties;


%cla%/jaxrpc.jar



org.apache.axis.wsdl.WSDL2Java




http://bchtraining.biodiv.org/service/3.0/service.asmx?WSDL

AXIS component to
understand WSDL files

AXIS:

Apache Extensible Interaction System
-

OpenSource implementation of SOAP which provides web
service tools

SOAP:

Simple Object Access Protocol

Web
-
Service Description Language
, URI which enables the Central BCH to publish its WebService, and
allows the clients to call its methods/operations

Colombian BCH

When you run this instruction you get this classes:

User roles

Record states

Registration process

Central BCH

Progress and technical issues related to

implementation of the national BCH

CONTENT




BCH Objective in the Project WB
-
GEF
-
Colombian
Government



Useful features in the BCH Central Portal



Constraints on making information available



There is a lack of documentation to register Information

(User level)






Sometimes it is difficult to know which information has to be put
in each category of information.



Is difficult to find information of filled formats (as examples) in
some categories of information



Constrains on making information available

There is a lack of documentation for the software developers



There is no way to reach to documentation page:

http://bch.biodiv.org/help/interoperability/webservice3/default.shtml









Constrains on making information available

There is a lack of documentation for the software developers:

(Programmer level):


A software developer doesn’t know the steps that he has to implement. To
register a
Law
, you have to register first the
National Competent
Authority

AND keep the ID that you give to it, link this with the law register.
We needs the
game rules
.


Constrains on making information available

Law WS registration

Step1:

National Competent Authority


NCA
-

WS registration

ID
-

NCA

Step2:

Law
-

WS registration

A country can’t
assume that costs

There is a lack of documentation for the software developers:

(Programmer level):


The XSD published for the Web Services don't match with the XML files you
have to send. It is difficult to know what to write on the XML tags for
sending them.

Constrains on making information available

(cont):

There is a lack of documentation for the software developer





The description of the mechanisms for interoperability with the BCH is not
very clear



<?xml version="1.0" encoding="utf
-
8"?>


<query>


<conditions>


<is refID="authority" />


<relates property ="government" refID="co"/>


</conditions>

</query>


Constrains on making information available

The XSD does not exist
to create this file.
Colombia doesn’t find this
sintaxis through the
Central Portal, but with
the direct help of the
UNEP
-
GEF.

There is a lack to register Information:




In the Central Portal BCH there is more than one unique identifier for the same
LMO (
Example
). In the OECD page there is only one register for each LMO.

Constrains on making information available

Mechanism for
avoiding the
duplication of
registers of new
LMO
´
s unique
identifier, by
giving the existing
list for selection
and not giving the
possibility of new
text entry.

There is a lack of documentation for the software developers:

(Programmer level):




There are different Web Services versions and the toolkit does not
show the differences between them.




There is not a standardized database model to help avoid
misunderstandings of the software developers.


Constrains on making information available


There are inconsistencies in the documentation:



Sometimes the BCH give a guide to build the information IDs
(
http://bch.biodiv.org/help/interoperability/webservice3/method
s/register.shtml
), but it doesn’t give a standard route



The IDs must be universally unique. We encourage organization to
include their domain name in the IDs

(e.g.
http://www.gov.zz/decision/4323

or

http://www.gov.zz/870F72A0
-
BD9F
-
4d71
-
9983
-
34FAEAD29399)
”.

Constrains on making information available

There is a lack of tools for implementation of the national
application with its requirements:



The Central Portal BCH offers the Thesaurus XML files for building
the formats and each term has associated an identifier
(
A1DB53EB
-
7015
-
4f60
-
910C
-
F226B012A37C).
It is not clear how
this identifier was built, neither if this identifier should be used in the
national applications.

Constrains on making information available

Detailed documentation

To improve the Central BCH forums


Conclusions

THANK YOU VERY MUCH


MUCHAS GRACIAS



bch@humboldt.org.co

pilar@humboldt.org.co

elrivera@humboldt.org.co


Volver Atrás

Multiple register for the same Unique Identifier

In Central Portal BCH