How to build your own Sky Node A
How to build your own Sky. Node A quick tutorial by Alberto Conti & Bernie Shiao Space Telescope Science Institute Baltimore, MD aconti@stsci. edu, shiao@stsci. edu
Introductory Notes l This brief tutorial was written after Bernie and I spend a morning at JHU with Alex, Tamas and Wil to set up a Sky. Node for GALEX (http: //galex. stsci. edu). The implementation was rather easy, and we decided it would be a good idea to document the steps we undertook for others to follow. – – – GALEX uses MS SQL Server as its database server GALEX database backend is written in C# under. NET Framework 1. 1 GALEX uses IIS as its web server
Requirements (based on GALEX example) l Database: <dbname>, i. e. GALEX l Objects Table: <objtable>, i. e. Photo. Obj. All – – – This table contains the catalog of all GALEX objects Each object has several attributes that will be accessible from each Sky. Node <objtable> MUST contain: l l obj. ID, RA, Dec htm. ID, cx, cy, cz
Requirements: continued (based on GALEX example) l Objects Table View: Photo. Primary – This view is obtained from <objtable> The most general view is obtained by – l create view Photo. Primary as select * from <objtable> DBObjects Table: DBObjects – Contains the metadata information about the database, such as tables and user functions.
Requirements: continued (based on GALEX example) l DBColumns Table: DBColumns – – Contains the metadata information about each table, such as columns, UCDs, units, etc. A view name columns was needed for the GALEX implementation and is was generated by – l create view columns as select * from dbcolumns HTM Functions – Run skynode-htm. Install. sql and install htm_v 2. dll under C: Program FilesMicrosoft SQL ServerMSSQLBinn
Implementation l Install Sky. Node software under an IIS virtual directory: http: //galex. stsci. edu/Sky. Node l Edit the Web. Config file and replace the database connection string: – <add key="Sql. Connection. String“ value="Initial Catalog=<dbname>; Data Source=<dbhost>; User ID=<user>; Password=<password>; Connect Timeout=90" />
Implementation: continued l Edit the Web. Config file and change the Info() dictionary information such as – – – – Survey. Name Survey. Area Meta. Table Sigma (astrometric precision) Primary. Table Ra. Name Dec. Name Location
Implementation: continued l Run the following SQL scripts: – skynode-web. Support. sql – – Creates all the stored procedures used by the Sky. Node web service skynode-get. Match. sql – Creates the matching stored procedure called by the XMATCH web method
Finally… l Provide the URL of your Sky. Node web service to budavari@pha. jhu. edu:
Important Note l The database user <user> under which the Sky. Node stored procedures will be executed, must also have execution privileges on db MASTER for ALL HTM stored and extended procedures.
- Slides: 10