Are you using the default Mulgara triplestore configuration?
If the multiple objects in your SPARQL query are, as I believe you wrote, not
actually resources but instead simple strings, have you considered using a
full-text index for this kind of search? It would seem to be a good fit for
Lucene's faceting abilities or a similar functionality.
---
A. Soroka
Online Library Environment
the University of Virginia Library
On Nov 23, 2011, at 11:47 AM, J.T.P. wrote:
> Reason for my investigation is for performance issues. I am using SPARQL
> retrieving 20 objects (string values, 20 triples in my where clause ) with
> about 1000 fedora objects in the datastore. It take about 18 seconds for
> retrieval. My sparql query is in the format of
>
> select * where{
> ?subject <namespace:object> ?object
> ?subject <namespace:object_1> ?object_1
> .
> .
> .
> ?subject <namespace:object_20> ?object_20
> FILTER(REGEX(?object, "stringValue","i")
> }
> Any info would be most conducive.
>
> Very Respectfully,
> J.Pitts
>
> *************************************************************************************
> "Inveniam viam aut faciam -- “I will find a way or make one.”
> ***********************************************************************************
>
> From: Alexis Miara <[email protected]>
> To: [email protected]; [email protected]
> Sent: Wednesday, November 23, 2011 9:04 AM
> Subject: RE: [fcrepo-dev] Non Dublin Core data in DB
>
> Hi
>
> When you use RELS-EXT, relationships are stored inside the associated triple
> store (by default Mulgara).
> With RISearch, you can make SPARQL queries on it.
>
> Alexis Miara
> LICEF
> Québec
>
> -----Original Message-----
> From: JTP [mailto:[email protected]]
> Sent: November-22-11 9:30 PM
> To: [email protected]
> Subject: Re: [fcrepo-dev] Non Dublin Core data in DB
>
> I am storing rdf in RELS-EXT,
> xmlns:myns="http://www.nsdl.org/ontologies/relationships#";>, namespace,
> text values (no images,document ..etc). Since I do not see these values in
> the database, beside the Dublic Core datastream, I was curious to where the
> RELS-EXT datastream is stored.
>
>
>
> **********************************************************************
> "Inveniam viam aut faciam -- "I will find a way or make one."
> **********************************************************************
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]]
> Sent: Tuesday, November 22, 2011 5:19 PM
> To: [email protected]
> Subject: Re: [fcrepo-dev] Non Dublin Core data in DB
>
> In particular, if you'd like to use full-text indexing with your metadata,
> you'll want to check out GSearch, a JMS-driven indexing service for Fedora.
>
> If you're storing RDF somewhere other than RELS-EXT or RELS-INT, perhaps
> there's a way to map it into those datastreams, which will allow you to use
> Fedora's built-in indexing, as described by Mr. Della Bitta. Perhaps you can
> tell us a little more about what you're doing?
>
> ---
> A. Soroka
> Online Library Environment
> the University of Virginia Library
>
>
>
>
> On Nov 22, 2011, at 4:04 PM, Michael Della Bitta wrote:
>
> > If your RDF is in one of the two built-in RDF datastreams, RELS-EXT
> > and RELS-INT, it's not indexed by default, but can be if you turn on
> > the Resource Index. If you're storing RDF elsewhere in another
> > datastream, it would take some hacking to get it indexed.
> >
> > Michael Della Bitta
> >
> > Senior Applications Developer
> > Information Technology Group
> > The New York Public Library
> > 40 West 20th Street, 5th Floor
> > New York, NY 10011-4211
> > (212) 621-0609
> >
> >
> >
> > On Tue, Nov 22, 2011 at 3:57 PM, J.T.P. <[email protected]> wrote:
> >> Other meta-data that is custom to my app (rdf data) . Where are these
> >> values stored ?
> >> Thanx....
> >>
> >>
> ****************************************************************************
> *********
> >> "Inveniam viam aut faciam -- "I will find a way or make one."
> >>
> ****************************************************************************
> *******
> >> ________________________________
> >> From: "[email protected]" <[email protected]>
> >> To: "[email protected] Developers"
> >> <[email protected]>
> >> Sent: Tuesday, November 22, 2011 3:21 PM
> >> Subject: Re: [fcrepo-dev] Non Dublin Core data in DB
> >>
> >> Data in datastreams other than DC aren't normally persisted into the SQL
> >> store. Are you thinking of object properties like "owner" or "set", or
> some
> >> other kind of metadata?
> >>
> >> ---
> >> A. Soroka
> >> Online Library Environment
> >> the University of Virginia Library
> >>
> >>
> >>
> >>
> >> On Nov 22, 2011, at 3:17 PM, J.T.P. wrote:
> >>
> >>> Hello FC'ers. Have a probably silly question. I recently migrated from
> >>> Derby to Sybase.
> >>> Applications works fine but a little slow on some queries. I can only
> see
> >>> the Dublin Core data in the doFields table. Where does the data in
> non-DC
> >>> namespaces reside ? I want to put indexes on some fields to see if I can
> >>> improve the performance. Any info would be most conducive.
> >>> Respectfully,
> >>> J. Pitts
> >>>
> >>>
> ****************************************************************************
> *********
> >>> "Inveniam viam aut faciam -- "I will find a way or make one."
> >>>
> >>>
> ****************************************************************************
> *******
> >>>
> >>>
> ----------------------------------------------------------------------------
> --
> >>> All the data continuously generated in your IT infrastructure
> >>> contains a definitive record of customers, application performance,
> >>> security threats, fraudulent activity, and more. Splunk takes this
> >>> data and makes sense of it. IT sense. And common sense.
> >>>
> >>>
> http://p.sf.net/sfu/splunk-novd2d___________________________________________
> ____
> >>> Fedora-commons-developers mailing list
> >>> [email protected]
> >>> https://lists.sourceforge.net/lists/listinfo/fedora-commons-developers
> >>
> >>
> >>
> ----------------------------------------------------------------------------
> --
> >> All the data continuously generated in your IT infrastructure
> >> contains a definitive record of customers, application performance,
> >> security threats, fraudulent activity, and more. Splunk takes this
> >> data and makes sense of it. IT sense. And common sense.
> >> http://p.sf.net/sfu/splunk-novd2d
> >> _______________________________________________
> >> Fedora-commons-developers mailing list
> >> [email protected]
> >> https://lists.sourceforge.net/lists/listinfo/fedora-commons-developers
> >>
> >>
> >>
> >>
> ----------------------------------------------------------------------------
> --
> >> All the data continuously generated in your IT infrastructure
> >> contains a definitive record of customers, application performance,
> >> security threats, fraudulent activity, and more. Splunk takes this
> >> data and makes sense of it. IT sense. And common sense.
> >> http://p.sf.net/sfu/splunk-novd2d
> >> _______________________________________________
> >> Fedora-commons-developers mailing list
> >> [email protected]
> >> https://lists.sourceforge.net/lists/listinfo/fedora-commons-developers
> >>
> >>
> >
> >
> ----------------------------------------------------------------------------
> --
> > All the data continuously generated in your IT infrastructure
> > contains a definitive record of customers, application performance,
> > security threats, fraudulent activity, and more. Splunk takes this
> > data and makes sense of it. IT sense. And common sense.
> > http://p.sf.net/sfu/splunk-novd2d
> > _______________________________________________
> > Fedora-commons-developers mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/fedora-commons-developers
>
>
> ----------------------------------------------------------------------------
> --
> All the data continuously generated in your IT infrastructure
> contains a definitive record of customers, application performance,
> security threats, fraudulent activity, and more. Splunk takes this
> data and makes sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-novd2d
> _______________________________________________
> Fedora-commons-developers mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/fedora-commons-developers
>
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure
> contains a definitive record of customers, application performance,
> security threats, fraudulent activity, and more. Splunk takes this
> data and makes sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-novd2d
> _______________________________________________
> Fedora-commons-developers mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/fedora-commons-developers
>
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure
> contains a definitive record of customers, application performance,
> security threats, fraudulent activity, and more. Splunk takes this
> data and makes sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-novd2d_______________________________________________
> Fedora-commons-developers mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/fedora-commons-developers
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
Fedora-commons-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/fedora-commons-developers
