John (et al.) , Just some ideas....
I have never questioned that it should be a different table. What I never understood is why the H tables are set up with a variable number of columns. Or even separate H tables (one per T table) for that matter. If the H table was structure with four columns then it could be used for any T table. schemaId Entry_ID Status_Integer_value Timestamp ( It could be 3 columns if each record used a GUID instead of "Entry_ID" values. Or It could be 3 columns if each H table maps to the schemaId the way they currently do. ) The only reason I see to not consolidate them all into one long (but narrow) table is just performance for write operation contentions. (I think Oracle can even mitigate that too with table partitions based on data values. Maybe other DB's can do that too, but I can not confirm it.) So then maybe the system could allow you to use multiple H tables upto a one per T table. But alas that is likely a more modern RDBMS design and likely would have failed "back in the day" when Remedy was getting v1.0 out of the door. I have also wondered if the intention was to enable the idea of tracking all status changes too. ( Instead of just keeping the last time the record went into that value.) By adding a column (Status-History GUID) the "Status-History" could turn into a set of data that shows all of the times the record was in any given status, and who put it in that status. Maybe that is part of the v1.0 design that has yet to be completed? Just some ideas.... -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Thu, Mar 25, 2010 at 1:41 PM, John Sundberg <[email protected]> wrote: > What would be the purpose of having a seperate table to hold the status > values and not just have it in the orig table? > > -John _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
