My historical data on document progress in the I-D tracker, collected
since the beginning of 2003, is available at
https://rtg.ietf.org/phpmyadmin username ietf password ietf; pick
database trackerdata and table dochistory. (Ignore the permission
denied error; go straight for the table list on the left or the SQL
tab on the top of the right pane)
A starter query to somewhat understand the table relationships is
SELECT docname, changedate, statename, substatename
FROM dochistory, docs
LEFT JOIN states ON stateid = newstate
LEFT JOIN substates ON substateid = newsubstate
WHERE docs.docid = dochistory.docid
ORDER BY dochistory.docid, histid;
(This will return some NULL transitions where something other than the
substate or substate transitioned, like the version number, etc.)
I don't have any great ideas on how to do the analysis, but at least I
have some data to supply.
Bill
_______________________________________________
Ietf mailing list
Ietf(_at_)ietf(_dot_)org
https://www1.ietf.org/mailman/listinfo/ietf