DaveAuld wrote:So the question is, particularly to any DBA's or architects, how would you or
what suggestions would you have on how best to build the database to meet the
needs, allowing for potentially more kpi parameters or groups to be added in the
Your notation is not familar to me however it doesn't seem to encapsulate what I would do.
The problem of your description seems to be the following.
1. You have a number of sites
2. You collect named 'metrics' from each site
3. The collection of metrics for a specific site do not match other sites.
4. And as a guess you have not considered that over time the metrics from one site might not be the same set either.
Given that I would have probably have the following table structure
1. "Site" with "Site Id" and other information specific only to the site.
2. "Metric Description" with "Metric Desc Id" and perhaps "Value Type"
3. "Metric" which has "Site Id", "Collected Timestamp", "Metric Desc Id" and "Metric Value"
Each site results in an entry in 1.
Each metric results in an entry in 3.
Table 2 is probably managed manually.
The "Value Type" allows one to identify what the "Metric Value" represents. For example it could be a timestamp, count, time span, float, integer, etc.
The above is a bit vague because the specifics of the actual system are needed to refine it further.