Hi, I have (simplified for the example) a table with the following data Row Start Finish ID Amount --- --------- ---------- -- ------ 1 2008-10-01 2008-10-02 01 10 2 2008-10-02 2008-10-03 02 20 3 2008-10-03 2008-10-04 01 38 4 2008-10-04 2008-10-05 01 23 5 2008-10-05 2008-10-06...
How would you represent a temporal many-to-many relation in SQL? Under non-temporal circumstances one would use a junction table (aka link/bridge/map) to connect the two sides. Is adding temporal tracking as simple as including a ValidStart and ValidEnd columns on the junction table? If you have done this, what issues (if any) did you r...
Hi I was reading about temporal databases and it seems they have built in time aspects. I wonder why would we need such a model? How different is it from a normal RDBMS? Can't we have a normal database i.e. RDBMS and say have a trigger which associates a time stamp with each transaction that happens? May be there would be a performance...
It doesn't take very much reading on REST before you run across Fielding and his dissertation IF you've had some wins with temporal modeling within the confines of a relational store Who are the big names in the field that you referenced? ...
We use a third-party product to manage our sports centre membership. We have several membership types (eg. junior, student, staff, community) and several membership statuses (eg. annual, active, inactive, suspended). Unfortunately the product only records a member's current membership type and status. I'd like to be able to track the way...
Should dates for a temporal database stored in one or 2 tables ? If one doesn't this violate normalisation ? PERSON1 DATE11 DATE21 INFO11 INFO21 DEPRECATED PERSON2 DATE21 DATE22 INFO21 INFO22 CURRENT PERSON1 DATE31 DATE32 INFO31 INFO32 CURRENT DATE1 and DATE2 Columns indicate that INFO1 and INFO2 are true for the period between DATE1 ...
I have a requirement to store all versions of an entity in a easily indexed way and was wondering if anyone has input on what system to use. Without versioning the system is simply a relational database with a row per, for example, person. If the person's state changes that row is changed to reflect this. With versioning the entry shou...
I'm exploring options for implementing a large-scale temporal database. There will likely be billions of records managed with minimal temporal churn, and I'd like a vendor implemented solution to avoid placing too much responsibility in the application(s) that will populate, update, and query the warehouse. Oracle Workspace Manager is o...
I'm building a website. It has groups that users can join. The difference between this and "normal" groups is that membership is temporary - when a user joins a group, he decides the length of membership: 5 days, a week, 2 weeks, etc (choices are pre-defined). Or potentially all memberships could be set to be of the same length - say a...
I am looking for an SQL database of some type that is entirely based around the concept of time, just like those that are geo-centric, relationship-centric, etc. My main wish is that I can make changes to the database as I go along, and then at any point run a query that essentially says, show me how the database looked at this date and...
I'm trying to wrap my head around this task and wondering if there is a standard way of doing this or some libraries that would be useful. Certain events are tracked and timed at several data sources S1 ... SN. The recorded information is the event type and timestamp. There may be several events of the same type sequentially or they may...
I'm going to try to keep this question database agnostic, but I have an interesting problem that I need to tackle and I thought I'd open up the floor for suggestions and feedback. I need to be able to download data from a feed source and store it in a database of some kind, the data needs to be merged into the existing data and I need t...
I'm curious if anyone has implemented or even knows of any bitemporal databases built on NoSQL platforms (e.g., riak). ...