[jboss-dev-forums] [Design of JBoss jBPM] - Re: user based process versioning ?

[david.lloyd@jboss.com]

"tom.baeyens at jboss.com" wrote : david, i don't yet see the point of having a table separation for process definition versions and process definitions.    now there is only a process definition version table and the name and version are columns. 

Yes, which means that in order to determine the latest version of a process, the generated SQL must select all rows for a process to know what the latest version is.

If we have a separate version table, then only one row from each table need be selected to determine the latest version.  This is just one benefit of having normalized database tables.  All the tables in jBPM should be normalized unless there is a very good reason not to (which there usually isn't).

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3999502#3999502

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3999502