Hi Alex,
The table schema and some sample data to load would be required for recreation.
Also, did you create the RDFView mappings by hand or using the conductor
Linked Data View wizard ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 14 Apr 2014, at 10:23, Alex Bondo Andersen <abon...@gmail.com> wrote:
> The end point is located at http://extbi.lab.aau.dk/sparql
>
> I have attached our mappings. The mappings specific for the example given
> earlier begin at line 270. The IRI classes er defined as follows:
>
> prefix busmap: <http://extbi.lab.aau.dk/mappings/business/>
>
> create iri class busmap:participant_iri
> "http://extbi.lab.aau.dk/data/business/participant/%U#this";
> (in surrogate_participantid varchar) .
>
> create iri class busmap:businessformat_iri
> "http://extbi.lab.aau.dk/data/business/businessformat/%U#this";
> (in surrogate_businessformatid varchar not null) .
>
> create iri class busmap:productionunit_iri
> "http://extbi.lab.aau.dk/data/business/productionunit/%U#this";
> (in surrogate_producitonunitid varchar not null) .
>
> create iri class busmap:addressfeature_iri
> "http://extbi.lab.aau.dk/data/business/addressfeature/%U#this";
> (in surrogate_addressfeatureid varchar not null) .
>
> create iri class busmap:municipality_iri
> "http://extbi.lab.aau.dk/data/business/municipality/%U#this";
> (in surrogate_municipalityid varchar not null) .
>
> create iri class busmap:activity_iri
> "http://extbi.lab.aau.dk/data/business/activity/description/%U#this";
> (in surrogate_activityid varchar not null) .
>
> create iri class busmap:activity_code_iri
> "http://extbi.lab.aau.dk/data/business/activity/code/%U#this";
> (in surrogate_activityid varchar) .
>
> create iri class busmap:address_iri
> "http://extbi.lab.aau.dk/data/business/address/%U#this";
> (in surrogate_addressid varchar) .
>
> create iri class busmap:company_iri
> "http://extbi.lab.aau.dk/data/business/company/%U#this";
> (in surrogate_legalunitid varchar) .
>
> What else can I get you? A (smaller) dump from the table on which the graph
> is based?
>
>
> 2014-04-12 21:52 GMT+02:00 Hugh Williams <hwilli...@openlinksw.com>:
> Hi Alex,
>
> Are you able to provide a simple test case for recreation of this issue ?
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software, Inc. // http://www.openlinksw.com/
> Weblog -- http://www.openlinksw.com/blogs/
> LinkedIn -- http://www.linkedin.com/company/openlink-software/
> Twitter -- http://twitter.com/OpenLink
> Google+ -- http://plus.google.com/100570109519069333827/
> Facebook -- http://www.facebook.com/OpenLinkSoftware
> Universal Data Access, Integration, and Management Technology Providers
>
> On 8 Apr 2014, at 09:56, Alex Bondo Andersen <abon...@gmail.com> wrote:
>
>> Hi,
>>
>> I have a couple of QUAD maps on top of relational tables. When I query the
>> graph, which is defined by the QUAD map, without binding the property all
>> triples with data properties will have the object
>> "iri_id_0_with_no_name_entry" or in some cases "node://" followed by
>> numbers. Object properties work fine. Example:
>>
>> I run the query:
>> CONSTRUCT {?S ?P ?O}
>> FROM <http://extbi.lab.aau.dk/materialized_data/business>
>> WHERE {
>> ?S ?P ?O . FILTER(?S =
>> <http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this>)}
>>
>> through the isql(-vt) interface or the conductor SPARQL interface and get:
>>
>> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
>> http://extbi.lab.aau.dk/ontologies/business/name iri_id_0_with_no_name_entry
>> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
>> http://extbi.lab.aau.dk/ontologies/business/productionUnitIdentifier
>> iri_id_0_with_no_name_entry
>> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
>> http://extbi.lab.aau.dk/ontologies/business/telephoneNumberIdentifier
>> iri_id_0_with_no_name_entry
>> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
>> http://extbi.lab.aau.dk/ontologies/business/hasActivity
>> http://extbi.lab.aau.dk/data/business/activity/description/aldersintegrerede_institutioner#this
>> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
>> http://extbi.lab.aau.dk/ontologies/business/mainActivityValidFromDate
>> iri_id_0_with_no_name_entry
>> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
>> http://extbi.lab.aau.dk/ontologies/business/officialAddress
>> http://extbi.lab.aau.dk/data/business/address/Ølstedvej_24____3310__#this
>> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
>> http://extbi.lab.aau.dk/ontologies/business/startDate
>> iri_id_0_with_no_name_entry
>> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
>> http://extbi.lab.aau.dk/ontologies/business/nameValidFromDate
>> iri_id_0_with_no_name_entry
>> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
>> http://www.w3.org/1999/02/22-rdf-syntax-ns#type
>> http://extbi.lab.aau.dk/ontologies/business/ProductionUnit
>> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
>> http://extbi.lab.aau.dk/ontologies/business/belongsTo
>> http://extbi.lab.aau.dk/data/business/company/29188416#this
>> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
>> http://extbi.lab.aau.dk/ontologies/business/mainDivisionIndicator
>> iri_id_0_with_no_name_entry
>> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
>> http://extbi.lab.aau.dk/ontologies/business/employmentQuarterEmploymentIntervalCode
>> iri_id_0_with_no_name_entry
>> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
>> http://extbi.lab.aau.dk/ontologies/business/addressOfficialValidFromDate
>> iri_id_0_with_no_name_entry
>>
>> I experience the same when using a SELECT query. If i bind the predicate to
>> one of the data properties it works fine and I get the data I would expect,
>> example:
>>
>> CONSTRUCT {?S ?P ?O}
>> FROM <http://extbi.lab.aau.dk/materialized_data/business>
>> WHERE {
>> ?S ?P ?O . FILTER(?S =
>> <http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this> && ?P
>> =<http://extbi.lab.aau.dk/ontologies/business/name>)}
>>
>> results in:
>>
>> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
>> http://extbi.lab.aau.dk/ontologies/business/name Ølsted Børnehus - Afdeling
>> Ølstedvej
>>
>> Note that this is a predicate which failed before when the the predicate ?P
>> was variable. I have even made queries with several ORs between the "?P =
>> <...>" conditions, thereby getting all the data required. However, this
>> makes the my queries quite big and unwieldy, not to mention very inflexible.
>>
>> My first thought was that it might be permissions with the IRI classes or
>> the QUAD maps, since I have been running in to such problems before.
>> However, I am running the queries as DBA and would therefore expect to have
>> full permissions to everything.
>>
>> Any ideas? I am running on Ubuntu with version:
>> Version: 07.10.3207
>> Build: Apr 2 2014
>>
>> --
>> Med venlig hilsen / Best Regards
>> Alex Bondo Andersen
>> ------------------------------------------------------------------------------
>> Put Bad Developers to Shame
>> Dominate Development with Jenkins Continuous Integration
>> Continuously Automate Build, Test & Deployment
>> Start a new project now. Try Jenkins in the cloud.
>> http://p.sf.net/sfu/13600_Cloudbees_______________________________________________
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
>
>
> --
> Med venlig hilsen / Best Regards
> Alex Bondo Andersen
> <materialized.spql>------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/NeoTech_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
