Does the REGEX function work with RELS-EXT in Fedora? Querying our risearch in Fedora 3.4.1, find tuples, with SPARQL outputting CSV thus --------------- select ?RefNo ?hasLocalReferenceNumber from <#ri> where { ?RefNo <fedora-rels-ext:hasLocalReferenceNumber> ?hasLocalReferenceNumber } --------------- returns --------------- <sparql><head><variable name="RefNo"/><variable name="hasLocalReferenceNumber"/></head> <results> <result><RefNo uri="info:fedora/UkDhU:c5c99db0-a962-4075-9e76-6441a728444f"/><hasLocalR eferenceNumber uri="UkDhU:SAD.204/4"/></result> <result><RefNo uri="info:fedora/UkDhU:abecf7d9-edbd-4d80-9243-182796d3a043"/><hasLocalR eferenceNumber uri="UkDhU:DCD.Misc.Ch.3650"/></result> </results> </sparql> or as CSV "RefNo","hasLocalReferenceNumber" info:fedora/UkDhU:c5c99db0-a962-4075-9e76-6441a728444f,UkDhU:SAD.204/4 info:fedora/UkDhU:abecf7d9-edbd-4d80-9243-182796d3a043,UkDhU:DCD.Misc.Ch .3650 -------------- but ------------- select ?RefNo ?hasLocalReferenceNumber from <#ri> where { ?RefNo <fedora-rels-ext:hasLocalReferenceNumber> ?hasLocalReferenceNumber . FILTER regex(?hasLocalReferenceNumber, "U", "i" ) } ----------- returns an empty ----------- <sparql><head><variable name="RefNo"/><variable name="hasLocalReferenceNumber"/></head> <results> </results> </sparql> or as CSV "RefNo","hasLocalReferenceNumber" ------------
Now, is this because you can only have URIs in rels-ext values and SPARQLs regex doesn't works with URIs? If that is so, presumably you cannot use regex in Fedora? And I need Yet Another Datastream instead of this more succinct solution? Sorry for the long email. - - - - - # Richard Higgins # Durham University Library # Archives & Special Collections # Palace Green # Durham # DH1 3RN # E-Mail: r.i.higg...@durham.ac.uk -----Original Message----- From: Scott Hammel [mailto:sc...@clemson.edu] Sent: 11 November 2011 14:10 To: Support and info exchange list for Fedora users. Subject: Re: [fcrepo-user] Wild card searching of Resource Index I use the REGEX function in SPARQL through Fedora's RI search service successfully. It won't work, though, if the value is an IRI and not a literal -- but I'm a fairly novice SPARQLer myself, so others can correct or confirm that. scott On 11/11/2011 08:40 AM, Benjamin Armintor wrote: > You might also try using the REGEX function in a SPARQL query. I'm > not sure if Fedora will pass it along to Mulgara or not, but it's > worth a shot. > > On Fri, Nov 11, 2011 at 8:32 AM,<aj...@virginia.edu> wrote: >> It sounds a bit like you're using the RI (an RDF index) to do something (string-matching) at which a full-text index (like Lucene or Zebra) would be better. >> >> If you want to use RDF for this problem, I suggest that you create objects to represent those upper entities you named (building, collection, section, etc) and make a graph, e.g. >> >> objects:myobject1 isMemberOf sections:UkDhU.DCD.Misc.Ch >> objects:myobject2 isMemberOf sections:UkDhU.DCD.Misc.Ch >> sections:UkDhU.DCD.Misc.Ch isPartOf collections:UkDhU.DCD >> collections:UkDhU.DCD isInside buildings:UkDhU >> >> or using some other suitable RDF predicates. Then your query will not rely on string-matching, at which RDF stores are not especially good, but on structure matching, at which RDF stores are very good. In my example a query to find the object in a building might look something like: >> >> SELECT >> ?object isInside ?building >> WHERE { >> ?object isMemberOf ?section. >> ?section isPartOf ?collection. >> ?collection isInside ?building. >> } >> >> or to find how many objects from a collection have been Fedora-ized, you could use a count query on: >> >> SELECT >> ?object >> WHERE { >> ?object isMemberOf ?section. >> ?section isPartOf ?collection. >> } >> >> and so forth. >> >> >> --- >> A. Soroka >> Online Library Environment >> the University of Virginia Library >> >> >> >> >> On Nov 11, 2011, at 7:50 AM, HIGGINS R.I. wrote: >> >>> Hello: >>> I am attempting to keep track of which of our real objects have digital >>> versions stored in Fedora. The simplest way to do this seemed to be to >>> add an entry to the RELS-EXT datastream along the lines of >>> >>> <hasLocalReferenceNumber >>> xmlns="info:fedora/fedora-system:def/relations-external#" >>> rdf:resource="UkDhU:DCD.Misc.Ch.3650"></hasLocalReferenceNumber> >>> >>> For this to be useful, it would be necessary to be able to different >>> searches: >>> find all starting UkDhU:* (everything in the building) >>> find all starting UkDhU:DCD* (everything in the collection) >>> find all starting UkDhU:DCD.Misc.Ch.* (everything in the section of the >>> collection) >>> and so forth - assuming * to be a wild card. >>> >>> The lack of information on wild card searching of RDF out there implies >>> that this is not a feature that is available. Is there a way to do this, >>> or is it back to the drawing board ? >>> Thank you >>> - - - - - >>> # Richard Higgins >>> # Durham University Library >>> # Archives& Special Collections >>> # Palace Green >>> # Durham >>> # DH1 3RN >>> # E-Mail: r.i.higg...@durham.ac.uk >>> >>> >>> ------------------------------------------------------------------------ ------ >>> RSA(R) Conference 2012 >>> Save $700 by Nov 18 >>> Register now >>> http://p.sf.net/sfu/rsa-sfdev2dev1 >>> _______________________________________________ >>> Fedora-commons-users mailing list >>> Fedora-commons-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/fedora-commons-users >> >> ------------------------------------------------------------------------ ------ >> RSA(R) Conference 2012 >> Save $700 by Nov 18 >> Register now >> http://p.sf.net/sfu/rsa-sfdev2dev1 >> _______________________________________________ >> Fedora-commons-users mailing list >> Fedora-commons-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/fedora-commons-users >> > ------------------------------------------------------------------------ ------ > RSA(R) Conference 2012 > Save $700 by Nov 18 > Register now > http://p.sf.net/sfu/rsa-sfdev2dev1 > _______________________________________________ > Fedora-commons-users mailing list > Fedora-commons-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/fedora-commons-users > -- CCIT Clemson University 864-656-8118 Free/Busy Calendar: http://bit.ly/dBeBzo ------------------------------------------------------------------------ ------ RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 _______________________________________________ Fedora-commons-users mailing list Fedora-commons-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/fedora-commons-users ------------------------------------------------------------------------------ RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 _______________________________________________ Fedora-commons-users mailing list Fedora-commons-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/fedora-commons-users