Hi Arif, This is interesting and I would like to know more about these changes. In particular,
1. Why were these changes necessary to fit D2RQ into OGSA-DAI? My guess is that the framework insists on personally executing all database queries, so you can only give it a SQL query and it will returns a ResultSet -- is this correct? Could you have solved the issue if D2RQ was able to accept a pre-established JDBC database Connection object? 2. Do you have a patch or can you name all the files that have been changed? Best, Richard On 23 Dec 2010, at 17:40, <[email protected]> <[email protected]> wrote: > Hi Everyone, > > I would like to draw your attention to a small project recently conducted by > the Science and Technology Facilities Council (STFC) and funded by the OMII > UK. The project, entitled "Geospatial Transformation using OGSA-DAI" > (GeoTOD-II), has developed a "Linked-Data" server that exposes spatial data > residing in relational databases as linked data, fully complying with the > guidelines provided by the UK Cabinet Office > (http://location.defra.gov.uk/wp-content/uploads/2010/04/Designing_URI_Sets_for_Location-Ver0.5.pdf). > > Of relevance to the D2RQ community is that the GeoTOD server uses a modified > version of the D2RQ model encapsulated in OGSA-DAI acitivities to serve up > linked data from relational databases. OGSA-DAI is an open source web > application (developed by the OMII UK) that allows data to be collected, > transformed, combined and exposed in different formats. > > Of particular mention here is the modified version of D2RQ used for GeoTOD; > it can be run in the following three different modes: > > * > > normal run (as per the original D2RQ implementation - default), > > * > > sqlOnly run (for generating the corresponding SQL statements for a SPARQL > query) and > > * > > triplesOnly run (for generating RDF triples using pre-generated Database > ResultSets for the corresponding SQL statements) > > These modifications of D2RQ were necessary to encapsulate an instance D2RQ > model within OGSA-DAI activities to generate different representations of a > dataset, e.g. RDF, HTML, GML, KML etc. > > GeoTOD and the modified version of D2RQ are available on SourceForge at: > https://sourceforge.net/projects/geotod/ > (For D2RQ source, look under the "Files" tab) > > Thanks for your time. > > Happy holidays. > > Best regards > Arif > > ---------------------------------------------------------------------- > Dr. Arif Shaon > > Software Research Scientist, > Scientific Applications Group, > E-Science Centre, Science and Technology Facilities Council, > Rutherford Appleton Laboratory Chilton, Didcot, OXON, OX11 0QX, UK > tel: +44 1235 448178 > [email protected]<mailto:[email protected]> > > -- > Scanned by iCritical. > > ------------------------------------------------------------------------------ > Learn how Oracle Real Application Clusters (RAC) One Node allows customers > to consolidate database storage, standardize their database environment, and, > should the need arise, upgrade to a full multi-node Oracle RAC database > without downtime or disruption > http://p.sf.net/sfu/oracle-sfdevnl > _______________________________________________ > d2rq-map-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel ------------------------------------------------------------------------------ Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ d2rq-map-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
