Open Data Interface, ODI

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

Monthly Progress Report

ODI-MR-9-08/09

Period: 2009-06-01--06-30

Author: Lars Eliasson

1. Progress status

- PM 2 was held on 4 June at ESTEC. Participants were Hugh Evans, Daniel Heynderickx, and Peter Wintoft. See minutes at http://www.lund.irf.se/odi/internal. Code, documents, and presentations were prepared for the meeting.

- The generation of column names of the dataset_* tables have been changed so that "_0" is not appended to scalars. 1D column names ends with "_i" and 2D names with "_i_j".

- The skeleton parsing code has been updated so that >1D variables are correctly parsed.

- The majority is now correctly parsed so that the first dimension increases the slowest for 2D variables.

- The variable_nrv table has been updated to also include the positional information for NRV data.

- The show_metadata.php script has been updated so that the global metadata (attributes) are displayed.

- Continued work has been carried out on SAAPS 2.0 (2.0 = ODI connection).

- DH went through all routines in odi.library.php and corrected some inconsistencies in some of the skeleton to database conversion routines.

- populate_all.php was updated to recognize # characters in datasets.txt as comment line indicators; it was renamed to populate.php.

- new versions of the various codes were committed to the repository.

- new datasets were added to the database: XMM, Integral, Dst, Rosetta.

- DH has converted the IDL code for the dataset listing page in SPENVIS from IDL to php (which is run as a stand-alone application in SPENVIS); this page is available on DH's test SPENVIS server.

- DH has identifies some inconsistencies in the skeleton files from different XMM data files.

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 (version 0.1, dated 2008-11-14).

The URD version 1.0 has been written (2009-04-07).

The Database Technical Note (D3) has been updated to version 0.2 (2009-06-02).

User manual for the database administrator (D2) version 1.0 has been written (2009-05-30).

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.

The structure of the database (S2) is basically fixed.

ECSS-E40 document.

The Database Technical Note draft 0.1 was written in October and has been updated to version 0.2.

WP300 SAAPS interface

Updated ECSS-E40 document at September 2009 according to the schedule

Software (S3) has been demonstrated to work on the database. Complete delivery in September.

Technical note (D4a note D1 in SoW) ready at September 2009 according to the schedule.

WP400 SEDAT interface

Updated ECSS-E40 document at September 2009 according to the schedule

Software (S4) has been demonstrated to work on the database. Complete delivery in September.

Technical note (D4b note D1 in SoW) ready at September 2009 according to the schedule.

WP500 SPENVIS interface

Updated ECSS-E40 document September 2009 according to the schedule

Software (S3) has been demonstrated to work on the database. Complete delivery in September.

Technical note (D4c note D1 in SoW) ready at September 2009 according to the schedule.

WP600 Maintenance and support

Start September 2009 according to the present schedule.

WP700 Administration/management

Monthly progress reports

Final Report (D5 note D2 in SoW) ready in March 2009 according to the present schedule.

Abstract (D6 note D3 in SoW) ready in March 2009 according to the present schedule.

2. Problem areas/reasons for slippages

The date for delivery of software has been delayed, partly 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.

The following action item was decided during the PM2:

Action Item PM-2 Check if the software is supposed to be open source.

6. Milestone payment status

Progress payment expected after software delivery (September 2009).

7. Expected dates for major schedule items

ODI system delivery is planned to take place during September 2009. A preliminary date for the next progress meeting is during the ESWW (16-20 Nov). The maintenance phase will run until March 2010.