Hi Leonard,
I've worked in TBC with file-based graphs containing up to 2M triples. It does get slower with large files, but primarily this is an issue on opening/loading. My machine is 32 bit with 2 GB of RAM. How large are your files? < There is a Spraql means of getting this done, but It would take several steps for each property.> Hmm. We've done something like this using a single SPARQL query before. Of course, I cannot be sure without seeing the structure of your spreadsheet. How handy are you with SPARQL? Since you already have a way to create your file, another approach would be to simply drag and drop a file you are creating as an import and then Export/Merge RDF graphs. This can be done manually in TBC by selecting Export/Merge option or by running in the TBC SPARQL console a query that would insert everything from one graph into another graph or by using a SPARQLMotion script that would do the same. But, if what you really want to do is copy and paste RDF serializations from one file to another as large chunks of text, your best bet is to do this is in a text editor. Regards, Irene From: [email protected] [mailto:[email protected]] On Behalf Of Leonard Jacuzzo Sent: Monday, March 28, 2011 5:55 PM To: [email protected] Subject: Re: [topbraid-users] Re: using source code in TBC Thanks Scott, Like I said, Irene's solution does not work when one wants to put stuff in as subclasses of several different classes. I tried narrowing done the place at which I did the import and none of it worked, though it always worked in Thing, at least until I got lots of stuff in it. I have 12gigs of Ram and I allocated more of it to TBC as was suggested a while ago. In fact I have the appropriate number well over 2048..And it still bogs down. Should I give it some more? For clarification, I know how to import spreadsheets. However, without setting the sheets up correctly in advance everything comes in as an instance where I want everything to come in as a class. This, though difficult in TBC, can be done easily by arranging the spreadsheet correctly. With instances, the properties of the individuals are easily imported . One can import info such that classes have the properties, but that is goofy because "Every man is a mammal" is dfiferent for "The Class man is a mammal" What I want to express is The class Man is a subclass of the restriction on the property "has genus" to some value of Mammal. I don't see how this can be done automatically with TBC. Basically I have spreadsheets with class names in the first column and features of the members of the class in the other columns. So I want to connect the class to the properties of the members of the class. There is a Spraql means of getting this done, but It would take several steps for each property. I would not be using Sparql to manipulate class definitons in terms of restrictions on poperties, as one cannot get that from a spreadsheet imported into TBC. I would have to find all of the triples that assert that a class has a property, construct a triple for each such that the class is now a subclass or an equivalent class of a restriction on a property, insert the new triple and delete the old triple. I have devised a work around that was working, all I had to do was click a button, select all, copy and paste.... and now it is not working. Trust me the source code is correct. Best, Leonard, PS. No best practices for removing and re-installing TBC? Shoud I just find and delete everything manually? On Mon, Mar 28, 2011 at 5:15 PM, Scott Henninger <[email protected]> wrote: Leonard; The recipe you gave stated that you placed the RDF/XML definition into the Source Code sub-tab for owl:Thing. At least that's how I read it. That would replace the definition for owl:Thing and could explain both the behavior you describe and the problems with TBC. Irene is correct that where you did the editing matters. If you were to create a class named Blood_Sugar_ExHigh, it should work as you expect, provided the syntax is correct. Excel spreadsheet importing is fully supported by TopBraid, including restrictions. See Help > Import and Export > Import external information > Import Spreadsheets. Restrictions are represented as RDF triples and can therefore be manipulated in SPARQL. Without benefit of a data store back-end, TopBraid uses an in-memory triple store. Text serializations are brought into memory by default. You can increase the amount of memory TBC has access to. See http://www.topquadrant.com/products/TBS_FAQ.html#TBC6. For data back-ends, see Help > Advanced Topics > Working with RDF Databases. You can use any of these back-ends and still use the Source Code tab. Performance will be improved greatly as it will be cached instead of having the entire data in memory. -- Scott On Mar 28, 3:50 pm, Leonard Jacuzzo <[email protected]> wrote: > Thanks Scott, > I am not trying to add one model to another. > > I am trying to convert massive spreadsheets to OWL in an interesting way.. > The TBC import function does not allow one to define classes as equivalent > to restrictions on properties etc. > > BTW: this method, the one I have been using, has worked. > > Refactoring does not work..for what I am doing. I have a mechanical means of > generating RDF/XML from excel. This results in a text file that I was > pasting with felicity into TBC...now suddenly I cannot. That is strange. > The info goes in, but gets mangled in the process.. > > I could use turtle.. maybe that would work, but I was happy with how things > were working. The Sparql motion method takes many more steps... can you add > this functionality or maybe get it to work all of the time, since it does > work some of the time? > > As far as can tell I am not trying to replace "Thing" with the new list of > definitons...there are hundreds of them BTW. There is no code displayed in > the source code field of "Thing" and even so, "thing" does not disappear. > Like I said this has worked in the past. > > I would rather uninstall all of TBC including the workbench etc and > reinstall it. I tried the new folder route once already. > I am using the latest version of TBC for Win7 64. I checked for updates > yesterday and found none. > > But all of my instances of TBC start getting ganky when I build a decent > model. For example, it stops responding when I right click on tabs in the > form view... it hangs up, then the tab opens so quickly I cannot see it, > when I right click again I get the same issue. > > Is there a limit to how much one can express in TBC before it stops being > able to handle it? This happens mostly when I get over 500 classes with > restrictions on properties and dijoint axioms...and it happens on win7 both > versions. > Anyway, thanks for the help. I guess I will try to forget about those sweet > days when I could paste 400 classes with restrictions and all directly into > TBC and do it the hard way. > If there is a mechanism by which I can completely uninstall TBC, I would > like to know of it. > Best, > Leonard > On Mon, Mar 28, 2011 at 4:31 PM, Scott Henninger <[email protected] > > > wrote: > > Leonard, first, to answer the question on whether this use case is a > > supported, the answer is "no". TopBraid Suite, including TopBraid > > Composer has a number of mechanisms for importing and including > > existing RDF/RDFS/OWL constructs. In particular, if your scenario is > > to move a definition from one model to another, I'd direct your > > attention to Help > How to? > Refactor ontologies. > > > Holger also mentions using SPARQLMotion to import files and snippets > > into your model. The is a very flexible > > power tool that will support moving data from one model to another. > > > If you wish to work with "source code", i.e. a text serialization > > format, I'd suggest using the Turtle syntax, which is more human- > > readable and editable, and has better performance characteristics when > > loading the text serialization. You can open a file in its text > > serialization by right-clicking on a file in the Navigator viewer and > > choosing Open With. > Text Editor. > > > Insofar as editing the Source Code sub-tab is concerned, it appears > > you are attempting to replace the definition of owl:Thing with a class > > definition. This would give the behavior you describe. Note that the > > interface will only show the definitions the interface is able to > > process correctly. If you need to see all of your data, either use > > the Triples View (Window > Show View > Triples) or view the triples in > > the SPARQL View (to get all triples, apply this query: SELECT * WHERE > > {?s ?p ?o}). > > > For re-installing TBC, just unzip the download into a different > > directory on your machine and run the executable from that directory > > (i.e. there is no need to delete old versions). In terms of system > > stability, make sure you don't edit any files in the TopBraid folder > > in the workspace. If you let us know what the startup errors are, > > we'd be happy to look into it (also let us know what version of TBC is > > used and the OS it is installed on). > > > -- Scott > > > On Mar 28, 2:21 pm, Leonard Jacuzzo <[email protected]> wrote: > > > Hi Holger, > > > I have two questions. First, I would like to completely uninstall and > > > reinstall TBC on my machine. What is the best means of doing this. > > Everytime > > > I try it, there is some piece left over. For example, I still have the > > same > > > workbench etc. I would like to completely reinstall TBC because it has > > been > > > ganky for a while and now show errors on start up. > > > > The second question is the same as last night. I tried to paste on the > > > machine at work and had the same problems as at home. Here is my detailed > > > explanation. > > > > I start off with a file that contains the class for which I would like to > > > make a subclass. The code for that class is > > > > <owl:Class rdf:ID="Blood_Sugar_InSpec"> > > > > <rdfs:subClassOf rdf:resource="#Blood_Sugar_Reading"/> > > > > </owl:Class> > > > > Then I create a long text file with hundreds strings that resemble this: > > > > <owl:Class rdf:ID="Blood_Sugar_ExHigh" > " > > > <rdfs:subClassOf rdf:resource="#Blood_Sugar_InSpec"/> > > > <rdfs:subClassOf> > > > <owl:Class> > > > <owl:intersectionOf rdf:parseType="Collection"> > > > <owl:Restriction> > > > <owl:onProperty rdf:resource="#Has_SL"/> > > > <owl:someValuesFrom> > > > <rdfs:Datatype> > > > <owl:onDatatype rdf:resource=" > >http://www.w3.org/2001/XMLSchema#float"/> > > > <owl:withRestrictions rdf:parseType="Collection"> > > > <rdf:Description> > > > <xsd:minInclusive rdf:datatype=" > >http://www.w3.org/2001/XMLSchema#float"; > > > >0.0898</xsd:minInclusive> > > > </rdf:Description> > > > </owl:withRestrictions> > > > </rdfs:Datatype> > > > </owl:someValuesFrom> > > > </owl:Restriction> > > > <rdfs:Datatype> > > > <owl:onDatatype rdf:resource=" > >http://www.w3.org/2001/XMLSchema#float"/> > > > <owl:withRestrictions rdf:parseType="Collection"> > > > <rdf:Description> > > > <xsd:maxExclusive rdf:datatype=" > >http://www.w3.org/2001/XMLSchema#float"; > > > >0.097</xsd:maxExclusive> > > > </rdf:Description> > > > </owl:withRestrictions> > > > </rdfs:Datatype> > > > </owl:intersectionOf> > > > </owl:Class> > > > </rdfs:subClassOf> > > > </owl:Class> > > > > When I paste this string into the source code view for "thing" I end up > > with > > > this: > > > > <owl:Class rdf:ID="Blood_Sugar_ExHigh"> > > > > <rdfs:subClassOf> > > > > <owl:Class> > > > > <owl:intersectionOf rdf:parseType="Collection"> > > > > <owl:Restriction> > > > > <owl:someValuesFrom> > > > > <rdfs:Datatype> > > > > <owl:withRestrictions rdf:parseType="Collection"> > > > > <rdf:Description> > > > > <xsd:minInclusive rdf:datatype="http://www.w3.org/2001/XMLSchema#float"; > > > > >0.2014</xsd:minInclusive> > > > > </rdf:Description> > > > > </owl:withRestrictions> > > > > <owl:onDatatype rdf:resource="http://www.w3.org/2001/XMLSchema#float"/> > > > > </rdfs:Datatype> > > > > </owl:someValuesFrom> > > > > <owl:onProperty rdf:resource="#Has_CT"/> > > > > </owl:Restriction> > > > > <rdfs:Datatype> > > > > <owl:withRestrictions rdf:parseType="Collection"> > > > > <rdf:Description> > > > > <xsd:maxExclusive rdf:datatype="http://www.w3.org/2001/XMLSchema#float"; > > > > >0.211</xsd:maxExclusive> > > > > As you can see, the class that I inserted is no longer declared to be a > > > subclass of the class which I encoded as subclass. It gets stuck as a > > > subclass of "thing" > > > > If I save this file in TBC, it erases all of the previous classes and > > will > > > only save the new "non-subclass" info. > > > > I just tried to accomplish the paste at work and it no longer works. > > Which > > > is strange because it worked on Friday. > > > > Here is a question. Is the method that I am attempting supposed to work > > as I > > > intend it to work? Can one paste source code for an ontology into the > > source > > > code field for "THING"? It was working like a charm and now does not. > > > However, it is a super convenient means of adding a ton of stuff to an > > > ontology. I would love to continue as I was. > > > > I hope that I have given you enough information. (I have to make up stuff > > to > > > show you as I can't show you the real deal) > > > > Best, > > > > Leonard > > > > On Sun, Mar 27, 2011 at 7:03 PM, Holger Knublauch < > > [email protected]>wrote: > > > > > On Mar 28, 2011, at 9:00 AM, Leonard Jacuzzo wrote: > > > > > I will attempt to supply more information on the pasting problem as I > > > > find this most convenient. > > > > > > What sorts of information would you like? > > > > > A minimal, reproducible test scenario would be needed, e.g. start with > > file > > > > A that has a couple of classes, then try to add file B and show me > > where > > > > data gets lost. If you could attach those two minimal files then I may > > be > > > > able to help you better. > > > > > Thanks, > > > > Holger > > > > > -- > > > > You received this message because you are subscribed to the Google > > > > Group "TopBraid Suite Users", the topics of which include TopBraid > > > > Composer, > > > > TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. > > > > To post to this group, send email to > > > > [email protected] > > > > To unsubscribe from this group, send email to > > > > [email protected] <mailto:topbraid-users%[email protected]> > > > > For more options, visit this group at > > > >http://groups.google.com/group/topbraid-users?hl=en > > > -- > > You received this message because you are subscribed to the Google > > Group "TopBraid Suite Users", the topics of which include TopBraid > > Composer, > > TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. > > ... > > read more > -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] <mailto:topbraid-users%[email protected]> For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en
