This will allow us to track how files were moved around
Example:
------------
* find events for subject_uri = nice.txt
find all events where (subj_id = 2 and timestamp > 2500) or (subj_id = 1 and timestamp <= 2500)
* find events for subject_uri = omg!
find all events where (subj_id = 4 and timestamp > 10000) or (subj_id = 2 and timestamp > 2500) or (subj_id = 1 and timestamp <= 2500)
I dont understand the soltuion tbh
However looking at your table i got an idea
Scenario:
* foo.txt gets renamed to nice.txt
* nice.txt gets renamed to stuff.txt
* create new foo.txt,
* stuff.txt gets renamed to omg!!
uri
=========
id | value
---------------
1 | foo.txt
2 | nice.txt
3 | stuff.txt
4 | omg!!
and
uri_change_map ------- ------- ------- ------
=============
new_id | old_id | timestamp
-------
2 | 1 | 2500
3 | 2 | 5000
4 | 3 | 10000
This will allow us to track how files were moved around
Example:
------------
* find events for subject_uri = nice.txt
find all events where (subj_id = 2 and timestamp > 2500) or (subj_id = 1 and timestamp <= 2500)
* find events for subject_uri = omg!
find all events where (subj_id = 4 and timestamp > 10000) or (subj_id = 2 and timestamp > 2500) or (subj_id = 1 and timestamp <= 2500)