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 <kide...@openlinksw.com> 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 <kide...@openlinksw.com> > 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>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 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 > 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 > > > > ------------------------------------------------------------------------------ > 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 > > -- ----------------------------------- > Eng.Bassam Najeeb. >Software Engineer.
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
