LightPath Status JRA4 model Database schema

From GEANT2-JRA1 Wiki

Vocabulary

GEANT2 JRA4 requires status for two types of links: domain and interdomain. Brief definition of domain and interdomain links (in our own words) are below.


Domain Link: A domain link is an aggregation of multiple links within a domain. These links are used together to provide a dedicated path within the domain. This dedicated path can be used to serve one or more projects or one or more organisations (or both). The status of a domain link would provide an aggregated view of all the links forming the domain link.


Interdomain Link: An Interdomain link consists of one or more links (each link could be a path cords) which are used to provide connectivity between two domains. Interdomain links mostly connect domain links belonging to different domains. There are usually two domains associated with an interdomain link. From the monitoring point of view, one or both of these domains could be monitoring the status of this interdomain link. A domain could only know the status of a 'partial interdomain link' (ex. incoming/recieving status). Such links and their status are 'tagged' as ID_Link_Partial_Info. If a domain happens to know the complete information for an interdomain link (ex. incoming/receiving and outgoing/sending status), the link and the status is 'tagged' as ID_Link.

From the database point of view, the table and data stored in this table doesn't care if the link is partial or complete. Such type of 'topology information' should be ideally stored in a topology database (i.e. describing the Interdomain_link id as being complete or partial, etc)


End to End link: An end to end link is a concatenation of interdomain and domain links. An end-to-end link provides connectivity between two sites which is required for a project or organisation.


Database Schema

Domain link table

Image:Domain-link-database-schema.PNG

Interdomain link table

Image:Interdomain-link-database-schema.PNG


Why not merge two tables (and add a linkType field indicating whehter it is a domain link or an interdomain link)?


Can I create my own tables or extend these for my own purposes? Certainly!


Sources (for above diagrams, etc)

Tables were created in a word document, copied the tables over to paint and output a png. The word document can be downloaded here:

Image:Domain-and-interdomain-link-database-schema-lightpath-status-jra4.doc


Back to Java SQL MA Page

Personal tools