Hi Scott, I have always considered D2RQ to be useful when you are leaving the data in relational form and need routine access to it via SPARQL, etc... Rocky's use case is more one-off where there is data in relational form that will be converted to triples and materialized on a triple store. The relational functionality will be shut-off once the transfer is complete.
That process involves everything from mapping the relational structure to an existing ontology, creating the correct CONSTRUCT queries to generate the triples, managing the creation of URIs and GRAPHS and ultimately materializing the triples in a triple store for access by other applications. Do you recommend D2RQ for the described use case? We typically use SPARQLMotion with a series SQL queries and ApplyConstructs to manage the ontology mapping and create the triples in cases where this is a one-off effort. Thanks in advance for your input! Tim On Wed, Dec 18, 2013 at 3:34 PM, Scott Henninger <[email protected] > wrote: > Rocky; Not really. D2RQ is how we support relational back-ends. There > is a SQL module in SPARQLMotion, but I would not see that as being as > effective as the D2RQ interface. > > -- Scott > > On 12/18/2013, 2:56 PM, R Wiethorn wrote: > > Scott, I was just informed I'm not to use D2RQ, but to utilize sparql > functions , particularly those associated with creating URIs. > > Can you suggest a different route? > Thanks, > Rocky > > On Wednesday, December 18, 2013 2:35:58 PM UTC-5, Scott Henninger wrote: > >> Rocky, for access to relational data, please see Composer Help > >> Working with Data Back Ends > Working with Relational Databases > Importing >> Relational Databases with D2RQ >> >> -- Scott >> >> On 12/18/2013, 2:25 PM, R Wiethorn wrote: >> >> Hello, >> I'm looking for more SPARQLMotion examples to practice on. >> >> Key Tasks I'm wanting to learn more about: >> >> 1. Reading Structured Data from a Oracle DB >> 2. Converting to Triples >> 3. Storing the Triples for use in Sematic Layer. >> >> >> >> The first 2 topics may be more easily obtained. I recognize the Semantic >> Layer may be a very customized layer. >> >> Thanks, >> Rocky >> >> -- >> -- You received this message because you are subscribed to the Google >> Group "TopBraid Suite Users", the topics of which include Enterprise >> Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid >> Insight, SPARQLMotion, SPARQL Web Pages and SPIN. >> To post to this group, send email to >> [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> For more options, visit this group at >> http://groups.google.com/group/topbraid-users?hl=en >> --- >> You received this message because you are subscribed to the Google Groups >> "TopBraid Suite Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> -- > -- You received this message because you are subscribed to the Google > Group "TopBraid Suite Users", the topics of which include Enterprise > Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid > Insight, SPARQLMotion, SPARQL Web Pages and SPIN. > To post to this group, send email to > [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/topbraid-users?hl=en > --- > You received this message because you are subscribed to the Google Groups > "TopBraid Suite Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- > -- You received this message because you are subscribed to the Google > Group "TopBraid Suite Users", the topics of which include Enterprise > Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid > Insight, SPARQLMotion, SPARQL Web Pages and SPIN. > To post to this group, send email to > [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/topbraid-users?hl=en > --- > You received this message because you are subscribed to the Google Groups > "TopBraid Suite Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en --- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
