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 this can be done in R2RML code manual??
Yes, that's what R2RML is all about. > > 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 Fine. Kingsley > > thanks > > On Mon, Nov 9, 2015 at 3:38 PM, Kingsley Idehen > <kide...@openlinksw.com <mailto: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 <mailto: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 <mailto: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 list >>>> Virtuoso-users@lists.sourceforge.net >>>> <mailto:Virtuoso-users@lists.sourceforge.net> >>>> https://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 >>> <http://www.openlinksw.com/blog/%7Ekidehen> >>> 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 >>> <mailto: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 >>> <mailto:Virtuoso-users@lists.sourceforge.net> >>> https://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 >> <http://www.openlinksw.com/blog/%7Ekidehen> >> 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 >> <mailto:Virtuoso-users@lists.sourceforge.net> >> https://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 > <http://www.openlinksw.com/blog/%7Ekidehen> > 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 > <mailto: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 -- 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
smime.p7s
Description: S/MIME Cryptographic Signature
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users