For simplistic answer, I suspect that all that could be arrived at would be some rule of thumb based on historical experience and some limited test data.
Material stress and fatigue is a heavy duty subject. The effect of stress would be a very non-linear equation... things would be fine up to a certain pressure level and then they would deteriorate quicky. Temperature is a big factor as well, and tghat is also non-linear... there will be a certain tempepature at which each type of material deteriorates very quickly.
Most materials are tested and rated under conditions of a constant pressure at a certain temperature over a period of many days. That would not extrapolate at all to a short duration "impulse".
Most likely, given the task of designing a cannon barrel to someone with considerable engineering experience but not in cannon design, an engineer would do tests in a pressure test barrel to determine peak pressure, double the expected peak pressure (a very common practice) consult the material strength tables, add in a bit of a safety factor to cover his butt (engineers hate being embarased, I know, I am one), round up to the nearest standard size, bring it to a peer review where it would get bigger still to make everyone happy, and the result would be a 12 inch diameter tube with a 1 inch bore in it.