revision statistic page
this page reports the statistic over the revisions; this allows the user to have a view over the database complexity and over the database evolution
- STATISTIC:
Revision released per month
- DESCRIPTION
The statistics show the number of revisions commited every month
- SQL STATEMENT
SELECT YEAR(tstart), MONTH(tstart), COUNT(*) FROM PRISM_VERSIONS WHERE schema_name LIKE ? GROUP BY YEAR(tstart), MONTH(tstart)
- Look inside the statistic data
- Show/Hide Statistic chart...
- STATISTIC:
Revision Lifetime
- DESCRIPTION
The statistics show the lifetime, in days, of each revision
- SQL STATEMENT
SELECT schema_unique_name, DATEDIFF(tend,tstart) FROM PRISM_VERSIONS WHERE schema_unique_name like ? AND tend < (SELECT MAX(tend) FROM PRISM_VERSIONS WHERE schema_unique_name like ?) ORDER BY tstart
- Look inside the statistic data
Group: From 0 to 5
Group: From 5 to 11
Group: From 11 to 17
Group: From 17 to 23
