The Siteview Database schema

The data relative to the four LHC experiments are stored in the same schema.

Description of the schema table by table:

SITEVIEW

This is the table where the most recent values of the metrics are stored. Every entry in SITEVIEW table refers to a 'column'. The concept of column is Siteview application is a tuple ov (VO, activity, metric), ex. (CMS, job processing, number of running jobs). Technically, a column is an entry in the SITEVIEW_COLUMNS table. The connection between a SITEVIEW entry and its corresponding column is given by the SITEVIEW.!ColumnId foreign key.

Table constraints:

• ColumnId is a foreign key to SITEVIEW_COLUMNS table.
• SourceEntryId and TargetEntryId are foreign keys to SITEVIEW_SITES table
• VOName is not null
• ColumnId is not null

SITEVIEW_COLUMNS

The concept of column is a tuple of a VO (ColumnGroup), an Activity and a Metric. This tuple has a unique constraint. Every value in the SITEVIEW table refers to a column, through a foreign key.

Table constraints:

• ColumnId: primary key
• ColumnName is not null
• ColumnId is not null
• ActivityId is a foreign key to the SITEVIEW_ACTIVITIES table
• MetricId is a foreign key to the SITEVIEW_METRICS table
• The columns tuple (ColumnGroup, ActivityId, MetricId) have a unique constraint
• ColumnGroup is a foreign key to SITEVIEW_VOS table

SITEVIEW_SITES

Every entry of this table represents an LCG site. The SiteName is the official site name as used in GOCDB. More alias for the sites are stored in another table (SITEVIEW_VOSITES), connected to the SITEVIEW_SITES with a foreign key.

Table constraints:

• SiteId primary key
• SiteName is unique

SITEVIEW_VOSITES

The same site is called with different names by different VOs. Every entry of this table is an alias of an LCG site, according to the terminology of a specific VO.

Table constraints:

• SiteId foreign key to SiteId
• VO foreign key to SITEVIEW_VOS.VOName
• the tuple (VO, SiteName) is unique

SITEVIEW_VOS

Simply list of VOs

Table constraints:

• VOName primary key

SITEVIEW_URLS

Every entry is a URL source of the metrics Table constraints:

• URL is primary key. this is not good. It should be changed. In principle the same URL could be present in more entries in this table. It's not a good idea to take the URL as primary key
• VO is a foreign key to the SITEVIEW_VOS.VOName

SITEVIEW_ACTIVITIES

SITEVIEW_METRICS

SITEVIEW_TARGETS

SITEVIEW_COLUMNS_LEGEND

SITEVIEW_DATA

SITEVIEW_DATA_CHANGES

-- ElisaLanciotti - 08 Jun 2009