The Guthrie NODEDETAILS table contains a list of all the nodes involed in PingER analysis done from SLAC. It is stored in the SLACPROD Oracle instance under the IEPM user/schema.
Column specifications
Name |
Null? |
Data Type |
Use |
|---|---|---|---|
NODENAME |
NOT NULL |
VARCHAR2(100) |
DNS host name |
IPADDRESS |
|
VARCHAR2(15) |
IPv4 address |
SITENAME |
|
VARCHAR2(100) |
Domain name of the node |
NICKNAME |
|
VARCHAR2(35) |
Abstraction of the hostname with the TLD first.1 |
FULLNAME |
|
VARCHAR2(100) |
Human-friendly description of the node/site |
LOCATION |
|
VARCHAR2(100) |
City and/or State/Province/Region for node |
COUNTRY |
|
VARCHAR2(100) |
Country for node |
CONTINENT |
|
VARCHAR2(100) |
Continent or region where node is thought to be located2 |
LATANDLONG VARCHAR2(25)
PROJECTTYPE VARCHAR2(10)
PINGSERVER VARCHAR2(100)
TRACESERVER VARCHAR2(100)
DATASERVER VARCHAR2(100)
URL VARCHAR2(100)
GMT VARCHAR2(10)
COMMENTS VARCHAR2(4000)
APP_USER VARCHAR2(20)
CONTACTS VARCHAR2(100)
PING_SIZE NUMBER
User interface
A user interface for the table was created in Oracle's HTML DB / Application Express and can be accessed at https://oraweb.slac.stanford.edu/apex/slacprod/f?p=123:1. Authorized users are authenticated by their SLAC Windows credentials.
The UI allows for the creation, search, modification, and deletion of nodes. As a rule, nodes should not be deleted from the database for referential integrity reasons -- even though there is only one table in the database, various processes use this table in concert with the flat files that contain the raw and analyzed PingER results.
Inside the UI, the country and continent (region) are set and restricted to a pop-up list of values. This list is actually based on values already existing in the NODEDETAILS table in those two fields. When adding a node in a country not previously used, the node can either be completely created through a SQL INSERT statement entered directly into the database (via SQLPlus or another tool); or all but the country and region/continent can be entered, the record can be saved, and then a SQL UPDATE statement can be used to add the new country and continent, similar to the following:
update nodedetails set country = 'United States, continent = 'North America' where nodename = 'EDU.SLAC.STANFORD.N3'
It may be necessary to exit and re-launch the UI in order to get the new country and continent to appear in the list of values.