The ORM Foundation

Get the facts!

Modeling derived values

Last post Fri, Jan 15 2010 8:26 by sbattisti. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • Thu, Jan 14 2010 11:00

    Modeling derived values

    How does ORM (and more specifically, NORMA) handle the modeling of derived values? For example, I'm currently working on a ORM model related to the concept of payroll deductions. A payroll deduction (object), in this case, has something like an "amount accrued YTD" value. (Payroll Deduction has AmountAccruedYTD)

    The YTD amount is important to the business, but the value is derived elsewhere.

    How can I represent the derivation of the value?



  • Thu, Jan 14 2010 12:07 In reply to

    • Ken Evans
    • Top 10 Contributor
    • Joined on Sun, Nov 18 2007
    • Stickford, UK
    • Posts 800

    Re: Modeling derived values

    Hi Steve,

    From your example, it seems to me that something called "AmountAccruedYTD" would be derived from whatever it is that is being accrued.
    From your description, I assume that each "deduction instance" is uniquely identified somewhere.

    So it would seem to be a matter of "just" adding up the deductions between two points in time (e.g. "CurrentAccountingYearStartDate" and "CurrentAccrualCutoffDate") and putting the result into the "Amount AccruedYTD" column.    

    Derivation is discussed extensively in the Big Brown Book (e.g. pages 98 onwards) and in NORMA Tutorial 2 which you can download from the library.
    Also, there are quite a number of posts on this site about derivation. (e.g. try a site search using "derived".)

    I don't think that "automatic derivation" is yet implemented in NORMA so we currently advise a textual annotation on the model.

    Hope this helps





    Filed under:
  • Fri, Jan 15 2010 8:26 In reply to

    Re: Modeling derived values

    Great, I'll go through the 2nd tutorial. I'd gone through it before, but often these things take practice before they get stuck in your brain! :D

    Thanks for the help!

Page 1 of 1 (3 items)
© 2008-2020 The ORM Foundation: A UK not-for-profit organisation -------------- Terms of Service