ToS SQL2XML
From GEANT2-JRA1 Wiki
This page shows the translation done between DFN's CNM SQL schema used as starting point for the topology represented in XML using GGF'S NMWG XML schema.
In the following table, the following abbreviations are used:
CNM: refers to DFN'S CNM SQL schema used as base, the source of the information, stored in PostgreSQL cause needs its object-relational database features.
NMWG: refers to GGF's NMWG schema, which is the target translation, that will used to export the information to ToS clients.
The information that is currently being exported in the XML file have three main elements: nodes, networks and interfaces and the references to link them.
The references are:
network are compound of interfaces
country_iso3166_cod nodes have references to interfaces (interfaces' information is not duplicated)
Therefore only the following browsing is possible:
network->interfaces
nodes->interfaces
| CNM | NMWG | Notes |
| node | ||
| dns_name1 | Hostname | |
| usage_type | attribute of nmgtopo3:name | |
| description | nmwgtopo3:location + "," + nmwgtopo3:city | |
| domain_name | nmwgtopo3:institution |
|
| country_iso3166_code | nmwgtopo3:country | |
| interface | ||
| if_type | nmtl3:type | standard snmp mib |
| if_index | nmtl3:ifIndex | standard snmp mib
|
| default_ip_interface_address | nmtl3:ifAddress | |
| default_ip_network_subnet_preffix | nmtl3:netmask | |
| if_description | nmtl3:ifDescription | |
| if_highspeed or if_speed or speed | nmtl3:capacity | The assignment will following rules of preference: speed > if_highspeed (mib2 extension) > if_speed (standard mib) |
| network | ||
| network_type | nmtl3:type | examples: loopback, elink, core (in general free string) |
| network_name | nmtl:name | |
| description | attribute of nmtl3:name |
