SLIDE 1
D.Morris Institute for Astronomy, Edinburgh University June 2016
D.Morris Institute for Astronomy, Edinburgh University June 2016
Working with ADQL Astronomy Data Query Language D.Morris Institute - - PowerPoint PPT Presentation
Working with ADQL Astronomy Data Query Language D.Morris Institute - - PowerPoint PPT Presentation
Working with ADQL Astronomy Data Query Language D.Morris Institute for Astronomy, Edinburgh University June 2016 Topcat The problem Different platforms Different languages Different formats Aladin D.Morris Institute for Astronomy,
SLIDE 2
SLIDE 3
D.Morris Institute for Astronomy, Edinburgh University June 2016
Topcat Aladin The abstraction The data
SLIDE 4
D.Morris Institute for Astronomy, Edinburgh University June 2016
Database Database Database Database
Topcat Aladin Virtual Observatory
Registry
TAP TAP TAP
Data discovery Registry Data access Table Access Protocol
SLIDE 5
D.Morris Institute for Astronomy, Edinburgh University June 2016
TAP
Database Database
TAP TAP
Database Database
Topcat Aladin Virtual Observatory
A D Q L A D Q L A D Q L
Astronomy Data Query Language
SELECT … FROM table WHERE …
SLIDE 6
D.Morris Institute for Astronomy, Edinburgh University June 2016
TAP
Database Database
TAP TAP
Database Database
Topcat Aladin Virtual Observatory
A D Q L A D Q L A D Q L
Observation Core Data Model
- who
- what
- when
- where
SLIDE 7
D.Morris Institute for Astronomy, Edinburgh University June 2016
Topcat Aladin Virtual Observatory The data
Registry Table Access Protocol Astronomy Data Query Language Observation Core Data Model
SLIDE 8
D.Morris Institute for Astronomy, Edinburgh University June 2016
Topcat Aladi n
TAP
Database Database
A D Q L
Data provider role
Observation Core Data Model
- tables
- columns
- name
- type
- units
- UCD
TAP schema
SLIDE 9
D.Morris Institute for Astronomy, Edinburgh University June 2016
Topcat Aladi n
Software developer
TCP/IP HTTP REST … Java Spring Hibernate JDBC … Python Django Flask WebPy ... PostgreSQL MySQL SQLServer Oracle ...
TAP
A D Q L
Database Database
SLIDE 10
D.Morris Institute for Astronomy, Edinburgh University June 2016
Topcat Aladi n
IVOA member
Database Database
TAP
A D Q L
##
Afwfwf Fafas Af ju lk Asf kget hipnd
!? ADQL ADQL TAP TAP
SLIDE 11
D.Morris Institute for Astronomy, Edinburgh University June 2016
OFFSET ?
Afwfwf Fafas Af ju lk Asf kget hipnd
!! ADQL ADQL
OFFSET
SELECT …. FROM …. WHERE …. OFFSET n Initial proposal and group discussion Sometimes the complicated ones are easy, and sometimes the simple ones are hard.
SLIDE 12
D.Morris Institute for Astronomy, Edinburgh University June 2016
OFFSET ADQL ADQL SELECT …. FROM …. WHERE …. OFFSET n Consensus and updated specification Optional features vs range of platforms What do we do if Oracle does not support OFFSET
SLIDE 13
D.Morris Institute for Astronomy, Edinburgh University June 2016
Docker containers, providing basic install
- f each database platform.
A simple platform for experimenting with ADQL syntax. https://github.com/ivoa/cosmopterix GitHub project
- contributions welcome
Cosmopterix
Working
- PostgreSQL
- MySQL
- MariaDB
- HSQLDB
- Apache Derby
- Oracle (*)
Future
- H2
- SQLite
- SQLServer
- Qserv
- SpiderEngine
- Hadoop
SLIDE 14
D.Morris Institute for Astronomy, Edinburgh University June 2016
A place to share example ADQL and SQL queries. Initial goals
- Provide source material for ADQL parser tests
- Provide source material for ADQL query tests
Medium term goals
- Provide reference material for science use cases
Long term goal
- Future work on validating the BNF grammar
https://github.com/ivoa/lyonetia GitHub project
- contributions welcome
Lyonetia
ADQL ADQL ##
Afwfwf Fafas Af ju lk Asf kget hipnd
!?
SLIDE 15
D.Morris Institute for Astronomy, Edinburgh University June 2016