Re: Time and Data Question

for a non-sql approach, see my implementation of bitemporal data at

    www.kx.com/technical/contribs/stevan/bitemporal

the code has been used (quite successfully) in the employee tracking system at union bank of switzerland.

<bgsmith01_at_fs.fed.us> wrote in message news:8i345e01svq_at_news1.newsguy.com...
> Many times of data evolve through time, e.g. the list of employees in the
> company. Data such as those in an employees table have an explicit time
> domain attached to them; they were hired on a specific date and are still
> employed by the company or left on a specific date.
>
> My question is: Is there a general structure that is recommended for these
> types of data so that we can easily ask questions such as "who are the
> current employees" or "who were the employees on 5 Jan 1993"?
>
> Thanks,
>
> Brad
>
Received on Fri Jun 16 2000 - 00:00:00 CEST