[Virtuoso-users] DIG/OWLlink support
Does Virtuoso support DIG or OWLlink for integration with other reasoners? If not, are there any plans on it?
[Virtuoso-users] Versioning support
Hello! Does Virtuoso RDF-store support versioning? Regards, Alexander
[Virtuoso-users] Semantic search
Hello! Does Virtuoso have any semantic search implementation based on RDF-store? Regards, Alexander
Re: [Virtuoso-users] Semantic search
Hi, Hugh! As I understand, Faceted Web Service is just a SPARQL-query results wrapper. But I asked about some semantic search implementation. Under semantic search I mean some more intellectual than pure SPARQL algorithms. Regards, Alexander 2010/1/3 Hugh Williams hwilli...@openlinksw.com Hi Alexander, Virtuoso versions 6 and above provide a Faceted Browser User Interface for querying the RDF-store using its Faceted Web Service interface as detailed at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtuosoFacetsWebService Details on installation and configuration can be found at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtFacetBrowserInstallConfig Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 2 Jan 2010, at 16:36, Alexander Sidorov wrote: Hello! Does Virtuoso have any semantic search implementation based on RDF-store? Regards, Alexander -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Entity Framework provider
Hi Hugh, At the moment I'm especially interested in working with Virtuoso using .NET. Are there some other frameworks excepting dotnetRDF and LINQTORDF? I'm also interested in EF, but not in this context. Documentation says your EF-provider can be used to access non-relation data stores. I expected some rocket science here - that why my first question was about EF. I think it would be useful to add some clarifications telling that non-relation data sources are accessed using relation Views. I have two more questions about EF, but I think it would be better to create another thread for it. Just a minute. Regards, Alexander 2010/1/5 Hugh Williams hwilli...@openlinksw.com Hi Alexander, Yes, we did perform some work to provide LiNQ2RDF support for Virtuoso which was committed to the project in 2008, see: http://virtuoso.openlinksw.com/Whitepapers/html/linqtordf/linqtordf1.htm I thought you were more interested in EF support which I why I did not include it along with the dotnetRDF project link which is more recent ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 5 Jan 2010, at 12:55, Alexander Sidorov wrote: Hi High, Thank you for dotnetRDF link: I didn't know about this framework before. I have also found one more .NET framework with Virtuoso support - LINQ2RDF. Now I'm choosing which of them to use. Regards, Alexander 2010/1/3 Hugh Williams hwilli...@openlinksw.com Hi Alexander, The walk-throughs provide sample applications of various methods for querying the Virtuoso RDF SQL stores in .Net using both the ADO.NetProvider and HTTP. The Entity Framework samples require a SQL/relational mapping and creating a SQL View of the RDF SPARQL query seems the obvious way of doing this. Have you looked at the dotnetRDF project which provides an RDF library for .Net and supports Virtuoso as detailed at: http://www.dotnetrdf.org/content.asp?pageID=Using%20Virtuoso%20Universal%20Server This may be more what you are looking for ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 2 Jan 2010, at 22:35, Alexander Sidorov wrote: Hi, Hugh! These examples demonstrate RDF-store access by EF using Views. But I would like some more dynamic way: I don't like the idea of creating a view for every query. The one dynamic example in that list called Creating Silverlight Application for Browsing RDF Datahttp://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtSilverlightSPARQLExample doesn't use EF at all: it uses SPARQL through http. So are there any means for dynamic RDF-store querying from .NET except nake http? I have the only idea about using Jena or Sesame converted with IKVM.NET, but may be there are some other options? Regards, Alexander 2010/1/3 Hugh Williams hwilli...@openlinksw.com Hi Alexander, There are a number of Sample Walk-through Application examples on accessing using the Virtuoso ADO.Net Provider for accessing the RDF-store via various methods, in the documentation at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtAdoNet35Provider I hope his is what you are looking for ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 2 Jan 2010, at 16:33, Alexander Sidorov wrote: Hello! Are there any examples of using Virtuoso provider for accessing non-relational sources (I am especially in accessing RDF-store)? Regards, Alexander -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev___ Virtuoso-users mailing list
[Virtuoso-users] EF4 support
Hello! What are your plans about EF4 support? Regards, Alexander
[Virtuoso-users] EF-provider
Hello! OpenLink EF provider is great in that it can be used with almost any relational database. But unfortunately it doesn't work without Virtuoso. It would be great to move the database independence mechanism from Virtuoso to the provider itself. I have no idea how difficult it is to implement... but it would be a great competitor for DevArt providers. Regards, Alexander
Re: [Virtuoso-users] Semantic search
Hi Hugh, Sorry, I have read it innattentively first time. It is really what I searched. Thank you :) Regards, Alexander 2010/1/3 Hugh Williams hwilli...@openlinksw.com Hi Alexander, Given that RDF-stores use SPARQL as their query mechanism, any form of semantic search is going to use SPARQL ultimately to access to the triples. Have you actually looked at the Virtuoso Facet Browser UI, like the one available fro DBpedia at: http://dbpedia.org/fct To see they type of searches that can be performed ? If this is does not provide necessary sophistication sought then via the Web Service API you should be able to extend or develop your own semantic search engine. OntoWiki which supports Virtuoso is classified as a Semantic Search engine at: http://swuiwiki.webscience.org/index.php/Semantic_Search_Survey#OntoWiki Details on configuring OntoWiki for use with Virtuoso is available from: http://code.google.com/p/ontowiki/wiki/UsingOntoWikiWithVirtuoso Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 2 Jan 2010, at 22:44, Alexander Sidorov wrote: Hi, Hugh! As I understand, Faceted Web Service is just a SPARQL-query results wrapper. But I asked about some semantic search implementation. Under semantic search I mean some more intellectual than pure SPARQL algorithms. Regards, Alexander 2010/1/3 Hugh Williams hwilli...@openlinksw.com Hi Alexander, Virtuoso versions 6 and above provide a Faceted Browser User Interface for querying the RDF-store using its Faceted Web Service interface as detailed at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtuosoFacetsWebService Details on installation and configuration can be found at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtFacetBrowserInstallConfig Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 2 Jan 2010, at 16:36, Alexander Sidorov wrote: Hello! Does Virtuoso have any semantic search implementation based on RDF-store? Regards, Alexander -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] Triple reference
Hello! I am storing triples generated from natural language texts at RDF-store. Also I need to store some metadata for these triples (for example, how often and where this triple occurs in the text). Of course, I could use reification for storing metadata... but I would like to store it at relation store. Is there any way to specify which triple's metadata I'm storing? Regards, Alexander
[Virtuoso-users] owl:Thing support
Hello! I am working with OWL ontology stored in Virtuoso RDF-store. Ontology contains assertions someClass rdfs:subClassOf owl:Thing not for all root classes. Is there any way to make Virtuoso reasoner take into consideration that all classes are derived from owl:Thing. In other words I want to shift reasoner from rdfs to owl world without requiring any additional reasonings (exceping the one about owl:Thing). Regards, Alexander
[Virtuoso-users] Get direct subclasses
Hello! Could you please hint me how to get some class' *direct* derivatives using Virtuoso SPARQL-endpoint in the case inference is enabled? Regards, Alexander
[Virtuoso-users] ADO.NET provider problems
Hello! I have some problems using virtado3.dll to access Virtuoso Open Source 5 RDF-store. 1. Performance (cpu usage is 100% for one core) and memory (OutOfMemoryException) problems during some trivial SPARQL-queries execution. Looks like a recursion... At the same time these queries are executed nice throught web-interface. 2. Not all results are returned (comparing to what web-interface SPARQL-utility returns). I'm virtado3 throught dotnetRDF but it looks like the root of problem is virtado3.dll. Are these problems known? Are there any workarounds? Regards, Alexander
[Virtuoso-users] Virtuoso 5 encoding problems
Hello! I am using Virtuoso Open Source 5 and have problems storing and retrieving non-english literals. Virtuoso.ini: Charset = UTF-8 Is this a known problem? Regards, Alexander
Re: [Virtuoso-users] Virtuoso 5 encoding problems
Hello Ivan, I use TTLP from .NET using virtado3. I have attached simplified source code and TTLP parameters values (.NET String is UTF-16). Regards, Alexander 2010/1/30 Ivan Mikhailov imikhai...@openlinksw.com Hello Alexander, May I get a sample TTLP call statement that demonstrates the problem, please? (My mail client shows an attachment icon at your previous mail but no attachments, please re-attach in some different way if there were any) Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Sat, 2010-01-30 at 01:04 +0600, Alexander Sidorov wrote: Hi Hugh, I have localized the problem and can be more specific now. I use two ways to add triples to the store: 1. SPARQL INSERT DATA query 2. DB.DBA.TTLP stored procedure The first way work normally, but the second stores triples with incorrect encoding (and nonenglish literals are displayed wrong). Regards, Alexander 2010/1/29 Hugh Williams hwilli...@openlinksw.com Hi Alexander, By what means are you inserting and retrieving the literals ? What are the literal values being inserted and what are the values that are being retrieved incorrectly ? If you can provide minimal steps to reproduce then we can attempt recreation in-house ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 29 Jan 2010, at 14:41, Alexander Sidorov wrote: Hello! I am using Virtuoso Open Source 5 and have problems storing and retrieving non-english literals. Virtuoso.ini: Charset = UTF-8 Is this a known problem? Regards, Alexander -- The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users Source code: VirtuosoCommand cmd = new VirtuosoCommand(); cmd.CommandText = DB.DBA.TTLP(@data, @base, @graph, 1); cmd.Parameters.Add(data, data); cmd.Parameters.Add(base, baseUri); cmd.Parameters.Add(graph, baseUri); cmd.Connection = this._db; int result = cmd.ExecuteNonQuery(); Data: baseUri = http://kms.cctpu.edu.ru/ontologies/2009/5/TPU.owl#; data = @base http://kms.cctpu.edu.ru/ontologies/2009/5/TPU.owl#. @prefix rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns#. @prefix rdfs: http://www.w3.org/2000/01/rdf-schema#. @prefix xsd: http://www.w3.org/2001/XMLSchema#. @prefix : http://kms.cctpu.edu.ru/ontologies/2009/5/TPU.owl#. @prefix dc: http://purl.org/dc/elements/1.1/. @prefix CEEO: http://kms.cctpu.edu.ru/ontologies/2009/5/CEEO.owl#. @prefix owl2xml: http://www.w3.org/2006/12/owl2-xml#. @prefix TPU: http://kms.cctpu.edu.ru/ontologies/2009/5/TPU.owl#. @prefix owl: http://www.w3.org/2002/07/owl#. @prefix CommonConceptOntology: http://kms.cctpu.edu.ru/ontologies/2009/5/CommonConceptOntology.owl#. @prefix TPU2: http://kms.cctpu.edu.ru/ontologies/2009/5/TPU.owl#8. @prefix UniversityOntology: http://kms.cctpu.edu.ru/ontologies/2009/5/UniversityOntology.owl#. http://kms.cctpu.edu.ru/ontologies/2009/5/TPU.owl rdf:type owl:Ontology. http://kms.cctpu.edu.ru/ontologies/2009/5/TPU.owl owl:imports http://kms.cctpu.edu.ru/ontologies/2009/5/CEEO.owl. http://kms.cctpu.edu.ru/ontologies/2009/5/TPU.owl owl:imports http://kms.cctpu.edu.ru/ontologies/2009/5/CommonConceptOntology.owl. http://kms.cctpu.edu.ru/ontologies/2009/5/TPU.owl
Re: [Virtuoso-users] Virtuoso 5 encoding problems
So I have succeeded in uploading graph to database, but looks like it is not the end of the story :) After triples were uploaded using SPARQL INSERT DATA query, web-interface sparql showed non-english literals correctly. But then I tried to get these strings using .NET provider virtado3... and received garbage. As these strings are returned correctly through standard web-interface, the most probable problem reason was ADO.NET provider. I have looked through it's code using Reflector and found some code like: Encoding.GetEncoding(iso-8859-1).GetBytes(s) As iso-8859-1 is one-byte encoding, I think non-english symbols are just lost during conversion. Would be very grateful for any comments about this approach. 2010/1/30 Alexander Sidorov alexi...@gmail.com Hi Hugh, I have localized the problem and can be more specific now. I use two ways to add triples to the store: 1. SPARQL INSERT DATA query 2. DB.DBA.TTLP stored procedure The first way work normally, but the second stores triples with incorrect encoding (and nonenglish literals are displayed wrong). Regards, Alexander 2010/1/29 Hugh Williams hwilli...@openlinksw.com Hi Alexander, By what means are you inserting and retrieving the literals ? What are the literal values being inserted and what are the values that are being retrieved incorrectly ? If you can provide minimal steps to reproduce then we can attempt recreation in-house ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 29 Jan 2010, at 14:41, Alexander Sidorov wrote: Hello! I am using Virtuoso Open Source 5 and have problems storing and retrieving non-english literals. Virtuoso.ini: Charset = UTF-8 Is this a known problem? Regards, Alexander -- The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] Virtuoso Open Source 6 binaries
Hello! Are Virtuoso Open Source 6 binaries available? Regards, Alexander
Re: [Virtuoso-users] Virtuoso Open Source 6 binaries
Hi Hugh, Yes, I am seeking Windows x64 binaries. Regards, Alexander 2010/1/31 Hugh Williams hwilli...@openlinksw.com Hi Alexander, Normally we do provide Virtuoso Open Source binaries for Windows only, although we have not produced a set for Virtuoso 6.0.0 yet, but will be for the upcoming 6.0.1 release due out next week. Is it windows binaries you are seeking ? Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 31 Jan 2010, at 09:12, Alexander Sidorov wrote: Hello! Are Virtuoso Open Source 6 binaries available? Regards, Alexander -- The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] dif:contains relevance
Hello! Does bif:contains support relevance? Can I order query results according to bif:contains? Regards, Alexander
[Virtuoso-users] Virtuoso 6.1
Hello! I can't download Virtuoso 6.1 Open Source from sourceforge. Tried several mirrors but no result. Are there any non-sourceforge mirrors? And what about binaries? Regards, Alexander
[Virtuoso-users] OWL reasoning
Hello! Virtuoso 6.1 contains some new OWL semantics support. And it makes me happy :) But at the moment I do not understand how OWL semantics is integrated into Virtuoso (primarily RDFS) reasoner. Some questions: 1. What about things like owl:Thing, owl:Nothing, owl:TopDataProperty, owl:BottomDataProperty (and the same for object properties)? Does reasoner know about them? 2. Does reasoner know, for example, that owl:ObjectProperty is subset of rdf:Property? Regards, Alexander
[Virtuoso-users] Windows build manual
Hello! Is there any more up-to-date build manual for Windows that thishttp://www.openlinksw.com/dataspace/dav/wiki/Main/VOSMakeWindows ? Regards, Alexander
Re: [Virtuoso-users] Windows build manual
Hello! Are there any news about Windows binaries? Regards, Alexander 2010/2/6 Patrick van Kleef pkl...@openlinksw.com Hi Alexander, Is there any more up-to-date build manual for Windows that this? The scripts are all up to date in both win32 and win64 directories, and while doc may need some attention, for the most part it should give you reasonable idea of how to perform a build yourself. However since Windows is not an easy option for most people to build, we will be uploading our builds for virtuoso open source 6.1.0 as soon as possible. Expect them some time Monday. Patrick
Re: [Virtuoso-users] Windows build manual
Hi, Hugh I am seeking 32bit version for my developer machine and 64bit for our test server :) Geo data integration is one of the last stages of our product development, that's why I will need it in about month or two (and as we discussed, I will use Amazon EC2 for it). Regards, Alexander 2010/2/10 Hugh Williams hwilli...@openlinksw.com Hi Alexander, You much have a sixth sense as these are being tested currently :) Is it a 32 or 64 bit windows build you are seeking ? Note as mentioned to you previously the open source builds do not include GEO support ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 10 Feb 2010, at 00:57, Alexander Sidorov wrote: Hello! Are there any news about Windows binaries? Regards, Alexander 2010/2/6 Patrick van Kleef pkl...@openlinksw.com Hi Alexander, Is there any more up-to-date build manual for Windows that this? The scripts are all up to date in both win32 and win64 directories, and while doc may need some attention, for the most part it should give you reasonable idea of how to perform a build yourself. However since Windows is not an easy option for most people to build, we will be uploading our builds for virtuoso open source 6.1.0 as soon as possible. Expect them some time Monday. Patrick -- SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Virtuoso 5 encoding problems
Hello! Are there any news about about ADO.NET provider encoding problems? Regards, Alexander 2010/1/30 Alexander Sidorov alexi...@gmail.com So I have succeeded in uploading graph to database, but looks like it is not the end of the story :) After triples were uploaded using SPARQL INSERT DATA query, web-interface sparql showed non-english literals correctly. But then I tried to get these strings using .NET provider virtado3... and received garbage. As these strings are returned correctly through standard web-interface, the most probable problem reason was ADO.NET provider. I have looked through it's code using Reflector and found some code like: Encoding.GetEncoding(iso-8859-1).GetBytes(s) As iso-8859-1 is one-byte encoding, I think non-english symbols are just lost during conversion. Would be very grateful for any comments about this approach. 2010/1/30 Alexander Sidorov alexi...@gmail.com Hi Hugh, I have localized the problem and can be more specific now. I use two ways to add triples to the store: 1. SPARQL INSERT DATA query 2. DB.DBA.TTLP stored procedure The first way work normally, but the second stores triples with incorrect encoding (and nonenglish literals are displayed wrong). Regards, Alexander 2010/1/29 Hugh Williams hwilli...@openlinksw.com Hi Alexander, By what means are you inserting and retrieving the literals ? What are the literal values being inserted and what are the values that are being retrieved incorrectly ? If you can provide minimal steps to reproduce then we can attempt recreation in-house ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 29 Jan 2010, at 14:41, Alexander Sidorov wrote: Hello! I am using Virtuoso Open Source 5 and have problems storing and retrieving non-english literals. Virtuoso.ini: Charset = UTF-8 Is this a known problem? Regards, Alexander -- The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] Virtuoso at Amazon EC2 price
Hello! I am very glad to know Virtuso Cloud Edition price for Amazon EC2 is so democratic :) But it is so much cheaper than other commercial Virtuoso editions that I would like to ask is it really fully-functional Virtuoso or may be there are some limitations (connections quantity or something else). Regards, Alexander
Re: [Virtuoso-users] Virtuoso at Amazon EC2 price
Hi Kingsley, I'm planning to use Virtuoso Cloud Edition at web-service that theoretically can have hundreds and thousands of connections. So limitation to 25 sessions looks critical. So 2 questions: 1. Is there any way to overcome this limitation? If not, 2. Can Virtuoso execute several queries using one shared connection simultaneously? Regards, Alexander 2010/2/10 Kingsley Idehen kide...@openlinksw.com Alexander Sidorov wrote: Hello! I am very glad to know Virtuso Cloud Edition price for Amazon EC2 is so democratic :) But it is so much cheaper than other commercial Virtuoso editions that I would like to ask is it really fully-functional Virtuoso or may be there are some limitations (connections quantity or something else). Regards, Alexander -- SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users The only limitation is the 25 DB sessions threshold, at the current time. -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen
Re: [Virtuoso-users] Virtuoso at Amazon EC2 price
And what is the price? 2010/2/10 Kingsley Idehen kide...@openlinksw.com Alexander Sidorov wrote: Hi Kingsley, I'm planning to use Virtuoso Cloud Edition at web-service that theoretically can have hundreds and thousands of connections. So limitation to 25 sessions looks critical. So 2 questions: 1. Is there any way to overcome this limitation? If not, 2. Can Virtuoso execute several queries using one shared connection simultaneously? You get a license from us that removes the limit. Kingsley Regards, Alexander 2010/2/10 Kingsley Idehen kide...@openlinksw.com mailto: kide...@openlinksw.com Alexander Sidorov wrote: Hello! I am very glad to know Virtuso Cloud Edition price for Amazon EC2 is so democratic :) But it is so much cheaper than other commercial Virtuoso editions that I would like to ask is it really fully-functional Virtuoso or may be there are some limitations (connections quantity or something else). Regards, Alexander -- SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users The only limitation is the 25 DB sessions threshold, at the current time. -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen
Re: [Virtuoso-users] Virtuoso at Amazon EC2 price
And one more detail. Is this restriction applied to each EC2 instance or totally to AWS account? 2010/2/10 Kingsley Idehen kide...@openlinksw.com Alexander Sidorov wrote: And what is the price? For how many DB sessions? Or are you seeking this to be unrestricted? Anyway, we are going to revise a few things re. EC2 (any minute now, once the commercial release is out), so you might also want to wait until then. Kingsley 2010/2/10 Kingsley Idehen kide...@openlinksw.com mailto: kide...@openlinksw.com Alexander Sidorov wrote: Hi Kingsley, I'm planning to use Virtuoso Cloud Edition at web-service that theoretically can have hundreds and thousands of connections. So limitation to 25 sessions looks critical. So 2 questions: 1. Is there any way to overcome this limitation? If not, 2. Can Virtuoso execute several queries using one shared connection simultaneously? You get a license from us that removes the limit. Kingsley Regards, Alexander 2010/2/10 Kingsley Idehen kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com Alexander Sidorov wrote: Hello! I am very glad to know Virtuso Cloud Edition price for Amazon EC2 is so democratic :) But it is so much cheaper than other commercial Virtuoso editions that I would like to ask is it really fully-functional Virtuoso or may be there are some limitations (connections quantity or something else). Regards, Alexander -- SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users The only limitation is the 25 DB sessions threshold, at the current time. -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen
Re: [Virtuoso-users] Virtuoso at Amazon EC2 price
It's very difficult to estimate connections quantity for web application... but I think 300 will be enough for the beginning. Could you provide new Cloud Edition limitation/limitations when it is cleared? 2010/2/10 Kingsley Idehen kide...@openlinksw.com Alexander Sidorov wrote: And what is the price? For how many DB sessions? Or are you seeking this to be unrestricted? Anyway, we are going to revise a few things re. EC2 (any minute now, once the commercial release is out), so you might also want to wait until then. Kingsley 2010/2/10 Kingsley Idehen kide...@openlinksw.com mailto: kide...@openlinksw.com Alexander Sidorov wrote: Hi Kingsley, I'm planning to use Virtuoso Cloud Edition at web-service that theoretically can have hundreds and thousands of connections. So limitation to 25 sessions looks critical. So 2 questions: 1. Is there any way to overcome this limitation? If not, 2. Can Virtuoso execute several queries using one shared connection simultaneously? You get a license from us that removes the limit. Kingsley Regards, Alexander 2010/2/10 Kingsley Idehen kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com Alexander Sidorov wrote: Hello! I am very glad to know Virtuso Cloud Edition price for Amazon EC2 is so democratic :) But it is so much cheaper than other commercial Virtuoso editions that I would like to ask is it really fully-functional Virtuoso or may be there are some limitations (connections quantity or something else). Regards, Alexander -- SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users The only limitation is the 25 DB sessions threshold, at the current time. -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen
Re: [Virtuoso-users] Virtuoso at Amazon EC2 price
So one licence per Amazon instance? 2010/2/10 Kingsley Idehen kide...@openlinksw.com Alexander Sidorov wrote: And one more detail. Is this restriction applied to each EC2 instance or totally to AWS account? Each AMI has a license that applies to the Virtuoso instances on the machine. Kingsley 2010/2/10 Kingsley Idehen kide...@openlinksw.com mailto: kide...@openlinksw.com Alexander Sidorov wrote: And what is the price? For how many DB sessions? Or are you seeking this to be unrestricted? Anyway, we are going to revise a few things re. EC2 (any minute now, once the commercial release is out), so you might also want to wait until then. Kingsley 2010/2/10 Kingsley Idehen kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com Alexander Sidorov wrote: Hi Kingsley, I'm planning to use Virtuoso Cloud Edition at web-service that theoretically can have hundreds and thousands of connections. So limitation to 25 sessions looks critical. So 2 questions: 1. Is there any way to overcome this limitation? If not, 2. Can Virtuoso execute several queries using one shared connection simultaneously? You get a license from us that removes the limit. Kingsley Regards, Alexander 2010/2/10 Kingsley Idehen kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com Alexander Sidorov wrote: Hello! I am very glad to know Virtuso Cloud Edition price for Amazon EC2 is so democratic :) But it is so much cheaper than other commercial Virtuoso editions that I would like to ask is it really fully-functional Virtuoso or may be there are some limitations (connections quantity or something else). Regards, Alexander -- SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users The only limitation is the 25 DB sessions threshold, at the current time. -- Regards, Kingsley Idehen President CEO OpenLink SoftwareWeb: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen -- Regards
Re: [Virtuoso-users] Virtuoso at Amazon EC2 price
I love OpenLink more and more :) Thank you! 2010/2/10 Kingsley Idehen kide...@openlinksw.com Alexander Sidorov wrote: And one more detail. Is this restriction applied to each EC2 instance or totally to AWS account? Re. default license, this is now 100 instead of 25 :-) Beyond that, you can contact us for 100, all the way up to unrestricted. Kingsley 2010/2/10 Kingsley Idehen kide...@openlinksw.com mailto: kide...@openlinksw.com Alexander Sidorov wrote: And what is the price? For how many DB sessions? Or are you seeking this to be unrestricted? Anyway, we are going to revise a few things re. EC2 (any minute now, once the commercial release is out), so you might also want to wait until then. Kingsley 2010/2/10 Kingsley Idehen kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com Alexander Sidorov wrote: Hi Kingsley, I'm planning to use Virtuoso Cloud Edition at web-service that theoretically can have hundreds and thousands of connections. So limitation to 25 sessions looks critical. So 2 questions: 1. Is there any way to overcome this limitation? If not, 2. Can Virtuoso execute several queries using one shared connection simultaneously? You get a license from us that removes the limit. Kingsley Regards, Alexander 2010/2/10 Kingsley Idehen kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com mailto:kide...@openlinksw.com Alexander Sidorov wrote: Hello! I am very glad to know Virtuso Cloud Edition price for Amazon EC2 is so democratic :) But it is so much cheaper than other commercial Virtuoso editions that I would like to ask is it really fully-functional Virtuoso or may be there are some limitations (connections quantity or something else). Regards, Alexander -- SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users The only limitation is the 25 DB sessions threshold, at the current time. -- Regards, Kingsley Idehen President CEO OpenLink SoftwareWeb: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen
[Virtuoso-users] Database GUI
Hello! Is there any user-friendly tool for working with DDL queries to Virtuoso? May be some tool supports Virtuoso? Regards, Alexander
Re: [Virtuoso-users] Database GUI
Hi Kingsley, Thank you for useful videos! But my problem is that I get 404 http error when I try to choose connection string at dbdesigner. What is the absolute path to XMLA endpoint? I tried to set it to myIp:8890/XMLA and myIp:/XMLA but it didn't help. Regards, Alexander 2010/2/14 Kingsley Idehen kide...@openlinksw.com Alexander Sidorov wrote: Hi Kingsley, OAT demo lookes very promising, but it didn't work for me (see attachment). So I will try it later :) Re. OAT, once we're done with updates and code sync I'll put out some new demos. The DBDesigner is at: http://demo.openlinksw.com/dbdesigner/ (I've set the Demo DB to defaults to you accept what's presented to you when challenged after watching the video [2]) . Links: 1. http://www.openlinksw.com/dataspace/%7Ekidehen/blog/public/Screencasts/oat-formdesigner-mashup-google-maps-demo1.mov-- FormsDesigner screencast demos (silent) from a few years ago (2006 or so) 2. http://my-movies.s3.amazonaws.com/oat_db_designer.mov -- quick movie I knocked up to show you how the DBDesigner works 3. http://demo.openlinksw.com/DAV/home/demo/Public/test_db_design.xml -- DDL file from Save Operation Kingsley Regards, Alexander 2010/2/13 Kingsley Idehen kide...@openlinksw.com mailto: kide...@openlinksw.com Alexander Sidorov wrote: Hello! Is there any user-friendly tool for working with DDL queries to Virtuoso? May be some tool supports Virtuoso? Regards, Alexander -- SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net mailto:Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users If using ODBC, JDBC, ADO.NET http://ADO.NET, or OLE DB, you should simply leverage compliant tools that offer SQL DDL functionality. Within Virtuoso you have some limited functionality of DDL assistance in the Conductor; basically, some code generators. You may also want to look at our OAT toolkit (an open source project) that has a DB Designer and Forms Designer component, the only problem is that OAT is in flux right now :-( Once we are done with complete V6.1 release effort, we will be attending to OAT. Links: 1. http://oat.openlinksw.com -- see applications demos re. Ajax Database Connectivity 2. http://sourceforge.net/projects/oat/ . -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen
Re: [Virtuoso-users] Database GUI
Hi Kingsley, OAT demo lookes very promising, but it didn't work for me (see attachment). So I will try it later :) Regards, Alexander 2010/2/13 Kingsley Idehen kide...@openlinksw.com Alexander Sidorov wrote: Hello! Is there any user-friendly tool for working with DDL queries to Virtuoso? May be some tool supports Virtuoso? Regards, Alexander -- SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users If using ODBC, JDBC, ADO.NET, or OLE DB, you should simply leverage compliant tools that offer SQL DDL functionality. Within Virtuoso you have some limited functionality of DDL assistance in the Conductor; basically, some code generators. You may also want to look at our OAT toolkit (an open source project) that has a DB Designer and Forms Designer component, the only problem is that OAT is in flux right now :-( Once we are done with complete V6.1 release effort, we will be attending to OAT. Links: 1. http://oat.openlinksw.com -- see applications demos re. Ajax Database Connectivity 2. http://sourceforge.net/projects/oat/ . -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen attachment: DbDesigner.png
[Virtuoso-users] ADO.NET provider Virtuoso 6.1 compatibility
Hello! Is ADO.NET provider compatible with Virtuoso 6.1? When I try to add tables through Visual Studio EF-designer, Virtuoso works strange, it's process size raises significantly (even if there is no user data) and finally designer throws an exception telling that MaxMemPoolSize (500mb) limit is not enough. Regards, Alexander
[Virtuoso-users] input:same-as and labels
Hello! First, I would like to ask a question: does same-as inference is enabled automatically when I set DEFINE input-inference ruleSetName? When I set just input-inference, everything is okay. But when I additionally set same-as inferencing this way: DEFINE input:inference ruleSetName DEFINE input:same-as yes rdfs:labels disappear from query results. And probably this behaviour is spread not only to labels... Regards, Alexander
Re: [Virtuoso-users] ADO.NET provider Virtuoso 6.1 compatibility
Hi Hugh, Sorry for the delay: I'm in a business trip now. I have tried new provider but the problem is still reproducable. I didn't apply Virtuoso Open Source patch that you provided together with new EF-provider that fixed encoding problems. Could it help? I have no time to provide you some additional information at the moment, but you can connect to ip 79.136.196.8 using default credentials from Visual Studio and try to add some table to designer (for example, Users). Or I will provide more information later. Regards, Alexander 2010/2/15 Hugh Williams hwilli...@openlinksw.com Hi Alexander, What is the version number of the Virtuoso ADO.Net Provider (virtado3.dll) you are using , checking the properties for the DLL or its version information in the GAC Assembly should provide this information ? The latest version of the Virtuoso ADO.Net Provider can be downloaded from the following location: ftp://download.openlinksw.com/support/virtuoso/virtado3.dll Note we are still to finalise the fix for the encoding issues you reported with the Provider and also an issue with object values and URIs not being differentiated with v6, so their will be an updated provider and server with fixes for these issues: Should you problem adding tables persist please provide the steps to reproduce and also enable tracing on the server and provider the resultant virtuoso.log file created. Details on enabling tracing on the server can be found at: http://docs.openlinksw.com/virtuoso/fn_trace_on.html Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 14 Feb 2010, at 23:17, Alexander Sidorov wrote: Hello! Is ADO.NET provider compatible with Virtuoso 6.1? When I try to add tables through Visual Studio EF-designer, Virtuoso works strange, it's process size raises significantly (even if there is no user data) and finally designer throws an exception telling that MaxMemPoolSize (500mb) limit is not enough. Regards, Alexander -- SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] Multiple graphs in one ruleset
Hello! Documentation says It is possible to combine multiple schema graphs into a single rule set, but how to implement this? If I try to use rdfs_rule_set with one name but different graphs only the last one is used. Also I tried to create graph group and rdfs_rule_set to it, but it didn't work too. What I really need is to split TBox and ABox into different graphs to be able clear and upload new TBox when I need. Regards, Alexander
Re: [Virtuoso-users] Multiple graphs in one ruleset
Hi, Jürgen
That's what I really have done: I uploaded all ontologies to one graph
(let's call it TBox). But I have one more graph with content (ABox). I need
inference on both of these graphs, but I don't want to combine them into one
graph.
Regards,
Alexander
2010/2/22 Jürgen Jakobitsch jakobits...@punkt.at
hi alex,
you need to first import different ontologies into one single graph
and then make a ruleset of this graph.
like so
DB.DBA.RDF_LOAD_RDFXML (http_get ('
http://www.w3.org/2009/08/skos-reference/skos-owl1-dl.rdf'http://www.w3.org/2009/08/skos-reference/skos-owl1-dl.rdf%27),
'no', 'urn:rulegraph');
DB.DBA.RDF_LOAD_RDFXML (http_get
('http://www.w3.org/2002/07/owl.rdf'http://www.w3.org/2002/07/owl.rdf%27),
'no', 'urn:rulegraph');
rdfs_rule_set ('rules', 'urn:rulegraph');
wkr www.turnguard.com
- Original Message -
From: Alexander Sidorov alexi...@gmail.com
To: Virtuoso Users virtuoso-users@lists.sourceforge.net
Sent: Monday, February 22, 2010 9:55:42 AM
Subject: [Virtuoso-users] Multiple graphs in one ruleset
Hello!
Documentation says It is possible to combine multiple schema graphs into a
single rule set, but how to implement this? If I try to use rdfs_rule_set
with one name but different graphs only the last one is used. Also I tried
to create graph group and rdfs_rule_set to it, but it didn't work too.
What I really need is to split TBox and ABox into different graphs to be
able clear and upload new TBox when I need.
Regards,
Alexander
--
Download Intel#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
punkt. netServices
__
Jürgen Jakobitsch
Codeography
Lerchenfelder Gürtel 43 Top 5/2
A - 1160 Wien
Tel.: 01 / 897 41 22 - 29
Fax: 01 / 897 41 22 - 22
netServices http://www.punkt.at
Re: [Virtuoso-users] Multiple graphs in one ruleset
Hi Kingsley, Thank you for clarifications. I have just misunderstood rdfs_rule_set concept :( Now the problem is solved. Regards, Alexander 2010/2/22 Kingsley Idehen kide...@openlinksw.com Alexander Sidorov wrote: Hello! Documentation says It is possible to combine multiple schema graphs into a single rule set, but how to implement this? This means putting triples from many graphs into a new graph IRI. If I try to use rdfs_rule_set with one name but different graphs only the last one is used. Also I tried to create graph group and rdfs_rule_set to it, but it didn't work too. No you use one graph IRI, in this case the one that has the TBox triples merged in from other Graphs. What I really need is to split TBox and ABox into different graphs to be able clear and upload new TBox when I need. This is how it works i.e. you put the OWL and RDFs triples in a Named Graph that is associated with a Named Rule. Then when you execute SPARQL Queries (in general or specifically scoped to the ABox Named Graph) you apply the inference rules pragmas. Kingsley Regards, Alexander -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen
Re: [Virtuoso-users] Multiple graphs in one ruleset
Hi Ivan, Thank you for implementing graph groups support for inference schemas. You said then add your TBox and ABox graphs to that group, but I see no sense to add ABox to schema as Virtuoso doesn't support any OWL features that mix TBox and ABox (for example, oneOf restriction). Regards, Alexander 2010/2/25 Ivan Mikhailov imikhai...@openlinksw.com Hello Alexander, As proven by studying the code, the support of multiple schema graphs become seriously incomplete as inference was extended more and more. Even worse, an attempt to extend it mechanically to coven new inference features would cause slow loading of big rule sets in big databases. As a consequence, I've rewritten the rule set loader in such a way that it loads ontology data faster and it can load from graph groups, not only from plain graph. So it will be possible to create a graph group as described in http://docs.openlinksw.com/virtuoso/rdfgraphsecurity.html#rdfgraphsecuritygroups then add your TBox and ABox graphs to that group and use a single procedure call to load the whole graph group. The fix is in the internal CVS and will appear in the nearest snapshot or release of VOS. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Mon, 2010-02-22 at 09:55 +0100, Alexander Sidorov wrote: Hello! Documentation says It is possible to combine multiple schema graphs into a single rule set, but how to implement this? If I try to use rdfs_rule_set with one name but different graphs only the last one is used. Also I tried to create graph group and rdfs_rule_set to it, but it didn't work too. What I really need is to split TBox and ABox into different graphs to be able clear and upload new TBox when I need. Regards, Alexander
Re: [Virtuoso-users] FreeText manual update
Hi Patrick,
Thank you for the link. It really clarified how this stored procedure works.
But it looks like this phrase from documentation is incorrect:
To set the text index to follow the triples in real time, use:
DB.DBA.VT_BATCH_UPDATE ('DB.DBA.RDF_OBJ', 'ON', null);
As I understand, 'ON' should be replaced by 'OFF'.
Regards,
Alexander
[Virtuoso-users] Autoincrement rdf field
Hello! What is the preferred way of stroring autoincrement values in RDF-storage? Now I just use GUIDs (but don't like them) and have some workaround ideas of using relational table's autoincrement field values at RDF-storage. But may be there is some build-in support? Regards, Alexander
[Virtuoso-users] Free text index update
Hello!
My message about possible error in
documentationhttp://docs.openlinksw.com/virtuoso/rdfsparqlrulefulltext.htmlwas
ignored, so once more :) Do I understand right that to make free text
index update synchronously I should execute the following code:
DB.DBA.VT_BATCH_UPDATE ('DB.DBA.RDF_OBJ', *'OFF'*, null);
If yes, I think there is an error in documentation:
To set the text index to follow the triples in real time, use:
DB.DBA.VT_BATCH_UPDATE ('DB.DBA.RDF_OBJ', 'ON', null);
Regards,
Alexander
Re: [Virtuoso-users] Storing uris
Hi Nathan, I use SPARUL. Regards, Alexander 2010/2/26 Nathan nat...@webr3.org Alexander Sidorov wrote: Hello! What is the best way of storing properties' values that are uris: as literal (http://somgraph#somename;) or as uri (http://somegraph#somename). May be there are some specific built in functions for one of this ways... normally (always) as URIs - as for the method it depends on your context, how are you getting info in to virtuoso? Many Regards Nathan
Re: [Virtuoso-users] Storing uris
Hi Nathan, But Virtuoso will do all right even if I save uri value as literal http://a.uri; :) For example: scienceConferenceUri typeOfScience http://uri#mathematics; When I save object properties values I always see some kind of dualism :) On the one hand, object property is a uri (reference to some individual) and I should add it using uri syntax http://uri#mathematics. On the other hand, Virtuoso at the moment doesn't support object/data properties semantics that's why I can store value as literal. Now I do it the second way because it unifies my SPARQL queries: I can search literals and uri values the same way. What I mean by unifying is that if you add the value using uri syntax and then try to query it using literal syntax it won't work (obviously). I have created this post to find out some unique features of both approaches. Regards, Alexander 2010/2/26 Nathan nat...@webr3.org Alexander Sidorov wrote: I use SPARUL. In that case it's just a simple http://a.uri which denotes the type of the uri :) virtuoso will do the rest 2010/2/26 Nathan nat...@webr3.org Alexander Sidorov wrote: Hello! What is the best way of storing properties' values that are uris: as literal (http://somgraph#somename;) or as uri (http://somegraph#somename). May be there are some specific built in functions for one of this ways... normally (always) as URIs - as for the method it depends on your context, how are you getting info in to virtuoso? Many Regards Nathan
Re: [Virtuoso-users] Autoincrement rdf field
Hi Ivan,
Thank you for information: it is really what I need. I have replaced my
entities' GUIDs with sequence generated integers.
The one question about sequences arised during documentation reading.
Sequence_next
bif documentationhttp://docs.openlinksw.com/virtuoso/fn_sequence_next.htmlsays
it returns integer (32 bits) and cluster edition documentation
says
http://docs.openlinksw.com/virtuoso/clusterprogrammingseqidenreg.htmlsequence
returns 64-bit integer. Is it cluster edition specific? I remember
I read about some Virtuoso mechanism that upgrades 32-bit values to 64-bit
values (can't find it now). Does it work for sequences?
Regards,
Alexander
2010/2/26 Ivan Mikhailov imikhai...@openlinksw.com
Hello Alexander,
You may use sequence_next()
(http://docs.openlinksw.com/virtuoso/fn_sequence_next.html) BIF as
source of autoincremented integers.
However this function should be used with care in SPARUL statements as
well as in UPDATE SQL statement. The optimizer does not know that the
function returns new value every time so it may decide to call it once
at the beginning of the query run and reuse the result. That may not
match your intention if you manipulate a batch of different rows in a
single request. To fool the optimizer, pass fake third argument to the
function such as a primary key of the updated row or fields of inserted
rows or the like, i.e. something that obviously can not be calculated in
advance. The function will ignore them but the optimizer will be fooled
in a desired way.
To construct sequential IRIs, the popular trick is
IRI(bif:sprintf('...%d...', bif:sequence_next ('mysequence',
1, ?some_variable_from_select)))
Wrap an expression like this in backquotes and use in constructor
template instead of a plain variable, that's all.
Note that bif:sprintf should form an absolute IRI as namespace prefixes
and BASE will not play any role at the runtime.
Best Regards,
Ivan Mikhailov
OpenLink Software
http://virtuoso.openlinksw.com
On Fri, 2010-02-26 at 11:54 +0100, Alexander Sidorov wrote:
Hello!
What is the preferred way of stroring autoincrement values in
RDF-storage? Now I just use GUIDs (but don't like them) and have some
workaround ideas of using relational table's autoincrement field
values at RDF-storage. But may be there is some build-in support?
Regards,
Alexander
Re: [Virtuoso-users] Complex search based on Virtuoso Free Text Search
Hi Nathan,
Thank you very much! You helped me significantly.
After your message receiving I googled more about IRI:RANK and bif:contains
and found some interesting information:
1. Orri Erling's article More On Parallel RDF/Text Query
Evaluationhttp://www.openlinksw.com/dataspace/oerling/weblog/Orri%20Erling%27s%20Blog/1570
2. Something very similar to my needs is implemented at Faceted View
service. That's why all documents describing it contain some useful
information: first of all, the article called Faceted Views over LargeScale
Linked Data http://www.openlinksw.com/weblog/oerling/lodw2.pdf.
Regards,
Alexander
2010/2/28 Nathan nat...@webr3.org
Nathan wrote:
SELECT DISTINCT ?s (sum(?oscore)) as ?finalWeight WHERE {
{ select ?s (xsd:integer( ?oscore * 1.4 )) as ?weight where {
?s predicate1 ?o . ?o bif:contains 'search text' option(score
?oscore)
} } UNION {
{ select ?s (xsd:integer( ?oscore * 1.8 )) as ?weight where {
?s predicate2 ?o . ?o bif:contains 'search text' option(score
?oscore)
}
} GROUP BY ?s
ORDER BY desc(?finalWeight)
correction, that first line should be:
SELECT DISTINCT ?s (sum(?weight)) as ?finalWeight WHERE {
also realised I forgot to point out the two different modifiers, 1.8 and
1.4 which does the weighting!
regards
[Virtuoso-users] Free Text Search nonenglish symbols
Hello!
I'm trying to find some information at lod.openlinksw.com using simple
query:
SELECT * WHERE { ?s ?p ?o . ?o bif:contains Some non english literal }
As result I get an error telling Invalid character in free-text search
expression, it may not appear outside quoted string. I there any way to
solve this problem?
Regards,
Alexander
Re: [Virtuoso-users] Free Text Search nonenglish symbols
Hi Hugh,
Thank you, that helped. But there are a lot of examples at documentation
that use just double quotes...
Regards,
Alexander
2010/3/4 Hugh Williams hwilli...@openlinksw.com
Hi Alexander,
Try the following:
SELECT * WHERE { ?s ?p ?o . ?o bif:contains 'Some non english literal' }
Note the addition of single quotes within the double quotes which is how
Virtuoso handles phrases in bif:contains.
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 4 Mar 2010, at 13:20, Alexander Sidorov wrote:
Hello!
I'm trying to find some information at lod.openlinksw.com using simple
query:
SELECT * WHERE { ?s ?p ?o . ?o bif:contains Some non english literal }
As result I get an error telling Invalid character in free-text search
expression, it may not appear outside quoted string. I there any way to
solve this problem?
Regards,
Alexander
--
Download Intel#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] Access nonlocal Virtuoso instance
Hello! I have installed Virtuoso and set System DSN using state white ip address. Virtuoso is accessed from local computer, but throws No such host exception at other computers. At the same time conductior is accessed without any problems. Firewall is switched off. Are there any additional activities to make Virtuoso accessible through the Internet? Regards, Alexander
Re: [Virtuoso-users] Free Text Search nonenglish symbols
Hi Hugh,
Have I understood right that bif:contains' query hello and world is equal
to 'hello' and 'world'? If yes, it looks very inconvenient. Imagine the
situation when user enters a query and then my application gives it to
Virtuoso Full Text Search. Of course I will give it using just one string
'hello and world'. So Full Text Search will use and as literal. Of
course I can parse this query before sending to Virtuoso, but I don't think
it's a good idea: 1. Virtuoso knows better what predicates and in what cases
it understands 2. this behaviour may change from version to version, that's
why it should be encapsulated into Virtuoso.
Regards,
Alexander
2010/3/4 Hugh Williams hwilli...@openlinksw.com
Hi Alexander,
If you can point out an such incorrect examples in the documentation then
we can fix them.
Do we aware that and and or act as a logical operators in bif:contains
and thus do not require the extra quoting in string searches, so you can
have:
bif:contains (?text, hello and world)
but not:
bif:contains (?text, hello world)
which needs the additional single quoting:
bif:contains (?text, 'hello world')
See the docs at the following location for more examples:
http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfpredicatessparqlexamples
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 4 Mar 2010, at 19:54, Alexander Sidorov wrote:
Hi Hugh,
Thank you, that helped. But there are a lot of examples at documentation
that use just double quotes...
Regards,
Alexander
2010/3/4 Hugh Williams hwilli...@openlinksw.com
Hi Alexander,
Try the following:
SELECT * WHERE { ?s ?p ?o . ?o bif:contains 'Some non english literal' }
Note the addition of single quotes within the double quotes which is how
Virtuoso handles phrases in bif:contains.
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 4 Mar 2010, at 13:20, Alexander Sidorov wrote:
Hello!
I'm trying to find some information at lod.openlinksw.com using simple
query:
SELECT * WHERE { ?s ?p ?o . ?o bif:contains Some non english literal }
As result I get an error telling Invalid character in free-text search
expression, it may not appear outside quoted string. I there any way to
solve this problem?
Regards,
Alexander
--
Download Intel#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] lod.openlinksw.com endpoint encoding
Hello!
Is all lod.openlinksw.com content encoded using UTF8? For example, when I
execute the following query:
SELECT * WHERE {http://linkedgeodata.org/triplify/node/163043169#id ?p ?o}
I expect cyrillic letters at the name but get some strange symbols. I tried
on another PC (thought it could be some problems with my PC), but with no
success.
Regards,
Alexander
Re: [Virtuoso-users] SPARQL select only one optional value
Thank you, Ivan. That's what I really need :)
2010/3/12 Ivan Mikhailov imikhai...@openlinksw.com
Hello Alexander,
I need to get some cities with it's names. And here is my query:
SELECT DISTINCT ?cityUri ?cityName
WHERE
{
?cityUri ?predicate ?value.
?cityUri a http://linkedgeodata.org/vocabulary#city.
?value bif:contains someCity.
OPTIONAL
{
?cityUri
http://linkedgeodata.org/vocabulary#name ?cityName
}
}
But when there are several names for one city I get duplicated cities.
Of course I can remove duplicates after retrieving the result, but
it's ugly. Is there any way to limit optional parameters (for example,
as adding Limit to query)?
My favorite cheating is
SELECT DISTINCT ?cityUri (MAX(?cityName)) as ?name
...
that eliminates redundant names. If names differs in language then
recent Virtuosos let you choose best suitable name based on browser
preferences, e.g.
SELECT DISTINCT
?cityUri
(sql:BEST_LANGMATCH (?cityName, 'ru, en-gb;q=0.8, en;q=0.7, *;q=0.1',
'')) as ?bestCityName
...
Best Regards,
Ivan Mikhailov
OpenLink Software
http://virtuoso.openlinksw.com
[Virtuoso-users] lod.openlinksw.com is down
Re: [Virtuoso-users] lod.openlinksw.com is down
Hi Ted, It's fine for me too at the moment :) But lod.openlinksw.com was unreachable for nearly 20 minutes recently. Regards, Alexander 2010/3/16 Ted Thibodeau Jr tthibod...@openlinksw.com Hi, Alexander -- On Mar 15, 2010, at 08:26 PM, Alexander Sidorov wrote: [no message content] http://lod.openlinksw.com/ looks fine to me from here ... Can you provide more detail about the issue you're seeing? Thanks, Ted -- A: Yes. http://www.guckes.net/faq/attribution.html | Q: Are you sure? | | A: Because it reverses the logical flow of conversation. | | | Q: Why is top posting frowned upon? Ted Thibodeau, Jr. // voice +1-781-273-0900 x32 Evangelism Support //mailto:tthibod...@openlinksw.com // http://twitter.com/TallTed OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 http://www.openlinksw.com/weblogs/uda/ OpenLink Blogs http://www.openlinksw.com/weblogs/virtuoso/ http://www.openlinksw.com/blog/~kidehen/http://www.openlinksw.com/blog/%7Ekidehen/ Universal Data Access and Virtual Database Technology Providers
[Virtuoso-users] lod.openlinksw.com host4 is down
Re: [Virtuoso-users] lod.openlinksw.com host4 is down
Hi Hugh, I just execute some simple geo queries, I don't think it could cause node failure. Besides the previous error differed: lod.openlinksw.com was unavailable at all. Regards, Alexander 2010/3/17 Hugh Williams hwilli...@openlinksw.com Hi Alexander, Node 4 has been brought back online. I note this to be the second time you have reported problems accessing the LOD server recently, are you performing any specific operations against it at these times that may be causing the node failure ? Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 16 Mar 2010, at 17:42, Alexander Sidorov wrote: -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] LOD encoding problems
Hello! I have already asked about LOD encoding problems before but no feedback followed. To be more expressive I have attached my application's screen shots with information about Manchester (english symbols - everything is okay) and Moscow (russian symbols are displayed incorrectly). Regards, Alexander attachment: Manchester.pngattachment: Moscow.png
Re: [Virtuoso-users] LOD encoding problems
Hi Hugh, As I remember ADO.NET encoding bug was fixed (I haven't checked because it has no sense while other Entity Framework bug you know about is not fixed). But this problem has no relation to ADO.NET. As I haven't yet deployed my application to Amazon EC2, I execute geo queries using lod.openlinksw.com/sparql endpoint using SPARQL protocol (but not using database directly). Here are my screen shots: 1. Manchester: http://img171.imageshack.us/img171/5568/manchesterk.png 2. Moscow: http://img204.imageshack.us/img204/7850/moscow.png Regards, Alexander 2010/3/17 Hugh Williams hwilli...@openlinksw.com Hi Alexander, Is this the encoding issue with the ADO.Net Provider you reported previously as that is the only one I am aware of, which is still to be resolved ? Note, their is a 40K limit on the size of emails to this mailing list thus your mail with attachment which exceeded this limit was with held pending approval initially. Please place such attachments on a remote server and provide links in your mails in future ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 17 Mar 2010, at 00:27, Alexander Sidorov wrote: Hello! I have already asked about LOD encoding problems before but no feedback followed. To be more expressive I have attached my application's screen shots with information about Manchester (english symbols - everything is okay) and Moscow (russian symbols are displayed incorrectly). Regards, Alexander Manchester.pngMoscow.png-- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] lod.openlinksw.com strange behaviour
Hi Hugh,
Could you please post here when maintanance is finished?
Is there any way to get information about lod.openlinksw.com/sparql status
changes?
Regards,
Alexander
2010/3/20 Hugh Williams hwilli...@openlinksw.com
Hi Alexander,
The lod server was down for maintenance, it is back online now ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 20 Mar 2010, at 07:14, Alexander Sidorov wrote:
Hello!
lod.openlinksw.com/sparql behaves strange today. For example, free text
search doesn't return any result:
select * where {?s ?p ?o . ?o bif:contains manchester} limit 10
Problems with index?
Regards,
Alexander
--
Download Intel#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] lod.openlinksw.com strange behaviour
Oh, it's already online.
2010/3/21 Alexander Sidorov alexi...@gmail.com
Hi Hugh,
Could you please post here when maintanance is finished?
Is there any way to get information about lod.openlinksw.com/sparql status
changes?
Regards,
Alexander
2010/3/20 Hugh Williams hwilli...@openlinksw.com
Hi Alexander,
The lod server was down for maintenance, it is back online now ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 20 Mar 2010, at 07:14, Alexander Sidorov wrote:
Hello!
lod.openlinksw.com/sparql behaves strange today. For example, free text
search doesn't return any result:
select * where {?s ?p ?o . ?o bif:contains manchester} limit 10
Problems with index?
Regards,
Alexander
--
Download Intel#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] lod.openlinksw.com strange behaviour
Hi Kingsley,
To buy my own EC2 instance is what I'm planning to do in the nearest future.
Really I would be glad to do it right now but there are two critical
problems (LinkedGeoData encoding and Entity Framework support bug) that make
me unsure I can use Virtuoso at production.
Regards,
Alexander
2010/3/21 Kingsley Idehen kide...@openlinksw.com
Alexander Sidorov wrote:
Oh, it's already online.
Alex,
What about having your own instance of LOD on EC2? Basically, you end with
an instance that serves the needs of your specific application.
This is better that sharing LOD with the rest of the world (like DBpedia)
combined with lots of changes and maintenance that hit the system etc..
Our model is really about using DBpedia and LOD instances to enable people
grok the value prop. of Linked Data, then we expect them to do one of the
following:
1. Make their own instances
- Own Data Center
- EC2
2. Negotiate an arrangement with us for SLA if customer seeks hosting from
us (this is what we did for the BBC last year as part of the steps outlined
above).
Kingsley
2010/3/21 Alexander Sidorov alexi...@gmail.com mailto:
alexi...@gmail.com
Hi Hugh,
Could you please post here when maintanance is finished?
Is there any way to get information about
lod.openlinksw.com/sparql http://lod.openlinksw.com/sparql
status changes?
Regards,
Alexander
2010/3/20 Hugh Williams hwilli...@openlinksw.com
mailto:hwilli...@openlinksw.com
Hi Alexander,
The lod server was down for maintenance, it is back online now ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 20 Mar 2010, at 07:14, Alexander Sidorov wrote:
Hello!
lod.openlinksw.com/sparql http://lod.openlinksw.com/sparql
behaves strange today. For example, free text search doesn't
return any result:
select * where {?s ?p ?o . ?o bif:contains manchester} limit 10
Problems with index?
Regards,
Alexander
--
Download Intel#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling,
find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
mailto:Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Download Intel#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Regards,
Kingsley Idehen President CEO OpenLink Software Web:
http://www.openlinksw.com
Weblog:
http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen
Twitter/Identi.ca: kidehen
Re: [Virtuoso-users] Retrieve triples for list of entities
Hi Sebastian,
I think the first query doesn't work because you are trying to filter first
subquery variable in the scope of second subquery.
Regards,
Alexander
2010/3/23 Sebastian Hellmann hellm...@informatik.uni-leipzig.de
Hello,
the IN is very fast and I would recommend to anyone using it.
btw. will IN be a part of the next SPARQL recommendation?
I have just a short question (tested on dbpedia):
SELECT DISTINCT ?subject { {
?subject a ?expanded0 } UNION {
?subject a ?expanded1 }
FILTER ( ?expanded0 IN (
http://dbpedia.org/ontology/Airlinehttp://dbpedia.org/ontology/Airline,
http://dbpedia.org/ontology/Band http://dbpedia.org/ontology/Band) ).
FILTER ( ?expanded1 IN (
http://dbpedia.org/ontology/Albumhttp://dbpedia.org/ontology/Album,
http://dbpedia.org/ontology/Book http://dbpedia.org/ontology/Book) ).
} LIMIT 50
The query above doesn't work, while this one works:
SELECT DISTINCT ?subject { {
?subject a ?expanded0 .
FILTER ( ?expanded0 IN (
http://dbpedia.org/ontology/Airlinehttp://dbpedia.org/ontology/Airline,
http://dbpedia.org/ontology/Band http://dbpedia.org/ontology/Band) ).
} UNION {
?subject a ?expanded1 .
FILTER ( ?expanded1 IN (
http://dbpedia.org/ontology/Albumhttp://dbpedia.org/ontology/Album,
http://dbpedia.org/ontology/Book http://dbpedia.org/ontology/Book) ).
} } LIMIT 50
Is there a reason behind it or just a glitch?
Regards,
Sebastian
Am 23.03.2010 02:56, schrieb Alexander Sidorov:
Hi Ivan,
Thank you! I should guess by analogy with SQL...
Does IN operator work with subqueries? I have the following query:
SELECT DISTINCT ?s ?p ?o
FROM http://www.semanticweb.org/ontologies/2010/1/EventsContent.owl#
WHERE
{
?s ?p ?o
FILTER
(
?s in
(
(
SELECT DISTINCT ?event
FROM
http://www.semanticweb.org/ontologies/2010/1/EventsContent.owl#
WHERE
{
?event ?property ?value .
?value bif:contains virtuoso OPTION (SCORE ?valueScore) .
}
GROUP BY ?event
ORDER BY DESC (sum(?valueScore))
)
)
)
}
but it returns only first event.
Regards,
Alexander
2010/3/23 Ivan Mikhailov imikhai...@openlinksw.com
Hello Alexander,
Let's imagine we have a list of entities uris' as input and we need to
retrieve all triples for each entity.
Is there any way to execute it using one query?
We have an IN operator extension:
select ?p ?o
where
{
?s ?p ?o .
filter (?s in (someGraph#entity1, someGraph#entity2, ...
someGraph#entityN ) )
}
Best Regards,
Ivan Mikhailov
OpenLink Software
http://virtuoso.openlinksw.com
--
Download Intel#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during
beta.http://p.sf.net/sfu/intel-sw-dev
___
Virtuoso-users mailing
listVirtuoso-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Dipl. Inf. Sebastian Hellmann
Department of Computer Science, University of Leipzig
Homepage: http://bis.informatik.uni-leipzig.de/SebastianHellmann
Research Group: http://aksw.org
Re: [Virtuoso-users] Retrieve triples for list of entities
I have looked through plenty of Virtuoso documentation articles and
blogposts and haven't found any IN usage with subqueries. Is it possible?
2010/3/23 Ivan Mikhailov imikhai...@openlinksw.com
Hello Alexander,
Let's imagine we have a list of entities uris' as input and we need to
retrieve all triples for each entity.
Is there any way to execute it using one query?
We have an IN operator extension:
select ?p ?o
where
{
?s ?p ?o .
filter (?s in (someGraph#entity1, someGraph#entity2, ...
someGraph#entityN ) )
}
Best Regards,
Ivan Mikhailov
OpenLink Software
http://virtuoso.openlinksw.com
[Virtuoso-users] DateTime UTC
Hello! Does Virtuoso consider UTC offsets for datetime values? I haven't seen any examples with UTC offsets at documentation... Regards, Alexander
[Virtuoso-users] Uptodate oat vad package
Hello! Where can I download uptodate oat vad package? Regards, Alexander
[Virtuoso-users] xsd:datetime type cast
Hello! I see two ways to mark RDF literal as xsd:datetime: 1. Add ^^xsd:datetime at the moment of addition it to the storage 2. Make type cast at query Is there any performance difference between these two ways? Regards, Alexander
[Virtuoso-users] SPARQL pagination
Hello!
At the moment I'm implementing pagination for my SPARQL queries and I can't
find out how to retrieve records count. By count I mean records number
that were retrieved if I didn't use OFFSET and LIMIT clauses.
Here is my sample query:
prefix events:http://www.semanticweb.org/ontologies/2010/1/Events.owl#
SELECT DISTINCT ?event, count(*)
FROM http://www.semanticweb.org/ontologies/2010/1/EventsContent.owl# WHERE
{
?event ?property ?value .
?event events:startDateTime ?startDateTime .
FILTER (xsd:dateTime(?startDateTime) =
xsd:dateTime(2010-04-11T15:04:58+07:00))
}
ORDER BY ASC (xsd:dateTime(?startDateTime))
OFFSET 0
LIMIT 10
In this case count returns value as if no filtering were applied.
Regards,
Alexander
[Virtuoso-users] System users
Hello! Documentationhttp://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtInstallationEC2says about only two system users. But there are some more users by default. Can I just remove them without any consequences? Regards, Alexander
[Virtuoso-users] ADO.NET provider stability
Hello! I need to decide can we use Virtuoso as relational storage at production or not. The most significant problem is ADO.NET provider. First we had encoding problem, then we had EDM generation one. They were fixed, but it took several months. After that we tried to use it with very simple scenarios and it didn't work again (my colleague Alex Efimov wrote here about some of these problems). The most strange thing about these bugs is that they concern the simplest scenarios I can imagine. We use other relational storage now but loose transactional integrity between the RDBMS and Virtuoso RDF storage. I don't like it but chances we can use Virtuoso as relational storage are less and less (from bug to bug). And it is not funny already. To take final decision I need answers to two questions: 1. We tried using ADO.NET provider only with Entity Framework. Is there any chance ADO.NET provider is more stable for pure ADO.NET. It could be a temporary measure (ugly and out-of-date measure) to use pure ADO.NET till EF support is stabilized. 2. Are there any chances ADO.NET provider will be stabilized in the nearest future (I mean month or two). Regards, Alexander
Re: [Virtuoso-users] ADO.NET provider DateTime bug(?)
I hope Virtuoso Mars Edition will solve crossplanets timezones synchronization :) 2010/4/16 Ivan Mikhailov imikhai...@openlinksw.com Hello Alexander, I will check details with other developers tomorrow. By default ODBC prints strings without timezone offsets and ODBC TIMESTAMP_STRUCT lacks timezone offset even in latest versions but I hope that there's some method to pass both TIMESTAMP_STRUCT content and the timezone offset. The server side should deal with tz offsets more accurately. Moreover, the server problem is lack of support for timezoneless datetimes --- I'm only adding them now but they're not in the production code. Current version of Virtuoso keeps all dates/times/datatimes in Oracle style: even if a timezone offset is not specified it is set, and the offset value is set to server's local offset. That will be changed so xsd:dateTime will be able to create values that have no timezone at all, as described in http://www.w3.org/TR/timezone/ . I should warn that it will make debugging brain-damaging. OTOH it will be even worse when we will live on more than one planet --- with calendars and timezones out of sync 8:O Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com Previously I stored DateTime values as strings and casted them to xsd:dateTime dynamically at query time. Then according to Ivan's advice I reimplemented SPARUL part to cast DateTime values when they are added to the store. But now ADO.NET provider returns xsd:dateTime values as strings without timezone offset information. At the same time sparql-endpoint web interface displays values correctly. Regards, Alexander
[Virtuoso-users] Load LGD to Amazon EC2 instance
Hello!
I'm trying to load LGD Elements dataset to my EC2 instance but as result get
the following error at logs:
02:46:41 PL LOG: File /opt/lgdelements/global.graph error 37000 SP029:
TURTLE RDF loader, line 1: Undefined namespace prefix at
http://linkedgeodata.org#
02:46:41 PL LOG: File /opt/lgdelements/lgd-elements.nt.bz2 error 37000
SP029: TURTLE RDF loader, line 8: syntax error
Here is my ld_dir configuration:
ld_dir ('/opt/lgdelements', '*.*', 'http://linkedgeodata.org#');
Folder /opt/lgdelements contains file global.graph that contains
http://linkedgeodata.org string.
Regards,
Alexander
Re: [Virtuoso-users] Load LGD to Amazon EC2 instance
Hi Hugh,
Thank you for feedback. I am decompressing the dataset right now... But I
didn't understand why I should compress the dataset again (using gzip) if I
can load uncompressed .nt file.
Regards,
Alexander
2010/4/16 Hugh Williams hwilli...@openlinksw.com
Hi Alexander,
The Virtuoso Bulk loader scripts do not support the extraction of bz2
compressed files, only gzip compressed or uncompressed files, so you will
need to uncompress the LGD bz2 file(s) first. Also, as you have *.* in the
ld_dir() command the loader is trying to load all file in the directory
including the global.graph file as if it is a dataset, which it is not.
Thus I would suggest you do the following:
1) Compress the LDG NT files you want to load with gzip
2) Remove all entries from the DB.DBA.LOAD_LIST table
3) Run ld_dir ('/opt/lgdelement', '*.gz',
'http://linkedgeodata.org#http://linkedgeodata.org/#%27
i')
4) Run rdf_loader_run()
Let us know if this now works for you ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 16 Apr 2010, at 08:11, Alexander Sidorov wrote:
Hello!
I'm trying to load LGD Elements dataset to my EC2 instance but as result
get the following error at logs:
02:46:41 PL LOG: File /opt/lgdelements/global.graph error 37000 SP029:
TURTLE RDF loader, line 1: Undefined namespace prefix at
http://linkedgeodata.org# http://linkedgeodata.org/#
02:46:41 PL LOG: File /opt/lgdelements/lgd-elements.nt.bz2 error 37000
SP029: TURTLE RDF loader, line 8: syntax error
Here is my ld_dir configuration:
ld_dir ('/opt/lgdelements', '*.*',
'http://linkedgeodata.org#'http://linkedgeodata.org/#%27
);
Folder /opt/lgdelements contains file global.graph that contains
http://linkedgeodata.org string.
Regards,
Alexander
--
Download Intel#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] Virtuoso Cloud Edition licensing
Hello! Some time ago we had a conversation concerning Virtuoso Cloud Edition pricing. Here is the quote from there Each AMI has a license that applies to the Virtuoso instances on the machine. (c) Kingsley. According to this quote I thought Cloud Edition license is applied per EC2 instance (machine). But when I visit Virtuoso Dev Pay page it tells my that I already have Virtuoso subscription (so I can't pay for one more instance). Furthemore I don't remember I entered activation key anywhere. Could you please clarify these licensing details? Regards, Alexander
[Virtuoso-users] SPARQL compare strings
Hello!
Should these queries:
WHERE
{
?s http://www.geonames.org/ontology#featureClass
http://www.geonames.org/ontology#P; .
}
WHERE
{
?s http://www.geonames.org/ontology#featureClass ?featureClass .
FILTER (?featureClass = http://www.geonames.org/ontology#P;)
}
be equivalent?
Yes, I know featureClass predicate stores URIs but not literals at GeoNames
dataset. But my custom GeoNames dataset first stored it as literals (it
really doesn't change anything from semantic point of view as there is now
URI http://www.geonames.org/ontology#P). Then for performance reasons I
have reimplemented RDF generator so that featureClass stores URIs. But there
is a chance this problem can be reproduced on more real usecases so I
decided to report it.
Regards,
Alexander
Re: [Virtuoso-users] SPARQL compare strings
I forgot to notice that first query doesn't work.
2010/4/23 Alexander Sidorov alexi...@gmail.com
Hello!
Should these queries:
WHERE
{
?s http://www.geonames.org/ontology#featureClass
http://www.geonames.org/ontology#P; .
}
WHERE
{
?s http://www.geonames.org/ontology#featureClass ?featureClass .
FILTER (?featureClass = http://www.geonames.org/ontology#P;)
}
be equivalent?
Yes, I know featureClass predicate stores URIs but not literals at GeoNames
dataset. But my custom GeoNames dataset first stored it as literals (it
really doesn't change anything from semantic point of view as there is now
URI http://www.geonames.org/ontology#P). Then for performance reasons I
have reimplemented RDF generator so that featureClass stores URIs. But there
is a chance this problem can be reproduced on more real usecases so I
decided to report it.
Regards,
Alexander
Re: [Virtuoso-users] SPARQL compare strings
Hi Ivan,
Here is a dataset: http://www.mediafire.com/?drtwizwozq5
Here are sample queries to compare:
prefix geo: http://www.w3.org/2003/01/geo/wgs84_pos#
prefix geonames: http://www.geonames.org/ontology#
SELECT DISTINCT ?cityName
FROM http://www.geonames.org#
WHERE
{
?city ?predicate ?value .
?city geonames:featureClass ?featureClass .
?city geonames:name ?cityName .
?value bif:contains 'tomsk' .
FILTER (?featureClass = http://www.geonames.org/ontology#P;)
}
and
prefix geo: http://www.w3.org/2003/01/geo/wgs84_pos#
prefix geonames: http://www.geonames.org/ontology#
SELECT DISTINCT ?cityName
FROM http://www.geonames.org#
WHERE
{
?city ?predicate ?value .
?city geonames:featureClass http://www.geonames.org/ontology#P; .
?city geonames:name ?cityName .
?value bif:contains 'tomsk' .
}
Regards,
Alexander
2010/4/24 Ivan Mikhailov imikhai...@openlinksw.com
Hello Alexander,
What is the complete text of the query and what are the data in
question? Additionally, what is exact server version? The case is quite
strange because by default these two should result in identical
fragments of SQL.
Best Regards,
Ivan Mikhailov
OpenLink Software
http://virtuoso.openlinksw.com
On Fri, 2010-04-23 at 23:28 +0700, Alexander Sidorov wrote:
I forgot to notice that first query doesn't work.
2010/4/23 Alexander Sidorov alexi...@gmail.com
Hello!
Should these queries:
WHERE
{
?s http://www.geonames.org/ontology#featureClass
http://www.geonames.org/ontology#P; .
}
WHERE
{
?s
http://www.geonames.org/ontology#featureClass ?featureClass .
FILTER (?featureClass = http://www.geonames.org/ontology#P;)
}
be equivalent?
Yes, I know featureClass predicate stores URIs but not
literals at GeoNames dataset. But my custom GeoNames dataset
first stored it as literals (it really doesn't change anything
from semantic point of view as there is now URI
http://www.geonames.org/ontology#P). Then for performance
reasons I have reimplemented RDF generator so that
featureClass stores URIs. But there is a chance this problem
can be reproduced on more real usecases so I decided to report
it.
Regards,
Alexander
[Virtuoso-users] SPARQL In operator
Hello! Should SPARQL IN operator work with subqueries? What I see now is that only first subquery result is used by IN operator. Regards, Alexander
[Virtuoso-users] Geo queries efficiency
Hello!
What is the most efficient way of filtering geomerty objects by
latitude/longitude? I need to retrieve LinkedGeoData objects inside some
rectangular boundaries. Here is how I filter objects now :
where
{
?entity geo:lat ?lat .
?entity geo:long ?long .
FILTER ( ?lat = 56.4881360279505 ?lat = 56.5118226056529 ?long =
84.9451732635498 ?long = 84.9880886077881 )
}
One more possible implementation:
where
{
?entity geo:geometry ?geo .
FILTER ( bif:st_y(?geo) = 56.4881360279505 bif:st_y(?geo) =
56.5118226056529 bif:st_x(?geo) = 84.9451732635498 bif:st_x(?geo) =
84.9880886077881 )
}
What is the most efficient way?
Regards,
Alexander
Re: [Virtuoso-users] Geo queries efficiency
I have found a more efficient way to filter objects inside boundaries.
Looks like the approach I used before:
FILTER ( ?lat = 56.4881360279505 ?lat = 56.5118226056529 ?long =
84.9451732635498 ?long = 84.9880886077881 )
doesn't use geo index at all. That's why I decided to prefilter objects
using bif:st_intersects function. As we know boundaries we can calculate
rectangle diagonal using Haversine
formulahttp://www.movable-type.co.uk/scripts/latlong.html.
After that we can draw a circle from the center of rectangular with radius
equal to diagonal/2: http://img717.imageshack.us/img717/6931/maptl.png
bif:st_intersects filters objects inside this circle and after that we need
just to filter objects that are inside the circle but outside the boundaries
(as I did it before). So the final query is like this:
FILTER ( bif:st_intersects (?geo, bif:st_point (-85.7686328887939,
41.0006278592186), 2.548784053237235) ?lat = 40.9844337033077 ?lat =
41.0168220151295 ?long = -85.7900905609131 ?long = -85.7471752166748
)
and it's performance is much better.
2010/4/26 Nathan nat...@webr3.org
Nathan wrote:
Alexander Sidorov wrote:
Hello!
What is the most efficient way of filtering geomerty objects by
latitude/longitude? I need to retrieve LinkedGeoData objects inside some
rectangular boundaries. Here is how I filter objects now :
where
{
?entity geo:lat ?lat .
?entity geo:long ?long .
FILTER ( ?lat = 56.4881360279505 ?lat = 56.5118226056529 ?long
=
84.9451732635498 ?long = 84.9880886077881 )
}
One more possible implementation:
where
{
?entity geo:geometry ?geo .
FILTER ( bif:st_y(?geo) = 56.4881360279505 bif:st_y(?geo) =
56.5118226056529 bif:st_x(?geo) = 84.9451732635498 bif:st_x(?geo)
=
84.9880886077881 )
}
What is the most efficient way?
I would have though st_within [1] would have been fastest, but you could
just run the three versions and time each one to see which is fastest.
http://docs.openlinksw.com/virtuoso/fn_st_within.html
ack ignore that, getting confused between mysql and virtuoso; was
thinking of mbr contains functionality where you see if points are
within a minimum bounding rectangle.
staff: is support for mbr and related functions planned, wip or due soon?
Best,
Nathan
Re: [Virtuoso-users] Import DBpedia into Virtuoso
Hi Benedik, I had similar problem. Switching to PC with more RAM solved it. Regards, Alexander
Re: [Virtuoso-users] Clear graph
Hi Kingsley, This table raised the question. There is no price for High-memory instances (but I can choose them during instance launching). Also it is very disappointing there is no over 96 hours discount for Large instances (I believe it is the most popular choice). Regards, Alexander 2010/5/17 Kingsley Idehen kide...@openlinksw.com Alexander Sidorov wrote: Hugh and Ivan, thank you for advices. I tried some of the ways you have suggested but they didn't work. It was easier to me to launch new Virtuoso EC2 instance and make dataset loading from scratch. The problem didn't appear again so looks like I have done something wrong previous time. 2010/5/16 Ivan Mikhailov imikhai...@openlinksw.com mailto: imikhai...@openlinksw.com Hello Alexander, Try define sql:log-enable NNN at the beginning of CLEAR GRAPH statement. That will invoke log_enable (NNN, 1) before the operation (and restore the log mode back to original value after the operation). The log_enable() BIF is described in http://docs.openlinksw.com/virtuoso/fn_log_enable.html Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Sun, 2010-05-16 at 19:44 +0700, Alexander Sidorov wrote: Hello! Virtuoso hanged during large graph clearing. I stopped Virtuoso, removed virtuoso.lck and started again. I am not sure whether graph was cleared or not but now all queries from this graph result in S1T00 Error SR171: Transaction timed out. I need to reload dataset to this graph. Is there any way to remove transaction lock? -- ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users Alex, Does this answer your questions? See: http://twitpic.com/1ohh2a/full -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen
Re: [Virtuoso-users] Amazon EC2 pricing clarification
Hi Kingsley, We just offer a paid AMI with minimal mark up of the base costs. Hm... We need to double check this option as it might have been introduced after our initial paid AMI scheme was constructed. Basically, the markup factors would be the same. Thus, if there is a 96 hour decrease from Amazon, the same will apply to our mark up factors atop their base costs. Hm once more. As I understand these prices and discounts are Virtuoso-specific. There is no any 96 hours discount from Amazon for usual instances. Do you mean, installing Virtuoso in your own data center? Yes Regards, Alexander Kingsley -- ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen
Re: [Virtuoso-users] Amazon EC2 pricing clarification
2010/5/17 Kingsley Idehen kide...@openlinksw.com Alexander Sidorov wrote: Hi Kingsley, We just offer a paid AMI with minimal mark up of the base costs. Hm... We need to double check this option as it might have been introduced after our initial paid AMI scheme was constructed. Basically, the markup factors would be the same. Thus, if there is a 96 hour decrease from Amazon, the same will apply to our mark up factors atop their base costs. Hm once more. As I understand these prices and discounts are Virtuoso-specific. There is no any 96 hours discount from Amazon for usual instances. Prices have been changed to reflect recent Amazon changes i.e., added prices for the missing categories. Thank you, now it is clear how different instance types prices relate to each other. But it is still unclear to me how these prices relate to Amazon EC2 pricing (http://aws.amazon.com/ec2/#pricing). See: http://twitpic.com/1okxhk/full Kingsley Do you mean, installing Virtuoso in your own data center? Yes Regards, Alexander Kingsley -- ___ 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 President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen -- ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen
Re: [Virtuoso-users] geometry predicate lack
Hi Alex, You are right, geo-capabilities are included only in commercial Virtuoso instances. But it is my case (as I use Virtuoso Cloud Edition). I hope OpenLink guys can clarify this behaviour so I have added virtuoso-users to cc. Regards, Alexander 2010/5/17 Alex Tucker a...@floop.org.uk Hi Alexander, I followed the link you provided but haven't found any information concerning geometry predicate generation. Could you please point to it? Also it is strange geometry predicate is generated at lod.openlinksw.combut is not generated at my custom Virtuoso instance. My understanding is that the geometry predicate is computed by Virtuoso and is only available in the commercial edition, not the free open source edition. This explains why you can use it at lod.openlinksw.com and potentially at the new LGD servers, as I believe OpenLink donated a commercial license to run the LGD servers too. Alex.
[Virtuoso-users] Migrating from x64 to x86 and back
Hello! For economical reasons I have to migrate from CentOs x64 (Amazon EC2 Large) to x86 (Amazon EC2 High-CPU Medium). I haven't found found any documentation concerning this kind of migration. Will it work if I just copy database files (which exactly?) from x64 instance to x86 instance? Regards, Alexander
Re: [Virtuoso-users] Amazon EC2 pricing clarification
Hi Kingsley, Please check new table for typos. I have launched High-CPU Medium instance and here is what I have in my Account: $0.400 per High-CPU Medium instance-hour (or partial hour) consumed (First 96 Hrs) 6 Hrs 2.40. So first 96 hours cost not 0.2$ but 0.4$. And probably following hours will cost not 0.2$ but 0.3$. Regards, Alexander 2010/5/17 Kingsley Idehen kide...@openlinksw.com Alexander Sidorov wrote: Hi Kingsley, We just offer a paid AMI with minimal mark up of the base costs. Hm... We need to double check this option as it might have been introduced after our initial paid AMI scheme was constructed. Basically, the markup factors would be the same. Thus, if there is a 96 hour decrease from Amazon, the same will apply to our mark up factors atop their base costs. Hm once more. As I understand these prices and discounts are Virtuoso-specific. There is no any 96 hours discount from Amazon for usual instances. Prices have been changed to reflect recent Amazon changes i.e., added prices for the missing categories. See: http://twitpic.com/1okxhk/full Kingsley Do you mean, installing Virtuoso in your own data center? Yes Regards, Alexander Kingsley -- ___ 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 President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen http://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen -- ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- Regards, Kingsley Idehen President CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen Twitter/Identi.ca: kidehen
Re: [Virtuoso-users] geometry predicate lack
Hi Hugh,
There wasn't any error. As there isn't geometry predicate at my instance,
Virtuoso doesn't find assertions with it and returns empty result set. Just
compare:
1. endpoint: lod.openlinksw.com/sparq
query: SELECT * WHERE {
http://linkedgeodata.org/triplify/node/163043169#id ?p ?o .}
2. endpoint: http://ec2-184-73-209-65.compute-1.amazonaws.com/sparql
query: SELECT * FROM http://linkedgeodata.org/content# WHERE {
http://linkedgeodata.org/triplify/node/163043169#id ?p ?o .}
geometry predicate exists in the first case but doesn't in the second one.
P. S. I use Virtuoso Cloud Edition 06.01.3127
Regards,
Alexander
2010/5/18 Hugh Williams hwilli...@openlinksw.com
Hi Alexander,
Are the LGD queries that worked against the lod.openlinksw.com server
giving a specific error when you attempt to run against your EC2 AMI with
the LGD datasets loaded ? Also what is the exact version of the Virtuoso EC2
AMI, this will be reported in the left frame of the conductor UI ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 17 May 2010, at 18:04, Alexander Sidorov wrote:
Hi Kingsley,
Yes, geo capabilities work very well under Virtuoso Cloud Edition (good
performance was a great surprise after migrating from lod.openlinksw.comto
custom Amazon EC2 instance). Here I will quote the initial question to
point out the problem:
Prevously I executed LGD queries using lod.openlinksw.com endpoint (where
full LGD is loaded). Today I have loaded LGD Elements to my custom Virtuoso
instance and all LGD queries became broken. As I have found out geometry
predicate is absent at LGD Elements dataset. Changing geometry to
combination of lat and long solved my problem. But please put the note
concerning geometry predicate at linkedgeodata.org/datasets page to
prevent other people to struggle with this problem.
Regards,
Alexander
2010/5/17 Kingsley Idehen kide...@openlinksw.com
Alexander Sidorov wrote:
Hi Alex,
You are right, geo-capabilities are included only in commercial Virtuoso
instances. But it is my case (as I use Virtuoso Cloud Edition). I hope
OpenLink guys can clarify this behaviour so I have added virtuoso-users to
cc.
Cloud Edition is the Commercial Edition so you have SPARQL-GEO and related
GeopSpatial index capabilities.
Kingsley
Regards,
Alexander
2010/5/17 Alex Tucker a...@floop.org.uk mailto:a...@floop.org.uk
Hi Alexander,
I followed the link you provided but haven't found any
information concerning geometry predicate generation. Could you
please point to it? Also it is strange geometry predicate is
generated at lod.openlinksw.com http://lod.openlinksw.com but
is not generated at my custom Virtuoso instance.
My understanding is that the geometry predicate is computed by
Virtuoso and is only available in the commercial edition, not the
free open source edition. This explains why you can use it at
lod.openlinksw.com http://lod.openlinksw.com and potentially at
the new LGD servers, as I believe OpenLink donated a commercial
license to run the LGD servers too.
Alex.
--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Regards,
Kingsley Idehen President CEO OpenLink Software Web:
http://www.openlinksw.com
Weblog:
http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen
Twitter/Identi.ca: kidehen
--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] geometry predicate lack
Hi Hugh,
Yes, I have missed this point. But after running DB.DBA.RDF_GEO_FILL my
Virtuoso instance hanged. I couldn't stop it and after rebooting couldn't
start (had to restore from backup). I use High-CPU Medium instance for
storing LinkedGeoData Elements dataset, so may the lack of resources is the
source of this problem (instance was tuned according to documentation).
Regards,
Alexander
2010/5/18 Hugh Williams hwilli...@openlinksw.com
Hi Alexander,
Did you run the DB.DBA.RDF_GEO_FILL () procedure to create the geometry
data/predicates for the loaded LGD datasets as detailed at:
http://docs.openlinksw.com/virtuoso/rdfsparqlgeospat.html#rdfsparqlgeospatcrg
As if the geometry predicates do not exist, this would seem the most
likely cause ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 18 May 2010, at 12:01, Alexander Sidorov wrote:
Hi Hugh,
There wasn't any error. As there isn't geometry predicate at my instance,
Virtuoso doesn't find assertions with it and returns empty result set. Just
compare:
1. endpoint: lod.openlinksw.com/sparq
query: SELECT * WHERE {
http://linkedgeodata.org/triplify/node/163043169#id ?p ?o .}
2. endpoint: http://ec2-184-73-209-65.compute-1.amazonaws.com/sparql
query: SELECT * FROM http://linkedgeodata.org/content# WHERE {
http://linkedgeodata.org/triplify/node/163043169#id ?p ?o .}
geometry predicate exists in the first case but doesn't in the second
one.
P. S. I use Virtuoso Cloud Edition 06.01.3127
Regards,
Alexander
2010/5/18 Hugh Williams hwilli...@openlinksw.com
Hi Alexander,
Are the LGD queries that worked against the lod.openlinksw.com server
giving a specific error when you attempt to run against your EC2 AMI with
the LGD datasets loaded ? Also what is the exact version of the Virtuoso EC2
AMI, this will be reported in the left frame of the conductor UI ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 17 May 2010, at 18:04, Alexander Sidorov wrote:
Hi Kingsley,
Yes, geo capabilities work very well under Virtuoso Cloud Edition (good
performance was a great surprise after migrating from lod.openlinksw.comto
custom Amazon EC2 instance). Here I will quote the initial question to
point out the problem:
Prevously I executed LGD queries using lod.openlinksw.com endpoint
(where full LGD is loaded). Today I have loaded LGD Elements to my custom
Virtuoso instance and all LGD queries became broken. As I have found out
geometry predicate is absent at LGD Elements dataset. Changing geometry
to combination of lat and long solved my problem. But please put the
note concerning geometry predicate at linkedgeodata.org/datasets page
to prevent other people to struggle with this problem.
Regards,
Alexander
2010/5/17 Kingsley Idehen kide...@openlinksw.com
Alexander Sidorov wrote:
Hi Alex,
You are right, geo-capabilities are included only in commercial Virtuoso
instances. But it is my case (as I use Virtuoso Cloud Edition). I hope
OpenLink guys can clarify this behaviour so I have added virtuoso-users to
cc.
Cloud Edition is the Commercial Edition so you have SPARQL-GEO and
related GeopSpatial index capabilities.
Kingsley
Regards,
Alexander
2010/5/17 Alex Tucker a...@floop.org.uk mailto:a...@floop.org.uk
Hi Alexander,
I followed the link you provided but haven't found any
information concerning geometry predicate generation. Could you
please point to it? Also it is strange geometry predicate is
generated at lod.openlinksw.com http://lod.openlinksw.com but
is not generated at my custom Virtuoso instance.
My understanding is that the geometry predicate is computed by
Virtuoso and is only available in the commercial edition, not the
free open source edition. This explains why you can use it at
lod.openlinksw.com http://lod.openlinksw.com and potentially at
the new LGD servers, as I believe OpenLink donated a commercial
license to run the LGD servers too.
Alex.
--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Regards,
Kingsley Idehen President CEO OpenLink Software Web:
http://www.openlinksw.com
Weblog:
http://www.openlinksw.com/blog/~kidehenhttp://www.openlinksw.com/blog/%7Ekidehen
Twitter
Re: [Virtuoso-users] LOD encoding problems
://linkedgeodata.org/triplify/node/27503927'http://linkedgeodata.org/triplify/node/27503927%27),
'',
'http://linkedgeodata.org/triplify/node/27503927'http://linkedgeodata.org/triplify/node/27503927%27
);
and query : select * where {
http://linkedgeodata.org/triplify/node/27503927#id ?y ?z . }
Best Regards,
Mitko
On Mar 20, 2010, at 9:33 PM, Alexander Sidorov wrote:
Hm... Look at this query results:
SELECT ?s ?p ?o ?name
WHERE
{
?s ?p ?o .
?s a http://linkedgeodata.org/vocabulary#city .
?o bif:contains 'moscow' .
OPTIONAL
{
?s http://linkedgeodata.org/vocabulary#name ?name
}
}
Do you see Москва as name? I see some strange symbols despite I see
correct cyrillic symbols at your query results. Looks like LinkedGeoData
specific problem.
2010/3/17 Mitko Iliev imi...@openlinksw.co.uk
Hi Alexander,
The sparql endpoint returns UTF8, also the experiments shows proper
encoding, for example try to execute :
SELECT ?o WHERE {http://dbpedia.org/resource/Moscow rdfs:label ?o .
filter (lang(?o) = 'ru' ) }
or
SELECT ?o WHERE { ?s ?p ?o . ?o bif:contains 'Москва' } limit 100
against http://lod.openlinksw.com/sparql . both returns readable
content.
If your query executed on endpoint above returns bad utf8 please give us
the query so we can debug what happens, otherwise a possible problem is at
client side re-coding the response or reading it as narrow charset.
Best Regards,
Mitko
On Mar 17, 2010, at 3:54 AM, Alexander Sidorov wrote:
Hi Hugh,
As I remember ADO.NET encoding bug was fixed (I haven't checked
because it has no sense while other Entity Framework bug you know about is
not fixed).
But this problem has no relation to ADO.NET. As I haven't yet deployed
my application to Amazon EC2, I execute geo queries using
lod.openlinksw.com/sparql endpoint using SPARQL protocol (but not
using database directly). Here are my screen shots:
1. Manchester: http://img171.imageshack.us/img171/5568/manchesterk.png
2. Moscow: http://img204.imageshack.us/img204/7850/moscow.png
Regards,
Alexander
2010/3/17 Hugh Williams hwilli...@openlinksw.com
Hi Alexander,
Is this the encoding issue with the ADO.Net Provider you reported
previously as that is the only one I am aware of, which is still to be
resolved ?
Note, their is a 40K limit on the size of emails to this mailing list
thus your mail with attachment which exceeded this limit was with held
pending approval initially. Please place such attachments on a remote
server
and provide links in your mails in future ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 17 Mar 2010, at 00:27, Alexander Sidorov wrote:
Hello!
I have already asked about LOD encoding problems before but no
feedback followed. To be more expressive I have attached my application's
screen shots with information about Manchester (english symbols -
everything
is okay) and Moscow (russian symbols are displayed incorrectly).
Regards,
Alexander
Manchester.pngMoscow.png--
Download Intel#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Download Intel#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Mitko Iliev
Developer Virtuoso Team
OpenLink Software
http://www.openlinksw.com/virtuoso
Cross Platform Web Services Middleware
--
Mitko Iliev
Developer Virtuoso Team
OpenLink Software
http://www.openlinksw.com/virtuoso
Cross Platform Web Services Middleware
--
You received this message because you are subscribed to the Google Groups
Linked Geo Data group.
To post to this group, send email to linked-geo-d...@googlegroups.com.
To unsubscribe from this group, send email to
linked-geo-data+unsubscr...@googlegroups.comlinked-geo-data%2bunsubscr...@googlegroups.com
.
For more options, visit this group at
http://groups.google.com/group/linked-geo-data?hl=en.
Re: [Virtuoso-users] LOD encoding problems
Fixed version:
public static string FixLgdString(string lgdString)
{
byte[] lgdStringBytes = Encoding.UTF8.GetBytes(lgdString);
if (lgdStringBytes.Length == lgdString.Length)
return lgdString;
int firstByteOffset = (194 + 144 + 195) - 208;
Listbyte fixedLgdStringBytes = new Listbyte();
for (int i = 0; i lgdStringBytes.Length; i++)
{
if (lgdStringBytes[i] 128)
fixedLgdStringBytes.Add(lgdStringBytes[i]);
else
{
fixedLgdStringBytes.Add((byte)((lgdStringBytes[i] +
lgdStringBytes[i + 1] + lgdStringBytes[i + 2]) - firstByteOffset));
fixedLgdStringBytes.Add(lgdStringBytes[i + 3]);
i += 3;
}
}
string fixedLgdString =
Encoding.UTF8.GetString(fixedLgdStringBytes.ToArray());
return fixedLgdString;
}
2010/5/21 Alexander Sidorov alexi...@gmail.com
Richards, thank you for posting your ideas concerning LGD incorrectly
encoded strings. I didn't want to solve this problem for a long time because
hoped that fixed LGD dataset will be released before our service launch.
Looks like I was too optimistic... So here I will share my solution (more
workaround than solution) of this problem. I used C# but it I think it will
be rather easy to port it to any other language.
First of all I needed to find some regularities between LGD (incorrectly
encoded) and correctly encoded literals. I took literal for Tomsk city
(Томск in russian) and used the following code:
string lgdString = Ð¢Ð¾Ð¼Ñ Ðº;
byte[] lgdStringBytes = Encoding.UTF8.GetBytes(lgdString);
string realString = Томск;
byte[] realStringBytes = Encoding.UTF8.GetBytes(realString);
and got very interesting results:
http://img231.imageshack.us/img231/1213/linkedgeodataencoding.png
As you see in the picture:
1. Lgd string uses twice more bytes
2. Every fourth byte of LGD string is equal to every second byte of normal
string.
3. First byte of normal string is a combination of three first bytes of LGD
string (third byte is a combination of 5, 6, 7 LGD bytes, etc.). Combination
of 195+*144*+194 is mapped to 208 and 195+*145*+194 is mapped to 209 (byte 9
of normal string).
Basing on these regularities I have implemented very simple conversion
algorithm (full source code is provided at the end of this message). It
suits my current need but it surely doesn't work for 3- and 4-bytes UTF-8
symbols. Here is how it works for Tomsk city name:
http://img199.imageshack.us/img199/8356/linkedgeodataencodingfi.png
P. S. There was one magic thing concerning this encoding problem. LGD
strings are used at several places of my site and there was one place where
they were displayed correctly. The speciality of this place is that it's
content is dynamically loaded using Ajax (jQuery). So there should be more
natural way of automatic fixing this kind of encoding problems.
PP. S. Source code:
class Program
{
static void Main(string[] args)
{
string lgdString = Ð¢Ð¾Ð¼Ñ Ðº;
string fixedLgdString = FixLgdString(lgdString);
}
public static string FixLgdString(string lgdString)
{
byte[] lgdStringBytes = Encoding.UTF8.GetBytes(lgdString);
if (lgdStringBytes.Length == lgdString.Length)
return lgdString;
int firstByteOffset = (194 + 144 + 195) - 208;
byte[] fixedLgdStringBytes = new byte[lgdStringBytes.Length / 2];
int k = 0; // fixedLgdStringBytes counter
for (int i = 0; i lgdStringBytes.Length; i += 4)
{
fixedLgdStringBytes[k++] = (byte)((lgdStringBytes[i] +
lgdStringBytes[i + 1] + lgdStringBytes[i + 2]) - firstByteOffset);
fixedLgdStringBytes[k++] = lgdStringBytes[i + 3];
}
string fixedLgdString =
Encoding.UTF8.GetString(fixedLgdStringBytes);
return fixedLgdString;
}
}
2010/3/23 Richard Cyganiak rich...@cyganiak.de
Well, I'm not affiliated with Linked Geo Data, but have already looked at
way too many RDF-related encoding problems in my life, so why not look at
one more ...
It is indeed a problem in Linked Geo Data.
The Moscow resource
http://linkedgeodata.org/triplify/node/27503927
has the following value for the :name property, in N-Triples:
\u00D0\u009C\u00D0\u00BE\u00D1\u0081\u00D0\u00BA\u00D0\u00B2\u00D0\u00B0
These are characters escaped with the \u notation of N-Triples. If one
decodes the characters, this is garbage: ÐœÐ¾Ñ ÐºÐ²Ð°
I guess the problem is that the Linked Geo Data code messes up an UTF-8
encoded input stream that comes from the input dataset. It looks like the
original stream contained bytes (hexadecimal)
D0 9C D0 BE D1 81 D0 BA D0 B2 D0 B0
If interpreted as a UTF-8 encoded Unicode string, this is: Москва
Now apparently in Linked Geo
[Virtuoso-users] EF support improvements
Hello! I was out of Virtuoso news for some time... Was there a ADO.NET provider release with EF support improvements? Regards, Alexander
Re: [Virtuoso-users] EF support improvements
Hi Hugh, Will this ADO.NET provider release be compatible with current Virtuoso Open-Source Edition? Regards, Alexander 2010/7/18 Hugh Williams hwilli...@openlinksw.com Hi Alexander, We are currently working on an updated Virtuoso 6.1.2 commercial release for Windows which will include the updated ADO.Net provider with the EF support improvements, which should be available next week ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 18 Jul 2010, at 07:42, Alexander Sidorov wrote: Hello! I was out of Virtuoso news for some time... Was there a ADO.NET provider release with EF support improvements? Regards, Alexander -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] EF support improvements
And the last thing. What about EF4 support? 2010/7/21 Patrick van Kleef pkl...@openlinksw.com Hi Alexander, Will this ADO.NET provider release be compatible with current Virtuoso Open-Source Edition? Yes. Patrick
[Virtuoso-users] Clear graph
Hello!
I need to clear some graph from Virtuoso database. I execute sparql clear
graph graphName from isql, virtuoso-t takes all my free memory but the
size of database file doesn't become better and even select count(*) from
graph graphName { ?s ?p ?o} doesn't become less. What am I doind wrong?
Regard,
Alexander
Re: [Virtuoso-users] Clear graph
Hi Hugh,
I forgot about that discussion and it really looks like the same problem.
Unfortunately I have no idea how to execute define sql:log-enable NNN
before the query - it doesn't run.
Virtuoso 06.01.3127
About 30kk of triples.
I am pretty sure my query calculates triples count inside a graph.
Regards,
Alexander
2011/6/9 Hugh Williams hwilli...@openlinksw.com
Hi Alexander,
Its been a while, but one of the last conversation we had about a year was
with regards to clear graph issues you were having in which Ivan had
suggested:
Try define sql:log-enable NNN at the beginning of CLEAR GRAPH
statement. That will invoke log_enable (NNN, 1) before the operation
(and restore the log mode back to original value after the operation).
The log_enable() BIF is described in
http://docs.openlinksw.com/virtuoso/fn_log_enable.html
Is this still the same or similar issue ?
What version of Virtuoso are you running currently (virtuoso-t -?) ?
What is the size in triple count of the graph(s) being clear’ed ?
In your query below you are counting the number of graphs, but clear graph
does not remove a graph it just clears its content so the graph count will
remain the same, but the key is has the over all triple count reduced ( ie
select count(*) where {?s ?p ?o}) ? If the graphs where explicitly created
then you can use “drop graph graph-name” instead to remove it, although
even that needs some explaining in terms of the differences between create,
drop, clear and delete Graph as detailed at:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideCreateGraph
The database size will not reduce when you remove content as once pages are
allocated they are not returned. If running v6 you can try running the
vacuum() function which will perform some compact of the database as
detailed at:
http://docs.openlinksw.com/virtuoso/fn_vacuum.html
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 9 Jun 2011, at 16:39, Alexander Sidorov wrote:
Hello!
I need to clear some graph from Virtuoso database. I execute sparql
clear graph graphName from isql, virtuoso-t takes all my free memory but
the size of database file doesn't become better and even select count(*)
from graph graphName { ?s ?p ?o} doesn't become less. What am I doind
wrong?
Regard,
Alexander
--
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Clear graph
log_enable 3 worked like a charm. Graph contains zero triples now. After that I tried to run vacuum() to make the size of my database less, but after it had finished its work, the size became even more (was 4.8gb, now 6.8gb). 2011/6/11 Ivan Mikhailov imikhai...@openlinksw.com Hi Alexander log_enable(3,1); delete from rdf_quad where g = iri_to_id (‘graph-name’); Note that this will not even try to remove free-text index data for this graph. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com
[Virtuoso-users] Bulk dataset uploading performance
Hello! What does influence on the bulk dataset uploading performance? I need to upload about 50kk triples (quads) to the server with outdated hardware and 1gb of memory. I have set MaxCheckpointRemap, NumberOfBuffers and MaxDirtyBuffers to take all available memory but uploading goes very slow, about 100k triples per hour (I am not even sure whether memory size plays significant role in dataset uploading process). Are there any other points to improve uploading performance? Does log_enable play role here (like in graph deletion)? Regards, Alexander
[Virtuoso-users] Caseinsensitive search for uri
Hello!
I need to search DbPedia uri by wikipedia link (entered by user). For
example:
SELECT ?uri WHERE
{
?uri foaf:page http://en.wikipedia.org/wiki/Moon
}
But I need to make this query case-insensitive (for the case when, for
example, user enters .../moon instead of .../Moon). Here is what I
tried:
SELECT ?uri
WHERE
{
?uri foaf:page ?url
FILTER regex(str(?url), ^http://en.wikipedia.org/wiki/Moon$;, i)
}
But it is obviously very and very slow. Is there any way to solve this task
more efficient?
Regards,
Alexander
