Derek; Yes, your assumptions are correct. D2RQ will interpret: - tables as classes - rows as instances of the class - columns as properties - D2RQ will interpret foreign key columns as owl:ObjectProperty, if the key is defined (i.e. the mapping to another table/column is defined) - all others are owl:DatatypeProperty
The default mapping is created in a separate .owl file and can be edited. I.e. the default mapping out of the wizard is a first guess at how to do the mapping and you can modify to fit needs. For more, see: Help > Import and Export > Import external information > Importing Relational Databases with D2RQ ...that also includes a link to the D2RQ language page where you can get more information on the mapping. <I don;t see any instances after import. > Make sure you're viewing the data file (-Test). A separate schema file is also generated that will not have instance data in it. Instances should show up in the -test file without needing to modify the default map. Check permissions with your database. Also, if there is any information in the Composor Error Log or Console view, you may be able to use that to figure out what is going wrong. -- Scott On Sep 17, 7:06 am, Derek S <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
