Hi Derek, Each column will become a datatype property. To see the object properties connecting individuals from different classes, you need to define foreign keys. Other than that, your expectations are correct with one clarification - schema actually gets translated into RDF in a persistent way as part of the import process, instance data is translated dynamically as you browse the ontology in TopBraid.
After the import, you should see the following files (note that "example" is a place holder, instead you will see your database name): example-Mapping.owl - contains an initial (default) mapping derived by introspection into the database tables. The mapping will consist of one class per table and one datatype property for each column. The mapping will also create object property values for foreign-key relationships among database tables. If a table only consists of two foreign keys, then the mapping will have inverse object properties, and no class will be created for the table. example.d2rq - serves as a placeholder of the actual instance ontology for TopBraid Composer. The file itself contains nothing but a reference to the mapping file, the base URI of the graph, and the URL of the driver's jar file. Note that Composer will automatically associate this d2rq file with the base URI provided in the wizard, so that any ontologies that import the namespace will be automatically redirected into the database. example-Schema.owl - contains an initial schema derived from the database tables. This schema is not sophisticated and only defines the classes and properties like in the mapping file. example-Test.owl - is an umbrella ontology that imports the schema and the instances file, so that it can be tested. You need to open example-Test.owl to see the schema and the data. If you want to then permanently convert all the data into RDF, use Export/Merge/Convert RDF Graphs. Regards, Irene -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Derek S Sent: Thursday, September 17, 2009 7:07 AM To: TopBraid Composer Users Subject: [tbc-users] Re: installing tbc in eclipse 3.4 using software updates Hi Scott, tbh I'm a little confused as to what to expect as a result of a d2rq import. I'd kind of assummed I would see the following (pardon me if I have the semantics slightly wrong) ... table names -> classes. e.g. table EMPLOYEE would result in an EMPLOYEE class rows -> instance of a class. e.g. a row in the EMPLOYEE table would become an instance in the class EMPLOYEEE column names -> objectProperties e.g. column name "FIRST_NAME" becomes objectProperty hasFirstName column values -> property values. e.g. the value 'Eric' in the FIRST_NAME column would produce these triples <employee#1> rdfsType:employee <employee#1> hasFirstName 'Eric' I thought this could happen without any FKs defined. I assume that in order to import the FKs I would need to explicitly define those after the import. What I am seeing is - a subclasses of owlthing for each table. - propoerties defined for each column I don;t see any instances after import. Cheers Derek On Sep 9, 2:25 pm, Scott Henninger <[email protected]> wrote: > Derek; I did find the past post, but you may need to refresh my memory > on exactly what you are seeing. > > One of our discoveries during that time was that D2RQ requires foreign > keys to be explicitly defined for tables. We've asked the D2RQ folks > to look into this and I can follow up on this. Did you get a chance > to try this out? > > If so, or not, let us know what your current issues are and we can > work towards a solution. Platform should not matter - i.e. Oracle/ > D2RQ interface works with Windows/Mac. > > -- Scott > > On Sep 9, 5:14 am, Derek S <[email protected]> wrote: > > > Hi, > > > Having tried a re-install in its own mount point [/eclipse] I'm still > > getting the same problem. > > > Ok this is getting a little more protracted than i thought it would. > > So the back ground to this whole thing is that I raised a post in May > > 2009, which Scott looked at for me. The Post (which has since been > > archived) was called "D2R import with Oracle". As part of the > > investigation for that I said that I would attempt the install on > > Linux (ubuntu) and show that Oracle connections work fine. - > > > This post is really because it doesn't seem possible to install TBC on > > Linux > > - because of these TBC dependency problems haven't been defined for > > TBC > > - I haven't as yet found anyone who has managed a successful install > > on a platform other than Windows or OSX. > > > I'm not sure how to progress this. > > > Cheers > > Derek --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TopBraid Composer Users" group. 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-composer-users?hl=en -~----------~----~----~----~------~----~------~--~---
