DMMapper Catalogues Hands on Session (ESAVO)

Advisors: Iñaki Ortiz & Aurélien Stébé

Summary and Objective

The purpose of this hands on session is to ingest and publish a catalogue in the VO. The first objective is to allow a client to query a catalogue using the ADQL language, including the REGION search. Then, try to map the catalogue to the Source Catalogue DM, allowing clients to send uniform queries across different services. The client used to demonstrate this is VOQuest, and the server package is the DMMapper. The session will first be run using the 1XMM source catalogue, and then using the participants data.

Hands on Session Main Steps

Environment set up & data ingestion (1:30h)

• Introduction (context & motivations)
• Demo of existing services (session objective)
• Environment set up (Tomcat, MySQL... as necessary)
• Data ingestion of test catalogue (1XMM source catalogue)

Server config & testing in 2 phases (1:30h)

• DMMapper config - tables/columns information, deployment
• Server testing using VOQuest, sending simple ADQL
• DMMapper config - Source Catalogue DM mapping, redeployment
• Server testing using VOQuest, sending uniform ADQL with SCDM

Support for participants data (2:00h)

• Repeat the whole process using participants data with advisors support (ingestion from CSV/TSV file formats, mapping to existing DB)

Software Required

• MySQL 4 or 5 or superior
• Tomcat 5.0 or superior
• Ant 1.6.5 or superior
• JDK 1.5 or superior

VO Standards Used

• ADQL v0.7.4 - v1.0 (/ v1.5)
• Source Catalogue DM
• VOTable v1.1

-- AurelienStebe - 15 Jun 2007