VO??????????

1
VO??????????
??????? ????
2
SkyNode toolkit

• VO Interface ?????????????????????
• ???????????????????????????????????
• JVO ?? SkyNode ???????????????? Toolkit
  ????????????
• http//jvo.nao.ac.jp/download/skynode-toolkit/

3
JVO SkyNode Architecture
SkyNode IN
SIAP/SSAP/SkyNode OUT
SIAP/SSAP IN
Translator
Parameter
Interface
ADQL
VOTable
VOTable
Formatter
QL Converter
Controller
upload
JDBC
JDBC
SQL for backend DB
Resource
ResultSet
Data
Metadata
ResultSetMetaData
4
??? Java Class

• org.apache.axis.transport.http.AxisServlet
• jp.ac.nao.jvop3.service.skynode.SkyNodeSoapImpl
• jp.ac.nao.jvop3.gateway.SOAPGatewaySkyNode
• jp.ac.nao.jvop3.controller.skynode.SkyNodeImpl
• jp.ac.nao.jvop3.controller.skynode.QuerySkyNode
• jp.ac.nao.jvop3.controller.skynode.ResultSetForSky
  Node
• jp.ac.nao.jvop3.controller.skynode.ResultSetMetaDa
  taForSkyNode
• jp.ac.nao.jvop3.controller.skynode.DataFormatter

5
SkyNodeSoapImpl

• SOAP ??????????????????
• http//jvo.nao.ac.jp/skynode/services/_at_serviceName
  _at_
• wsdd file ??? web GUI ????
• ????? DB ?? wsdd file ???????????
• etc/deploy-template.wsdd
• ltservice name"_at_serviceName_at_" provider"javaRPC"
  
• style"wrapped" use"literal"gt
• ltparameter name"skynode.db" value"_at_DB_at_"/gt
• ltparameter name"className"
  value"_at_serviceClass_at_"/gt
• ...

6
SOAPGatewaySkyNode

• AXIS Java ???????? JAXB Java ??????????
• AXIS SOAP ????? SOAP ???????????, ??????????? XML
  ?? Java ??????????????
• ADQL-x ? AXIS Java ? SelectType ??????
• SkyNode ?????? JAXB ? SelectType
  ??????????(????????????????)?
• ????(JAXB)?????????(AXIS) ???????????AXIS
  ??????????????

7
SkyNodeImpl

• ?????????????????????
• ResultSet performQuery(SelectSQL select)
• Connection conn
• connManager.getConnection(dbms, dbname, 10)
• StatementForSkyNode st
• (StatementForSkyNode) conn.createStatement()
• ResultSetForSkyNode rs st.executeQuery(selectT
  ype)
• VOTABLEType vot DataFormmatter.getVOTable(rs)
• return vot

8
QuerySkyNode

• ADQL ? Backend DBMS ?????? SQL ??????????????
  (abstract)?
• ??????? QuerySingle (????????????), QueryMulti
  (?????????) ?????????
• etc/jvo.properties ???????????

9
Region ??
t1
id object crpx1 crpix2 filter
1 SXDS 300 150 Image/fits

(2)
REGION(BOX 30 10 0.1)
t3
t2
Select from (select t2.id from t2, t3 where
t2.htm between t3.low and t3.upp) t4 natural join
t1
qid rid low upp
1 1 1004 1005
1 1 1008 1009

id htm
1 10045
1 10046

(1)
(1) Select id from t2 with t2.htm between
t3.low and t3.upp (2) Select records from t1
corresponding to the selected id
10
jvo.properties

• prefix/usr/local/skynode/
• work.dirwork
• tmp.dirtmp
• deploy.templateetc/deploy-template.wsdd
• jdbc.driver.pgsqlorg.postgresql.Driver
• jdbc.url.pgsqljdbcpostgresql//localhost5432/
• jdbc.user.pgsqlyshirasa
• jdbc.passwd.pgsql
• metadata.db.namemetadb
• dbms.metadbpgsql
• connection.max10
• query.class.defaultjp.ac.nao.jvop3.controller.sky
  node.QueryMulti
• logger.propertiesetc/log4j.properties

11
struts-config.xml

• ltplug-in className"jp.ac.nao.jvop3.controller.sk
  ynode.PlugInForSkyNode"gt
• ltset-property property"jvoProperties"
• value"/usr/local/skyn
  ode/etc/jvo.properties"/gt
• lt/plug-ingt

12
web.xml

• ltservletgt
• ltservlet-namegtAxisServletlt/servlet-namegt
• ltdisplay-namegtApache-Axis Servletlt/display-nam
  egt
• ltservlet-classgt
• org.apache.axis.transport.http.AxisServlet
• lt/servlet-classgt
• ltload-on-startupgt1lt/load-on-startupgt
• lt/servletgt
• ltservlet-mappinggt
• ltservlet-namegtAxisServletlt/servlet-namegt
• lturl-patterngt/services/lt/url-patterngt
• lt/servlet-mappinggt

13
????????

• Skynode_dev
• src ??????
• lib ????? (jar ????)
• doc ?????? (instruction.txt)
• etc ???????????????
• sample ????????????SQL?
• war SkyNode service war file
• build. ???????????
• init-cshrc ?????????