Hi, I have a solr core to which I can add simple documents (essentially these consist of a triple: resource URL, referrer URL and timestamp) that provide information on activity data for open-access repositories.
Replicating this in a SQL database I can retrieve other resource URLs (for a given resource URL) that have been viewed or downloaded within a specified time frame (e.g. 10 minutes) by the using referrer URLs. The SQL query would involve an inner join e.g. select distinct a1.resource_url from activity a1, activity a2 where a1.referrer=a2.referrer and a1.resource_url <> a2.resource_url and a2.resource_url ='http://resource/1' and (a2.timestamp, interval '00:10') overlaps (a1.timestamp, interval '00:10'); My question(s): Can this be represented by a solr query? Would it be possible using nested queries or would I need to filter a result set and/or perform a second solr query? Or should I simply use an sql database for this type of query.. Any help or guidance would be much appreciated. Thanks, Antony -- Antony Corfield Project developer AEIOU Project Tel. 01970 628724 http://aeiouproject.blogspot.com/
