[Virtuoso-users] load SQL data in Virtouso
hi The converting strategy DB to RDF via Virtuoso is mapping OWL class to every table, but in reality for example Person table may be divided to two table "Basic info and extended" for DB design considerations I want to make R2RML, I have a Person RDF class that is must be type of Person table, In my DB design I have Basic_Person and Extended_Person tables, not a single table that mapped to Person RDF class So must I make changes to DB design before convert it to RDF "merge Person tables into one and other changes"?? thanks -- ------- > Eng.Bassam Najeeb. >Software Engineer. -- ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] load SQL data in Virtouso
My problem is make map customization, so I want use my own types "owl" not a virtuoso automatic generated types for tables and columns e.g Person owl class can't be class for basic info and also to extended table too. is this right? On Sun, Nov 8, 2015 at 1:48 AM, Kingsley Idehen wrote: > On 11/6/15 11:40 PM, Eng.Bassam wrote: > > hi > The converting strategy DB to RDF via Virtuoso is mapping OWL class to > every table, but in reality for example Person table may be divided to two > table "Basic info and extended" for DB design considerations > > I want to make R2RML, I have a Person RDF class that is must be type of > Person table, In my DB design I have Basic_Person and Extended_Person > tables, not a single table that mapped to Person RDF class > > So must I make changes to DB design before convert it to RDF "merge Person > tables into one and other changes"?? > > thanks > > > All you do is make a VIEW that reflect your desired reality. Then use the > VIEW as the target of the RDF Linked Data Generation process provided by > the RDF Views wizard provided by Virtuoso :) > > Kingsley > > > -- > --- > > Eng.Bassam Najeeb. > >Software Engineer. > > > > -- > > > > ___ > Virtuoso-users mailing > listVirtuoso-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > > -- > Regards, > > Kingsley Idehen > Founder & CEO > OpenLink Software > Company Web: http://www.openlinksw.com > Personal Weblog 1: http://kidehen.blogspot.com > Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen > Twitter Profile: https://twitter.com/kidehen > Google+ Profile: https://plus.google.com/+KingsleyIdehen/about > LinkedIn Profile: http://www.linkedin.com/in/kidehen > Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this > > > > -- > > _______ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > -- --- > Eng.Bassam Najeeb. >Software Engineer. -- ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] load SQL data in Virtouso
additional info on previous mail : My problem is make map customization, so I want use my own types "owl" not a virtuoso automatic generated types for tables and columns e.g Person owl class can't be class for basic info and also to extended table too. the objective is make my DB published to any one, so I thinks current DB design and build RDF on it confuse the users for query e.g ?x a Pesron ?x foaf:name ?y here I want also get birth date in extended table, how I can do that the user may be write ?x foaf:birthdate ?z but this is wrong x not have direct relation to DOB, it's have relation to node that represent Person extended info and the relation to DOB is this right? On Sun, Nov 8, 2015 at 5:58 AM, Eng.Bassam wrote: > My problem is make map customization, so I want use my own types "owl" not > a virtuoso automatic generated types for tables and columns > e.g Person owl class can't be class for basic info and also to extended > table too. > > is this right? > > On Sun, Nov 8, 2015 at 1:48 AM, Kingsley Idehen > wrote: > >> On 11/6/15 11:40 PM, Eng.Bassam wrote: >> >> hi >> The converting strategy DB to RDF via Virtuoso is mapping OWL class to >> every table, but in reality for example Person table may be divided to two >> table "Basic info and extended" for DB design considerations >> >> I want to make R2RML, I have a Person RDF class that is must be type of >> Person table, In my DB design I have Basic_Person and Extended_Person >> tables, not a single table that mapped to Person RDF class >> >> So must I make changes to DB design before convert it to RDF "merge >> Person tables into one and other changes"?? >> >> thanks >> >> >> All you do is make a VIEW that reflect your desired reality. Then use the >> VIEW as the target of the RDF Linked Data Generation process provided by >> the RDF Views wizard provided by Virtuoso :) >> >> Kingsley >> >> >> -- >> --- >> > Eng.Bassam Najeeb. >> >Software Engineer. >> >> >> >> -- >> >> >> >> ___ >> Virtuoso-users mailing >> listVirtuoso-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/virtuoso-users >> >> >> >> -- >> Regards, >> >> Kingsley Idehen >> Founder & CEO >> OpenLink Software >> Company Web: http://www.openlinksw.com >> Personal Weblog 1: http://kidehen.blogspot.com >> Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen >> Twitter Profile: https://twitter.com/kidehen >> Google+ Profile: https://plus.google.com/+KingsleyIdehen/about >> LinkedIn Profile: http://www.linkedin.com/in/kidehen >> Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this >> >> >> >> -- >> >> ___ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >> >> > > > -- > --- > > Eng.Bassam Najeeb. > >Software Engineer. > > -- --- > Eng.Bassam Najeeb. >Software Engineer. -- ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] load SQL data in Virtouso
So Idehen, I think must make refactoring to my DB to be converted to RDF using my owl classes and R2RML code is this right?? On Sun, Nov 8, 2015 at 11:37 PM, Kingsley Idehen wrote: > On 11/7/15 10:58 PM, Eng.Bassam wrote: > > My problem is make map customization, so I want use my own types "owl" not > a virtuoso automatic generated types for tables and columns > e.g Person owl class can't be class for basic info and also to extended > table too. > > is this right? > > > If you want your own mappings that's fine, but you can't use the RDF Views > wizard for that, just make those mappings using R2RML. > > > Kingsley > > > On Sun, Nov 8, 2015 at 1:48 AM, Kingsley Idehen > wrote: > >> On 11/6/15 11:40 PM, Eng.Bassam wrote: >> >> hi >> The converting strategy DB to RDF via Virtuoso is mapping OWL class to >> every table, but in reality for example Person table may be divided to two >> table "Basic info and extended" for DB design considerations >> >> I want to make R2RML, I have a Person RDF class that is must be type of >> Person table, In my DB design I have Basic_Person and Extended_Person >> tables, not a single table that mapped to Person RDF class >> >> So must I make changes to DB design before convert it to RDF "merge >> Person tables into one and other changes"?? >> >> thanks >> >> >> All you do is make a VIEW that reflect your desired reality. Then use the >> VIEW as the target of the RDF Linked Data Generation process provided by >> the RDF Views wizard provided by Virtuoso :) >> >> Kingsley >> >> >> -- >> --- >> > Eng.Bassam Najeeb. >> >Software Engineer. >> >> >> >> -- >> >> >> >> ___ >> Virtuoso-users mailing >> listVirtuoso-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/virtuoso-users >> >> >> >> -- >> Regards, >> >> Kingsley Idehen >> Founder & CEO >> OpenLink Software >> Company Web: http://www.openlinksw.com >> Personal Weblog 1: http://kidehen.blogspot.com >> Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen >> Twitter Profile: https://twitter.com/kidehen >> Google+ Profile: https://plus.google.com/+KingsleyIdehen/about >> LinkedIn Profile: http://www.linkedin.com/in/kidehen >> Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this >> >> >> >> -- >> >> ___ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >> >> > > > -- > --- > > Eng.Bassam Najeeb. > >Software Engineer. > > > > -- > > > > ___ > Virtuoso-users mailing > listVirtuoso-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > > > -- > Regards, > > Kingsley Idehen > Founder & CEO > OpenLink Software > Company Web: http://www.openlinksw.com > Personal Weblog 1: http://kidehen.blogspot.com > Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen > Twitter Profile: https://twitter.com/kidehen > Google+ Profile: https://plus.google.com/+KingsleyIdehen/about > LinkedIn Profile: http://www.linkedin.com/in/kidehen > Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this > > -- --- > Eng.Bassam Najeeb. >Software Engineer. -- ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] load SQL data in Virtouso
thanks Idehen sorry about my pretty questions, but I'm beginner in Virtuoso :) I have understood the SQL views better solution than modify DB ERD, but what about Primary and Foreign keys to links nodes in RDF e.g emplyee and his department?? is this can be done in R2RML code manual?? Note: my project strategy is generate R2RML by virtuoso "auto generate" and then modify it to custom OWL classes, then I will upload R2RML in virtuoso to make custom mapping as described here http://docs.openlinksw.com/virtuoso/r2rml.html#r2rmlgentransperslviewrs thanks On Mon, Nov 9, 2015 at 3:38 PM, Kingsley Idehen wrote: > On 11/8/15 4:42 PM, Eng.Bassam wrote: > > So Idehen, I think must make refactoring to my DB to be converted to RDF > using my owl classes and R2RML code > is this right?? > > > You don't refactor your DBMS per se., what you do is make you own custom > mappings in your R2RML. Of course, if your database modelling doesn't fit > your mapping requirements you will then have to massage your modelling > using Views. > > Remember you are basically mapping relational tables to RDF statement > graphs i.e., different ways of representing entity relationships. > > Kingsley > > > On Sun, Nov 8, 2015 at 11:37 PM, Kingsley Idehen > wrote: > >> On 11/7/15 10:58 PM, Eng.Bassam wrote: >> >> My problem is make map customization, so I want use my own types "owl" >> not a virtuoso automatic generated types for tables and columns >> e.g Person owl class can't be class for basic info and also to extended >> table too. >> >> is this right? >> >> >> If you want your own mappings that's fine, but you can't use the RDF >> Views wizard for that, just make those mappings using R2RML. >> >> >> Kingsley >> >> >> On Sun, Nov 8, 2015 at 1:48 AM, Kingsley Idehen < >> kide...@openlinksw.com> wrote: >> >>> On 11/6/15 11:40 PM, Eng.Bassam wrote: >>> >>> hi >>> The converting strategy DB to RDF via Virtuoso is mapping OWL class to >>> every table, but in reality for example Person table may be divided to two >>> table "Basic info and extended" for DB design considerations >>> >>> I want to make R2RML, I have a Person RDF class that is must be type of >>> Person table, In my DB design I have Basic_Person and Extended_Person >>> tables, not a single table that mapped to Person RDF class >>> >>> So must I make changes to DB design before convert it to RDF "merge >>> Person tables into one and other changes"?? >>> >>> thanks >>> >>> >>> All you do is make a VIEW that reflect your desired reality. Then use >>> the VIEW as the target of the RDF Linked Data Generation process provided >>> by the RDF Views wizard provided by Virtuoso :) >>> >>> Kingsley >>> >>> >>> -- >>> --- >>> > Eng.Bassam Najeeb. >>> >Software Engineer. >>> >>> >>> >>> -- >>> >>> >>> >>> ___ >>> Virtuoso-users mailing >>> listVirtuoso-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/virtuoso-users >>> >>> >>> >>> -- >>> Regards, >>> >>> Kingsley Idehen >>> Founder & CEO >>> OpenLink Software >>> Company Web: http://www.openlinksw.com >>> Personal Weblog 1: http://kidehen.blogspot.com >>> Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen >>> Twitter Profile: https://twitter.com/kidehen >>> Google+ Profile: https://plus.google.com/+KingsleyIdehen/about >>> LinkedIn Profile: http://www.linkedin.com/in/kidehen >>> Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this >>> >>> >>> >>> -- >>> >>> ___ >>> Virtuoso-users mailing list >>> Virtuoso-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >>> >>> >> >> >> -- >> --- >> > Eng.Bassam Najeeb. >> >Software Engineer. >> >> >> >> -- >> >> >&
[Virtuoso-users] federated SPARQL queries?
Hi I'm Bassam a software engineer, I'm preparing master thesis in semantic web I have my medical data in virtuoso and want to link my data to external ontology for diseases, how can I do that : must upload the ontology in virtuoso server, if yes how do that? my objective is make federated SPARQL queries to traversal on my data also diseases ontology thanks. -- --- > Eng.Bassam Najeeb. >Software Engineer. -- Presto, an open source distributed SQL query engine for big data, initially developed by Facebook, enables you to easily query your data on Hadoop in a more interactive manner. Teradata is also now providing full enterprise support for Presto. Download a free open source copy now. http://pubads.g.doubleclick.net/gampad/clk?id=250295911&iu=/4140___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] Quad Store Upload?
Hi I want to load ontology to virtuoso server and query from it, I upload the "owl file" via conductor from linked data->Quad Store Upload, is this right way ?? thanks -- --- > Eng.Bassam Najeeb. >Software Engineer. -- ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] Load Big RDF Quad Store
Hi I have an RDF file "geonames" dataset, size of file about 600 MB I try to upload the file to my virtuoso server via Linked Data -> Upload Quad Store but the operation failed :(, low memory (I have win7 and 4 GB Ram) any solution to upload big RDF file??? thanks -- --- > Eng.Bassam Najeeb. >Software Engineer. -- Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK. Use one codebase in this all-in-one HTML5 development environment. Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs. http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] FA003: Access Denied
Hi I have an virtuoso on windows7 OS I try to load big file n3 (geonames ontology) via Interactive ISQL as: DB.DBA.TTLP_MT (file_to_string_output ('C:\Program Files\OpenLink Software\Virtuoso 7.2\vad\geonames.nt'), '', ' http://localhost:8890/ontologies/geonames'); but when I execute the following error occurred: SQLState: 42000 Message: FA003: Access to 'C:Program FilesOpenLink SoftwareVirtuoso 7.2adgeonames.nt' is denied due to access control in ini file but I have a permission to vad dir in ini file DirsAllowed = ., ../vad what is the problem?!!! thanks -- --- > Eng.Bassam Najeeb. >Software Engineer. -- Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK. Use one codebase in this all-in-one HTML5 development environment. Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs. http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] FA003: Access Denied
sorry, I found the problem :) the path must be written c:/ not c:\ other question please: I turned off the virtuoso service via service manager but when I try to modify virtuoso.ini I get the is used, why ? I want to add other vad allowed dir thanks On Tue, Dec 1, 2015 at 10:45 PM, Eng.Bassam wrote: > Hi > I have an virtuoso on windows7 OS > I try to load big file n3 (geonames ontology) via Interactive ISQL as: > > DB.DBA.TTLP_MT (file_to_string_output ('C:\Program Files\OpenLink > Software\Virtuoso 7.2\vad\geonames.nt'), '', ' > http://localhost:8890/ontologies/geonames'); > > but when I execute the following error occurred: > > SQLState: 42000 > > Message: FA003: Access to 'C:Program FilesOpenLink SoftwareVirtuoso 7.2 > adgeonames.nt' is denied due to access control in ini file > > > but I have a permission to vad dir in ini file > > DirsAllowed = ., ../vad > > what is the problem?!!! > > thanks > -- > ------- > > Eng.Bassam Najeeb. > >Software Engineer. > > -- --- > Eng.Bassam Najeeb. >Software Engineer. -- Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK. Use one codebase in this all-in-one HTML5 development environment. Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs. http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] Send SPARQL queries via C# ?
Hi I want to query my graphs in virtuoso via C# .Net, I note vi google there is a dotnet dll to do that, any body has experience to query virtuoso via C# -send sqprql to virtuoso and iterate query result data set- ??? thanks -- --- > Eng.Bassam Najeeb. >Software Engineer. -- ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Send SPARQL queries via C# ?
thanks Parick I see the dll file in open source lib folder, but I'm working on commercial virtuoso v 7.0 1- can I use it in commercial version? 2- any tutorial or reference how to use the virtuoso .net dll ? thanks again On Thu, Dec 10, 2015 at 1:08 AM, Patrick van Kleef wrote: > HI, > > > I want to query my graphs in virtuoso via C# .Net, I note vi google > there is a dotnet dll to do that, any body has experience to query virtuoso > via C# -send sqprql to virtuoso and iterate query result data set- ??? > > > Yes, the virtuoso open source version contains a > OpenLink.Data.Virtuoso.dll which works with Mono. > > You can execute any sparql query via the Virtuoso .NET Adapter by > prefixing the query with the SPARQL keyword as shown here: > > http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsparqlinline > > The resultset is returned as a set of rows which can be iterated over. > > > Patrick > > > > > > Patrick > --- > Patrick van Kleef > Program Manager > OpenLink Software > > http://www.openlinksw.com/ > http://twitter.com/openlink/ > > -- --- > Eng.Bassam Najeeb. >Software Engineer. -- ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] 08004 Number of of licensed connections exceeded
Hello I try to make local connection to virtuoso server via Windows ODBC manager -as described in attachments- but I got the error "08004 Number of of licensed connections exceeded" Also when I trying to connect ISQL via command line I get same error. isql 1113 dba dba; (default port in ini file is ServerPort = 1113) All screen exist in attachments. for more info I have a virtuoso 7 commercial and Windows 7 OS. thanks -- --- > Eng.Bassam Najeeb. >Software Engineer. -- ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] 08004 Number of of licensed connections exceeded
the problem has been resolved, I change the value of MaxClientConnections to "2" in ini file. thanks. On Sat, Dec 19, 2015 at 4:08 AM, Hugh Williams wrote: > Hi Bassam, > > The most common cause of this error on first connection via SQL > (ODBC/JDBC/ADO.Net etc) is that the "MaxClientConnections" (ServerThreads > in earlier versions) in the "[HTTP Server]" section of the INI file is set > to a value the same or greater than the number of DB connections allowed as > specified in the license being used. As the "MaxClientConnections" setting > results in that number of HTTP Server threads being allocated on server > startup of use in the HTTP Server thread pool, each of which consumes a > license point, resulting in all being consume if it is too high, leaving > none of SQL connections, hence the error you report. > > So you needed to ensure the "MaxClientConnections" in the "[HTTP Server]" > section is less than the number of DB connection specified in the license > ... > > 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 17 Dec 2015, at 19:19, Eng.Bassam wrote: > > > > Hello > > > > I try to make local connection to virtuoso server via Windows ODBC > manager -as described in attachments- but I got the error "08004 Number > of of licensed connections exceeded" > > > > Also when I trying to connect ISQL via command line I get same error. > > isql 1113 dba dba; (default port in ini file is ServerPort = 1113) > > > > All screen exist in attachments. > > for more info I have a virtuoso 7 commercial and Windows 7 OS. > > > > thanks > > > > > > -- > > --- > > > Eng.Bassam Najeeb. > > >Software Engineer. > > > > > -- > > ___ > > Virtuoso-users mailing list > > Virtuoso-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > -- --- > Eng.Bassam Najeeb. >Software Engineer. -- ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] confusing in rr:joinCondition generated by virtuoso ??
Hi I'm wonder about child parent in rr:joinCondition in R2RML generated by virtuoso, suppose I have tow tables patient and Diagnose Patient (ID, name, country) -- ID is PK Diagnose (DiagnosesID, DiseaseID, PatientID,) DiagnosesID is PK , PatientID is FK to patient table I have imported the tow tables by virtuoso wizard and it generate to me R2RML <#TriplesMapDiagnoses> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "emr" ; rr:tableOwner "emr-ODBC" ; rr:tableName "Diagnoses" ]; rr:subjectMap [ rr:termType rr:IRI ; rr:template " http://localhost:8890/emr/diagnoses/DiagnosesID={DiagnosesID}";; rr:class DB:Diagnoses; rr:graph <http://localhost:8890/DB#> ]; rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:diagnosesid ] ; rr:objectMap [ rr:column "DiagnosesID" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:diagnoses_has_disease ] ; rr:objectMap [ rr:termType rr:IRI ; rr:template "http://localhost:8890/emr/disease/DiseaseID={DiseaseID}"; ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:diagnoses_has_patient ] ; rr:objectMap [ rr:termType rr:IRI ; rr:template "http://localhost:8890/emr/patient/PatientID={PatientID}"; ]; ] . --patient <#TriplesMapPatient> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "emr" ; rr:tableOwner "emr-ODBC" ; rr:tableName "Patient" ]; rr:subjectMap [ rr:termType rr:IRI ; rr:template " http://localhost:8890/emr/patient/ID={ID}";; rr:class DB:Patient; rr:graph < http://localhost:8890/DB#> ]; rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:id ] ; rr:objectMap [ rr:column "ID" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:firstname ] ; rr:objectMap [ rr:column "FirstName" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:dead ] ; rr:objectMap [ rr:column "Dead" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:dead_date ] ; rr:objectMap [ rr:column "Dead_Date" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:patient_has_disease ] ; rr:objectMap [ rr:termType rr:IRI ; rr:template " http://localhost:8890/emr/disease/Cause_Dead={Cause_Dead}"; ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:patient_of_diagnoses ] ; rr:objectMap [ rr:parentTriplesMap <#TriplesMapDiagnoses>; rr:joinCondition [ r*r:child "ID" ; rr:parent "PatientID" *] ; ]; ] . the file R2RML attached also by this mail I want understand why the output R2RML in patient make the child is patient and parent is dianoses.? diagnoses table it is has FK so I thinks it is a child and Patient it 's a parent, opposite to output !!! --- > Eng.Bassam Najeeb. >Software Engineer. @prefix rr: <http://www.w3.org/ns/r2rml#> . @prefix DB: <http://localhost:8890/schemas/DB/> . @prefix db-stat: <http://localhost:8890/DB/stat#> . @prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> . @prefix void: <http://rdfs.org/ns/void#> . @prefix scovo: <http://purl.org/NET/scovo#> . @prefix aowl: <http://bblfish.net/work/atom-owl/2006-06-06/> . <#TriplesMapDiagnoses> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "emr" ; rr:tableOwner "emr-ODBC" ; rr:tableName "Diagnoses" ]; rr:subjectMap [ rr:termType rr:IRI ; rr:template "http://localhost:8890/emr/diagnoses/DiagnosesID={DiagnosesID}";; rr:class DB:Diagnoses; rr:graph <http://localhost:8890/DB#> ]; rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:diagnosesid ] ; rr:objectMap [ rr:column "DiagnosesID" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:encounterid ] ; rr:objectMap [ rr:column "EncounterID" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:orderid ] ; rr:objectMap [ rr:column "OrderID" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:date ] ; rr:objectMap [ rr:column "Date" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:diagnoses_has_disease ] ; rr:objectMap [ rr:termType rr:IRI ; rr:template "http://localhost:8890/emr/disease/DiseaseID={DiseaseID}"; ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:diagnoses_has_patient ] ; rr:objectMap [ rr:termType rr:IRI ; rr:template "http://localhost:8890/emr/patient/PatientID={PatientID}"; ]; ] . <#TriplesMapDisease> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "emr" ; rr:tableOwner "emr-ODBC" ; rr:tableName "Disease" ]; rr:subjectMap [ rr:termType rr:IRI ; rr:template "http://localhost:8890/emr/disease/ID={ID}";; rr:class DB:Disease; rr:graph <http://localhost:8890/DB#> ]; rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:id ] ; r
Re: [Virtuoso-users] confusing in rr:joinCondition generated by virtuoso ??
Mr. Kingsley another description about my confusing :) : the parent table here in my example is Patient which has ID primary Key the child table is the Diagnoses which has foreign key is Patient ID now the R2RML must make a join condition to link child table (Diagnoses) with it's parent (Patient) the condition is in sql ( Diagnoses,PatientID = Patient.ID) but in generated R2RML by virtuoso is make the child -->parent and make parent-->child rr:joinCondition [ r*r:child "ID" ; rr:parent "PatientID" *] ; ]; ] i.e I think the generated r2rml must be opposite: rr:child "PatientID" --- not ID rr:parent "ID" not PatientID because the PatientID is a column in child table(diagnoses) and ID is a column in Parent table (Patient). right??? this what I have understood from http://www.w3.org/TR/r2rml/#example-fk sorry again about long questions and thanks :) On Wed, Dec 23, 2015 at 10:33 PM, Kingsley Idehen wrote: > On 12/23/15 2:59 PM, Eng.Bassam wrote: > > yes Kingsley > to be my question more clear :) > > Patient (ID, name, country) -- ID is PK > Diagnose (DiagnosesID, DiseaseID, PatientID,) DiagnosesID is PK , > PatientID is FK to patient table > > the r2rml is > rr:predicateObjectMap [ rr:predicateMap [ rr:constant > DB:patient_of_diagnoses ] ; rr:objectMap [ rr:parentTriplesMap > <#TriplesMapDiagnoses>; rr:joinCondition [ r*r:child "ID" ; rr:parent > "PatientID" *] ; ]; ] > > I understand the patient is parent and the diagnose is child > but In r2rml I have noted the opposite make ID column in patient table is > child (r*r:child "ID"*) and make the PatientID Fk in diagnose is parent > (*rr:parent > "PatientID"*) > I don't know if I have misunderstood of this syntax > wish it's clear and thanks again :) > > The product of Patient..ID and Diagnose..ParentID will produce a > projection of the records that constitute the parent/child relation. That's > what's important i.e., rr:child "ID" and rr:parent "PatientID" clearly > identified for use in SQL join. > > If the projection from the query join is incorrect, then we have a > problem. > > Kingsley > > > On Wed, Dec 23, 2015 at 9:49 PM, Kingsley Idehen > wrote: > >> On 12/23/15 9:51 AM, Eng.Bassam wrote: >> >> Hi >> I'm wonder about child parent in rr:joinCondition in R2RML generated by >> virtuoso, suppose I have tow tables patient and Diagnose >> >> Patient (ID, name, country) -- ID is PK >> Diagnose (DiagnosesID, DiseaseID, PatientID,) DiagnosesID is PK , >> PatientID is FK to patient table >> >> I have imported the tow tables by virtuoso wizard and it generate to me >> R2RML >> >> <#TriplesMapDiagnoses> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema >> "emr" ; rr:tableOwner "emr-ODBC" ; rr:tableName "Diagnoses" ]; >> rr:subjectMap [ rr:termType rr:IRI ; rr:template " >> http://localhost:8890/emr/diagnoses/DiagnosesID={DiagnosesID}";; rr:class >> DB:Diagnoses; rr:graph < <http://localhost:8890/DB#> >> http://localhost:8890/DB#> ]; >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:diagnosesid ] ; >> rr:objectMap [ rr:column "DiagnosesID" ]; ] ; >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant >> DB:diagnoses_has_disease ] ; rr:objectMap [ rr:termType rr:IRI ; >> rr:template " >> <http://localhost:8890/emr/disease/DiseaseID=%7BDiseaseID%7D> >> http://localhost:8890/emr/disease/DiseaseID={DiseaseID}"; ]; ] ; >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant >> DB:diagnoses_has_patient ] ; rr:objectMap [ rr:termType rr:IRI ; >> rr:template " >> <http://localhost:8890/emr/patient/PatientID=%7BPatientID%7D> >> http://localhost:8890/emr/patient/PatientID={PatientID}"; ]; ] . >> >> --patient >> <#TriplesMapPatient> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema >> "emr" ; rr:tableOwner "emr-ODBC" ; rr:tableName "Patient" ]; >> rr:subjectMap [ rr:termType rr:IRI ; rr:template " >> http://localhost:8890/emr/patient/ID={ID}";; rr:class DB:Patient; >> rr:graph < <http://localhost:8890/DB#>http://localhost:8890/DB#> ]; >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:id ] ; >> rr:objectMap [ rr:column "ID" ]; ] ; >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:firstname ] ; >> rr:objectMap [ rr:column "FirstName" ]; ] ; >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:dead ] ; >> rr:objectM
Re: [Virtuoso-users] confusing in rr:joinCondition generated by virtuoso ??
thanks again waiting a fix a problem if you want more simple example (dept & emp) it's in attachment file also, as you will see the file has R2RML not same as W3 example at http://www.w3.org/TR/r2rml/ if apply the emp & dept example on virtuoso and to get RDF graph, we will see the emp triple has reference to department (it's right) but also the dept has triples for it's emloyees (wrong sure there is no key in DB from Dept to employee) I wish it's clear description and thanks a lot to answer me :) On Thu, Dec 24, 2015 at 5:36 PM, Kingsley Idehen wrote: > On 12/23/15 11:49 PM, Eng.Bassam wrote: > > Mr. Kingsley > another description about my confusing :) : > > the parent table here in my example is Patient which has ID primary Key > the child table is the Diagnoses which has foreign key is Patient ID > > now the R2RML must make a join condition to link child table (Diagnoses) > with it's parent (Patient) > the condition is in sql ( Diagnoses,PatientID = Patient.ID) > > but in generated R2RML by virtuoso is make the child -->parent and make > parent-->child > > > We have a issue that we need fix here as the generated R2RML shouldn't be > confusing, which is the case right now. > > The issue is being looked into. > > Kingsley > > rr:joinCondition [ r*r:child "ID" ; rr:parent "PatientID" *] ; ]; ] > i.e I think the generated r2rml must be opposite: > rr:child "PatientID" --- not ID > rr:parent "ID" not PatientID > because the PatientID is a column in child table(diagnoses) and ID is a > column in Parent table (Patient). > right??? > this what I have understood from http://www.w3.org/TR/r2rml/#example-fk > > sorry again about long questions and thanks :) > > > > > On Wed, Dec 23, 2015 at 10:33 PM, Kingsley Idehen < > kide...@openlinksw.com> wrote: > >> On 12/23/15 2:59 PM, Eng.Bassam wrote: >> >> yes Kingsley >> to be my question more clear :) >> >> Patient (ID, name, country) -- ID is PK >> Diagnose (DiagnosesID, DiseaseID, PatientID,) DiagnosesID is PK , >> PatientID is FK to patient table >> >> the r2rml is >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant >> DB:patient_of_diagnoses ] ; rr:objectMap [ rr:parentTriplesMap >> <#TriplesMapDiagnoses>; rr:joinCondition [ r*r:child "ID" ; rr:parent >> "PatientID" *] ; ]; ] >> >> I understand the patient is parent and the diagnose is child >> but In r2rml I have noted the opposite make ID column in patient table is >> child (r*r:child "ID"*) and make the PatientID Fk in diagnose is parent >> (*rr:parent >> "PatientID"*) >> I don't know if I have misunderstood of this syntax >> wish it's clear and thanks again :) >> >> The product of Patient..ID and Diagnose..ParentID will produce a >> projection of the records that constitute the parent/child relation. That's >> what's important i.e., rr:child "ID" and rr:parent "PatientID" clearly >> identified for use in SQL join. >> >> If the projection from the query join is incorrect, then we have a >> problem. >> >> Kingsley >> >> >> On Wed, Dec 23, 2015 at 9:49 PM, Kingsley Idehen < >> kide...@openlinksw.com> wrote: >> >>> On 12/23/15 9:51 AM, Eng.Bassam wrote: >>> >>> Hi >>> I'm wonder about child parent in rr:joinCondition in R2RML generated by >>> virtuoso, suppose I have tow tables patient and Diagnose >>> >>> Patient (ID, name, country) -- ID is PK >>> Diagnose (DiagnosesID, DiseaseID, PatientID,) DiagnosesID is PK , >>> PatientID is FK to patient table >>> >>> I have imported the tow tables by virtuoso wizard and it generate to me >>> R2RML >>> >>> <#TriplesMapDiagnoses> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema >>> "emr" ; rr:tableOwner "emr-ODBC" ; rr:tableName "Diagnoses" ]; >>> rr:subjectMap [ rr:termType rr:IRI ; rr:template " >>> <http://localhost:8890/emr/diagnoses/DiagnosesID=> >>> http://localhost:8890/emr/diagnoses/DiagnosesID={DiagnosesID}";; >>> rr:class DB:Diagnoses; rr:graph < <http://localhost:8890/DB#> >>> http://localhost:8890/DB#> ]; >>> rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:diagnosesid ] ; >>> rr:objectMap [ rr:column "DiagnosesID" ]; ] ; >>> rr:predicateObjectMap [ rr:predicateMap [ rr:constant >>> DB:diagnoses_has_disease ] ;
Re: [Virtuoso-users] confusing in rr:joinCondition generated by virtuoso ??
sorry to send again, forget the attachment :D thanks again waiting a fix a problem if you want more simple example (dept & emp) it's in attachment file also, as you will see the file has R2RML not same as W3 example at http://www.w3.org/TR/r2rml/ if apply the emp & dept example on virtuoso and to get RDF graph, we will see the emp triple has reference to department (it's right) but also the dept has triples for it's emloyees (wrong sure there is no key in DB from Dept to employee) I wish it's clear description and thanks a lot to answer me :) On Thu, Dec 24, 2015 at 5:36 PM, Kingsley Idehen wrote: > On 12/23/15 11:49 PM, Eng.Bassam wrote: > > Mr. Kingsley > another description about my confusing :) : > > the parent table here in my example is Patient which has ID primary Key > the child table is the Diagnoses which has foreign key is Patient ID > > now the R2RML must make a join condition to link child table (Diagnoses) > with it's parent (Patient) > the condition is in sql ( Diagnoses,PatientID = Patient.ID) > > but in generated R2RML by virtuoso is make the child -->parent and make > parent-->child > > > We have a issue that we need fix here as the generated R2RML shouldn't be > confusing, which is the case right now. > > The issue is being looked into. > > Kingsley > > rr:joinCondition [ r*r:child "ID" ; rr:parent "PatientID" *] ; ]; ] > i.e I think the generated r2rml must be opposite: > rr:child "PatientID" --- not ID > rr:parent "ID" not PatientID > because the PatientID is a column in child table(diagnoses) and ID is a > column in Parent table (Patient). > right??? > this what I have understood from http://www.w3.org/TR/r2rml/#example-fk > > sorry again about long questions and thanks :) > > > > > On Wed, Dec 23, 2015 at 10:33 PM, Kingsley Idehen < > kide...@openlinksw.com> wrote: > >> On 12/23/15 2:59 PM, Eng.Bassam wrote: >> >> yes Kingsley >> to be my question more clear :) >> >> Patient (ID, name, country) -- ID is PK >> Diagnose (DiagnosesID, DiseaseID, PatientID,) DiagnosesID is PK , >> PatientID is FK to patient table >> >> the r2rml is >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant >> DB:patient_of_diagnoses ] ; rr:objectMap [ rr:parentTriplesMap >> <#TriplesMapDiagnoses>; rr:joinCondition [ r*r:child "ID" ; rr:parent >> "PatientID" *] ; ]; ] >> >> I understand the patient is parent and the diagnose is child >> but In r2rml I have noted the opposite make ID column in patient table is >> child (r*r:child "ID"*) and make the PatientID Fk in diagnose is parent >> (*rr:parent >> "PatientID"*) >> I don't know if I have misunderstood of this syntax >> wish it's clear and thanks again :) >> >> The product of Patient..ID and Diagnose..ParentID will produce a >> projection of the records that constitute the parent/child relation. That's >> what's important i.e., rr:child "ID" and rr:parent "PatientID" clearly >> identified for use in SQL join. >> >> If the projection from the query join is incorrect, then we have a >> problem. >> >> Kingsley >> >> >> On Wed, Dec 23, 2015 at 9:49 PM, Kingsley Idehen < >> kide...@openlinksw.com> wrote: >> >>> On 12/23/15 9:51 AM, Eng.Bassam wrote: >>> >>> Hi >>> I'm wonder about child parent in rr:joinCondition in R2RML generated by >>> virtuoso, suppose I have tow tables patient and Diagnose >>> >>> Patient (ID, name, country) -- ID is PK >>> Diagnose (DiagnosesID, DiseaseID, PatientID,) DiagnosesID is PK , >>> PatientID is FK to patient table >>> >>> I have imported the tow tables by virtuoso wizard and it generate to me >>> R2RML >>> >>> <#TriplesMapDiagnoses> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema >>> "emr" ; rr:tableOwner "emr-ODBC" ; rr:tableName "Diagnoses" ]; >>> rr:subjectMap [ rr:termType rr:IRI ; rr:template " >>> <http://localhost:8890/emr/diagnoses/DiagnosesID=> >>> http://localhost:8890/emr/diagnoses/DiagnosesID={DiagnosesID}";; >>> rr:class DB:Diagnoses; rr:graph < <http://localhost:8890/DB#> >>> http://localhost:8890/DB#> ]; >>> rr:predicateObjectMap [ rr:predicateMap [ rr:constant DB:diagnosesid ] ; >>> rr:objectMap [ rr:column "DiagnosesID" ]; ] ; >>> rr:predicateObjectMap [ rr:predicateM
Re: [Virtuoso-users] [virtuoso-opensource] Accessing Virtuoso from C#? (#512)
Hi for developers who want to access virtuoso via C#, I do the following: 1- add connection string at app settings 2- using virtado4.dll ADO's classes after reference it string conString = System.Configuration.ConfigurationManager.ConnectionStrings["MYCONN"].ConnectionString; VirtuosoConnection virtuosoSrv = new VirtuosoConnection(conString ); virtuosoSrv .Open(); VirtuosoCommand cmd = new VirtuosoCommand("sparql SELECT ?termURI FROM <http://localhost:8890/ontologies/geonames> WHERE { ?termURI ?z ?y.} LIMIT 10", virtuosoSrv ); VirtuosoDataReader countryDataReader = cmd.ExecuteReader(); while (countryDataReader.Read()) { String col = countryDataReader.GetString(0); // make something } wish it's usefull :) On Sun, Dec 20, 2015 at 7:30 AM, Eng.Bassam wrote: > thanks Hugh > I have downloaded connectivity kit as described at: > http://docs.openlinksw.com/virtuoso/virtclientref.html > and all done successfully and it exist in installed programs list. > I have visual studio 2013, when I try to add data source via provider > (openlink virtuoso data source), this provider not exist what is the > problem > > thanks again > > On Sat, Dec 19, 2015 at 4:18 AM, HughWilliams > wrote: > >> Do u actually search our documentation or google before asking questions, >> as there is a complete chapter on the Virtuoso ADO.Net Provider and sample >> programs, see: >> >> http://docs.openlinksw.com/virtuoso/virtclientref.html >> >> Not the "OpenLink.Data.Virtuoso.dll" is basically a .Net 2 version >> provider for command line use build against Mono. >> >> If you have the commercial installer there are .Net 2 , 3 & 4 Providers >> called: >> >> virtado2.dll >> virtado3.dll >> virtado4.dll >> >> and you can select which one most closely matches your .Net version and >> it will automatically get registered as a .Net Assembly making instantly >> accessible in the .Net runtime (or it can also be reference manually as >> some seem to prefer these days) ... >> >> — >> Reply to this email directly or view it on GitHub >> <https://github.com/openlink/virtuoso-opensource/issues/512#issuecomment-165936272> >> . >> > > > > -- > --- > > Eng.Bassam Najeeb. > >Software Engineer. > > -- --- > Eng.Bassam Najeeb. >Software Engineer. -- ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] Make my views refer to external ontology?
Hello I have a person pesron table with columns (id, name , country_geo), person table type in R2RML is foaf:person, I have also loaded geonames onology in my virtuoso server at link http://localhost:8890/ontologies/geonames now for the country_geo column the r2rml is : rr:predicateObjectMap [ rr:predicateMap [ rr:constant SIO:SIO_000664 ] ; rr:objectMap [ rr:column "Country_geo" ]; ] ; the value of country_geo is IRI e.g "http://sws.geonames.org/2378080/"; described in my loaded ontology geonames. now how can I make the generated country_geo property in person refer to my loaded ontology geonames, what should I write in r2rml ??? my objective is making sparql queries on the generated views (persons) and traverse to geonames for more info about countries. wish it's clear question :) thanks -- --- > Eng.Bassam Najeeb. >Software Engineer. -- ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Make my views refer to external ontology?
suppose the geoname resource is: http://sws.geonames.org/2378080/";> http://sws.geonames.org/2378080/about.rdf"/> Mauritania I want to get name of country_geo select ?o ?cname where {?s SIO:SIO_000664 ?o; ?s a foaf:Person. ?o gn:name ?cname } limit 10 how I can traverse to geonames ontology to get a name property ??? On Tue, Dec 29, 2015 at 6:36 PM, Kingsley Idehen wrote: > On 12/29/15 8:31 AM, Eng.Bassam wrote: > > Hello > I have a person pesron table with columns (id, name , country_geo), person > table type in R2RML is foaf:person, I have also loaded geonames onology in > my virtuoso server at link http://localhost:8890/ontologies/geonames > > now for the country_geo column the r2rml is : > rr:predicateObjectMap [ rr:predicateMap [ rr:constant SIO:SIO_000664 ] ; > rr:objectMap [ rr:column "Country_geo" ]; ] ; > > the value of country_geo is IRI e.g " <http://sws.geonames.org/2378080/> > http://sws.geonames.org/2378080/"; described in my loaded ontology > geonames. > now how can I make the generated country_geo property in person refer to > my loaded ontology geonames, what should I write in r2rml ??? > my objective is making sparql queries on the generated views (persons) and > traverse to geonames for more info about countries. > > wish it's clear question :) > thanks > > -- > --- > > Eng.Bassam Najeeb. > >Software Engineer. > > > Okay, so have you generated you views and hit a problem? You are already > mapping Geoname IRIs to country_geo, so your end product would be instances > of a class that have IRI property values from the geonames ontology. Net > effect, from your SPARQL DESCRIBE, SELECT, or CONSTRUCTs on the foaf:Person > instances you will be able to follow-your-nose through SIO:SIO_000664 > property values. > > select ?o > where {?s SIO:SIO_000664 ?o; > ?s a foaf:Person. } > limit 10 > > > Kingsley > > > > > -- > > > > ___ > Virtuoso-users mailing > listVirtuoso-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > > -- > Regards, > > Kingsley Idehen > Founder & CEO > OpenLink Software > Company Web: http://www.openlinksw.com > Personal Weblog 1: http://kidehen.blogspot.com > Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen > Twitter Profile: https://twitter.com/kidehen > Google+ Profile: https://plus.google.com/+KingsleyIdehen/about > LinkedIn Profile: http://www.linkedin.com/in/kidehen > Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this > > > > ------ > > ___ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > -- --- > Eng.Bassam Najeeb. >Software Engineer. -- ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Make my views refer to external ontology?
thanks I thinks only must write FROM statement to include local ontologies in my sparql or to inform sparql engine where can locate the data, i.e: select ?o ?cname FROM <http://localhost:8890/ontologies/mydata> //my persons data FROM <http://localhost:8890/ontologies/geonames> // geo country data where {?s SIO:SIO_000664 ?o; ?s a foaf:Person. OPTIONAL { ?o gn:name ?cname. } } limit 10 right? On Tue, Dec 29, 2015 at 9:02 PM, Kingsley Idehen wrote: > On 12/29/15 12:46 PM, Eng.Bassam wrote: > > suppose the geoname resource is: > http://sws.geonames.org/2378080/";> > http://sws.geonames.org/2378080/about.rdf > "/> > Mauritania > > > I want to get name of country_geo > select ?o ?cname > where {?s SIO:SIO_000664 ?o; > ?s a foaf:Person. > ?o gn:name ?cname } > limit 10 > > how I can traverse to geonames ontology to get a name property ??? > > > That has nothing to do with R2RML. That's all about de-referencing data > from geonames "on the fly" as part of query processing -- if you don't have > this data loaded locally. If loaded locally, then query above will return > the correct solution for ?cname. > > To be extra safe (i.e. query for a solution that includes relations that > have empty gname objects) try: > > select ?o ?cname > where {?s SIO:SIO_000664 ?o; > ?s a foaf:Person. > OPTIONAL { ?o gn:name ?cname. } > } > limit 10 > > Kingsley > > > > On Tue, Dec 29, 2015 at 6:36 PM, Kingsley Idehen > wrote: > >> On 12/29/15 8:31 AM, Eng.Bassam wrote: >> >> Hello >> I have a person pesron table with columns (id, name , country_geo), >> person table type in R2RML is foaf:person, I have also loaded geonames >> onology in my virtuoso server at link >> <http://localhost:8890/ontologies/geonames> >> http://localhost:8890/ontologies/geonames >> >> now for the country_geo column the r2rml is : >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant SIO:SIO_000664 ] ; >> rr:objectMap [ rr:column "Country_geo" ]; ] ; >> >> the value of country_geo is IRI e.g " <http://sws.geonames.org/2378080/> >> http://sws.geonames.org/2378080/"; described in my loaded ontology >> geonames. >> now how can I make the generated country_geo property in person refer to >> my loaded ontology geonames, what should I write in r2rml ??? >> my objective is making sparql queries on the generated views (persons) >> and traverse to geonames for more info about countries. >> >> wish it's clear question :) >> thanks >> >> -- >> --- >> > Eng.Bassam Najeeb. >> >Software Engineer. >> >> >> Okay, so have you generated you views and hit a problem? You are already >> mapping Geoname IRIs to country_geo, so your end product would be instances >> of a class that have IRI property values from the geonames ontology. Net >> effect, from your SPARQL DESCRIBE, SELECT, or CONSTRUCTs on the foaf:Person >> instances you will be able to follow-your-nose through SIO:SIO_000664 >> property values. >> >> select ?o >> where {?s SIO:SIO_000664 ?o; >> ?s a foaf:Person. } >> limit 10 >> >> >> Kingsley >> >> >> >> >> -- >> >> >> >> ___ >> Virtuoso-users mailing >> listVirtuoso-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/virtuoso-users >> >> >> >> -- >> Regards, >> >> Kingsley Idehen >> Founder & CEO >> OpenLink Software >> Company Web: http://www.openlinksw.com >> Personal Weblog 1: http://kidehen.blogspot.com >> Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen >> Twitter Profile: https://twitter.com/kidehen >> Google+ Profile: https://plus.google.com/+KingsleyIdehen/about >> LinkedIn Profile: http://www.linkedin.com/in/kidehen >> Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this >> >> >> >> -- >> >> ___ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >> >> > > > -- > --- > > Eng.Bassa
Re: [Virtuoso-users] Make my views refer to external ontology?
Hi Kingsely and all members still there is the same problem can't traverse from ontology to other cause the generated IRI is text not IRI type, next is the description and sorry to be long but it's a problem need to solve ASAP to complete my project As I have said I have imported SQL DB using custom R2RML: <#TriplesMapPerson> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "dataMaster" ; rr:tableOwner "data-ODBC" ; rr:tableName "Person" ]; rr:subjectMap [ rr:termType rr:IRI ; rr:template " http://localhost:8890/dataMaster/person/PersonID={ID}";; rr:class sio:SIO_000393; rr:graph <http://localhost:8890/dataMaster#> ]; rr:predicateObjectMap [ rr:predicateMap [ rr:constant sio:SIO_000664 ] ; rr:objectMap [ rr:column "Country" ]; ] ; the column Country contain the IRIs of country geo ontology i.e as http://sws.geonames.org/226074/, this ontology I have loaded in my Virtuoso server at http://localhost:8890/ontologies/geonames this local ontology have rdf resources as : http://sws.geonames.org/226074/ <http://sws.geonames.org/2378080/>"> http://sws.geonames.org/226074/about.rdf <http://sws.geonames.org/2378080/about.rdf>"/> USA now my query is : PREFIX sio: <http://semanticscience.org/resource/> prefix gn: <http://www.geonames.org/ontology#> select ?country FROM <http://localhost:8890/dataMaster#> FROM <http://localhost:8890/ontologies/geonames> WHERE { ?s a sio:SIO_000393. ?s sio:SIO_000664 ?country. } the result unfortunately is the IRIs but in quotation as a text not an IRI type i.e "http://sws.geonames.org/226074/";, so I can't add to where clause in my query ?country gn:name ?cname also can't do ?country a gn:Feature PREFIX sio: <http://semanticscience.org/resource/> prefix gn: <http://www.geonames.org/ontology#> select ?country FROM <http://localhost:8890/dataMaster#> FROM <http://localhost:8890/ontologies/geonames> WHERE { ?s a sio:SIO_000393. ?s sio:SIO_000664 ?country. ?country gn:name ?cname// *this triple make a traverse to other local ontology (geonames)* } I think the problem is : generated country property is text not IRI type. I have try to modify the my R2RML using IRI template as rr:predicateObjectMap [ rr:predicateMap [ rr:constant sio:SIO_000664 ] ; rr:objectMap [ rr:termType rr:IRI ; rr:constant gn:Feature; rr:template "{Country_geo}" ]; ] ; but also fail the generated IRI "need an encoding"as http%3A%2F%2Fsws.geonames.org%2F226074%2F <http://localhost:8890/conductor/http%3A%2F%2Fsws.geonames.org%2F226074%2F> wish to give me a solution :) thanks On Tue, Dec 29, 2015 at 9:46 PM, Kingsley Idehen wrote: > On 12/29/15 2:08 PM, Eng.Bassam wrote: > > thanks > I thinks only must write FROM statement to include local ontologies in my > sparql or to inform sparql engine where can locate the data, i.e: > > select ?o ?cname > FROM < <http://localhost:8890/ontologies/mydata> > http://localhost:8890/ontologies/mydata> //my persons data > FROM <http://localhost:8890/ontologies/geonames> // geo country data > where {?s SIO:SIO_000664 ?o; > ?s a foaf:Person. > OPTIONAL { ?o gn:name ?cname. } > } > limit 10 > > right? > > > You can also just do: > > select ?o ?cname > where { GRAPH ?g { ?s SIO:SIO_000664 ?o; > ?s a foaf:Person. > OPTIONAL { ?o gn:name ?cname. } } > } > limit 10 > > Kingsley > > > On Tue, Dec 29, 2015 at 9:02 PM, Kingsley Idehen > wrote: > >> On 12/29/15 12:46 PM, Eng.Bassam wrote: >> >> suppose the geoname resource is: >> http://sws.geonames.org/2378080/";> >> http://sws.geonames.org/2378080/about.rdf >> "/> >> Mauritania >> >> >> I want to get name of country_geo >> select ?o ?cname >> where {?s SIO:SIO_000664 ?o; >> ?s a foaf:Person. >> ?o gn:name ?cname } >> limit 10 >> >> how I can traverse to geonames ontology to get a name property ??? >> >> >> That has nothing to do with R2RML. That's all about de-referencing data >> from geonames "on the fly" as part of query processing -- if you don't have >> this data loaded locally. If loaded locally, then query above will return >> the correct solution for ?cname. >> >> To be extra safe (i.e. query for a solution that includes relations that >> have empty gname objects) try: >> >> select ?o ?cname >> where {?s SIO:SIO_000664 ?o; >> ?s a foaf:Person. >> OPTIONAL { ?o gn:name ?cname
Re: [Virtuoso-users] confusing in rr:joinCondition generated by virtuoso ??
Kingsley, 1- : the second link need a login, can I get the file without account I try login via facebook but it fail. 2- Do you mean there is really a problem in auto generated virtuoso r2rml or not ??? thanks On Thu, Dec 24, 2015 at 8:53 PM, Kingsley Idehen wrote: > On 12/24/15 1:03 PM, Eng.Bassam wrote: > > sorry to send again, forget the attachment :D > > thanks again > waiting a fix a problem > if you want more simple example (dept & emp) it's in attachment file also, > as you will see the file has R2RML not same as W3 example > at http://www.w3.org/TR/r2rml/ > > if apply the emp & dept example on virtuoso and to get RDF graph, we will > see the emp triple has reference to department (it's right) but also the > dept has triples for it's emloyees (wrong sure there is no key in DB from > Dept to employee) > > I wish it's clear description and thanks a lot to answer me :) > > > While we look into this confusing generated syntax matter, here are some > R2RML docs used in my live RDF Views over ODBC Data Source demos [1]: > > [1] > http://kidehen.blogspot.com/2015/07/conceptual-data-virtualization-across.html > [2] > http://kingsley.idehen.net/public_home/kidehen/Public/R2RML%20Demos/oracle_hr_rdf_views_r2rml.ttl > -- Oracle Demo HR . > > > Kingsley > > > > On Thu, Dec 24, 2015 at 5:36 PM, Kingsley Idehen > wrote: > >> On 12/23/15 11:49 PM, Eng.Bassam wrote: >> >> Mr. Kingsley >> another description about my confusing :) : >> >> the parent table here in my example is Patient which has ID primary Key >> the child table is the Diagnoses which has foreign key is Patient ID >> >> now the R2RML must make a join condition to link child table (Diagnoses) >> with it's parent (Patient) >> the condition is in sql ( Diagnoses,PatientID = Patient.ID) >> >> but in generated R2RML by virtuoso is make the child -->parent and make >> parent-->child >> >> >> We have a issue that we need fix here as the generated R2RML shouldn't be >> confusing, which is the case right now. >> >> The issue is being looked into. >> >> Kingsley >> >> rr:joinCondition [ r*r:child "ID" ; rr:parent "PatientID" *] ; ]; ] >> i.e I think the generated r2rml must be opposite: >> rr:child "PatientID" --- not ID >> rr:parent "ID" not PatientID >> because the PatientID is a column in child table(diagnoses) and ID is a >> column in Parent table (Patient). >> right??? >> this what I have understood from >> <http://www.w3.org/TR/r2rml/#example-fk> >> http://www.w3.org/TR/r2rml/#example-fk >> >> sorry again about long questions and thanks :) >> >> >> >> >> On Wed, Dec 23, 2015 at 10:33 PM, Kingsley Idehen < >> kide...@openlinksw.com> wrote: >> >>> On 12/23/15 2:59 PM, Eng.Bassam wrote: >>> >>> yes Kingsley >>> to be my question more clear :) >>> >>> Patient (ID, name, country) -- ID is PK >>> Diagnose (DiagnosesID, DiseaseID, PatientID,) DiagnosesID is PK , >>> PatientID is FK to patient table >>> >>> the r2rml is >>> rr:predicateObjectMap [ rr:predicateMap [ rr:constant >>> DB:patient_of_diagnoses ] ; rr:objectMap [ rr:parentTriplesMap >>> <#TriplesMapDiagnoses>; rr:joinCondition [ r*r:child "ID" ; rr:parent >>> "PatientID" *] ; ]; ] >>> >>> I understand the patient is parent and the diagnose is child >>> but In r2rml I have noted the opposite make ID column in patient table >>> is child (r*r:child "ID"*) and make the PatientID Fk in diagnose is >>> parent (*rr:parent "PatientID"*) >>> I don't know if I have misunderstood of this syntax >>> wish it's clear and thanks again :) >>> >>> The product of Patient..ID and Diagnose..ParentID will produce a >>> projection of the records that constitute the parent/child relation. That's >>> what's important i.e., rr:child "ID" and rr:parent "PatientID" clearly >>> identified for use in SQL join. >>> >>> If the projection from the query join is incorrect, then we have a >>> problem. >>> >>> Kingsley >>> >>> >>> On Wed, Dec 23, 2015 at 9:49 PM, Kingsley Idehen < >>> kide...@openlinksw.com> wrote: >>> >>>> On 12/23/15 9:51 AM, Eng.Bassam wrote: >>>> >>>> Hi >>>> I'm wonder about child parent in
Re: [Virtuoso-users] Make my views refer to external ontology?
Hi I have tried this solution many times but unfortunately it's fail the generated IRI by virtuoso as "http%3A%2F%2Fsws.geonames.org%2F226074%2F <http://localhost:8890/conductor/http%3A%2F%2Fsws.geonames.org%2F226074%2F> " now to solve this problem temporary, I' using rr:column not template for IRI for this situation, I'm using IRI function then to convert the "http://sws.geonames.org/226074"; text to IRI in filter clause like this select ?countryName where { GRAPH <http://localhost:8890/emrMaster#> { ?patient sio:SIO_000664 ?country. } GRAPH <http://localhost:8890/ontologies/geonames> { ?geo gn:name ?countryName. } FILTER(IRI(?country) = ?geo) . } GROUP BY ?countryName is it a bug ??? or something wrong ??? thanks again On Wed, Dec 30, 2015 at 7:57 PM, Kingsley Idehen wrote: > On 12/30/15 8:21 AM, Eng.Bassam wrote: > > Hi Kingsely and all members > > still there is the same problem can't traverse from ontology to other > cause the generated IRI is text not IRI type, next is the description and > sorry to be long but it's a problem need to solve ASAP to complete my > project > As I have said I have imported SQL DB using custom R2RML: > <#TriplesMapPerson> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema > "dataMaster" ; rr:tableOwner "data-ODBC" ; rr:tableName "Person" ]; > rr:subjectMap [ rr:termType rr:IRI ; rr:template " > <http://localhost:8890/dataMaster/person/PersonID=%7BID%7D> > http://localhost:8890/dataMaster/person/PersonID={ID}";; rr:class > sio:SIO_000393; rr:graph < <http://localhost:8890/dataMaster#> > http://localhost:8890/dataMaster#> ]; > > rr:predicateObjectMap [ rr:predicateMap [ rr:constant sio:SIO_000664 ] ; > rr:objectMap [ rr:column "Country" ]; ] ; > > the column Country contain the IRIs of country geo ontology i.e as > http://sws.geonames.org/226074/, this ontology I have loaded in my > Virtuoso server at > http://localhost:8890/ontologies/geonames > > this local ontology have rdf resources as : > http://sws.geonames.org/2378080/> > http://sws.geonames.org/226074/";> > http://sws.geonames.org/226074/about.rdf > <http://sws.geonames.org/2378080/about.rdf>"/> > USA > > > now my query is : > > PREFIX sio: <http://semanticscience.org/resource/> > prefix gn: <http://www.geonames.org/ontology#> > select ?country > FROM <http://localhost:8890/dataMaster#> > FROM <http://localhost:8890/ontologies/geonames> > WHERE { ?s a sio:SIO_000393. > ?s sio:SIO_000664 ?country. > } > > the result unfortunately is the IRIs but in quotation as a text not an IRI > type i.e "http://sws.geonames.org/226074/";, so I can't add to where > clause in my query ?country gn:name ?cname also can't do ?country a > gn:Feature > > PREFIX sio: <http://semanticscience.org/resource/> > prefix gn: <http://www.geonames.org/ontology#> > select ?country > FROM <http://localhost:8890/dataMaster#> > FROM <http://localhost:8890/ontologies/geonames> > WHERE { ?s a sio:SIO_000393. > ?s sio:SIO_000664 ?country. > ?country gn:name ?cname// *this > triple make a traverse to other local ontology (geonames)* > } > > I think the problem is : > generated country property is text not IRI type. > I have try to modify the my R2RML using IRI template as > rr:predicateObjectMap [ rr:predicateMap [ rr:constant sio:SIO_000664 ] ; > rr:objectMap [ rr:termType rr:IRI ; rr:constant gn:Feature; rr:template > "{Country_geo}" ]; ] ; > > but also fail the generated IRI "need an encoding"as > http%3A%2F%2Fsws.geonames.org%2F226074%2F > <http://localhost:8890/conductor/http%3A%2F%2Fsws.geonames.org%2F226074%2F> > > wish to give me a solution :) > > thanks > > > You don't need an encoded IRI. You need < > <http://sws.geonames.org/2378080/>http://sws.geonames.org/226074/> . > > > rr:predicateObjectMap [ rr:predicateMap [ rr:constant sio:SIO_000664 ] ; > rr:objectMap [ rr:termType rr:IRI ; rr:constant gn:Feature; rr:template > "{Country_geo}" ]; ] > > should be producing <http://sws.geonames.org/226074/ > <http://sws.geonames.org/2378080/>>, not " > <http://sws.geonames.org/2378080/>http://sws.geonames.org/226074/"; . > > We'll try to make time to simulate this if my response still doesn't get > you over this problem. > > Kingsley > > > > On Tue, Dec 29, 2015 at 9:46 PM, Kingsley Ideh
Re: [Virtuoso-users] Make my views refer to external ontology?
OK, so I will still using a temporary solution Now when this bug will be fixed also I inform you a bug from 1 week about auto generated R2RML file (child and parent column) ??? also How can I get notification these fixed ?? thanks On Mon, Jan 4, 2016 at 4:52 PM, Kingsley Idehen wrote: > On 1/4/16 4:52 AM, Eng.Bassam wrote: > > Hi > I have tried this solution many times but unfortunately it's fail > the generated IRI by virtuoso as " > http%3A%2F%2Fsws.geonames.org%2F226074%2F > <http://localhost:8890/conductor/http%3A%2F%2Fsws.geonames.org%2F226074%2F> > " > > > now to solve this problem temporary, I' using rr:column not template for > IRI for this situation, > I'm using IRI function then to convert the " <http://sws.geonames.org/> > http://sws.geonames.org/226074"; text to IRI in filter clause > like this > select ?countryName > where > { > GRAPH <http://localhost:8890/emrMaster#> > { > > ?patient sio:SIO_000664 ?country. > } > > GRAPH <http://localhost:8890/ontologies/geonames> > { > ?geo gn:name ?countryName. > } > > FILTER(IRI(?country) = ?geo) . > } > GROUP BY ?countryName > > is it a bug ??? or something wrong ??? > thanks again > > On Wed, Dec 30, 2015 at 7:57 PM, Kingsley Idehen > wrote: > >> On 12/30/15 8:21 AM, Eng.Bassam wrote: >> >> Hi Kingsely and all members >> >> still there is the same problem can't traverse from ontology to other >> cause the generated IRI is text not IRI type, next is the description and >> sorry to be long but it's a problem need to solve ASAP to complete my >> project >> As I have said I have imported SQL DB using custom R2RML: >> <#TriplesMapPerson> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema >> "dataMaster" ; rr:tableOwner "data-ODBC" ; rr:tableName "Person" ]; >> rr:subjectMap [ rr:termType rr:IRI ; rr:template " >> http://localhost:8890/dataMaster/person/PersonID={ID}";; rr:class >> sio:SIO_000393; rr:graph < <http://localhost:8890/dataMaster#> >> http://localhost:8890/dataMaster#> ]; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant sio:SIO_000664 ] ; >> rr:objectMap [ rr:column "Country" ]; ] ; >> >> the column Country contain the IRIs of country geo ontology i.e as >> http://sws.geonames.org/226074/, this ontology I have loaded in my >> Virtuoso server at >> http://localhost:8890/ontologies/geonames >> >> this local ontology have rdf resources as : >> http://sws.geonames.org/226074/";> >> http://sws.geonames.org/226074/about.rdf >> <http://sws.geonames.org/2378080/about.rdf>"/> >> USA >> >> >> now my query is : >> >> PREFIX sio: <http://semanticscience.org/resource/> >> prefix gn: <http://www.geonames.org/ontology#> >> select ?country >> FROM <http://localhost:8890/dataMaster#> >> FROM <http://localhost:8890/ontologies/geonames> >> WHERE { ?s a sio:SIO_000393. >> ?s sio:SIO_000664 ?country. >> } >> >> the result unfortunately is the IRIs but in quotation as a text not an >> IRI type i.e " <http://sws.geonames.org/226074/> >> http://sws.geonames.org/226074/";, so I can't add to where clause in my >> query ?country gn:name ?cname also can't do ?country a gn:Feature >> >> PREFIX sio: <http://semanticscience.org/resource/> >> prefix gn: <http://www.geonames.org/ontology#> >> select ?country >> FROM <http://localhost:8890/dataMaster#> >> FROM <http://localhost:8890/ontologies/geonames> >> WHERE { ?s a sio:SIO_000393. >> ?s sio:SIO_000664 ?country. >> ?country gn:name ?cname// *this >> triple make a traverse to other local ontology (geonames)* >> } >> >> I think the problem is : >> generated country property is text not IRI type. >> I have try to modify the my R2RML using IRI template as >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant sio:SIO_000664 ] ; >> rr:objectMap [ rr:termType rr:IRI ; rr:constant gn:Feature; rr:template >> "{Country_geo}" ]; ] ; >> >> but also fail the generated IRI "need an encoding"as >> http%3A%2F%2Fsws.geonames.org%2F226074%2F >> <http://localhost:8890/conductor/http%3A%2F%2Fsws.geonames.org%2F226074%2F> >> >> wish to give me a solution :) >> >> thanks
[Virtuoso-users] inference queries ?
Hi may be my question out of virtuoso, I don't know, wish someone answer me and thanks :) is there any way to make inference queries in SPARQL, i.e may be I have an ontology that have A is subclass from B also C owl:sameAS D how can I make inference queries? get all B classes this will return also A classes (inheritance). get all D classes this will return also D classes (owl:sameAS) thanks -- --- > Eng.Bassam Najeeb. >Software Engineer. -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] ontology graphical representation ?
Hi Is there any way to show loaded ontology in virtuoso in graphical representation ??? I mean named nodes and arcs ? thanks -- --- > Eng.Bassam Najeeb. >Software Engineer. -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] uploade TTl big file?
Hello I have a big TTL file about (2GB), I try upload it in virtuoso via ISQL: DB.DBA.TTLP_MT (file_to_string_output ('C:/Program Files/OpenLink Software/Virtuoso 7.2/vad/geneDiseaseAssociation.ttl'), '', ' http://localhost:8890/ontologies/DisGen'); is this right, or wrong? I need fastest way, and wish to see a progress bar to know how remaining time note: while it executing, I made COUNT(*) via SPARQL to see if count of added triples to graph increase or not, I think after 1 hour not add any triple on graph and ISQL still busy :( -- --- > Eng.Bassam Najeeb. >Software Engineer. -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] uploade TTl big file?
I have split my file to 4 files, and Now I'm trying bulk loader strategy, I see after create the loader, I can see the files handled select * from DB.DBA.load_list; the first time was an error in my files, how can I try again run loader and check status in DB.DBA.load_list (delete last result)?? thanks On Mon, Jan 25, 2016 at 2:20 PM, Hugh Williams wrote: > Hi Bassam, > > You can call the TTLP_MT() function as you are doing for a single file, > but generally we would recommend the use of the Virtuoso RDF Bulk loader as > detailed at: > > > http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtBulkRDFLoader > > Which enable you to better manage the bulk loading of RDF datasets. > > The Virtuoso LDMeter functions can also be used to monitor the progress of > data loads ie load rates etc as detailed at: > > > http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksGuideLDMeterUtility > > Generally you need to ensure you have tuned the Virtuoso server for RDF > performance, as if you run out of Buffers (memory) and have to swapping to > and from disk, this will kill load rates and performance generally as > detailed at: > > > http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFPerformanceTuning > > 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 25 Jan 2016, at 10:45, Eng.Bassam wrote: > > Hello > > I have a big TTL file about (2GB), I try upload it in virtuoso via ISQL: > > DB.DBA.TTLP_MT (file_to_string_output ('C:/Program Files/OpenLink > Software/Virtuoso 7.2/vad/geneDiseaseAssociation.ttl'), '', ' > http://localhost:8890/ontologies/DisGen'); > > is this right, or wrong? > I need fastest way, and wish to see a progress bar to know how remaining > time > > note: > while it executing, I made COUNT(*) via SPARQL to see if count of added > triples to graph increase or not, I think after 1 hour not add any triple > on graph and ISQL still busy :( > > -- > --- > > Eng.Bassam Najeeb. > >Software Engineer. > > > -- > Site24x7 APM Insight: Get Deep Visibility into Application Performance > APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month > Monitor end-to-end web transactions and take corrective actions now > Troubleshoot faster and improve end-user experience. Signup Now! > > http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140___ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > -- --- > Eng.Bassam Najeeb. >Software Engineer. -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] How I make an inference in Virtuoso?
Hi Suppose I have an ontology for fruits: Bana is Fruit. Apple is Fruit. Also suppose I have other dataset that contains: Bassam eat Apple. Husam eat Banana. Can I do following question (SPARQL query) using Virtuoso, Who eat Fruits? the answer must be Bassam and Husam, because there is an inference (Banana and Apple are fruits) Thanks -- --- > Eng.Bassam Najeeb. >Software Engineer. -- ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Load MySQL database into Virtuoso server
As I know, to able to load a DB into a Virtuoso directly via database tab, the Virtuoso must be a commercial edition. On Mon, Jan 16, 2017 at 4:39 PM, AA Saa wrote: > Hi, > > I am new to Virtuoso. I wanted to load some already exist database (MySQL) > into Virtuoso. However, flowing the tutorial here ( > https://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/ > Main/VirtMySQLLinkingObjects) I couldn't even find where to load local > database stored in my PC. I could do step 1 and 2 correctly but under the > "Select the *Databases* -> *External Data Source* -> *Data Sources"*I > found no way to load my database stored on my PC. > > I am using this version: > >- Version: 07.20.3217 >- Build: Apr 13 2016 > > > any help? > > > > > -- > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > ___ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > -- --- > Eng.Bassam Najeeb. >Software Engineer. -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] Mapping XML files to RDF graph using Virtuoso?
Hi I transformed an SQL database to RDF graph using an R2RML in a commercial edition of Virtuoso 7.2. Now I have 5000 *standard XML files*, Can I do a mapping to RDF Graph "same as R2RML" for those XML files using a Virtuoso??? Thanks. -- --- > Eng.Bassam Najeeb. >Software Engineer. -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Mapping XML files to RDF graph using Virtuoso?
Thank Kingsley Could you please support me more information about 2 fundementals that you has said ??? may be short example :) ?? 1. I think first create an ontology data model for my native XML files. 2. The second step is create a data model mapping between my XML file and an ontology data model which created in the first step "as R2RML does RDB2RDF mapping". Thanks again. On Mar 17, 2017 5:05 PM, "Kingsley Idehen" wrote: > On 3/17/17 10:05 AM, Eng.Bassam wrote: > > Hi > I transformed an SQL database to RDF graph using an R2RML in a commercial > edition of Virtuoso 7.2. > Now I have 5000 *standard XML files*, Can I do a mapping to RDF Graph > "same as R2RML" for those XML files using a Virtuoso??? > > Thanks. > > > Only if you can turn the content of the XML files into RDF which requires: > > 1. Ontological understanding of whats represented in the XML files > > 2. Mechanism for using said understanding to transform that content into > RDF -- e.g., deriving an RDF/XML doc. > > There might be an RML processor for achieving the above. Naturally, you > can also use the Virtuoso Cartridge system to achieve the same goal. > > Links: > > > 1. https://virtuoso.openlinksw.com/whitepapers/sponger% > 20cartridge%20programmers%20guide%20rdf%20middleware.html > > 2. https://virtuoso.openlinksw.com/whitepapers/sponger% > 20cartridge%20programmers%20guide%20rdf%20middleware.html#mozTocId139 -- > XSLT part of Cartridge Creation > > -- > Regards, > > Kingsley Idehen > Founder & CEO > OpenLink Software (Home Page: http://www.openlinksw.com) > > Weblogs (Blogs): > Legacy Blog: http://www.openlinksw.com/blog/~kidehen/ > Blogspot Blog: http://kidehen.blogspot.com > Medium Blog: https://medium.com/@kidehen > > Profile Pages: > Pinterest: https://www.pinterest.com/kidehen/ > Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen > Twitter: https://twitter.com/kidehen > Google+: https://plus.google.com/+KingsleyIdehen/about > LinkedIn: http://www.linkedin.com/in/kidehen > > Web Identities (WebID): > Personal: http://kingsley.idehen.net/dataspace/person/kidehen#this > : > http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this > > > > -- > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > ___ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users