Re: [Virtuoso-users] Problems materialising data using rdb2rdf trigger option within rdf views

t: http://support.openlinksw.com > Forums: http://boards.openlinksw.com/support > Twitter: http://twitter.com/OpenLink > > On 21 Sep 2011, at 14:39, Mark James wrote: > >> Hi, >> Using the Commercial 6.2 version of Virtuoso I've created and populated a >> table within the relat

[Virtuoso-users] Problems materialising data using rdb2rdf trigger option within rdf views

Hi, Using the Commercial 6.2 version of Virtuoso I've created and populated a table within the relational part of Virtuoso. I've then tried to materialise this data as triples using the rdb2rdf and sync options (checkboxes) found within the final screen of the rdf view creation wizard. Once the vi

[Virtuoso-users] Error from a valid xsl file

Hi, I'm trying to run an xsl script from within Virtuoso that I've successfully run externally within a php class. When run within Virtuoso I get the following error. SQLState: 22007 Message: XM003: XML parser detected an error: ERROR : 37000 XM028: XPath interpreter, line 1: Namespace

Re: [Virtuoso-users] Disk space for a graph's data

of data a user can store... Cheers Mark On 18 January 2011 19:12, Ivan Mikhailov wrote: > Hello Mark, > > On Sun, 2011-01-16 at 14:21 +1100, Mark James wrote: > > > Is there an easy way to determine the amount of disk space an > > individual quad store graph is taking up?

[Virtuoso-users] Disk space for a graph's data

Hi, Is there an easy way to determine the amount of disk space an individual quad store graph is taking up? Cheers Mark

Re: [Virtuoso-users] ETL from SQL to RDF?

Hi Lars, The commercial version of virtuoso has a 'virtual database' capability. You can create tables within virtuoso that are links to tables within other rdbms. It's then possible to create rdf views and either materialize the triples or query the rdbms data directly. Note that if you want to pe

[Virtuoso-users] Sparql Insert question

Hi, I've found that the inference inverseOf only seems to occur when the predicate that is the inverse is explicitly stated within the query. Eg This works - define input:inference "wsf_inference_rule" prefix output: select * where {

[Virtuoso-users] inserting aggregated data into quad store via sparql

Hi, I'm trying to aggregate up some particular values within the quad store and insert these totals as triples. Using the following statement I get the error - Message: SQ074: Line 18: SP030: SPARQL compiler, line 4: syntax error at 'sum' before '(' SPARQL PREFIX INT:

[Virtuoso-users] sparql hints to specify index

Hi, It mentions in the documentation that an index can be explicitly hinted within a query - *http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#perfdiagqueryplans* ***If the index choice is not the right one, consider the following possibilities:* - *Run statistics. This is not always n

[Virtuoso-users] Slow query performance after moving to amazon ec2

Hi All, I've moved a demo application to AWS Ec2 from another hosted setup. Since doing so I've found that a large portion of my sparql queries have gone from returning in 0.5 seconds to 7-8 seconds. The datasets themselves are quite small ~ 120k triples total in quad store. An example of one of t

[Virtuoso-users] identifying objects that have different uri's but are the same due to IVF

Hi, Is there an effective way via sparql to first identify and then dedupe a list of uri's that have been inferred to be the same via inverseFunctionalProperty rule? For example define sql:table-option "index rdf_quad" define input:inference "wsf_inference_rule1" SELECT * WHERE {

[Virtuoso-users] date manipulation for xsd types within sparql

Hi, I was wondering if there was functionality available within sparql to manipulate columns of type xsd:date, xsd:time and xsd:dataTime. The most important one to me right now is the ability to truncate a dateTime column to only a date in order to perform a group by on this column. Eg in oracle

[Virtuoso-users] string manipulation within an rdf view

Hi, Is it possible to create an rdf attribute as a manipulation of 1 or more columns from a table or does this have to be done in a sql view prior to the rdf view? I attempted to perform a concat like the one below but got the error - SQ074: Line 46: SP031: SPARQL compiler: Table alias name is not

Re: [Virtuoso-users] Virtual Database - Composite data types

d I'm more than happy for it to slip into the rdf view to quad store sink, provided it doesn't delay it :) You know how keen I am for that change! Cheers Mark On 26 May 2010 10:56, Kingsley Idehen wrote: > Mark James wrote: > >> Hi Hugh, >> Thanks for following up on t

Re: [Virtuoso-users] Virtual Database - Composite data types

http://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: http://boards.openlinksw.com/support > Twitter: http://twitter.com/OpenLink > > On 25 May 2010, at 03:33, Mark James wrote: > > Hi, > I'm trying to load a number of oracle tables as a vi

[Virtuoso-users] Virtual Database - Composite data types

Hi, I'm trying to load a number of oracle tables as a virtual tables. These tables contain complex datatypes within certain columns. Eg - CREATE or REPLACE TYPE "CUST_ADDRESS_TYP" as object (streed_address varhar2(40), postal_code varchar2(10), city varhar2(30), state_province varchar2(10), countr

Re: [Virtuoso-users] linking datasets with virtuoso

Hi, Thanks for the link. I hadn't seen this. An alternative approach for simple scenario's is to use the inverseFunctionalProperty. This will allow virtuoso to infer a sameAs link if two instances have the same data within an attribute, usually a primary key. Eg two instances of Customer with a cu

[Virtuoso-users] Inferencing Question with InverseFunctionalProperty

Hi, I can't seem to get an inference pattern match (sameAs) when combining InverseFunctionalProperty and subPropertyOf. The first example (based on) - http://docs.openlinksw.com/virtuoso/rdfsparqlrule.html#rdfsparqlruleinversefunc(I've only removed the sameAs triple). This example produces the exp

Re: [Virtuoso-users] RDF views and caching the data locally

raph to a n3 dumps, see the script head for help , at the > end there are examples of it's use. > Then the produced dumps can be loaded on any Virtuoso instance using TTLP > () import function. > > Best Regards, > Mitko > > > > > > On Apr 19, 2010, at 7

Re: [Virtuoso-users] RDF views and caching the data locally

les of it's use. > Then the produced dumps can be loaded on any Virtuoso instance using TTLP > () import function. > > Best Regards, > Mitko > > > > > > On Apr 19, 2010, at 7:25 PM, Kingsley Idehen wrote: > > > Mark James wrote: > >> Hi, >

[Virtuoso-users] RDF views and caching the data locally

Hi, Is it possible to cache data (in the quad store) retrieved by a sparql query against an rdf view much like a sponger query? Eg. (Using northwind demo db) select * from where { ?s 'Rancho grande' } returns 5 rows. How

[Virtuoso-users] Error creating wiki application for ODS user

Hi, I've created an ODS user with the following roles - Primary Role = WikiAdmin, Others = WikiUser. I can log in as that user just fine. When trying to create and launch a wiki application with this user I get the following error? What am I doing wrong. 42WV9 [11001] System user account "Internal