DARTS/Akari at ISAS/JAXA

SQL Schema

The FIS and IRC source catalogs are stored in Tables in each Database. Views are defined as special subsets of the original table, however, Tables and Views look the same for the user. The name of Tables or Views can be set after `FROM' keyword in the SQL statement. The list of columns and their descriptions of Tables and Views are shown in Tables page and Views page.

We prepared a number of Functions for you to use SQL calls efficiently. Functions take some arguments, execute a previously defined sequence of commands, and returns value(s) or table. Their names are prefixed by f, like in fGetNearbyObjCel or fGetObjFromRectCel. The functions can be used after `SELECT' or `FROM' keyword in the SQL statement.

The version of catalogs in Tables(Views) differ in databases. However, there is no differences about functions.

Here is an example of SQL call to get 10 object within 50arcmins of a point (ra='12:34:56.999', dec='-65:43:21.111').


SELECT o.*, n.distance

FROM fGetNearbyObjCel('Fis', 'j2000',

       fLonStr2Deg('12:34:56.999'), fLatStr2Deg('-65:43:21.111'),

       50) n,

     FisObj o

WHERE n.objID = o.objID

ORDER BY n.distance

LIMIT 10

fGetNearbyObjCel() function uses an optimized sequence for the radial search, and returns a table which contains minimum set of columns including objID of found objects. You have to set two numerical values in degree to the 3rd and 4th arguments of this function. But you can also use string expression of `hh:mm:ss' and `dd:mm:ss' style by using fLonStr2Deg() and fLatStr2Deg() functions, since they convert a string expression into a numerical value in degree.

Using Functions is the most easy way to obtain the performance/convenience for SQL search. Before writing the SQL call, please read the Function list and search the functions suitable to your request.