Hi Luis, Look here: http://www4.wiwiss.fu-berlin.de/bizer/d2rq/spec/#propertybridge
and scroll down a bit till you find "Example: Property bridge using information from another database table". The example actually is a bit more complicated because it does two joins through an n:m table to get the final column. In your case, you'd just have one join. You can use this pattern to attach the Recorder.name to the Product class name. To type the product as class Music (a weird class name! MusicProduct maybe?), create a property bridge with a d2rq:condition that checks the type column, and d2rq:property should be rdf:type, and d2rq:value should be the xyz:Music. (If you have multiple other types besides Music, then you might want to look into d2rq:TranslationTable as well, it can be faster than creating lots of property bridges with different d2rq:conditions.) Hope that helps, Richard On 27 Apr 2011, at 19:01, Luis Eufrasio Teixeira Neto wrote: > Hi Guys, > > I'm a new user of d2rq and I wanna do something like this: > I have a table in MySQL called 'Recorder', this table has 2 columns id (pk) > and name. > I have another table called 'Product', this table has many columns including > type and recorder (fk of Recorder.id) nullable. > When the value of the column type is 'music', the recorder column is filled > with a value. Case else it's null. > The problem is: my ontology doesn't have a Class Recorder. Otherwise, it has > a Class Product and a subclass Music. The Music class has the field recorder. > How can I map this? > > -- > Thanks, > Luís Eufrasio T. Neto > MSN: [email protected] > > "To be FREE is to be capable of LOVE without expecting any return". > "Ser LIVRE é ser capaz de AMAR sem exigir nada em troca." > ------------------------------------------------------------------------------ > WhatsUp Gold - Download Free Network Management Software > The most intuitive, comprehensive, and cost-effective network > management toolset available today. Delivers lowest initial > acquisition cost and overall TCO of any competing solution. > http://p.sf.net/sfu/whatsupgold-sd_______________________________________________ > d2rq-map-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel ------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd _______________________________________________ d2rq-map-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
