Hugh, On Mon, May 25, 2009 at 9:25 AM, Hugh Williams <hwilli...@openlinksw.com> wrote: > Hi Aldo, > "grant select on xx.xx.* ..." is not supported as far as I can see, this > has to be done individually unless you write to procedure to perform this > operation against all tables in a given catalog.
We will create such procedure ;) > Are you writing the RDFviews by hand as we already have a UI for generating > the RDFViews, Ontology and Linked Data deployment URL rewrite rules as > detailed at; Yes of course we used the UI! It has helped us a lot, since it gives us a quick workflow. And we can then work against the data. What we are doing now is "reducing" xxx_id columns ( Foreign keys ) to predicate hops, adding some IFP URIs ( eg. replace SSN numbers with an ssn URI class ) and removing relation classes ( in case of highly normalized tables ). I can imagne how a visual editor ( where one can from cols to ontology nodes, add some parameters, etc ) could pick up where the current UI leaves us and would help in much of these steps but I guess it will never be the silver bullet ( I would love to be proven wrong, you guys might see this more clearly than I do ). So, w/o a silver bullet UI, we will always have to go down and code. When this happens, reducing boilerplate and making succint dialects is the way to go, methinks. Most of the language is now very dense, but there are some parts, like "grants", where you can see low hanging fruit in terms of improvement. I would love working towards a terser dialect for this because I can predict I will spend quite some time here ;) Ah and then there is the traditional roundtrip issue related to generation of any kind ( aka. keeping derived stuff up to date with the source ). Reducing weight of artifacts provides some benefits here. Regards, A > http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFOWLGeneration > Best Regards > Hugh Williams > Professional Services > OpenLink Software > Web: http://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: http://boards.openlinksw.com/support > > > On 25 May 2009, at 08:14, Aldo Bucchi wrote: > > Hi, > When generating RDF Views, it is commonplace to > "grant select on xx.xx.table to SPARQL_SELECT" > For as many "table"s as must be mapped. Which makes a lot of the > generated scripts now look like this: > "grant select on xx.xx.table to SPARQL_SELECT" > "grant select on xx.xx.table to SPARQL_SELECT" > "grant select on xx.xx.table to SPARQL_SELECT" > "grant select on xx.xx.table to SPARQL_SELECT" > "grant select on xx.xx.table to SPARQL_SELECT" > "grant select on xx.xx.table to SPARQL_SELECT" > "grant select on xx.xx.table to SPARQL_SELECT" > "grant select on xx.xx.table to SPARQL_SELECT" > Is there a way to do something like "grant select on xx.xx.* ..." ? > Of course this is not really a problem as these statements can be > easily generated and are idempotent. However, I can foresee that > manual edition of these files will be necessary and/or desirable at > least until a full blown point and click UI editor is developed ( and > even then... mapping is full of border cases ) > Just asking ;) > When dealing with 200+ tables this contributes to a lot of boilerplate. > Thanks, > A > -- > Aldo Bucchi > U N I V R Z > Office: +56 2 795 4532 > Mobile:+56 9 7623 8653 > skype:aldo.bucchi > http://www.univrz.com/ > http://aldobucchi.com/ > PRIVILEGED AND CONFIDENTIAL INFORMATION > This message is only for the use of the individual or entity to which it is > addressed and may contain information that is privileged and confidential. > If > you are not the intended recipient, please do not distribute or copy this > communication, by e-mail or otherwise. Instead, please notify us immediately > by > return e-mail. > INFORMACIÓN PRIVILEGIADA Y CONFIDENCIAL > Este mensaje está destinado sólo a la persona u organización al cual está > dirigido y podría contener información privilegiada y confidencial. Si usted > no > es el destinatario, por favor no distribuya ni copie esta comunicación, por > email o por otra vía. Por el contrario, por favor notifíquenos > inmediatamente > vía e-mail. > ------------------------------------------------------------------------------ > Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT > is a gathering of tech-side developers & brand creativity professionals. > Meet > the minds behind Google Creative Lab, Visual Complexity, Processing, & > iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian > Group, R/GA, & Big Spaceship. http://www.creativitycat.com > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > -- Aldo Bucchi U N I V R Z Office: +56 2 795 4532 Mobile:+56 9 7623 8653 skype:aldo.bucchi http://www.univrz.com/ http://aldobucchi.com/ PRIVILEGED AND CONFIDENTIAL INFORMATION This message is only for the use of the individual or entity to which it is addressed and may contain information that is privileged and confidential. If you are not the intended recipient, please do not distribute or copy this communication, by e-mail or otherwise. Instead, please notify us immediately by return e-mail. INFORMACIÓN PRIVILEGIADA Y CONFIDENCIAL Este mensaje está destinado sólo a la persona u organización al cual está dirigido y podría contener información privilegiada y confidencial. Si usted no es el destinatario, por favor no distribuya ni copie esta comunicación, por email o por otra vía. Por el contrario, por favor notifíquenos inmediatamente vía e-mail.
