I am currently designing my first database. The complexity is
manageable. However in the future I might want to expand the domain to
time-series and as far as I understand time-series and databases don't
go well together. How does this relate to the object-relational
mismatch? I have seen that there is some research, e.g. H.Darwen's
Temporal Data and the Relational Model, but don't have the time to
study those things in depth. Basically I want to avert bigger problems
later on. Should I research the theory more before starting
implementation or can I adapt as I go along?
How do you expect to avert problems later if you do not know what
you are doing? Read first.
Sincerely,
Gene Wirchenko
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.
Read first. In particular, download the Rick Snodgrass book from the
the University of Arizona website.It is the classic for doing temporal
queries in SQL.