Developing Time-Oriented Database Applications in SQL

Section 3.2: INTERVALS

3.2 INTERVALS

and an ocean tumbled by with a private boat for Max

and he sailed off through night and day

and in and out of weeks

and almost over a year

to where the wild things are.

Maurice Sendak, Where the Wild Things Are

And which of you by being anxious can add one cubit to his span of life?

Matthew 6:27

An interval is an unanchored contiguous portion of the time line. An interval is relative; an instant is absolute. An interval can be added to an instant, yielding another instant. Intervals cannot be added to spatial points, nor spatial intervals (such as cubits) to temporal intervals, except as (often highly effective) literary devices, as the above quotes illustrate.

Tip

An interval is an unanchored, directional duration of the time line.

The distance between two instants is an interval. Unlike instants, intervals have direction. An interval can be positive or negative, denoting a shift to the future or to the past.

Intervals are less prominent in the FINDER schema than instants. Some are signaled with "duration" or "interval" in their name, examples being the Period_Durtn column in Well_Test_Period and the Sampling_Interval column of the Seis_Survey_Hdr table, or by mentioning the time during which something was happening, as in the Time_String_In_Hole column of the Well_Log_Service table. Other interval columns are more obscure, such as the Incrmnt_Time column of the Stage_Flowback table (other columns having...

UNLIMITED FREE
ACCESS
TO THE WORLD'S BEST IDEAS

SUBMIT
Already a GlobalSpec user? Log in.

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.

Customize Your GlobalSpec Experience

Category: Electromechanical Timers
Finish!
Privacy Policy

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.