The ORM Foundation

Get the facts!

Search

Page 2 of 3 (26 items) < Previous 1 2 3 Next >
  • Re: Exclusion constraints

    Hi Ken, We are in full agreement with respect to gravity. It&#39;s not a fact, which can easily be shown since it is a noun. Gravity makes the Earth rotate around the Sun, is a fact, just as a falling Apple made Newton contemplate about gravity, is a fact. Whether an apple actually fell on his head may be an untrue fact. Now to your definition ...
    Posted to Extensions to ORM (Forum) by Niels Hoogeveen on Tue, Mar 18 2014
  • Re: Exclusion constraints

    Hello Ken, We&#39;re getting really philosophical here. Does there exist something like a &quot;naked&quot; fact? Even if we say that a fact and its existence are one and the same, we already have to introduce an additional fact to express the knowledge of that fact. It is even debatable whether a fact can exist without someone knowing about it. ...
    Posted to Extensions to ORM (Forum) by Niels Hoogeveen on Tue, Mar 18 2014
  • Re: Exclusion constraints

    Hello Ken, Many things stored in databases are beliefs.This is why update functionality exists in the first place. There are a few examples where a database is the primary fact holder, general ledger comes to mind, and in such cases update functionality is prohibited. Instead of changing a line in a general ledger we create a new entry negating ...
    Posted to Extensions to ORM (Forum) by Niels Hoogeveen on Tue, Mar 18 2014
  • Re: Exclusion constraints

    Exactly because of the points you mention, the range types as present in PostgreSQL, are defined as having a lower and an upper bound. These bounds can be either exclusive or inclusive, and can also be infinite.&nbsp; To store periods, a built in datatype exists called&nbsp;tstzrange, which stands for &quot;time stamp with time zone range&quot;. ...
    Posted to Extensions to ORM (Forum) by Niels Hoogeveen on Mon, Mar 17 2014
  • Re: Exclusion constraints

    Thank you Terry, I see how indeed the valid time, transaction time example I gave should indeed in ORM be modelled using elementary fact types, using external unicity constraints. I guess I am still a little bit too much trying to derive a conceptual model from a desired implementation instead of the other way around. Niels&nbsp;
    Posted to Extensions to ORM (Forum) by Niels Hoogeveen on Mon, Mar 17 2014
  • Re: Exclusion constraints

    I realized I made a wrong assumption that in order to define validity period (previously erroneously called validity duration) and transaction period, I would have to define period twice. This of course is not necessary. Period can be defined only once and used twice in a relation, once in the role of validity and once in the role of ...
    Posted to Extensions to ORM (Forum) by Niels Hoogeveen on Mon, Mar 17 2014
  • Re: Exclusion constraints

    Hello Ken, Thanks for the model. I am afraid I didn&#39;t use the correct terminology in my response to Terry. I used the term duration, where I should have used the term period.&nbsp; Let me give an example of the usage of those two periods. Suppose we want to record the employment of persons, and we don&#39;t want to lose any information we ...
    Posted to Extensions to ORM (Forum) by Niels Hoogeveen on Mon, Mar 17 2014
  • Re: Exclusion constraints

    Hi Clifford, I by an large agree with what you say, although I would tend to see your final statement in a different light. First of all, the range type, which has been so important to the discussion so far, is not only a compound data type, it is also an abstract data type. A range type can be defined as having a start, an end, and some ...
    Posted to Extensions to ORM (Forum) by Niels Hoogeveen on Mon, Mar 17 2014
  • Re: Exclusion constraints

    Hi Terry, Thank you for your explanation, although I don&#39;t fully understand how to use compound value types as entity types. Suppose we have a model with two durations, for example by having a relation that contains a validity duration and a transaction duration, as is a scenario found in some temporal databases. &nbsp; I understand we can ...
    Posted to Extensions to ORM (Forum) by Niels Hoogeveen on Mon, Mar 17 2014
  • Re: Exclusion constraints

    Thank you Terry, That completely answered my original question. Would it be feasible to have compound value types, such as range, point, line, circle, polygon etc., such that phrases like &quot;Reservation1.end &lt;= Reservation2.start or Reservation1.start &gt;= Reservation2.end&quot; can be replaced by something like Reservation1 does not ...
    Posted to Extensions to ORM (Forum) by Niels Hoogeveen on Sun, Mar 16 2014
Page 2 of 3 (26 items) < Previous 1 2 3 Next >
© 2008-2020 The ORM Foundation: A UK not-for-profit organisation -------------- Terms of Service