Re: Impossible Database Design?

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 - 13:19:27 CDT