Re: Impossible Database Design?
Date: 17 May 2006 11:19:27 -0700
Message-ID: <1147889967.269324.174880_at_i40g2000cwc.googlegroups.com>
Hey Alvin,
> Agreed, I used CRON as inspiration too.
Did you use a stored procedure to parse the pattern or did you move
that on the application side?
the remaining worry I would have is how to ensure integrity...
What if someone somehow deletes an event through say MySQLAdmin?
Since the repeating rules are not tied to the actual events (though
events know of their rule) I would have to make sure that events only
get added/modified through a clearly defined data storage class or
so...
Maybe it would be possible to create some sort of checksum after each
time a pattern changes the entries (what could that consist of? Number
of rows related to a pattern could be misleading since I theoretically
could accidentally delete a row and add one)
This especially gets tricky if I want to connect other data to
events....
Its quite interesting that there's no commercial main line temporal
database existing yet but I'm curious to see what kind of concepts
'Temporal Data and the Relational Model' will reveal. Are there any
projects being pushed by bigger companies?
Regards,
Nikolai Received on Wed May 17 2006 - 20:19:27 CEST