How to build your own skynode
Download
1 / 10

How to ppt - PowerPoint PPT Presentation


  • 234 Views
  • Updated On :

How to build your own SkyNode. A quick tutorial by Alberto Conti & Bernie Shiao Space Telescope Science Institute Baltimore, MD [email protected] , [email protected] Introductory Notes.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'How to ppt' - Roberta


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
How to build your own skynode l.jpg

How to build your own SkyNode

A quick tutorial

by

Alberto Conti & Bernie Shiao

Space Telescope Science Institute

Baltimore, MD

[email protected], [email protected]


Introductory notes l.jpg
Introductory Notes

  • This brief tutorial was written after Bernie and I spend a morning at JHU with Alex, Tamas and Wil to set up a SkyNode 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.jpg
Requirements(based on GALEX example)

  • Database: <dbname>, i.e. GALEX

  • Objects Table: <objtable>, i.e. PhotoObjAll

    • This table contains the catalog of all GALEX objects

    • Each object has several attributes that will be accessible from each SkyNode

    • <objtable> MUST contain:

      • objID, RA, Dec

      • htmID,cx,cy,cz


Requirements continued based on galex example l.jpg
Requirements: continued(based on GALEX example)

  • Objects Table View: PhotoPrimary

    • This view is obtained from <objtable>The most general view is obtained by

      • create view PhotoPrimary 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 example5 l.jpg
    Requirements: continued(based on GALEX example)

    • 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

        • create view columns as select * from dbcolumns

  • HTM Functions

    • Run skynode-htmInstall.sql and install htm_v2.dll under C:\Program Files\Microsoft SQL Server\MSSQL\Binn


  • Implementation l.jpg
    Implementation

    • Install SkyNode software under an IIS virtual directory: http://galex.stsci.edu/SkyNode

    • Edit the Web.Config file and replace the database connection string:

      • <add key="SqlConnection.String“ value="Initial Catalog=<dbname>; Data Source=<dbhost>; User ID=<user>; Password=<password>;Connect Timeout=90" />


    Implementation continued l.jpg
    Implementation: continued

    • Edit the Web.Config file and change the Info() dictionary information such as

      • SurveyName

      • SurveyArea

      • MetaTable

      • Sigma (astrometric precision)

      • PrimaryTable

      • RaName

      • DecName

      • Location


    Implementation continued8 l.jpg
    Implementation: continued

    • Run the following SQL scripts:

      • skynode-webSupport.sql

        • Creates all the stored procedures used by the SkyNode web service

    • skynode-getMatch.sql

      • Creates the matching stored procedure called by theXMATCH web method


    Finally l.jpg
    Finally…

    • Provide the URL of your SkyNode web service to [email protected]:

    http://galex.stsci.edu/

    SkyNode/skynodews.asmx


    Important note l.jpg
    Important Note

    • The database user <user> under which the SkyNode stored procedures will be executed, must also have execution privileges on db MASTER for ALL HTM stored and extended procedures.


    ad