Databases Reference
In-Depth Information
￿ Now() stands for a function, not a value. However, we will often use
Now() to designate a specific point in time. For example, we may say
that a time period starts at Now() and continues on until 9999. This is a
shorthand way of emphasizing that, whenever that time period was
created, it was given as its begin date the value returned by Now() at that
moment. (From Chapter 3.)
Components: clock tick, point in time.
object
Mechanics: what is represented by the object identifier (oid) in an asserted
version table.
Semantics: an instance of a type of thing which exists over time, has properties
and relationships, and can change over time.
Comments:
￿ See also: events . Events, whether points in time or durations in time, are
not objects, because events, by definition, do not change.
￿ Examples of objects include vendors, customers, employees, regulatory
agencies, products, services, bills of material, invoices, purchase orders,
claims, certifications, etc.
Components: asserted version table, instance, object identifier, oid, represent,
type, thing.
object identifier
Mechanics: the unique identifier of the persistent object represented by a row in
an asserted version table, used as part of the primary key of that row.
Comments:
￿ The unique identifier of a row in an asserted version table is the
concatenation of an object identifier, an effective begin date, and an
assertion begin date.
Components: asserted version table, persistent object.
occupied
Mechanics: a series of one or more clock ticks is occupied by an object if and only
if those clock ticks are all included within the effective time period of a
version of that object.
Semantics: a time period is occupied by an object if and only if the object is
represented in every clock tick in that time period.
Components: clock tick, effective time period, include, object, represent,
version.
oid
See object identifier .
ontological time
Semantics: the ontological time of a row in a bi-temporal table is the period of
time during which its referenced object exists.
Comments:
￿ A neutral term referring to either the standard temporal model's valid
time or to Asserted Versioning's effective time.
Components: bi-temporal table, object, referent, time period.
open episode
Mechanics: An episode whose effective end date is 9999.
Semantics: an episode whose effective end date is not known.
Search WWH ::




Custom Search