Retrieving Complex Data in TAP services - Archive ouverte HAL Accéder directement au contenu
Article Dans Une Revue ASP Conference series Année : 2020

Retrieving Complex Data in TAP services

Récupération de données complexes dans les services TAP

Résumé

Thanks to the Virtual Observatory, users can query services through a common language (ADQL) to get data directly from databases and they can choose an output format derived from a simple table serialization: VOTable, TSV and so on. To write advanced queries, users must first understand the database schema to identify the tables containing data of interest and to figure out how to join them. Some tools (TOPCAT, TAPHandle, Aladin, ...) propose generic interfaces helping for this but none of these tools is capable of providing a convenient view of a table set containing complex data. It is furthermore difficult to reconstruct complex data structures from flattened tables usually returned by SQL queries. TAP Simbad is a significant example of this difficulty with data spread out over 25 tables linked by foreign keys. We are working on a client module addressing this issue for TAP Web interfaces. The database schema, namely the TAP_SCHEMA, is analysed to build a JSON representation of complex data that can be annotated with query constraints set by the user. So that complex queries can be easily setup and run. Query results are parsed out to reconstruct the data structure in JSON strings, where top level data are explicitly listed and subcomponents can be fetched with appropriate synchronous TAP queries. These queries are generated by the parser and included within the JSON output. Thus, users can unfold on demand any part of the searched data. This mechanism is being implemented in Javascript to be proposed as a new overlay for both SIMBAD (Wenger et al. 2000) and TAPHandle (Michel et al. 2014) interfaces.
Fichier principal
Vignette du fichier
Retrieving_Complex_data_in_TAP__ADASS_.pdf (342.56 Ko) Télécharger le fichier
Origine : Fichiers produits par l'(les) auteur(s)

Dates et versions

hal-03765469 , version 1 (06-03-2023)

Identifiants

Citer

Anaïs Oberto, Laurent Michel, Grégory Mantelet, Haoyun Liao. Retrieving Complex Data in TAP services. ASP Conference series, 2020, 527, pp.105. ⟨hal-03765469⟩
14 Consultations
32 Téléchargements

Partager

Gmail Facebook X LinkedIn More