how to build your own skynode
Download
Skip this Video
Download Presentation
How to build your own SkyNode

Loading in 2 Seconds...

play fullscreen
1 / 10

How to ppt - PowerPoint PPT Presentation


  • 241 Views
  • Uploaded 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

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
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
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
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
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
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
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
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
Finally…

http://galex.stsci.edu/

SkyNode/skynodews.asmx

important note
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