Open Data Interface, ODI

ESTEC/Contract No. 21964/08/NL/AT

Monthly Progress Report

ODI-MR-8-08/09

Period: 2009-05-01--05-31

Author: Lars Eliasson

1. Progress status

A mature version (0.4) of ODI was committed to subversion on the server at neptun.umea.irf.se.

The SQL tables to hold metadata were further developed leading to a simpler architecture.

A set of core ODI functions were put in the file odi.library.php.

A PHP program to parse CDF skeleton files was developed (cdf_skeleton_to_odi.php).

A set of tools to query the ODI database were developed in PHP (in tools directory).

A set of routines to download data, parse, and store into the ODI database were written.

IDL codes were written for the SPENVIS data selection templates.

The SEDAT cgi-client perl script 02-D-Op.pl was adapted to the new database structure.

A "control file" (datasets.txt in parsers directory) was created which holds all necessary information for the parser scripts to automatically set up dataset tables and populate them.

A php script (populate_all) was written that cycles through datasets.txt to set up dataset tables and ingest the data.

Four dataset have been ingested into ODI (IMP8, Proba1, Rosetta, Dst index).

A first draft of the administrator user guide was written.

Web page http://www.lund.irf.se/odi

WP 100 Core Database System

A draft of the ECSS-E40 documents (D1) is prepared including e.g. Software System Specification.

The URD version 1.0 has been written.

A draft of the Database Technical Note (D3) has been written.

User manual (first draft) for the database administrator (D2) has been written.

Database system and source code (S1) prototype is produced.

WP200 Database

Work with the populated database and source code. Prototypes have been generated for parts of the system.

MySQL database has been updated.

Update ECSS-E40 document.

The Database Technical Note first draft 0.1 was written in October and has been updated in May.

WP300 SAAPS interface

Updated ECSS-E40 document at T0 + 6 according to the schedule

The plan is that the software will be delivered before the MTR.

Technical note ready at T0 + 6 according to the schedule

WP400 SEDAT interface

Updated ECSS-E40 document at T0 + 6 according to the schedule

The plan is that the software will be delivered before the MTR.

Technical note ready at T0 + 6 according to the schedule

WP500 SPENVIS interface

Updated ECSS-E40 document at T0 + 6 according to the schedule

The plan is that the software will be delivered before the MTR.

Technical note ready at T0 + 6 according to the schedule

WP600 Maintenance and support

Start T0+6

WP700 Administration/management

Monthly progress reports

Final Report ready at T0 + 12

2. Problem areas/reasons for slippages

The date for the MTR has been slightly delayed. Some work has been delayed due to part time parental leave.

3. Events anticipated to be accomplished during next reporting period

No major.

4. Status report on all long lead or critical delivery items

None

5. Action items

The following action item was decided during the PM1

Action Item PM-1 Hugh Evans shall investigate where the system will be hosted at ESTEC, allocate space, and arrange for the necessary licences and servers to be set up at ESTEC.

6. Milestone payment status

Progress payment expected after software delivery.

7. Expected dates for major schedule items

The second Progress Meeting (MTR) will take place 4 June, 2009 at ESTEC. Final delivery is November 2009 according to the present schedule. The agenda for the MTR meeting can be found on the internal pages http://www.lund.irf.se/odi/internal/.