Hello, Imagine you have data on 100000 test subjects. For every test subject there are 2 data files. For example, one might be a data file describing the actions of a test subject as he went through an obstacle course and the other data file may be time-stamped readings of the subject's heartbeat and breathing rates during the time. These are kept in separate files because the data differs in structure and paradigm (one is event-based the other is a time log).
Queries run against such a data base will very frequently want to match up events in one data file to timestamped biometric data in the other for the same student.
My question is whether there is a way to set up a persistent pairing of these two files so that any query run against the database knows of this natural connection without it having to be explicitly built each time.
For example, it would be nice to create two persistent maps $events and $bio so that the keys of the $events map are document nodes of the data files recording actions students make in the obstacle course and the values are document nodes for associated biometric data, and then $bio is the reverse lookup.
Is it possible in BaseX to create a persistent, user-defined hash that is stored and available without needing to be rebuilt to all queries run against a database?
Thanks, Davd