Query interface – explained

Here you’ll find a detailed explanation to the query interface.

Open the Query interface in a browser window. Insert your SQL query in the text area (1) or choose an example query from the “Examples” tab (6) (just double click on one of them) above the text area. Click “Submit” (4) to submit your job. A message appears that shows how your query is reformulated and will be executed. Confirm the query plan with OK if it looks reasonable to you. If something looks not quite right, please report back to us! Any kind of comments or bug reports are most welcome!

Screenshot of the query interface

Screenshot of the query interface with (1) SQL text area, (2) field for result table name, (3) Short/Long queue, (4) Submit button, (5) Job list, (6) Example queries and (7) Database/Function browser

After successful job submission, your job will appear in the job list in the left side bar (5). Its name corresponds to the result-table name, which is either the current time stamp or a name that you provided in the table field (2) below the query form, before submitting your query. For now, the jobs are sorted by time with the most recent ones at the top.

Above the text area, you can find the “Database browser” (7). This is very useful to find out which columns exist for which table in which database. Hover with the mouse over the columns for a short description.

You can view your results by clicking on the table name for your job in the job list (5) and then choosing the “Results Table” tab (8).
Back in the “Job Overview” tab (9), you can review again which query was executed (10), its query plan, timing (11) etc.
It is also possible to rename your job table or remove the job completely using the buttons just below the job parameters (12).
The “Plot”-tab provides a simple plot-interface. You rather want to connect to Topcat for plotting? No problem – choose the “SAMP” tab (13) and follow the instructions given there (also see Topcat and SAMP for an example). Alternatively, you can download your results first at the “Download” tab and process them further.


Query interface with the (9) Job Overview for a finished job. Accessible are also the (8) Results Table tab, (10) executed query, (11) job parameters and timing, (12) buttons for renaming or deleting a job as well as (13) SAMP for exchange of data, a simple plot feature and several download options.

Proudly powered by Daiquiri
©2016 GAIA@AIPImprint and Data Protection Statement