<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://sqlblog.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>SSIS Junkie : semantic web, RDF</title><link>http://sqlblog.com/blogs/jamie_thomson/archive/tags/semantic+web/RDF/default.aspx</link><description>Tags: semantic web, RDF</description><dc:language>en</dc:language><generator>CommunityServer 2.1 SP2 (Build: 61129.1)</generator><item><title>Explaining the difference between OData &amp; RDF by way of analogy</title><link>http://sqlblog.com/blogs/jamie_thomson/archive/2010/04/14/explaining-the-difference-between-odata-rdf-using-an-analogy.aspx</link><pubDate>Wed, 14 Apr 2010 10:18:00 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:24273</guid><dc:creator>jamiet</dc:creator><slash:comments>5</slash:comments><comments>http://sqlblog.com/blogs/jamie_thomson/comments/24273.aspx</comments><wfw:commentRss>http://sqlblog.com/blogs/jamie_thomson/commentrss.aspx?PostID=24273</wfw:commentRss><wfw:comment>http://sqlblog.com/blogs/jamie_thomson/rsscomments.aspx?PostID=24273</wfw:comment><description>&lt;p&gt;A couple of months back I wrote a blog post entitled &lt;a href="http://sqlblog.com/blogs/jamie_thomson/archive/2010/02/03/microsoft-odata-and-rdf.aspx" target="_blank"&gt;Microsoft, OData and RDF&lt;/a&gt; where I gave a high level view of the &lt;a href="http://www.odata.org" target="_blank"&gt;OData protocol&lt;/a&gt; and how it compares to &lt;a href="http://www.w3.org/RDF/" target="_blank"&gt;RDF&lt;/a&gt;. I talked about linked data, triples and such like which may have been somewhat useful however jargon-heavy. Earlier today &lt;a href="http://sw-app.org/mic.xhtml#i" target="_blank"&gt;Dr Michael Hausenblas&lt;/a&gt; (&lt;a href="http://webofdata.wordpress.com/" target="_blank"&gt;blog&lt;/a&gt; | &lt;a href="http://twitter.com/mhausenblas"&gt;twitter&lt;/a&gt;) offered an analogy which I think is probably more useful and with Michael's permission I'm re-posting it here:&lt;/p&gt;&lt;blockquote&gt;&lt;p&gt;&lt;i&gt;Imagine a Web (a Web of Documents, if you wish), which is not based
on HTML and hyperlinks, but on MS Word documents. The documents are all
available on the Internet, so you can download them and consume the
content. But after you’re done with a certain document that talks about
a book, how do you learn more about it? For example, reviews about the
book or where you can purchase it? Maybe the original document mentions
that there is some more related information on another server. So you’d
need to go there and look for the related bit of information yourself.
You see? That’s what the Web is great at – you just click on a
hyperlink and it takes you to the document (or section) you’re
interested in. All the legwork is taken care of for you through HTML,
URIs and HTTP.&lt;/i&gt;&lt;/p&gt;&lt;p&gt;&lt;i&gt;Hm, right, but how is this related to OData?&lt;/i&gt;&lt;/p&gt;&lt;p&gt;&lt;i&gt;
Well, OData feels a bit like the above mentioned scenario, just
concerning data. Of course you – well actually rather a software
program I guess – can consume it (a single source), but that’s it.&lt;/i&gt;&lt;/p&gt;&lt;p&gt;&lt;i&gt;from &lt;a href="http://webofdata.wordpress.com/2010/04/14/oh-it-is-data-on-the-web/" rel="bookmark" title="Permanent Link: Oh – it is data on the&amp;nbsp;Web"&gt;Oh – it is data on the&amp;nbsp;Web by Michael Hausenblas&lt;br&gt;&lt;/a&gt;&lt;/i&gt;&lt;/p&gt;&lt;/blockquote&gt;
&lt;p&gt;I believe that OData has loads of use cases but its important to understand its limitations as well and I think Michael has done a good job of explaining those limitations.&lt;/p&gt;&lt;p&gt;&lt;a href="http://twitter.com/jamiet" target="_blank"&gt;@Jamiet&lt;/a&gt; &lt;br&gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;img src="http://sqlblog.com/aggbug.aspx?PostID=24273" width="1" height="1"&gt;</description><category domain="http://sqlblog.com/blogs/jamie_thomson/archive/tags/linked+data/default.aspx">linked data</category><category domain="http://sqlblog.com/blogs/jamie_thomson/archive/tags/OData/default.aspx">OData</category><category domain="http://sqlblog.com/blogs/jamie_thomson/archive/tags/RDF/default.aspx">RDF</category><category domain="http://sqlblog.com/blogs/jamie_thomson/archive/tags/semantic+web/default.aspx">semantic web</category></item><item><title>Microsoft, OData and RDF</title><link>http://sqlblog.com/blogs/jamie_thomson/archive/2010/02/03/microsoft-odata-and-rdf.aspx</link><pubDate>Wed, 03 Feb 2010 16:53:00 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:21784</guid><dc:creator>jamiet</dc:creator><slash:comments>5</slash:comments><comments>http://sqlblog.com/blogs/jamie_thomson/comments/21784.aspx</comments><wfw:commentRss>http://sqlblog.com/blogs/jamie_thomson/commentrss.aspx?PostID=21784</wfw:commentRss><wfw:comment>http://sqlblog.com/blogs/jamie_thomson/rsscomments.aspx?PostID=21784</wfw:comment><description>&lt;p class="MsoNormal"&gt;Earlier today Chris Webb posted a blog entry entitled &lt;a href="http://cwebbbi.spaces.live.com/Blog/cns%217B84B0F2C239489A%216224.entry"&gt;OData and Microsoft BI&lt;/a&gt; where he remarked upon the increasing importance of Microsoft’s burgeoning &lt;a href="http://www.odata.org/" target="_blank"&gt;OData protocol &lt;/a&gt;for accessing data over HTTP. Chris also linked to Douglas Purdy’s blog post &lt;a href="http://www.douglaspurdy.com/2010/02/01/odata-the-movie/"&gt;OData: The Movie&lt;/a&gt; which listed the following Microsoft and non-Microsoft technologies that support (or soon will support) OData either as a data producer or a data consumer:&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;Excel&lt;/li&gt;    &lt;li&gt;.Net client&lt;/li&gt;    &lt;li&gt;AJAX Client&lt;/li&gt;    &lt;li&gt;PHP client&lt;/li&gt;    &lt;li&gt;Java client&lt;/li&gt;    &lt;li&gt;Visual Studio&lt;/li&gt;    &lt;li&gt;Sharepoint&lt;/li&gt;    &lt;li&gt;SQL Server (via Reporting Services)&lt;/li&gt;    &lt;li&gt;Codename &amp;quot;Dallas&amp;quot;&lt;/li&gt;    &lt;li&gt;Websphere&lt;/li&gt; &lt;/ul&gt;  &lt;p class="MsoNormal"&gt;To that list I would add Windows Azure which exposes data from its storage engine using OData and also the forthcoming Live Framework technology that is expected to surface user-centric data from Microsoft’s various Live Services properties (e.g. SkyDrive, Messenger, Calendar).&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;  &lt;p class="MsoNormal"&gt;&lt;o:p&gt;&amp;#160;&lt;/o:p&gt;&lt;/p&gt;  &lt;p class="MsoNormal"&gt;Chris suggested that a pervasive format for data on the web would be a big step forward because any consumer that understood that format could talk to any producer that chose to expose it; win-win-win indeed. Unfortunately life is of course never that simple and as is so often the case there are many competing technologies in this space including (but, I suspect, not limited to) Microsoft’s OData, Google’s &lt;a href="http://code.google.com/apis/gdata/index.html" target="_blank"&gt;GData &lt;/a&gt;and the World Wide Web consortium’s &lt;a href="http://www.w3.org/RDF/" target="_blank"&gt;Resource Description Framework (RDF)&lt;/a&gt;.&lt;/p&gt;  &lt;p class="MsoNormal"&gt;&amp;#160;&lt;/p&gt;  &lt;p class="MsoNormal"&gt;This is nothing new of course; we can draw parallels with Atom and RSS which were recent competing technologies used to expose blog syndication feeds. Interestingly both of these technologies generally sit side-by-side quite happily these days (read: &lt;a href="http://www.25hoursaday.com/weblog/2009/01/06/WillTheOnlineIdentityWarTurnOutLikeTheXMLSyndicationWar.aspx" target="_blank"&gt;Will the Online Identity War turn out like the XML Syndication War?&lt;/a&gt;) and it will be interesting to see whether the same will happen in the OData/GData/RDF space; will organisations opt to expose multiple service heads for their various databases? I await the answer to that one with interest.&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;  &lt;p class="MsoNormal"&gt;&lt;o:p&gt;&amp;#160;&lt;/o:p&gt;&lt;/p&gt;  &lt;p class="MsoNormal"&gt;RDF is of particular interest chiefly because one of its main proponents is Sir Tim Berners-Lee, the inventor of the world wide web. RDF has been knocking around for about 10 years now and Berners-Lee sees it as the technology that will underpin the growth of the fabled Semantic Web; indeed he has been heavily involved with the recently announced service &lt;a href="http://data.gov.uk/"&gt;http://data.gov.uk&lt;/a&gt; which exposes data held by the UK government and it is no surprise that that service exposes its data using RDF.&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;  &lt;p class="MsoNormal"&gt;&lt;o:p&gt;&amp;#160;&lt;/o:p&gt;&lt;/p&gt;  &lt;p class="MsoNormal"&gt;I don’t know too much about GData but I do have a working knowledge of both OData &amp;amp; RDF so perhaps an overview and comparison of the two might be useful. To this observer it appears as though OData is closely tied to the tables-rows-and-columns paradigm that anybody familiar with traditional relational databases will understand. An OData service exposes multiple entities (roughly analogous to tables) and the relationships between them.&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;  &lt;p class="MsoNormal"&gt;   &lt;br /&gt;RDF however is built around the concept of triples which I assert is more analogous to a conceptual Entity-Attribute-Value model (that assertion is something I hope to explore in a future blog post). The key difference between RDF and OData though is that an RDF document can contain links to RDF documents that are hosted on &lt;i&gt;other&lt;/i&gt; services and attributes of entities are defined in terms of those other services. Put more simply, RDF data is one massively distributed, non-centralised, interlinked web of data and if that sounds an awful lot like the mass of HTML documents which form the world wide web then you shouldn’t be too surprised given that Berners-Lee is so heavily involved. The notion of linking data together in this way has also given rise to the very descriptive moniker &lt;a href="http://linkeddata.org/" target="_blank"&gt;linked data&lt;/a&gt; which you may well hear mentioned in the same sentence as “semantic web” from time to time.&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;  &lt;p class="MsoNormal"&gt;&lt;o:p&gt;&amp;#160;&lt;/o:p&gt;&lt;/p&gt;  &lt;p class="MsoNormal"&gt;This has been a rather rambling blog post and really its just me dumping some thoughts out onto your computer screen as you can tell from the rather unimaginative title. Nonetheless there is some interesting stuff going on here that I hope to explore in the future so if you're interested please return some time. If you have any thoughts I'd love to read them in the comments section below.&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;  &lt;p class="MsoNormal"&gt;&lt;o:p&gt;&amp;#160;&lt;/o:p&gt;&lt;/p&gt;  &lt;p class="MsoNormal"&gt;&lt;a href="http://twitter.com/jamiet" target="_blank"&gt;@Jamiet&lt;/a&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;&lt;img src="http://sqlblog.com/aggbug.aspx?PostID=21784" width="1" height="1"&gt;</description><category domain="http://sqlblog.com/blogs/jamie_thomson/archive/tags/linked+data/default.aspx">linked data</category><category domain="http://sqlblog.com/blogs/jamie_thomson/archive/tags/OData/default.aspx">OData</category><category domain="http://sqlblog.com/blogs/jamie_thomson/archive/tags/RDF/default.aspx">RDF</category><category domain="http://sqlblog.com/blogs/jamie_thomson/archive/tags/semantic+web/default.aspx">semantic web</category></item></channel></rss>