[Virtuoso-users] Contd: RDFViews, NVarchar, Unicode and Create IRI Class
Aldo Bucchi wrote: Hi, On Fri, Aug 14, 2009 at 7:17 AM, Aldo Bucchialdo.buc...@gmail.com wrote: On Aug 13, 2009, at 22:51, Aldo Bucchi aldo.buc...@gmail.com wrote: Hi Ivan, On Thu, Aug 13, 2009 at 10:21 PM, Ivan Mikhailovimikhai...@openlinksw.com wrote: Hello Aldo, I will extend the list of supported column types soon, to fully support NVARCHAR, LONG NVARCHAR and ANY. After that, the only unsupported type remaining will be VARBINARY (and LONG VARBINARY). OK. And what about using Function-Based IRI Classes in the meantime. Should that work? It does not :( What happens if I cast the nvarchar to varchar in the views? This obviously breaks bijection as I might be loosing data. But, I see no other way around. CREATE VIEW X.X.Concept AS SELECT cast ( concept_id as varchar )as id, FROM X.X.concept_table ; and then create an IRI class that can be used like so x:concept ( concept.id ) Note that I am 100% certain that the data in this column is simply alphanumeric w/no strange chars. Basically, IDs that may look like 980YUHS877 Of course, changing the column type in the source database is impossible. Thanks, A We really need this ASAP. So any workarounds are welcome. Here's the dataflow so you get a bigger picture. * Data lives in Sybase 12.5.x * Comes in via respective UDA driver ( unicode, because some chars in other columns may be latin ) * We link the remote datasource into VDB * Create a SQL View to consolidate entities * Then create RDFViews. Here's where we need the IRI class on a PK which ends up being an nvarchar Thanks, A Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Thu, 2009-08-13 at 19:01 -0400, Aldo Bucchi wrote: Hi, I'm trying to create an iri class that takes an nvarchar field as input. Virtuoso spits: 22023 The datatype nvarchar is not supported in CREATE IRI CLASS... How can I go around this? We need unicode support because there might be latin characters flying around. ( we think we need ). Thanks, A -- Aldo Bucchi 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. Just realized that's what your attempting above. I read mails bottom up sometimes :-) -- Regards, Kingsley Idehen Weblog: http://www.openlinksw.com/blog/~kidehen President CEO OpenLink Software Web: http://www.openlinksw.com
Re: [Virtuoso-users] Contd: RDFViews, NVarchar, Unicode and Create IRI Class
Hi, On Fri, Aug 14, 2009 at 5:36 PM, Kingsley Idehenkide...@openlinksw.com wrote: Aldo Bucchi wrote: Hi, On Fri, Aug 14, 2009 at 7:17 AM, Aldo Bucchialdo.buc...@gmail.com wrote: On Aug 13, 2009, at 22:51, Aldo Bucchi aldo.buc...@gmail.com wrote: Hi Ivan, On Thu, Aug 13, 2009 at 10:21 PM, Ivan Mikhailovimikhai...@openlinksw.com wrote: Hello Aldo, I will extend the list of supported column types soon, to fully support NVARCHAR, LONG NVARCHAR and ANY. After that, the only unsupported type remaining will be VARBINARY (and LONG VARBINARY). OK. And what about using Function-Based IRI Classes in the meantime. Should that work? It does not :( What happens if I cast the nvarchar to varchar in the views? This obviously breaks bijection as I might be loosing data. But, I see no other way around. CREATE VIEW X.X.Concept AS SELECT cast ( concept_id as varchar ) as id, FROM X.X.concept_table ; and then create an IRI class that can be used like so x:concept ( concept.id ) Note that I am 100% certain that the data in this column is simply alphanumeric w/no strange chars. Basically, IDs that may look like 980YUHS877 Of course, changing the column type in the source database is impossible. Thanks, A We really need this ASAP. So any workarounds are welcome. Here's the dataflow so you get a bigger picture. * Data lives in Sybase 12.5.x * Comes in via respective UDA driver ( unicode, because some chars in other columns may be latin ) * We link the remote datasource into VDB * Create a SQL View to consolidate entities * Then create RDFViews. Here's where we need the IRI class on a PK which ends up being an nvarchar Thanks, A Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Thu, 2009-08-13 at 19:01 -0400, Aldo Bucchi wrote: Hi, I'm trying to create an iri class that takes an nvarchar field as input. Virtuoso spits: 22023 The datatype nvarchar is not supported in CREATE IRI CLASS... How can I go around this? We need unicode support because there might be latin characters flying around. ( we think we need ). Thanks, A -- Aldo Bucchi 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. Just realized that's what your attempting above. I read mails bottom up sometimes :-) We need wave like stuff! -- Regards, Kingsley Idehen Weblog: http://www.openlinksw.com/blog/~kidehen President CEO OpenLink Software Web: http://www.openlinksw.com -- Aldo Bucchi 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.
Re: [Virtuoso-users] Contd: RDFViews, NVarchar, Unicode and Create IRI Class
Aldo Bucchi wrote: Hi, We need wave like stuff! We have a dcc feature in ODS-Mail that converts emails threads into NNTP based discussion threads and surfaces this in Linked Data form via the SIOC ontology. That's been the case for a number of years, just need better UI which is the only issue re. ODS (as I state repeatedly). I will soon be moving my attention back to ODS re. public demos and screencasts. Kingsley -- Regards, Kingsley Idehen Weblog: http://www.openlinksw.com/blog/~kidehen President CEO OpenLink Software Web: http://www.openlinksw.com -- Regards, Kingsley Idehen Weblog: http://www.openlinksw.com/blog/~kidehen President CEO OpenLink Software Web: http://www.openlinksw.com