<?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 : data modelling, twitter</title><link>http://sqlblog.com/blogs/jamie_thomson/archive/tags/data+modelling/twitter/default.aspx</link><description>Tags: data modelling, twitter</description><dc:language>en</dc:language><generator>CommunityServer 2.1 SP2 (Build: 61129.1)</generator><item><title>Twitter status id conundrum</title><link>http://sqlblog.com/blogs/jamie_thomson/archive/2010/04/18/twitter-status-id-conundrum.aspx</link><pubDate>Sun, 18 Apr 2010 15:05:38 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:24385</guid><dc:creator>jamiet</dc:creator><slash:comments>5</slash:comments><comments>http://sqlblog.com/blogs/jamie_thomson/comments/24385.aspx</comments><wfw:commentRss>http://sqlblog.com/blogs/jamie_thomson/commentrss.aspx?PostID=24385</wfw:commentRss><wfw:comment>http://sqlblog.com/blogs/jamie_thomson/rsscomments.aspx?PostID=24385</wfw:comment><description>&lt;p&gt;I have an interest, a slightly perverse one some might say, in using online services and trying to figure out what the underlying (logical) data model is and in this day and age Twitter is one that lends itself very well to scrutiny. Consider this recent tweet of mine:&lt;/p&gt;  &lt;blockquote&gt;   &lt;p&gt;&lt;a title="odata rdf tweet" href="http://twitter.com/jamiet/status/12154647354" target="_blank"&gt;&lt;img style="border-bottom:0px;border-left:0px;display:inline;border-top:0px;border-right:0px;" title="odata rdf tweet screenshot" border="0" alt="odata rdf tweet screenshot" src="http://sqlblog.com/blogs/jamie_thomson/image_0DAD61B4.png" width="389" height="246" /&gt;&lt;/a&gt; &lt;/p&gt; &lt;/blockquote&gt;  &lt;p&gt;The URL that enables you to see that tweet is &lt;a href="http://twitter.com/jamiet/status/12154647354" target="_blank"&gt;http://twitter.com/jamiet/status/12154647354&lt;/a&gt;&lt;strong&gt;&lt;/strong&gt;. We can interpret that URL to mean &amp;quot;a tweet by jamiet with an id of 12154647354&amp;quot; and hence we might further assume that the unique identifier for the tweet is {jamiet,12154647354}.    &lt;br /&gt;&lt;/p&gt;  &lt;p&gt;However, its well-known that Twitter gives each status a unique ID regardless of who tweeted it so we might expect we could reach that tweet just by using a URL of &lt;a href="http://twitter.com/status/12154647354" target="_blank"&gt;http://twitter.com/status/12154647354&lt;/a&gt; however (at the time of writing) that only redirects to Twitter's homepage. That seems strange to me especially given that we can use Twitter's API to access information about that tweet using only the id of the status. Witness &lt;a href="http://api.twitter.com/1/statuses/show/12154647354.xml" target="_blank"&gt;http://api.twitter.com/1/statuses/show/12154647354.xml&lt;/a&gt;:&lt;/p&gt;  &lt;blockquote&gt;   &lt;p&gt;&lt;a title="twitter api screenshot xml" href="http://api.twitter.com/1/statuses/show/12154647354.xml" target="_blank"&gt;&lt;img style="border-bottom:0px;border-left:0px;display:inline;border-top:0px;border-right:0px;" title="screenshot of twitter api result" border="0" alt="screenshot of twitter api result" src="http://sqlblog.com/blogs/jamie_thomson/image_0C8852C8.png" width="477" height="400" /&gt;&lt;/a&gt; &lt;/p&gt; &lt;/blockquote&gt;  &lt;blockquote&gt;   &lt;p&gt;&lt;em&gt;[We can also access a &lt;/em&gt;&lt;a href="http://json.org/" target="_blank"&gt;JSON&lt;/a&gt;&lt;em&gt;&lt;/em&gt;&lt;em&gt; version of that information using &lt;/em&gt;&lt;a href="http://api.twitter.com/1/statuses/show/12154647354.json" target="_blank"&gt;http://api.twitter.com/1/statuses/show/12154647354.json&lt;/a&gt;&lt;em&gt;&lt;/em&gt;&lt;em&gt;]&lt;/em&gt;&lt;/p&gt; &lt;/blockquote&gt;  &lt;p&gt;I'm puzzled as to why a tweet can't be accessed using on the main twitter website using the id alone. Anyone have any suggestions?&lt;/p&gt;  &lt;p&gt;&lt;a href="http://twitter.com/jamiet" target="_blank"&gt;@jamiet&lt;/a&gt;&lt;/p&gt;&lt;img src="http://sqlblog.com/aggbug.aspx?PostID=24385" width="1" height="1"&gt;</description><category domain="http://sqlblog.com/blogs/jamie_thomson/archive/tags/data+modelling/default.aspx">data modelling</category><category domain="http://sqlblog.com/blogs/jamie_thomson/archive/tags/random+waffle/default.aspx">random waffle</category><category domain="http://sqlblog.com/blogs/jamie_thomson/archive/tags/twitter/default.aspx">twitter</category></item></channel></rss>