Scott, it would be really great to feed any enhancement, even small ones, back into the open source community, it would allow you to integrate new D2RQ releases faster into TopBraid. That's why we're trying to feed our own changes back as well, hoping that the main developer of D2RQ will merge our changes with the main branch so that we would no longer be responsible for that code. It would also give a real boost to the D2RQ development in general if a company like TopBraid actively participates.
About R2RML support, here's what the main developer of D2RQ (Richard Cyganiak) has to say about it: https://github.com/d2rq/d2rq/issues/84 It does not seem too much work to make that happen, but it is solely dependent on the time that he and other volunteers can spend on it. Again, active participation of TopBraid would help. As D2RQ is not only used in TopBraid but also as a standalone "triple server", it seems to me that your customers, like the one I work for, would like TopBraid to support the exact same feature set with regards to the embedded version of D2RQ as are supported with the standalone version. If I use TopBraid to create/edit/maintain D2RQ mapping files then I should be able to deploy those mapping files on the standalone version of D2RQ (which we run in the cloud) where I would expect that features (of SPARQL for instance) that work in my TopBraid environment will also work on our standalone servers. I don't think that that is currently entirely the case? On Jan 26, 9:32 am, Scott Henninger <[email protected]> wrote: > Jacobus; For 1, the edits we have done for D2RQ are conservative, > focusing on getting D2RQ working with versions of Jena since the last > release of D2RQ. Small enhancements as well for use in the TopBraid > suite, but nothing like adding SPARQL 1.1 support. I have heard there > is active development underway to incorporate the R2RML standard in > D2RQ. > > For 2, some of the enhancements are specific to TBS, so they would not > be appropriate for public domain. In addition, maintaining D2RQ code > for public domain use is not currently in our work scope. Depending > on customer demands and internal resources that could change, but for > now we will report bugs to D2RQ committers as they arise. > > So, if there are any questions about using D2RQ in TopBraid Suite, > we'd be happy to look into them. Also, in 3.6.0 (beta in a couple of > weeks), we will also add a new wizard for creating mappings that is a > significant improvement over the current grab-the-whole-schema > approach. > > -- Scott > > On Jan 26, 7:40 am, Jacobus Geluk <[email protected]> wrote: > > > > > > > > > Hi Scott and Holger, > > > Two questions: > > > 1. Did you update D2RQ up to the Jena SPARQL 1.1 features, I mean does > > your version basically support federated queries? I've been working on > > that myself but it's quite a lot of work in D2RQ to make that happen, > > so if you guys already did that than that would be good. > > 2. When are you planning to feed your changes to D2RQ back to the > > public domain? :-) (preferably to the github version) > > > -- Jacobus > > > On 26 jan, 02:16, Scott Henninger <[email protected]> wrote: > > > > In addition to Holger's statement that we have maintained D2RQ for new > > > versions of Jena, we are closely watching D2RQ enhancements w.r.t. > > > r2rml enhancements and will adopt once this effort reaches a stable > > > state. > > > > You can find the version umber of any of the software packaged with > > > TopBraid Suite by Choosing About TopBraid Composer in TBC and clicking > > > on the Installation details button. Click to view plugins and scroll > > > to the package you are interested in. Click on Plug-ins. In this > > > case, there is not much information beyond stating that it is based on > > > D2RQ, but others will give some information on the package version > > > used. > > > > If there are any deficiencies or errors beyond what you expect from > > > D2RQ, please let us know. > > > > -- Scott > > > > On Jan 25, 4:58 pm, Holger Knublauch <[email protected]> wrote: > > > > > FYI we had taken the version from sourceforge and updated it to changes > > > > in Jena that have happened in the meantime. > > > > > Holger > > > > > On Jan 12, 2012, at 5:33 AM, Jacobus Geluk wrote: > > > > > > I wonder which version of D2RQ is actually used in topbraid. There are > > > > > several versions around: > > > > > > - Version 0.7 on sourceforge, which has not been updated since August > > > > > 2009 (http://sourceforge.net/projects/d2rq-map/files/) > > > > > - The github version, which is actively maintained by Richard Cyganiak > > > > > and a few others:https://github.com/d2rq/d2rq. I hope that this > > > > > version is used by TopBraid since it contains many changes since > > > > > version 0.7 (see commit history > > > > > here:https://github.com/d2rq/d2rq/commits/master) > > > > > > I created a fork myself and just added two new command line options to > > > > > D2RQ: "-i" and "-e" that allow you to specify "include and exclude > > > > > patterns", regular expressions that can be used to filter the tables > > > > > while D2RQ is generating the mapping file. We had a 30000+ table > > > > > database where we "only" needed to generate a mapping for 300 tables, > > > > > so this feature was rather necessary. Here's the code: > > > > >https://github.com/jgeluk/d2rq/tree/feature_ignore_tables. > > > > > > On Jan 11, 10:52 am, Scott Henninger <[email protected]> > > > > > wrote: > > > > >> Tim; This is something we've seen before. The overall issue is that > > > > >> the D2RQ wizard in TBC will read the entire schema when creating the > > > > >> mapping. But not everything in the relational model can be mapped > > > > >> correctly. It's also common that only a few table mappings are > > > > >> needed for the mapping. > > > > >> This overall issue will be addressed in a revamped D2RQ wizard that > > > > >> allows the user to choose the table mappings you want. This will be > > > > >> available in a beta release in the next few weeks. > > > > >> In the meantime, there are a couple of ways you can remove unwanted > > > > >> mappings. One is to edit the -mapping file. It's in RDF and you > > > > >> can open it directly in Composer. The class and property mappings > > > > >> are found in the subclasses of d2rq:ResourceMap. Classes correspond > > > > >> to tables and are mapped via the d2rq:class property of a > > > > >> d2rq:ClassMap instance. Property maps are instances of > > > > >> d2rq:PropertyBridge and mapped to the relational table through the > > > > >> d2rq:column (for columns) or d2rq:join (for foreign key > > > > >> relationships). To see the effects of an edit, save your changes > > > > >> and close/open the DataView file. > > > > >> Another way to do this is to use the attached service. Copy the > > > > >> file into your workspace and run Scripts > Refresh/Display > > > > >> SPARQLMotion functions... Once that is done, the menu choice > > > > >> 'Resource > Get mappings for table column' will appear. The script > > > > >> takes a previous mapping (specifically the schema and mapping files) > > > > >> and converts to a new set of mappings, retaining the old one. This > > > > >> way you can create a mapping with a dump of the entire schema then > > > > >> build multiple mappings based on that. > > > > >> To fill in the wizard, you need the base URI for the mapping and > > > > >> schema files from a previously executed D2RQ wizard. Specify the > > > > >> new URIs for the four files generated by the D2RQ wizard and the > > > > >> names of the tables you want to include in the mapping. The four > > > > >> files are created and you can view the data in Composer using the > > > > >> file generated for the Target Database. > > > > >> Give those a try and let us know if that addresses the problems you > > > > >> are having. > > > > >> -- Scott > > > > >> On 1/9/12 3:22 PM, Tim Smith wrote:Hi, > > > > >> This may be more of D2RQ issue that TBC so I apologize in advance if > > > > >> that is the case. > > > > >> I've managed to connect to my database, create the mapping files, > > > > >> delete the references to Blobs and indices, etc... > > > > >> I can open the DataView file and see instances in the Instance view > > > > >> for the various classes. However, when I try to view the instances, > > > > >> a D2RQ exception is thrown that essentially displays an Oracle SQL > > > > >> error. > > > > >> In short, the query generated by D2RQ is not valid: > > > > >> de.fuberlin.wiwiss.d2rq.D2RQException: ORA-01722: invalid number > > > > >> : SELECT 1 FROM "ATTRIBUTE" WHERE "ATTRIBUTE"."ATTRIBUTE_ID" = > > > > >> '_TYPE10' (E0) > > > > >> Of course this query will always return a value of "1" so I do not > > > > >> know what D2RQ is attempting to do. Regardless, this query is > > > > >> invalid since Attribute.Attribute_ID is a number column - not a > > > > >> character. The schema file correctly indicates a range of > > > > >> xsd:decimal for this column. > > > > >> Has anyone seen this type of behavior from D2RQ before? > > > > >> Thanks, > > > > >> Tim > > > > >> -- > > > > >> You received this message because you are subscribed to the Google > > > > >> Group "TopBraid Suite Users", the topics of which include TopBraid > > > > >> Composer, > > > > >> TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. > > > > >> To post to this group, send email [email protected] > > > > >> To unsubscribe from this group, send email > > > > >> [email protected] > > > > >> For more options, visit this group > > > > >> athttp://groups.google.com/group/topbraid-users?hl=en > > > > > >> ChooseTableMappings.sms.ttl > > > > >> 20KViewDownload > > > > > > -- > > > > > You received this message because you are subscribed to the Google > > > > > Group "TopBraid Suite Users", the topics of which include TopBraid > > > > > Composer, > > > > > TopBraid Live, TopBraid Ensemble, SPARQLMotion 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 Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion 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
