pan-european infrastructure for ocean & marine data management an eu integrated research...
TRANSCRIPT
Pan-European infrastructure for Ocean & Marine Data management
An EU Integrated research Infrastructure Initiative (I3)
MIKADO : Java tool for XML CreationV. Tosello
Training Course, 12-17 February 2007, Oostende, Belgium
19/04/23
Introduction
MIKADO has been developped by IFREMER in the framework of the SEASEARCH project. MIKADO can be used to generate EDMED, CSR and CDI XML files.
MIKADO can be used into 2 different ways : One manual way, to input manually information for
EDMED, CSR and CDI fields in order to generate XML files. One automatic way, to generate these descriptions
automatically if information is catalogued in a relational database.
MIKADO interests Only one interface for all catalogs EDMED, CSR (and CDI) Automatic way is adapted when you have numerous
entries catalogued in a relational database.
19/04/23
MIKADO interfaceWhen you run MIKADO, the first screen enables you to export EDMED, CSR or CDI either manually or automatically.
19/04/23
Manual entries for EDMED
The 3 parts of the EDMED forms (A1, A2, B) are presented as tabs on the main window :
Data set = EDMED form - Part B
Data contact = EDMED form - Part A2
Data holding center = EDMED form – Part A1
19/04/23
Manual entries for CSRThere are 4 main input windows for the CSR information, which are directly inspired by the original ROSCOP form:
General information about the
cruiseInformation about the moorings
Information about the measurements done during
the cruise
Information about the geographical areas
of the cruise
19/04/23
Export of the XML fileThe EDMED/CSR xml file will be created by selecting “Save” in the “File” main menu. There is no proposed extension for the XML file, but we recommend to use “.xml”.
19/04/23
EDMED XML file (extract)
Metadata information
Dataset information
…
ISO 19115 : International Metadata Standard for Geographic Information
19/04/23
CSR XML file (extract)Measurement information
Ship information
…
…
…
…
19/04/23
Automatic generation of EDMED and CSR XML
filesElementary information for EDMED/CSR/CDI have to be catalogued in a relational database which can be queried with SQL language through a JDBC driver (Java Data Base Connectivity).
Automatic generation requires configuring properties files : “files.properties” file which contains all the information
about the name and the location of the files that are used by the software,
“edmed.properties/csr.properties/cdi.properties” files contain:
Database access parameters,Mapping between the partner’s database and the XML format, Queries to extract items from the database into the XML fields.
19/04/23
Database access
JDBC (Java Data Base Connectivity) connection parameters Timeout URL of database (driver + server name + internet port
+ database name) User Name and password.
###############################JDBC parameters for querying database###############################bdd.query.timeout = 300bdd.connectURL = jdbc:oracle:thin:@borneo:1521:idmbdd.user.name = usernamebdd.user.password = userpassword
JDBC drivers are available for most popular relational database management system : ORACLE, Sybase, Microsoft Access, MySQL, PostSQL.
19/04/23
General query
It is the query which identifies all EDMED, CSR or CDI entries that must be exported. This request must return only one column which is the identifier of each entry and that will be used for sub-queries.
SQL syntax must be adapted to your own database (example provided for Oracle IFREMER EDMED database):
############################General query (dataset identifier list)############################query.=select BAS.BAS_CBASE from BAS where
BAS.BAS_EDNO is not null
-> This syntax must be adapted to your own database.
19/04/23
This table is given in the properties file of each catalog.
It allows to define linksbetween returned columns inqueries and fields in theEDMED, CSR or CDIdescription (and XML).
For most databases, there is no
need to change this matchingtable (recommended).
Matching table
19/04/23
Sub-queries
For each row of the general query, it is possible to define single or multi sub-queries. Single sub-queries : return one row for each row of the
general query (ex: dataset name, description), Multi sub-queries : return several rows for each row of the
general query (ex: instruments, parameters).
The link between the fields of the partner’s database and the variables of the matching table have to be defined in theses sub-queries.
Single and multi sub-queries syntax: queries.single.1 = select table1.column1 variable1 from
table1 queries.multi.moorings = select ‘’ variable2, ‘’
variable3 from dual
19/04/23
Automatic generation of XML files
Once all the properties files have been configurated, you can choose “Automatic” in the Export Menu of EDMED, CSR or CDI and this window opens.
Select the output directoryClick on the “Generate” button to create the XML files.
19/04/23
MIKADO improvements
Version V1: Version at the end of the Sea-Search project.
Version V2: The libraries will be updated using Web Services, EDIOS will be certainly integrated, EDMERP?
19/04/23
MIKADO on Windows
MIKADO is available on Unesco/Iodetraining/Seadatanet/Vanessa Tosello
Copy the MIKADO directory on your PC: MIKADO tool, MIKADO examples, User Manual.
Execute ‘mikado_tool/mikado.bat', by double-clicking
If it does not work, make sure java 1.4 or superior is available on your computer. See read_me.txt file.
19/04/23
Thank you for your attention.Questions?
19/04/23
Java version
Make sure java 1.4 or superior is available on your computer:
To know if Java is available on your computer, in the right version, follow this steps :
- Open 'Start' menu, then 'Execute'- On the displayed window, enter : 'cmd', then click on 'OK'
button- Enter 'java -version‘
Check if command has been executed :- If not, download java at http://www.sun.com.- Else, check the version displayed. The version should be
greater or equals than 1.4
(from MIKADO/read-me.txt)