DB i t i t ti ††† ††
277-8582 2–21–1 5–1–5 2–1–1 112-8610 ††† E-mail: ↑{ yuji.shirasaki,masahiro.tanaka,honda.satoshi,masatoshi.ohishi,mizumoto.y }@nao.ac.jp, ††yasuda@icrr.u-tokyo.ac.jp, †††masunaga@is.ocha.ac.jp DB, DB
Design of the Astronomical Query Language Yuji SHIRASAKI†, Masahiro TANAKA†, Satoshi HONDA†, Masatoshi OHISHI†, Yoshihiko MIZUMOTO†, Naoki YASUDA††, and Yoshifumi MASUNAGA††† † National Astronomical Observatory of Japan, 2–21–1 Osawa, Mitaka, Tokyo, 181–8588 Japan †† Institue for Cosmic Ray Research, University of Tokyo, 5–1–5 Kashiwa-no-Ha, Kashiwa, Chiba, 277–8582 Japan ††† Department of Information Science, Ochanomizu University, 2–1–1 Otsuka, Bunkyo-ku, Tokyo, 112-8610 Japan E-mail: †{ yuji.shirasaki,masahiro.tanaka,honda.satoshi,masatoshi.ohishi,mizumoto.y}@nao.ac.jp, ††yasuda@icrr.u-tokyo.ac.jp, †††masunaga@is.ocha.ac.jp In the field of the astronomical research, based on the advanced technology of manufacturing of a photon Abstract detector and a large telescope, development of the high-quality telescopes has been carried out all over the world. Virtual Observatory (VO) project is in progress for the purpose of archiving such high quality and large amount of data which will be produced by those telescopes. The aim of the VO is to federate the distributed astronomical data bases and make them look like a big database. Using such system, astronomical researcher can access in seemless to the distributed database. This paper discribes the result of investigation on the specification of query language used in the VO. Key words   Astronomical DB, DB Language, 3D DB, Distributed DB, Information Search Internatioanal Virtual Observatory Alliance (IVOA) [1] VO 1. IVOA [3] sxds sxdsB1 ivoa://naoj/sxds/sxdsB1 shema naoj authority authority SQL FROM [[AUTORITY.]DB_NAME.]TABLE_NAME [[AS] ALIAS] FROM DB authority SQL [[[AUTORITY.]DB_NAME.]TABLE_NAME.]COLUMN_NAME [[AS] ALIAS] sql SQL 2.
12h34m56.7s, -76d54m32.1s,
Suprime-Cam 1 2 0 Identifier uri
ivoa IVOA sxds/sxdsB1 Identifer 2 VO 12:34:56.7, -76:54:32.1
） POINT( 2 0 VO VO [, ） ） ]) FROM VO
BOX Registry BOX deg, arcmin, arcsec UCD “I” deg HTM [2] HTM3, HTM4, ...}) POLYGON ( : {HTM1, HTM2, LARGE SPECT_FLUX_NORM UCD PHOT_*_* X BOX SELECT WHERE UCD
CIRCLE [ , LARGE] ) UCD WHERE (  : {POINT(203, 20, RA_DEC, J2000), (203, 21), (204, 21)} ) SELECT SELECT FROM TABLE OF 3. Registry TABLE OF [METADATA_KEYWORD] IVOA [4] X SQL 4. Unified Column Description (UCD) [5] IVOA UCD POS_EQ_RA_MAIN  POS_EQ_DEC_MAIN  B PHOT_MAG_B   R PHOT_MAG_R 1 ASCA UCD UCD 120
2） < [NEAREST | BRIGHTEST | ALL] 100 NEAREST SELECT POS_EQ_RA_MAIN, POS_EQ_DEC_MAIN, (PHOT_MAG_B | PHOT_MAG_K | SPECT_FLUX_NORM) BOX(POINT(120., +30., RA_DEC, J2000), WHERE 1 deg, 1 deg)
(B K FLUX  ) ( VO X 2 ! 1 2 Optical ir Radio X-ray Cube Cube
しspatialRegion spectrumRange
timeRange Cube imagePixsize SQL IMAGE SPECTRUM x B, R, i' Optical WHERE integrateion = true R, i' B, 2 6. SQL VO 1
SQL
) SELECT IMAGE([spatialRegion, spectrumRange]) FROM Cube ) WHERE spatialRegion IN ( AND spectrumRange IN ( ) SPECTRUM ( 1, SPECTRUM( 2) ) 1 2 [1]  http://www.ivoa.net/ http://www.sdss.jhu.edu/htm/ [2] http://www.ivoa.net/Documents/WD/ [3] Identifiers/WD-Identifiers.html [4] http://www.ivoa.net/Documents/WD/ ResMetadata/WD-ResMetadata.html http://vizier.u-strasbg.fr/doc/UCD.htx [5] “JVO ” DEWS2004 [6] (2004) 5.
[6]