Re: [Virtuoso-users] load SQL data in Virtouso

2015-11-10 Thread Kingsley Idehen
On 11/10/15 2:57 AM, Eng.Bassam wrote: > 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 t

Re: [Virtuoso-users] load SQL data in Virtouso

2015-11-09 Thread Eng.Bassam
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 pro

Re: [Virtuoso-users] load SQL data in Virtouso

2015-11-09 Thread Kingsley Idehen
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 mode

Re: [Virtuoso-users] load SQL data in Virtouso

2015-11-09 Thread Marco Tenti
Hello, I'm no expert, but if you find problems for the creation of a specific map for the conversion of your database tables in a suit specific structure RDF / OWL and you will want to customize one of your own, try to take a look Web-Karma project:https://github.com/usc-isi-i2/Web-Karma After cre

Re: [Virtuoso-users] load SQL data in Virtouso

2015-11-08 Thread Eng.Bassam
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"

Re: [Virtuoso-users] load SQL data in Virtouso

2015-11-07 Thread Eng.Bassam
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

Re: [Virtuoso-users] load SQL data in Virtouso

2015-11-07 Thread Eng.Bassam
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

Re: [Virtuoso-users] load SQL data in Virtouso

2015-11-07 Thread Kingsley Idehen
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