http://www.openlinksw.com/weblog/public/search.vspx?blogid=127&q=.isparql&type=text&output=html
Kingsley Idehen's Blog Data Space
2024-03-29T17:00:31Z
Kingsley Uyi Idehen
kidehen@openlinksw.com
About .isparql
16
1
10
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1238
<p> <a href="http://www.openlinksw.com">OpenLink Software</a> are pleased to announce release 2.6 of the <a href="http://oat.openlinksw.com">OpenLink AJAX Toolkit</a> (OAT).</p> <p> New Semantic Data Web related features and enhancements include:</p> <ul> * A Javascript-based <a href="http://www.w3.org/2005/04/fresnel-info/">Fresnel</a> processor enabling declarative RDF-based display templates for RDF Data Sources</ul> <ul>* An XSLT template for generating HTML pages from the Fresnel processor's XML output</ul> <ul>* <a href="http://demo.openlinksw.com/DAV/JS/isparql/index.html">Interactive Query Builder for SPARQL</a> (iSPARQL). This version of the iSPARQL application includes support for INSERTs and DELETEs</ul> <ul>* Enhanced Javascript-based N3/Turtle parser</ul> <ul>* New Navigator viewer panel for <a href="http://demo.openlinksw.com/DAV/JS/rdfbrowser/index.html">RDF Browser</a>.</ul> Related Items: <ul>*<a href="http://sourceforge.net/projects/oat">Project Home Page</a> </ul> <ul>*<a href="http://sourceforge.net/projects/oat/files">Source Code</a> </ul> <ul>*<a href="http://demo.openlinksw.com/DAV/JS/demo/index.html">Live Features Demonstrations</a>.</ul>
OpenLink Ajax Toolkit (OAT) 2.6 Released!
2007-08-01T18:49:17Z
2007-08-01T14:49:17-04:00
Kingsley Uyi Idehen
kidehen@openlinksw.com
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1134
<p>The simple demo use our Ajax based Visual Query Builder for the SPARQL Query Language (this isn't Grandma's Data Web UI, but not to worry, that is on it's way also). Here goes:</p> <ol> <li> go to http://demo.openlinksw.com/isparql </li> <li> Enter any of the following values into the "Default Data URI"; field: </li> <ul>- http://www.mkbergman.com/?p=336</ul> <ul>- http://radar.oreilly.com/archives/2007/02/pipes_and_filte.html</ul> <ul>- http://jeremy.zawodny.com/blog/archives/008513.html</ul> <ul>- Other URIs </ul> </ol> <p> What I am demonstrating is how existing Web Content hooks transperently into the <a href="http://www.openlinksw.com/weblog/public/search.vspx?blogid=127&q=data%20web&type=text&output=html">"Data Web"</a>. Zero RDF Tax :-) Everything is good!</p> <p>Note: Please look to the bottom of the screen for the "Run Query" Button. Remember, it not quite Grandma's UI but should do for Infonauts etc.. A screencast will follow.</p>
Hello Data Web!
2008-02-05T04:22:04Z
2008-02-04T23:22:04.000001-05:00
Kingsley Uyi Idehen
kidehen@openlinksw.com
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1146
<p>Situation Analysis: Pre or Post Oscars, you want to research Forest Whitaker, Helen Mirren, or Jennifer Hudson. What do you do? Go on a screen scrapping and keyword regular expression odyssey? Or you simply lookup a Data Web oriented Data Source like <a href="http://dbpedia.org">dbpedia</a>.</p> <p>Here is what I was I was able to knock together using my <a href="http://demo3.openlinksw.com:8890/isparql">SPARQL QBE</a> (without writing the SPARQL by hand):</p> <ol> <li> <a href="http://demo3.openlinksw.com:8890/DAV/home/demo/Forest_Whitaker_DataSpace.isparql.xml">Forest Whitaker Data</a> </li> <li> <a href="http://demo3.openlinksw.com:8890/DAV/home/demo/Helen_Mirren_DataSpace.isparql.xml">Helen Mirren Data</a> </li> <li> <a href="http://demo3.openlinksw.com:8890/DAV/home/demo/Jennifer_Hudson_DataSpace.isparql.xml">Jennifer Hudson Data</a>. </li> </ol> <p>Note: Just select the "Explore" option when the link-lookup window appears in response to you clicking on any of the links. That said, if you are using the <a href="https://addons.mozilla.org/firefox/190/">Firefox Linkification</a> extension the page will not work properly (as per this <a href="http://www.beggarchooser.com/forum/index.php?topic=37.0">discussion about disabling Linkification</a>) :-(</p> <p>BTW - I have a comments page, so don't be shy about showing me how you could produce this kind of data driven web page much quicker than I have :-)</p> <p>Warning: IE6 and Safari (use <a href="http://webkit.org/">Webkit</a> instead) cannot process these pages due to the use of Ajax.</p>
Using The Data Web to Research Oscar Winners
2007-02-27T05:29:02Z
2007-02-27T00:29:02-05:00
Kingsley Uyi Idehen
kidehen@openlinksw.com
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1081
<p> <a href="http://novaspivack.typepad.com/nova_spivacks_weblog/">Nova Spivack</a> provides poignant insights into the recent Web 2.0 vs Web 3.0 brouhaha which I've excerpted below: </p> <blockquote> <a href="http://novaspivack.typepad.com/nova_spivacks_weblog/2006/11/web_me20_explod.html">Web Me2.0 -- Exploding the Myth of Web 2.0</a>: <p>"Many people have told me this week that they think 'Web 2.0' has not been very impressive so far and that they really hope for a next-generation of the Web with some more significant innovation under the hood -- regardless of what it's called. A lot of people found the Web 2.0 conference in San Francisco to be underwhelming -- there was a lot of self-congratulation by the top few brands and the companies they have recently bought, but not much else happening. Where was all the innovation? Where was the focus on what's next? It seemed to be a conference mainly about what happened in the last year, not about what will happen in the coming year. But what happened last year is already so 'last year.' And frankly Web 2.0 still leaves a lot to be desired. The reason Tim Berners-Lee proposed the Semantic Web in the first place is that it will finally deliver on the real potential and vision of the Web. Not that today's Web 2.0 sucks completely -- it only sort of sucks. It's definitely useful and there are some nice bells and whistles we didn't have before. But it could still suck so much less!"</p> </blockquote> <p>Web 2.0 is a (not was) a piece of the overall Web puzzle. The Data Web (so called Web 3.0) is another critical piece of this puzzle, especially as it provides the foundation layer (Layer 1) of the Semantic Web.</p> <p>Web 2.0 was never about "Open Data Access", "Flexible Data Models", or "Open World" meshing of disparate data sources built atop disparate data schemas (see: <a href="http://www.openlinksw.com/blog/~kidehen/?id=1032">Web 2.0's Open Data Access Conundrum</a>). It was simply about "Execution and APIs". I already written about "Web Interaction Dimensions", but you call also look at the relationship of the currently perceived dimensions through the M-V-C programming pattern: </p> <ol> <li>Viewer (V) - Web 1.0 (Interaction, Dimension 1 - Interactive-Web)</li> <li>Controller (C) - Web 2.0 (Services, Dimension 2 - Services-Web which is about Execution & Application Logic; SOA outside/in-front-of the Firewall for Enterprise 2.0 crowd)</li> <li>Model (M) - Web 3.0 (Data, Dimension 3 - Data-Web which is about data model dexterity and open data access)</li> </ol> <p>Another point to note, Social Networking is hot, but nearly every social network that I know (and I know and use most of them) suffers from an impedance mismatch between the service(s) they provide (social networks) and their underlying data models (in many cases Relational as opposed to Graph). Networks are about Relationships (N-ary) and your cannot effectively exploit the deep potential of: "Network Effects" (Wisdom of Crowds, Viral Marketing etc..) without a complimentary data model, you simply can't.</p> <p>Finally, the Data Web is already here, I promised a long time ago (Internet Time) that the manifestation of the Semantic Web would occur unobtrusively, meaning, we will wake up one day and realize we are using critical portions of the Semantic Web (i.e. Data-Web) without even knowing it. Guess what? It's already happening. Simple case in point, you may have started to notice the emergence of <a href="http://rdfs.org/sioc/spec/">SIOC</a> gems in the same way you may have observed those RSS 2.0 gems at the dawn of Web 2.0. What I am implying here is that the real question we should be asking is: Where is the Semantic Web Data? And how easy or difficult will it be to generate? And where are the tools? My answers are presented below:</p> <p> </p> <ol> <li> <a href="http://pingthesemanticweb.com/">Pingthesemanticweb.com</a> - Semantic Web Data Source Lookup & Tracking Service</li> <li> <a href="http://swoogle.umbc.edu/">Swoogle </a>- Semantic Web Ontology Location Service</li> <li> <a href="http://esw.w3.org/topic/RdfAndSql">Semantic Web Solutions for Generating RDF Data from SQL Data</a> </li> <li> <a href="http://esw.w3.org/topic/SemanticWebTools">Semantic Web Solutions Directory</a> </li> <li> <a href="http://sioc-project.org/">SIOC Project</a> - Semantically-Interlinked Online Communities Ontology, a grassroots effort that provides a critical bridge between Web 2.0 and the Data-Web. For instance, existing Web 2.0 application profiles such as; Blogs, Wikis, Feed Aggregators, Content Managers, Discussion Forums etc.. are much closer to the Data-Web than you may think :-) </li> <li> <a href="http://virtuoso.openlinksw.com/wiki/main/Main/">Virtuoso</a> - our <a href="http://en.wikipedia.org/wiki/Virtuoso_Universal_Server">Universal Server</a> for the Data-Web</li> <li> <a href="http://virtuoso.openlinksw.com/wiki/main/Main/OdsIndex">OpenLink Data Spaces</a> (ODS) - our SIOC based platform for transparent incorporation of the Data-Web into Web 1.0 and Web 2.0</li> </ol> <p>Next stop, less writing, more demos, these are long overdue! At least from my side of the fence :-) I need to produce a little step-by-guide oriented screencasts that demonstrates how Web 2.0 meshes nicely with the Data-Web.</p> <p>Here are some (not so end-user friendly) examples of how you can use <a href="http://www.w3.org/TR/rdf-sparql-query/">SPARQL</a> (Data-Web's Query Language) to query Web 2.0 Instance Data projected through the SIOC Ontology:</p> <p> </p> <ol> <li> <a href="http://virtuoso.openlinksw.com/wiki/main/Main/ODSSIOCRef#Weblog%20Data%20Space">Weblog Data Query</a> </li> <li> <a href="http://virtuoso.openlinksw.com/wiki/main/Main/ODSSIOCRef#Wiki%20Data%20Space">Wiki Data Query</a> </li> <li> <a href="http://virtuoso.openlinksw.com/wiki/main/Main/ODSSIOCRef#Feeds%20/%20Subscriptions%20Data%20Space%20(Feed%20Aggregation)">Aggregated Feeds Data Query</a> - (RSS 1.0, RSS 2.0, Atom etc)</li> <li a="a" href="http://virtuoso.openlinksw.com/wiki/main/Main/ODSSIOCRef#Bookmarks%20Data%20Space">Shared Bookmarks Data Space</li> <li> <a href="http://virtuoso.openlinksw.com/wiki/main/Main/ODSSIOCRef#Briefcase%20Applications%20Data%20Space">Web Filesystem Data Query</a> - (Briefcase - Virtual Spotlight of sorts)</li> <li> <a href="http://virtuoso.openlinksw.com/wiki/main/Main/ODSSIOCRef#Photo%20Gallery%20Data%20Space">Photo Gallery Data Query</a> (this could be data from Flickr etc..)</li> <li> <a href="http://virtuoso.openlinksw.com/wiki/main/Main/ODSSIOCRef#Discussion%20/%20Conversation%20Data%20Space">Discussion Data Query</a> (e.g. Blog posts comments)</li> <li> <a href="http://virtuoso.openlinksw.com/wiki/main/Main/ODSSIOCRef#Generic%20Data%20Space%20Queries">Data Queries across different Data Spaces</a> - combining data from Wikis, Blogs, Feeds, Photos, Bookmarks, Discussions etc..</li> </ol> <p>Note: You can use the online SPARQL Query Interface at: http://demo.openlinksw.com/isparql.</p> <p> </p> <p> Other Data-Web Technology usage demos include:</p> <p> </p> <ol> <li> <a href="http://www.w3.org/2005/ajar/tab">TimBL's Tabulator</a> - A Data-Web Browser</li> <li> <a href="http://sites.wiwiss.fu-berlin.de/suhl/bizer/ng4j/semwebclient/#examples">Semantic Web Client Library</a> - <a href="http://www.w3.org/TR/rdf-concepts/">RDF</a> Data Drill Down Demos using SPARQL</li> <li> <a href="http://sioc-project.org/firefox">Semantic Radar</a> - A Firefox plug-in for auto-discovering SIOC Instance Data</li> <li> <a href="http://www.talkdigger.com/">Talk Digger</a> - SIOC based Web Conversation Tracker</li> </ol>
Web Me2.0 -- Exploding the Myth of Web 2.0
2006-11-16T21:11:46Z
2006-11-16T16:11:46-05:00
Kingsley Uyi Idehen
kidehen@openlinksw.com
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1612
<p>Deceptively simple demonstrations of how <a href="http://virtuoso.openlinksw.com" id="link-id11dfe45b8">Virtuoso</a>'s <a href="http://dbpedia.org/resource/SPARQL" id="link-id11a3d8968">SPARQL</a>-GEO extensions to SPARQL lay critical foundation for Geo Spatial solutions that seek to leverage the burgeoning <a href="http://dbpedia.org/resource/World_Wide_Web">Web</a> of <a href="http://dbpedia.org/resource/Linked_Data" id="link-id11ae855b8">Linked Data</a>. </p> <h3>Setup <a href="http://dbpedia.org/resource/Information" id="link-id120a6f478">Information</a> </h3> <p>SPARQL Endpoint: <a href="http://lod.openlinksw.com/sparql" id="link-id120401958">Linked Open Data Cache</a> (8.5 Billion+ Quad Store which includes data from Geonames and the <a href="http://dl-learner.org/Projects/LinkedGeoData" id="link-id11b8f31d8">Linked GeoData Project</a> Data Sets) .</p> <h3>Live Linked Data Meshup Links:</h3> <ul> <li> <a href="http://bit.ly/cyJjwo" id="link-id120396168">LinkedGeoData things within 2km ORDER BY Dist LIMIT 10 </a>(Use from <strong>iPhone</strong> only since its an iPhone oriented Linked Data driven application)</li> <li> <a href="http://uriburner.com/isparql/view/?query=PREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0APREFIX%20lgv%3A%20%3Chttp%3A%2F%2Flinkedgeodata.org%2Fvocabulary%23%3E%0Aconstruct%20%7B%3Fthing%20a%20%3Ftype%3B%0A%20geo%3Ageometry%20%3Fgeo%3B%0A%20foaf%3Aname%20%3Fname%7D%0Awhere%20%7B%0A%3Fthing%20geo%3Ageometry%20%3Fgeo%20.%0A%3Fthing%20lgv%3Aname%20%3Fname%20.%0A%3Fthing%20a%20%3Ftype.%0AFILTER%20%28bif%3Ast_intersects%20%28%3Fgeo%2C%20bif%3Ast_point%20%28-0.128056%2C%2051.508057%29%2C%202%29%29%0A%7D%0ALIMIT%20100&endpoint=http://lod.openlinksw.com/sparql&resultview=map&maxrows=50" id="link-id1209a6f38">LinkedGeoData things within 2km of Trafalgar Square</a> | <a href="http://uriburner.com/isparql/view/?query=PREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0APREFIX%20lgv%3A%20%3Chttp%3A%2F%2Flinkedgeodata.org%2Fvocabulary%23%3E%0Aconstruct%20%7B%0A%20%3Fthing%20rdfs%3Atype%20%3Ftype%3B%0A%20geo%3Ageometry%20%3Fgeo%3B%0A%20foaf%3Aname%20%3Fname%7D%0Awhere%20%7B%0A%20%3Fthing%20geo%3Ageometry%20%3Fgeo%20.%0A%20%3Fthing%20lgv%3Aname%20%3Fname%20.%0A%20%3Fthing%20a%20%3Ftype.%0AFILTER%20(bif%3Ast_intersects%20(%3Fgeo%2C%20bif%3Ast_point%20(-0.128056%2C%2051.508057)%2C%202))%0A%7D%0Aorder%20by%20asc%20(bif%3Ast_distance%20(%3Fgeo%2C%20bif%3Ast_point%20(-0.128056%2C%2051.508057)))%0ALIMIT%20100&endpoint=http://lod.openlinksw.com/sparql&resultview=map&maxrows=50" id="link-id11ebb07f8">ORDER By Distance - closest first</a> | <a href="http://uriburner.com/isparql/view/?query=PREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0APREFIX%20lgv%3A%20%3Chttp%3A%2F%2Flinkedgeodata.org%2Fvocabulary%23%3E%0Aconstruct%20%7B%0A%20%3Fthing%20rdfs%3Atype%20%3Ftype%3B%0A%20geo%3Ageometry%20%3Fgeo%3B%0A%20foaf%3Aname%20%3Fname%7D%0Awhere%20%7B%0A%20%3Fthing%20geo%3Ageometry%20%3Fgeo%20.%0A%20%3Fthing%20lgv%3Aname%20%3Fname%20.%0A%20%3Fthing%20a%20%3Ftype.%0AFILTER%20(bif%3Ast_intersects%20(%3Fgeo%2C%20bif%3Ast_point%20(-0.128056%2C%2051.508057)%2C%202))%0A%7D%0Aorder%20by%20desc%20(bif%3Ast_distance%20(%3Fgeo%2C%20bif%3Ast_point%20(-0.128056%2C%2051.508057)))%0ALIMIT%20100&endpoint=http://lod.openlinksw.com/sparql&resultview=map&maxrows=50" id="link-id1207a27e8">ORDER By Distance - most distant first</a> .</li> </ul> <h3>Related</h3> <ul> <li> <a href="http://delicious.com/kidehen/linked_data_demo" id="link-id11ac9a2a8">Collection of Live Linked Data Demos</a> </li> <li> <a href="http://www.openlinksw.com/dataspace/oerling/weblog/Orri%20Erling%27s%20Blog/1587" id="link-id11aca1d68">Virtuoso's SPARQL-GEO Extensions</a> </li> </ul>
Meshups Demonstrating How SPARQL-GEO Enhances Linked Data Exploitation (Update 2)
2010-03-24T15:44:24Z
2010-03-24T11:44:24.000002-04:00
Kingsley Uyi Idehen
kidehen@openlinksw.com
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1489
<h3>What is it?</h3> <p>A pre-installed edition of <a href="http://virtuoso.openlinksw.com" id="link-id14bea838">Virtuoso</a> for Amazon's EC2 Cloud platform.</p> <h3>What does it offer?</h3> From a <a href="http://dbpedia.org/resource/World_Wide_Web">Web</a> Entrepreneur perspective it offers: <ol> <li> Low cost entry point to a game-changing Web 3.0+ (and beyond) platform that combines <a href="http://dbpedia.org/resource/SQL" id="link-id11309b38">SQL</a>, <a href="http://dbpedia.org/resource/Resource_Description_Framework" id="link-id135f7988">RDF</a>, XML, and Web Services functionality</li> <li> Flexible variable cost model (courtesy of <a href="http://aws.amazon.com/devpay/" id="link-id17941018">EC2 DevPay</a>) tightly bound to revenue generated by your services</li> <li> Delivers federated and/or centralized model flexibility for you SaaS based solutions</li> <li> Simple entry point for developing and deploying sophisticated database driven applications (SQL or RDF <a href="http://dbpedia.org/resource/Linked_Data" id="link-id14ea6b10">Linked Data Web</a> oriented)</li> <li> Complete framework for exploiting OpenID, OAuth (including Role enhancements) that simplifies exploitation of these vital Identity and <a href="http://dbpedia.org/resource/Data">Data</a> Access technologies</li> <li>Easily implement RDF Linked Data based Mail, Blogging, Wikis, Bookmarks, Calendaring, Discussion Forums, Tagging, Social-Networking as <a href="http://en.wikipedia.org/wiki/Data_Spaces" id="link-id11519928">Data Space</a> (data containers) features of your application or service offering</li> <li>Instant alleviation of challenges (e.g. service costs and agility) associated with <a href="http://dbpedia.org/resource/DataPortability" id="link-id111cb610">Data Portability</a> and Open Data Access across Web 2.0 data silos</li> <li> LDAP integration for <a href="http://dbpedia.org/resource/Intranet" id="link-id114a8270">Intranet</a> / <a href="http://dbpedia.org/resource/Extranet" id="link-id10fe4f08">Extranet</a> style applications.</li> </ol> <p>From the DBMS engine perspective it provides you with one or more pre-configured instances of Virtuoso that enable immediate exploitation of the following services:</p> <ol> <li> RDF Database (a Quad Store with <a href="http://dbpedia.org/resource/SPARQL" id="link-id11911bf8">SPARQL</a> & SPARUL Language & Protocol support)</li> <li> <a href="http://dbpedia.org/resource/SQL" id="link-id110544c8">SQL</a> Database (with <a href="http://dbpedia.org/resource/Open_Database_Connectivity" id="link-id1524c7d0">ODBC</a>, <a href="http://dbpedia.org/resource/Java_Database_Connectivity" id="link-id14cfb658">JDBC</a>, OLE-DB, <a href="http://dbpedia.org/resource/ADO.NET" id="link-id110ec6c8">ADO</a>.NET, and XMLA driver access)</li> <li>XML Database (XML Schema, <a href="http://dbpedia.org/resource/XQuery" id="link-id10ebf218">XQuery</a>/<a href="http://dbpedia.org/resource/XPath" id="link-id142a7898">Xpath</a>, XSLT, Full Text Indexing)</li> <li>Full Text Indexing.</li> </ol> <p>From a Middleware perspective it provides:</p> <ol> <li> RDF Views (Wrappers / Semantic Covers) over SQL, XML, and other data sources accessible via SOAP or REST style Web Services</li> <li> Sponger Service for converting non RDF <a href="http://dbpedia.org/resource/Information" id="link-id11931c60">information</a> resources into RDF <a href="http://dbpedia.org/resource/Linked_Data" id="link-id118f7168">Linked Data</a> "on the fly" via a large collection of pre-installed RDFizer Cartridges.</li> </ol> <p>From the Web Server Platform perspective it provides an alternative to LAMP stack components such as <a href="http://dbpedia.org/resource/MySQL" id="link-id10f7b780">MySQL</a> and Apace by offering</p> <ol> <li> HTTP Web Server</li> <li> WebDAV Server</li> <li> Web <a href="http://dbpedia.org/resource/Application_server" id="link-id1268daa8">Application Server</a> (includes <a href="http://dbpedia.org/resource/PHP" id="link-id1585d238">PHP</a> runtime hosting)</li> <li> SOAP or REST style Web Services Deployment</li> <li> RDF Linked Data Deployment</li> <li> SPARQL (SPARQL Query Language) and SPARUL (SPARQL Update Language) endpoints</li> <li>Virtuoso Hosted PHP packages for <a href="http://dbpedia.org/resource/MediaWiki" id="link-id15568818">MediaWiki</a>, <a href="http://dbpedia.org/resource/Drupal" id="link-id110bd7a8">Drupal</a>, <a href="http://dbpedia.org/resource/WordPress" id="link-id10f66918">Wordpress</a>, and <a href="http://dbpedia.org/resource/PhpBB" id="link-id13fda4d0">phpBB3</a> (just install the relevant Virtuoso Distro. Package). </li> </ol> <p>From the general System Administrator's perspective it provides:</p> <ol> <li> Online Backups (Backup Set dispatched to S3 buckets, FTP, or HTTP/WebDAV server locations)</li> <li>Synchronized Incremental Backups to Backup Set locations</li> <li>Backup Restore from Backup Set location (without exiting to EC2 shell).</li> </ol> <p>Higher level user oriented offerings include:</p> <ol> <li>OpenLink Data Explorer front-end for exploring the burgeoning Linked Data <a href="http://dbpedia.org/resource/Giant_Global_Graph" id="link-id11646dc8">Web</a> </li> <li> Ajax based SPARQL Query Builder (iSPARQL) that enables SPARQL Query construction by Example</li> <li>Ajax based SQL Query Builder (QBE) that enables SQL Query construction by Example.</li> </ol> <p>For Web 2.0 / 3.0 users, developers, and entrepreneurs it offers it includes Distributed Collaboration Tools & Social Media realm functionality courtesy of <a href="http://dbpedia.org/resource/OpenLink_Data_Spaces" id="link-id11009930">ODS</a> that includes:</p> <ol> <li> Point of presence on the Linked Data Web that meshes your Identity and your Data via URIs</li> <li> System generated Social Network Profile & Contact Data via <a href="http://dbpedia.org/resource/Friend_of_a_friend" id="link-id1185a1c0">FOAF</a>?</li> <li> System generated <a href="http://dbpedia.org/resource/SIOC" id="link-id14791890">SIOC</a> (Semantically Interconnected Online Community) <a href="http://en.wikipedia.org/wiki/Data_Spaces" id="link-id1577cad8">Data Space</a> (that includes a Social Graph) exposing all your Web data in RDF Linked Data form</li> <li> System generated OpenID and automatic integration with FOAF</li> <li> Transparent Data Integration across Facebook, Digg, LinkedIn, FriendFeed, Twitter, and any other Web 2.0 data space equipped with RSS / Atom support and/or REST style Web Services</li> <li> In-built support for SyncML which enables data synchronization with Mobile Phones.</li> </ol> <h3>How Do I Get Going with It?</h3> <ul> <li> <a href="http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/ODSInstallationEC2" id="link-id114e1600">Standard Installation Guide</a> </li> <li> <a href="http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtEC2AMIDBpediaInstall" id="link-id110a98e8">Personal or Service Specific DBpedia Installation Guide</a> </li> </ul>
Introducing Virtuoso Universal Server (Cloud Edition) for Amazon EC2
2008-11-28T21:06:02Z
2008-11-28T16:06:02.000006-05:00
Kingsley Uyi Idehen
kidehen@openlinksw.com
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1306
<p>The title of this post is a "Tongue in cheek" expression of euphoria now that I have <a href="http://dbpedia.org/resource/Friend_of_a_friend" id="link-idfa63488">FOAF</a> and <a href="http://dbpedia.org/resource/SIOC" id="link-idfa976f0">SIOC</a> (pronounced SHOCK) based data spaces exposed via <a href="http://myopenlink.net/dataspace/person/kidehen" id="link-idfde41f8">my FOAF</a> and <a href="http://myopenlink.net/dataspace/kidehen" id="link-idfdca6c8">my SIOC</a> information resource (<a href="http://dbpedia.org/resource/Resource_Description_Framework" id="link-id16d0b0d8">RDF</a> files) <a href="http://dbpedia.org/resource/Uniform_Resource_Identifier" id="link-idfa97070">URI</a>s.</p> <p>If you want to explore who I know, what I read, and what I've tagged (amongst other things), all you have to do is:</p> <ol> <li>Beam a <a href="http://dbpedia.org/resource/SPARQL" id="link-idfdca878">SPARQL</a> query down my data space URIs which expose FOAF or SIOC based interconnected <a href="http://dbpedia.org/resource/Linked_Data" id="link-idfa954e8">Linked Data</a> graphs.</li> <li> Walkthrough using an RDF Browser until you reach a beachhead and then beam your SPARQL from there (remember you only need the URI of the RDF Data Source, and while in my Data Space every data item has a proper URI).</li> </ol> <p>Some Tools that help you comprehend what I am saying:</p> <h2>Browsers</h2> <ul> Zitgist Data Viewer (<a href="http://dataviewer.zitgist.com/?uri=http%3A//myopenlink.net/dataspace/kidehen" id="link-id16d410c0">SIOC</a> and <a href="http://dataviewer.zitgist.com/?uri=http%3A//myopenlink.net/dataspace/person/kidehen" id="link-idfa489e8">FOAF</a> data spaces)</ul> <ul>OpenLink RDF Browser (<a href="http://demo.openlinksw.com/rdfbrowser/?uri=http%3A%2F%2Fmyopenlink.net%2Fdataspace%2Fkidehen" id="link-idfa8b0d8">SIOC</a> and <a href="http://demo.openlinksw.com/rdfbrowser/?uri=http%3A%2F%2Fmyopenlink.net%2Fdataspace%2Fperson%2Fkidehen" id="link-idfa974a8">FOAF</a> data spaces)</ul> <ul>DISCO (<a href="http://www4.wiwiss.fu-berlin.de/rdf_browser/?browse_uri=http%3A%2F%2Fmyopenlink.net%2Fdataspace%2Fkidehen%2Fspace%23this" id="link-idfa62288">SIOC</a> and <a href="http://myopenlink.net/dataspace/person/kidehen#this" id="link-idf940338">FOAF</a> data spaces)</ul> <ul> <a href="http://dig.csail.mit.edu/2005/ajar/release/tabulator/0.8/tab.html" id="link-id16d6a4b8">Tabulator</a> </ul> <h2>Query Tools</h2> <ul> <a href="http://demo.openlinksw.com/sparql_demo" id="link-idfdd43b8">SPARQL Demo</a> </ul> <ul> <a href="http://demo.openlinksw.com/isparql" id="link-idfa96bd0">iSPARQL QBE</a> </ul>
FOAF-ing Linked Data is quite SIOC-ing
2008-02-01T23:20:34Z
2008-02-01T18:20:34-05:00
Kingsley Uyi Idehen
kidehen@openlinksw.com
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1295
<p>The W3C officially unveiled the SPARQL Query Language today via a press release titled: <a href="http://www.w3.org/2007/12/sparql-pressrelease" id="link-id10074ca8">W3C Opens Data on the Web with SPARQL</a>.</p> <h2>What is <a href="http://dbpedia.org/resource/SPARQL" id="link-id10183f60">SPARQL</a>?</h2> <p>A query language for the burgeoning Structured & <a href="http://dbpedia.org/resource/Linked_Data" id="link-id10426b18">Linked Data</a> Web (aka <a href="http://dbpedia.org/resource/Semantic_Web" id="link-idffde090">Semantic Web</a> / <a href="http://en.wikipedia.org/wiki/Giant_Global_Graph" id="link-id103e3688">Giant Global Graph</a>). Like <a href="http://dbpedia.org/resource/SQL" id="link-id103365f8">SQL</a>, for the Relational Data Model, it provides a query language for the Graph based <a href="http://dbpedia.org/resource/RDF" id="link-id103e33e8">RDF</a> Data Model.</p> <p>It's also a <a href="http://dbpedia.org/resource/Representational_State_Transfer" id="link-id1036a3d0">REST</a> or <a href="http://dbpedia.org/resource/SOAP" id="link-id103b36d8">SOAP</a> based Web Service that exposes SPARQL access to RDF Data via an endpoint. </p> <p>In addition, it's also a Query Results Serialization format that includes <a href="http://dbpedia.org/resource/XML" id="link-id1023bc60">XML</a> and <a href="http://dbpedia.org/resource/JSON" id="link-id102c3f88">JSON</a> support.</p> <h2>Why is it Important?</h2> <p>It brings important clarity to the notion of the "Web as a Database" by transforming existing Web Sites, Portals, and Web Services into bona fide corpus of Mesh-able (rather than Mash-able) Data Sources. For instance, you can perform queries that join one or more of the aforementioned data sources in exactly the same manner (albeit different syntax) as you would one or more SQL Tables. </p> <h3>Example:</h3> <p>-- SPARQL equivalent of SQL SELECT * against my personal data space hosted FOAF file</p> <b><pre> SELECT DISTINCT ?s ?p ?o FROM <http://myopenlink.net/dataspace/person/kidehen> WHERE {?s ?p ?o}</pre></b> <p>-- SPARQL against my social network -- Note: My SPARQL will be beamed across all of contacts in the social networks of my contacts as long as they are all HTTP URI based within each data space</p> <b><pre>PREFIX foaf: <http://xmlns.com/foaf/0.1/> SELECT DISTINCT ?Person FROM <http://myopenlink.net/dataspace/person/kidehen> WHERE {?s a foaf:Person; foaf:knows ?Person}</pre></b> <p>Note: you can use the basic <a href="http://demo.openlinksw.com/sparql" id="link-id1007d9b8">SPARQL Endpoint</a>, <a href="http://demo.openlinksw.com/isparql" id="link-id102c3e08">SPARQL Query By Example</a>, or <a href="http://demo.openlinksw.com/sparql_demo" id="link-id10201f98">SPARQL Query Builder Demo tool</a> to experiment with the demonstration queries above.</p> <h2>How Do I use It?</h2> <p>SPARQL is implemented by RDF Data Management Systems (Triple or Quad Stores) just as SQL is implemented by Relational Database Management Systems. The aforementioned data management systems will typically expose SPARQL access via a SPARQL endpoint.</p> <h2>Where are it's implementations?</h2> <p>A SPARQL implementors Testimonial page accompanies the SPARQL press release. In addition the is a growing collection of implementations on the<a href="http://esw.w3.org/topic/SparqlImplementations" id="link-id10066ca8"> ESW Wiki Page for SPARQL compliant RDF Triple & Quad Stores</a>.</p> <h2>Is this really a big deal?</h2> <p>Yes! SPARQL facilitates an<a href="http://virtuoso.openlinksw.com/presentations/Virtuoso_Sponger_1/Virtuoso_Sponger_1.html" id="link-id101ee5b0"> unobtrusive manifestation of a Linked Data Web</a> by way of natural extension of the existing Document Web i.e these Web enclaves co-exist in symbiotic fashion. </p> <p>As <a href="http://dbpedia.org" id="link-id1037edc0">DBpedia</a> very clearly demonstrates, Linked Data makes the Semantic Web demonstrable and much easier to comprehend. Without SPARQL there would be no mechanism for <a href="http://virtuoso.openlinksw.com/presentations/Virtuoso_Deploying_Linked_Data/Virtuoso_Deploying_Linked_Data.html" id="link-id10455da8">Linked Data deployment</a>, and without Linked Data there is no mechanism for Beaming Queries (directly or indirectly) across the Giant Global Graph of data hosted by Social Networks, Shard Bookmarks Services, Weblogs, Wikis, RSS/Atom/OPML feeds, Photo Galleries and other Web accessible Data Sources (Data Spaces).</p> <h2>Related items</h2> <ul> <a href="http://www.w3.org/TR/cooluris/" id="link-id102021d8">Cool URIs</a> </ul> <ul> <a href="http://sites.wiwiss.fu-berlin.de/suhl/bizer/pub/LinkedDataTutorial/" id="link-id1020d5c0">Publishing Linked Data Tutorial</a> </ul> <ul a="a" href="http://virtuoso.openlinksw.com/wiki/main/Main/ODSSIOCRef"> Detailed SPARQL Query Examples using SIOC Data Spaces</ul> <ul> <a href="http://virtuoso.openlinksw.com/wiki/main/Main/ODSFOAFRef" id="link-id102c4608">Detailed SPARQL Query Examples using FOAF Data Spaces</a> </ul>
W3C's SPARQLing Data Access Ingenuity
2008-01-17T20:41:04Z
2008-01-17T15:41:04.000006-05:00
Kingsley Uyi Idehen
kidehen@openlinksw.com
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1261
<p>I've written extensively on the subject of <a href="http://www.openlinksw.com/weblog/public/search.vspx?blogid=127&q=data%20spaces&type=text&output=html" id="link-id134c2280">Data Spaces</a> in relation to the <a href="http://www.openlinksw.com/weblog/public/search.vspx?blogid=127&q=data%20web%0D%0A&type=text&output=html" id="link-id105aef90">Data Web</a> for while. I've also written sparingly about <a href="http://virtuoso.openlinksw.com/wiki/main/Main/OdsIndex" id="link-id105bd100">OpenLink Data Spaces</a> (a Data Web Platform that build using Virtuoso). On the other hand, I haven't shed much light on installation and deployment of OpenLink Data Spaces.</p> <p> <a href="http://blog.jonudell.net" id="link-id14347f20">Jon Udell</a> recently penned a post titled: <a href="http://blog.jonudell.net/2007/09/21/the-fourth-platform/" id="link-id1439ed48">The Fourth Platform</a>. The post arrives at a spookily coincidental time (this happens quite often between Jon and I as demonstrated last year during our <a href="http://weblog.infoworld.com/udell/gems/ju_idehen.mp3" id="link-id107d17a8">podcast</a>; the "Fourth" in his Innovators Podcast series).</p> <p>The platform that Jon describes is "Cloud Based" and comprised of Storage and Computation. I would like to add Data Access and Management (native and virtual) under the fourth platform banner with the end product called: "Cloud based Data Spaces". </p> <p>As I write, we are releasing a Virtuoso AMI (Amazon Image) labeled: virtuoso-dataspace-server. This edition of<a href="http://virtuoso.openlinksw.com" id="link-id13543210"> Virtuoso</a> includes the OpenLink Data Spaces Layer and all of the OAT applications we've been developing for a while.</p> <h2>What Benefits Does this offer?</h2> <ol> <li>Personal Data Spaces in the Cloud - a place where you can control and consolidate data across your Blogs, Wikis, RSS/Atom Feed Subscriptions, Shared Bookmarks, Shared Calendars, Discussion Threads, Photo Galleries etc</li> <li>All the data in your Data <a href="http://en.wikipedia.org/wiki/Data_Spaces">Space</a> is <a href="http://dbpedia.org/resource/SPARQL" id="link-id1149a4f8">SPARQL</a> or <a href="http://dbpedia.org/resource/GData" id="link-id107a9f28">GData</a> accessible.</li> <li>All of the data in your Personal Data Space is <a href="http://dbpedia.org/resource/Linked_Data">Linked Data</a> from the get go. Each Item of data is <a href="http://dbpedia.org/resource/Uniform_Resource_Identifier">URI</a> addressable</li> <li> <a href="http://dbpedia.org/resource/SIOC" id="link-id104f4160">SIOC</a> support - your Blogs, Wikis, Bookmarks etc.. are based on the SIOC ontology for Semantically Interlinking Online Communities (think: Open social-graph++) </li> <li> <a href="http://dbpedia.org/resource/Friend_of_a_friend" id="link-id105beb78">FOAF</a> support - your FOAF Profile page provides a URI that is an in-road to all Data in your Data Space.</li> <li> <a href="http://dbpedia.org/resource/OpenID" id="link-id1144e138">OpenID</a> support - your Personal Data Space ID is usable wherever OpenID is supported. OpenID and FOAF are integrated as per latest FOAF specs</li> <li>Two Integration with Facebook - You can access your Data Space from Facebook or access Facebook from your Data Space</li> <li>Unified Storage - The WebDAV based filesystem provides Cloud Storage that's integrated with Amazon S3; It also exposes all of your Data Space data via a traditional filesystem UI (think virtual Spotlight); You can also mount this drive to your local filesystem via your native operating system's WebDAV support</li> <li> <a href="http://dbpedia.org/resource/SyncML" id="link-id11128f48">SyncML</a> - you can sync calendar and contact details with your Data Space in the cloud from your Mobile phone.</li> <li>A practical Semantic Data Web solution - based on Web Infrastructure and doesn't require you to do anything beyond exposing URIs for data in your Data Spaces.</li> </ol> <h2> <a href="http://dbpedia.org/resource/Amazon_Elastic_Compute_Cloud" id="link-id115d1920">EC2</a>-AMI Details:</h2> <ul>AMI ID: ami-e2ca2f8b</ul> <ul>Manifest file: virtuoso-images/virtuoso-dataspace-server.manifest.xml</ul> <h2>Installation Guide:</h2> <ol> <li>Get an Amazon Web Services (AWS) account</li> <li>Signup for S3 and EC2 services</li> <li>Install the EC2 plugin for Firefox</li> <li>Start the EC2 plugin</li> <li>Locate the row containing <b>ami-7c31d515 Manifest virtuoso-test/virtuoso-cloud-beta-9-i386.manifest.xml </b>(sort using the AMI ID or Manifest Columns or search on pattern: virtuoso, due to name flux)</li> <li>Start the Virtuoso Data Space Server AMI</li> <li>Wait 4-5 minutes (*take a few minutes to create the pre-configured Linux Image*)</li> <li>Connect to http://<public_dns_name_of_your_instance>http://your-ec2-instance-cname:8890/ Log in with user/password dba/dba</public_dns_name_of_your_instance> </li> <li>Go to the Admin UI (Virtuoso Conductor) and change the PWDs for the 'dba' and 'dav' accounts (*Important!*)</li> <li>Give the "SPARQL" user "SPARQL_UPDATE" privileges (required if you want to exploit the in-built Sponger Middleware)</li> <li>Click on the <a href="http://dbpedia.org/resource/OpenLink_Data_Spaces">ODS</a> (OpenLink Data Spaces) link to start an Personal Editon of OpenLink Data Spaces (or go to: http://your-ec2-instance-cname/dataspace/ods/index.html)</li> <li>Log-in using the username and password credentials for the 'dav' account (or register a new user note: OpenID is an option here also) Create an Data Space Application Instance by clicking on a Data Space App. Tab</li> <li>Import data from your existing Web 2.0 style applications into OpenLink Data Spaces e.g. subscribe to a few RSS/Atom feeds via the "Feeds Manager" application or import some Bookmarks using the "Bookmarks" application</li> <li>Then look at the imported data in Linked Data form via your ODS generated URIs based on the patterns: http://your-ec2-instance-cname/dataspace/person/your-ods-id#this (URI for You the Person), http://your-ec2-instance-cname/dataspace/person/your-ods-id (FOAF File URI), http://your-ec2-instance-cname/dataspace/your-ods-id (SIOC File URI)<br /> </li> </ol> <h2> (OAT) from your Data Space instance</h2>Install the OAT VAD package via the Admin UI and then apply the URI patterns below within your browser:<br /> <ol> <li>http://<public_dns_name_of_your_instance>:8890/oatdemo - Entire OAT Demo Collection</public_dns_name_of_your_instance> </li> <li>http://<public_dns_name_of_your_instance>:8890/rdfbrowser - RDF Browser</public_dns_name_of_your_instance> </li> <li>http://<public_dns_name_of_your_instance>:8890/isparql - SPARQL Query Builder (iSPARQL)</public_dns_name_of_your_instance> </li> <li>http://<public_dns_name_of_your_instance>:8890/qbe - SQL Query Builder (iSQL)</public_dns_name_of_your_instance> </li> <li>http://<public_dns_name_of_your_instance>:8890/formdesigner - Forms Builder (for building Meshups based on RDF, SQL, or Web Servives Data Souces)</public_dns_name_of_your_instance> </li> <li>http://<public_dns_name_of_your_instance>:8890/dbdesigner - SQL DB Schema Designer (note a Visual SQL-RDF Mapper is also on it's way</public_dns_name_of_your_instance> </li> <li>http://<public_dns_name_of_your_instance>:8890/DAV/JS/ - To view the OAT Tree (there are some experimental demos that are missing from the main demo app etc..) </public_dns_name_of_your_instance> </li> </ol> <p>There's more to come!</p>
Fourth Platform: Data Spaces in The Cloud (Update)
2008-10-26T21:59:33Z
2008-10-26T17:59:33-04:00
Kingsley Uyi Idehen
kidehen@openlinksw.com
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1224
<p>Last week we <a href="http://www.openlinksw.com/press/virt_501.htm">officially released Virtuoso 5.0.1</a> (in Commercial and Open Source Editions). The press release provided us with an official mechanism and timestamp for the current Virtuoso feature set.</p> <p>A vital component of the new Virtuoso release is the finalization of our SQL to RDF mapping functionality -- enabling the declarative mapping of SQL Data to RDF. Additional technical insight covering other new features (delivered and pending) is provided by <a href="http://www.openlinksw.com/weblogs/oerling/">Orri Erling</a>, as part of a series of post-Banff posts.</p> <h2>Why is SQL to RDF Mapping a Big Deal?</h2> <p>A majority of the world's data (especially in the enterprise realm) resides in SQL Databases. In addition, Open Access to the data residing in said databases remains the biggest challenge to enterprises for the following reasons:</p> <ol> <li> SQL Data Sources are inherently heterogeneous because they are acquired with business applications that are in many cases inextricably bound to a particular DBMS engine </li> <li> Data is predictably dirty </li> <li> DBMS vendors ultimately hold the data captive and have traditionally resisted data access standards such as ODBC (*trust me they have, just look at the unprecedented bad press associated with ODBC the only truly platform independent data access API. Then look at how this bad press arose..*) </li> </ol> <p> Enterprises have known from the beginning of modern corporate times that data access, discovery, and manipulation capabilities are inextricably linked to the "Real-time Enterprise" nirvana (hence my use of 0.0 before this becomes 3.0).</p> <p>In my experience, as someone whose operated in the data access and data integration realms since the late '80s, I've painfully observed enterprises pursue, but unsuccessfully attain, full control over enterprise data (the prized asset of any organization) such that data-, information-, knowledge-workers are just a click away from commencing coherent platform and database independent data drill-downs and/or discovery that transcend intranet, internet, and extranet boundaries -- serendipitous interaction with relevant data, without compromise!</p> <p>Okay, situation analysis done, we move on.. </p> <p>At our most recent (<a href="http://esw.w3.org/topic/CambridgeSemanticWebGatherings/Meeting/2007-06-12_Gathering">12th June</a>) monthly <a href="http://esw.w3.org/topic/CambridgeSemanticWebGatherings">Semantic Web Gathering</a>, I unveiled to <a href="http://www.w3.org/People/Berners-Lee/card#i">TimBL</a> and a host of other attendees a simple, but powerful, demonstration of how <a href="http://en.wikipedia.org/wiki/Linked_Data">Linked Data</a>, as an aspect of the <a href="http://www.businessweek.com/technology/content/apr2007/tc20070409_961951.htm">Semantic Data Web</a>, can be applied to enterprise data integration challenges.</p> <h2>Actual SQL to RDF Mapping Demo / Experiment</h2> <h4>Hypothesis</h4> A SQL Schema can be effectively mapped declaratively to RDF such that SQL Rows morph into RDF Instance Data (Entity Sets) based on the Concepts & Properties defined in a Concrete Conceptual Data Model oriented Data Dictionary (<a href="http://www.w3schools.com/rdf/rdf_schema.asp">RDF Schema</a> and/or <a href="http://www.w3schools.com/rdf/rdf_owl.asp">OWL Ontology</a>). In addition, the solution must demonstrate how "Linked Data in the Web" is completely different from "Data on the Web" or "Linked Data on the Web" (btw - <a href="http://kasei.us/people/Tom_Heath/">Tom Heath</a> eloquently unleashed this point in his recent <a href="http://blogs.talis.com/nodalities/2007/06/tom_heath_talks_with_talis_abo.php">podcast interview with Talis</a>). <h4>Apparatus</h4> An Ontology - in this case we simply derived the <a href="http://demo.openlinksw.com/DAV/home/demo/Public/Queries/SQLRDFIntegraton/Explore_Northwind_Ontology.isparql">Northwind Ontology</a> from the XML Schema based CSDL (<a href="http://blogs.msdn.com/adonet/archive/2007/01/30/entity-data-model-part-1.aspx">Conceptual Schema Definition Language</a>) used by Microsoft's public <a href="http://astoria.mslivelabs.com/Default.aspx">Astoria demo</a> (specifically the <a href="http://astoria.mslivelabs.com/termsOfUseNorthwind.aspx?returnURL=Northwind">Northwind Data Services demo</a>). SQL Database Schema - <a href="http://www.microsoft.com/library/media/1033/technet/images/prodtechnol/sql/2000/maintain/sscpop07_big.gif">Northwind</a> (comes bundled with ACCESS, SQL Server, and Virtuoso) comprised of tables such as: <a href="http://www.openlinksw.com/schemas/northwind#Customer">Customer</a>, <a href="http://www.openlinksw.com/schemas/northwind#Employee">Employee</a>, <a href="http://www.openlinksw.com/schemas/northwind#Product">Product</a>, <a href="http://www.openlinksw.com/schemas/northwind#Category">Category</a>, <a href="http://www.openlinksw.com/schemas/northwind#Supplier">Supplier</a>, <a href="http://www.openlinksw.com/schemas/northwind#Shipper">Shipper</a> etc. <a href="http://www.openlinksw.com/virtuoso/">OpenLink Virtuoso</a> - SQL DBMS Engine (although this could have been any <a href="http://en.wikipedia.org/wiki/Open_Database_Connectivity">ODBC</a> or <a href="http://en.wikipedia.org/wiki/Java_Database_Connectivity">JDBC</a> accessible Database), <a href="http://www.openlinksw.com/virtuoso/Whitepapers/pdf/Virtuoso_SQL_to_RDF_Mapping.pdf">SQL-RDF Metaschema Language</a>, HTTP URL-rewriter, WebDAV Engine, and DBMS hosted XSLT processor Client Tools -<a href="http://demo.openlinksw.com/isparql/"> iSPARQL Query Builder</a>, <a href="http://demo.openlinksw.com/DAV/JS/rdfbrowser/index.html">RDF Browser</a> (which could also have been <a href="http://www.w3.org/2005/ajar/tab">Tabulator</a> or<a href="http://sites.wiwiss.fu-berlin.de/suhl/bizer/ng4j/disco/"> DISCO</a> or a standard Web Browser) <h4>Experiment / Demo</h4> <ol> <li> Declaratively map the Northwind SQL Schema to RDF using the Virtuoso Meta Schema Language (see: <a href="http://demo.openlinksw.com/DAV/home/demo/Public/Queries/SQLRDFIntegraton/northwind_sql_rdf.sql">Virtuoso PL based Northwind_SQL_RDF script</a>) </li> <li> Start browsing the data by clicking on the URIs that represent the RDF Data Model Entities resulting from the SQL to RDF Mapping </li> </ol> <h4>Observations</h4> <ol> <li> Via a single Data Link click I was able to obtain specific information about the Customer represented by the URI <a href="http://demo.openlinksw.com/Northwind/Customer/ALFKI">"ALFKI"</a> (act of URI Dereferencing as you would an Object ID in an Object or Object-Relational Database) </li> <li> Via a <a href="http://demo.openlinksw.com/DAV/home/demo/Public/Queries/SQLRDFIntegraton/Explore_Northwind.isparql">Dynamic Data Page </a> I was able to explore all the entity relationships or specific entity data (i.e Exploratory or Entity specific dereferencing) in the Northwind Data Space </li> <li> I was able to perform similar exploration (as per item 2) using our <a href="http://demo.openlinksw.com/DAV/home/demo/Public/Queries/SQLRDFIntegraton/Explore_Northwind_Customer_ALFKI.wqx">OpenLink Browser. </a> </li> </ol> <h4>Conclusions</h4> <p>The vision of data, information, or knowledge at your fingertips is nigh! Thanks to the infrastructure provided by the Semantic Data Web (URIs, <a href="http://en.wikipedia.org/wiki/Resource_Description_Framework">RDF Data Model</a>, variety of RDF Serialization Formats[<a href="http://www.dajobe.org/2004/01/turtle/">1</a>][<a href="http://www.w3.org/DesignIssues/Notation3">2</a>][<a href="http://www.w3.org/TR/2002/WD-rdf-syntax-grammar-20020325/">3</a>], and Shared Data Dictionaries / Schemas / Ontologies [<a href="http://xmlns.com/foaf/spec/">1</a>][<a href="http://rdfs.org/sioc/spec/">2</a>][<a href="http://www.w3.org/TR/swbp-skos-core-guide/">3</a>][<a href="http://musicontology.com/">4</a>][<a href="http://bblfish.net/work/atom-owl/2006-06-06/AtomOwl.html">5</a>]) it's now possible to Virtualize enterprise data from the Physical Storage Level, through the Logical Data Management Levels (Relational), up to a Concrete Conceptual Model (Graph) without operating system, development environment or framework, or database engine lock-in.</p> <h2>Next Steps</h2> <p>We produce a shared ontology for the CRM and Business Reporting Domains. I hope this experiment clarifies how this is quite achievable by converting XML Schemas to RDF Data Dictionaries (RDF Schemas or Ontologies). Stay tuned :-) </p> <p>Also watch <a href="http://news.com.com/1606-2-6189377.html">TimBL amplify and articulate Linked Data value</a> in a recent interview.</p> <h2>Other Related Matters</h2> <p>To deliver a mechanism that facilitates the crystallization of this reality is a contribution of boundless magnitude (as we shall all see in due course). Thus, it is easy to understand why even "her majesty", the queen of England, simply had to get in on the act and <a href="http://www.royal.gov.uk/output/Page1880.asp">appoint TimBL to the "British Order of Merit</a>" :-)</p> <p>Note: All of the demos above now work with IE & Safari (a "remember what Virtuoso is epiphany") by simply putting Virtuoso's DBMS hosted XSLT engine to use :-) This also applies to my earlier collection of demos from the <a href="http://www.openlinksw.com/weblog/public/search.vspx?blogid=127&q=hello%20data%20web&type=text&output=html">Hello Data Web</a> and other <a href="http://www.openlinksw.com/weblog/public/search.vspx?blogid=127&q=.isparql&type=text&output=html">Data Web & Linked Data related demo style posts</a>.</p>
Enterprise 0.0, Linked Data, and Semantic Data Web
2008-02-05T04:19:26Z
2008-02-04T23:19:26.000001-05:00
Kingsley Uyi Idehen
kidehen@openlinksw.com
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1204
<p> <a href="http://fgiasson.com/">Frederick Giasson</a> has put out a number of interesting posts (via his <a href="http://fgiasson.com/blog/">blog</a>) about a conceptual <a href="http://fgiasson.com/blog/index.php/2007/05/24/the-music-data-space">Music Data Space</a> (one of many Data Spaces that will ultimately permeate the Semantic Data Web). Anyway, While reading his initial post covering <a href="http://fgiasson.com/blog/index.php/2007/05/22/browsing-musicbrainzs-dataset-via-uri-dereferencing">Music Domain URIs and Linked Data</a>, it occurred to me that by only exposing the raw RDF instance data (RDF/XML format in this case) via URIs for: Diana Ross, Paul McCartney, The Beatles, and Madonna, the essence of the post may not be revealed to all, so I've knocked up a few demos to illustrate the core message:</p> <p> <b>Note</b>: the enhanced hyperlink (typed data link) lookup presents options to perform an Explore (all data about subject across Domains in the data space i.e. data links to and from Subject), Dereference (specific data in the Subject's Domain i.e. data links originating from subject).</p> <ol> <li> <a href="http://dbpedia.openlinksw.com:8890/DAV/home/demo/dataweb/linked_data_pages/Diana_Ross.isparql">Diana Ross</a> </li> <li> <a href="http://dbpedia.openlinksw.com:8890/DAV/home/demo/dataweb/linked_data_pages/Paul_McCartney.isparql">Paul McCartney</a> </li> <li> <a href="http://dbpedia.openlinksw.com:8890/DAV/home/demo/dataweb/linked_data_pages/The_Beatles.isparql">The Beatles</a> </li> <li> <a href="http://dbpedia.openlinksw.com:8890/DAV/home/demo/dataweb/linked_data_pages/Madonna.isparql">Madonna</a> </li> </ol> <p>I built these Linked Data Pages by simply doing the following:</p> <ol> <li>Open up our <a href="http://oat.openlinksw.com">OAT</a> based <a href="http://dbpedia.openlinksw.com:8890/isparql">iSPARQL (Interactive SPARQL Query By Example)</a> Tool</li> <li>Paste a URI of Interest into the Data Source URI input field</li> <li>Execute the Query (hitting the ">" button) </li> <li>Saving the Query to WebDAV as a Linked Data Page (or what I initial called Dynamic Data Web pages in my Hello Data Web series of posts).</li> <li>Share your Data, Information, Knowledge with others via URIs (as shown in the section above). </li> </ol>
Exploring a Music Data Space via Linked Data
2008-02-05T04:20:47Z
2008-02-04T23:20:47.000003-05:00
Kingsley Uyi Idehen
kidehen@openlinksw.com
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1202
<p>Over the last few hours the FOAF project received a <a href="http://dannyayers.com/2007/05/25/foaf-0">wakeup call</a> via <a href="http://danbri.org/">Dan Brickley</a>'s <a href="http://xmlns.com/foaf/spec">FOAF 0.9</a> "touch" effort.</p> <p>Naturally, this triggered an obvious opportunity to demonstrate the prowess of <a href="http://en.wikipedia.org/wiki/Linked_Data">Linked Data</a> on the Semantic Web. What follows is a quick dump of what I sent to the <a href="http://lists.foaf-project.org/mailman/listinfo/foaf-dev">foaf-dev</a> mailing list:</p> <p>Here are variety of FOAF Views built using:</p> <ul> - <a href="http://dbpedia.openlinksw.com:8890/DAV/JS/rdfbrowser/index.html">OpenLink RDF Browser</a> </ul> <ul> - <a href="http://dbpedia.openlinksw.com:8890/isparql">Interactive SPARQL QBE </a> </ul> <ul> - <a href="http://dbpedia.openlinksw.com:8890/sparql">Raw SPARQL Endpoint</a> </ul> <p>Enabling you to explore the following lines:</p> <ul> - <a href="http://dbpedia.openlinksw.com:8890/DAV/home/demo/dataweb/linked_data_pages/foaf_overview.isparql">FOAF Overview via a Linked Data Page</a> (same as Dynamic Data Page) </ul> <ul> - <a href="http://dbpedia.openlinksw.com:8890/DAV/home/demo/dataweb/linked_data_pages/foaf_overview_by_status.isparql">FOAF Overview by Term Status via Linked Data Page</a> </ul> <ul> - <a href="http://dbpedia.openlinksw.com:8890/DAV/home/demo/dataweb/queries/foaf_overview.rq">FOAF Overview SPARQL Query (.rq File)</a> </ul> <ul> - <a href="http://dbpedia.openlinksw.com:8890/DAV/home/demo/dataweb/queries/foaf_overview_by_status.rq">FOAF Overview by Term Status</a> </ul> <ul> - <a href="http://tinyurl.com/2hpeau">FOAF Overview via OpenLink RDF Browser</a> </ul>
Exploring FOAF Linked Data Style!
2007-05-25T18:36:47Z
2007-05-25T14:36:47-04:00
Kingsley Uyi Idehen
kidehen@openlinksw.com
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1157
<p> <a href="http://en.wikipedia.org/wiki/Virtuoso_Universal_Server">Virtuoso</a> joins <a href="http://wingerz.com/blog/2007/02/06/text-indexing-and-query-in-boca/">Boca</a> and <a href="http://seaborne.blogspot.com/2006/11/larq-lucene-arq.html">ARC 2.0</a> as RDF Quad or Triple Stores with Full Text Index extensions to SPARQL. Here is our example applied to <a href="http://dbpedia.org">DBpedia</a>:</p> <pre><font size="2">PREFIX dbpedia: <http://dbpedia.org/> PREFIX foaf: <http://xmlns.com/foaf/0.1/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> SELECT ?name ?birth ?death FROM <http://dbpedia.org> WHERE { ?person dbpedia:birthplace <http://dbpedia.org/resource/Berlin> . ?person dbpedia:birth ?birth . ?person foaf:name ?name . ?person dbpedia:death ?death FILTER (?birth < "1900-01-01"^^xsd:date and bif:contains (?name, 'otto')) . } ORDER BY ?name </font></pre> <p> You can test further using our <a href="http://demo3.openlinksw.com:8890/sparql/">SPARQL Endpoint for DBpedia</a> or via the <a href="http://demo3.openlinksw.com:8890/isparql/">DBPedia bound Interactive SPARQL Query Builder</a> or just click *<a href="http://demo3.openlinksw.com:8890/sparql/?default-graph-uri=&query=PREFIX+dbpedia%3A+%3Chttp%3A%2F%2Fdbpedia.org%2F%3E%0D%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0APREFIX+xsd%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0D%0ASELECT+%3Fname+%3Fbirth+%3Fdeath%0D%0AFROM+%3Chttp%3A%2F%2Fdbpedia.org%3E%0D%0AWHERE+%7B%0D%0A++++%3Fperson+dbpedia%3Abirthplace+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FBerlin%3E+.%0D%0A++++%3Fperson+dbpedia%3Abirth+%3Fbirth+.%0D%0A++++%3Fperson+foaf%3Aname+%3Fname+.%0D%0A++++%3Fperson+dbpedia%3Adeath+%3Fdeath%0D%0A++++FILTER+%28%3Fbirth+%3C+%221900-01-01%22%5E%5Exsd%3Adate+and+bif%3Acontains+%28%3Fname%2C+%27otto%27%29%29+.%0D%0A%7D%0D%0AORDER+BY+%3Fname&format=text%2Fhtml">Here</a>* for results courtesy of the <a href="http://www.w3.org/TR/rdf-sparql-protocol/">SPARQL Protocol</a> (REST based Web Service). </p> <p>Note: This is in-built functionality as Virtuoso has possessed <a href="http://en.wikipedia.org/wiki/Full_text_index">Full Text Indexing</a> since 1998-99. This capability applies to physical and virtual graphs managed by Virtuoso.</p> <p>A per usual, there is more to come as we now have a nice intersection point for SPARQL and XQuery/XPath since Triple Objects (the Literal variety) can take the form of XML Schema based Complex Types :-) A point I alluded too in my <a href="http://weblog.infoworld.com/udell/2006/04/28.html">podcast interview with Jon Udell </a>last year (*note: mechanical turk based transcript is bad*). The point I made went something like this: "...you use SPARQL to traverse the typed links and then use XPath/XQuery for further granular access to the data if well-formed..."</p> <p>Anyway, the podcast interview lead to this InfoWorld article titled: <a href="http://www.infoworld.com/article/06/05/03/77873_19OPstrategic_1.html">Unified Data Theory</a>.<br /> </p>
SPARQL and Full Text Indexing implementations are growing
2007-03-13T10:09:43Z
2007-03-13T06:09:43-04:00
Kingsley Uyi Idehen
kidehen@openlinksw.com
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1148
<blockquote> <p> <a href="http://www.johnbreslin.com/blog/2007/03/01/linking-personal-posted-content-across-communities/#comments">Linking personal posted content across communities</a>: "</p> <p>With the help of Kingsley, Uldis and I have been looking at how <a href="http://sioc-project.org/">SIOC</a> can be used to link the content that a single person posts to a number of community sites. The picture below shows an example of stuff that I’ve created on Flickr, YouTube, etc. through my various user identities on those sites (these match some <a href="http://wiki.sioc-project.org/index.php/TypesModule">SIOC types</a> that we want to add to a separate module). We can also say that each Web 2.0 content item is a user-contributed post, with some attached or embedded content (e.g. a file or maybe just some metadata). This is part of a new discussion on the <a href="http://groups.google.com/group/sioc-dev">sioc-dev</a> mailing list, and we’d value your contributions.</p> <p> <img id="image1178" src="http://www.johnbreslin.com/blog/wp-content/uploads/2007/03/20070228a.png" alt="20070228a.png" /> </p> <p>Edit: The inner layer is a person (semantically described in FOAF), the next layer is their user accounts (described in FOAF, SIOC) and the outer layer is the posted content - text, files, associated metadata - on community sites (again described using SIOC). </p> No Tags" <p>(Via <a href="http://www.johnbreslin.com/blog">John Breslin - Cloudlands</a>.)</p> </blockquote> <p>The point that John is making about the Data Web and Interlinked <a href="http://www.openlinksw.com/weblog/public/search.vspx?blogid=127&q='data%20spaces'&type=text&output=html">Data Spaces</a> exposed via <a href="http://en.wikipedia.org/wiki/Uniform_Resource_Identifier">URI</a>s (e.g Personal URIs), crystallizes a number of very important issues about the Data Web that may remain unclear. I am hoping that by digesting the post excerpt above, in conjunction with the items below, aids the pursuit of clarity and comprehension about the all important Data Web (Semantic Web - Layer 1):</p> <ol> <li> <a href="http://kidehen.idehen.net/dataspace/kidehen">Your OpenID can be Your Personal URI</a> (as noted by <a href="http://blogs.sun.com/bblfish/">Henry Story</a>'s post about: <a href="http://blogs.sun.com/bblfish/entry/openid_for_blogs_sun_com">The Many Uses of OpenID</a>). That that's what I have courtesy of OpenLink Data Spaces (ODS)</li> <li>The above only works unobtrusively (i.e. OpenID and Personal sharing a URI) if Content Negotiation is exploited on the Client and Server sides.</li> <li> <a href="http://www.w3.org/People/Berners-Lee/card.rdf">TimBL</a>'s call out to <a href="http://www.w3.org/DesignIssues/LinkedData.html">Share Your Data and Link to Other Data</a> via URIs via post titled: <a href="http://dig.csail.mit.edu/breadcrumbs/node/71">Give Yourself a URI</a>.</li> <li> <a href="http://www.w3.org/TR/swbp-vocab-pub/">W3C's Best Practice Recipes for Publishing RDF Vocabularies</a> </li> <li> <a href="http://www.w3.org/TR/2004/REC-webarch-20041215/#dereference-uri">W3C's Architecture of the World Wide Web - Vol 1</a> which covers URI Dereferencing (HTTP GET-ing the data that a URI points to)</li> <li> <a href="http://www4.wiwiss.fu-berlin.de/is-group/page/persons/Person6">Richard Cyganiak</a>'s post titled: <a href="http://dowhatimean.net/2007/02/debugging-semantic-web-sites-with-curl">Debugging Semantic Web Sites with Curl</a>.</li> </ol> <p>Examples of some of these principles in practice:</p> <ol> <li>Chris Bizer, Tobias Gaub, and Richard's Javascript based<a href="http://sites.wiwiss.fu-berlin.de/suhl/bizer/ng4j/semwebclient/"> Semantic Web Client Library</a> </li> <li> <a href="http://sites.wiwiss.fu-berlin.de/suhl/bizer/ng4j/disco/">DISCO RDF Browser</a> </li> <li> <a href="http://oat.openlinksw.com">OpenLink Ajax Toolkit</a>'s (OAT) <a href="http://demo.openlinksw.com/DAV/JS/tests/rdfbrowser/index.html">RDF Browser</a> </li> <li>OpenLink <a href="http://demo.openlinksw.com/isparql">Interactive SPARQL Query by Example</a> (iSPARQL QBE)</li> <li>Dynamic Data Web Pages from my prior posts [<a href="http://www.openlinksw.com/blog/~kidehen/?id=1144">1</a>][<a href="http://www.openlinksw.com/blog/~kidehen/index.vspx?page=&id=1145">2</a>][<a href="http://www.openlinksw.com/blog/~kidehen/index.vspx?page=&id=1146">3</a>]</li> <li> <a href="http://dbpedia.org/docs/">dbpedia</a> (Wikipedia as a Data Web oriented Data Source)</li> <li>And of course this blog post's permalink is a bona fide dereferencable URI.</li> </ol> <p>And of course there is more to come such as Grandma's Semantic Web Browser which is coming from <a href="http://fgiasson.com/blog/index.php/2007/02/18/zitgist_a_semantic_web_search_engine">Zitgist LLC</a> (pronounced: Zeitgeist) a joint venture of OpenLink Software and <a href="http://fgiasson.com/blog/">Frederick Giasson</a>.</p>
Personal URIs & Data Spaces
2007-03-02T14:14:02Z
2007-03-02T09:14:02.000004-05:00
Kingsley Uyi Idehen
kidehen@openlinksw.com
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1129
<blockquote> <p> <a href="http://ajaxian.com/archives/oat-openajax-alliance-compliant-toolkit">OAT: OpenAjax Alliance Compliant Toolkit</a>: "</p> <p>Ondrej Zara and his team at Openlink Software have created a Openlink Software JS Toolkit, known as OAT. It is a full-blown JS framework, suitable for developing<br /> rich applications with special focus to data access.</p> <p>OAT works standalone, offers vast number of widgets and has some rarely seen features, such as on-demand library loading (which reduces the total amount of downloaded JS code).</p> <p>OAT is one of the first JS toolkits which show full OpenAjax Alliance conformance: see the appropriate <a href="http://www.openajax.org/member/wiki/InteropFest_2007_March)">wiki page</a> and <a href="http://demo.openlinksw.com/DAV/JS/openajax/HubTest-OATConformance.html">conformance test page</a>.</p> <p>There is a lot to see with this toolkit:</p> <p>You can see some of the widgets in a <a href="http://demo.openlinksw.com/DAV/JS/demo/index.html">Kitchen sink application</a> </p> <p>Sample data access applications:</p> <ul> <li> <a href="http://demo.openlinksw.com/DAV/JS/qbe/index.html">SQL Query By Example</a> </li> <li> <a href="http://demo.openlinksw.com/DAV/JS/formdesigner/index.html">Forms designer</a> </li> <li> <a href="http://demo.openlinksw.com/DAV/JS/designer/index.html">DB Designer</a> </li> </ul> <p>OAT is Open Source and GPL’ed over at <a href="http://sourceforge.net/project/showfiles.php?group_id=168143">sourceforge</a> and the team has recently managed to incorporate our OAT data access layer as a<br /> module to <a href="http://demo.openlinksw.com/DAV/JS/dojo-oatstore-demo/test_OATStore_in_FilteringTable.html">dojo datastore</a>.</p> <p>(Via <a href="http://ajaxian.com">Ajaxian Blog</a>.)</p> </blockquote> <p>This is a corrected version of the initial post. Unfortunately, the initial post was inadvertently littered with invalid links :-( Also, since the original post we have released <a href="http://sourceforge.net/mailarchive/forum.php?thread_id=31568932&forum_id=49207">OAT 1.2</a> that includes integration of our iSPARQL QBE into the OAT Form Designer application.</p> <p>Re. Data Access, It is important to note that OAT's Ajax Database Connectivity layers supports data binding to the following data source types:</p> <ol> <li> <a href="http://www.w3.org/TR/rdf-primer/">RDF</a> - via <a href="http://demo.openlinksw.com/DAV/JS/demo/index.html?dav">SPARQL</a> (Query Language, Protocol, and Resultset Serialization formats: <a href="http://en.wikipedia.org/wiki/JDBC">RDF/XML</a>, <a href="http://www.w3.org/DesignIssues/Notation3">RDF/N3</a>, <a href="http://www.dajobe.org/2004/01/turtle/">RDF/Turtle</a>, <a href="http://en.wikipedia.org/wiki/XML">XML</a>, and <a href="http://www.json.org/">JSON</a>)</li> <li> <a href="http://en.wikipedia.org/wiki/SQL">SQL</a> - via <a href="http://www.xmla.org/faq.asp">XMLA</a> (somewhat forgotten <a href="http://en.wikipedia.org/wiki/SOAP">SOAP</a> protocol for SQL Data Access that can sit atop <a href="http://en.wikipedia.org/wiki/Open_Database_Connectivity">ODBC</a>, <a href="http://en.wikipedia.org/wiki/ADO.NET">ADO.NET</a>, <a href="http://en.wikipedia.org/wiki/OLE_DB">OLE-DB</a>, and even <a href="http://en.wikipedia.org/wiki/JDBC">JDBC</a>)</li> <li>XML - via SOAP or <a href="http://en.wikipedia.org/wiki/Representational_State_Transfer">REST</a> style Web Services</li> </ol> In all cases, OAT also provides Data Aware controls for the above that include: <ol> <li> <a href="http://demo.openlnksw.com/DAV/JS/demo/index.html?grid">Tabular Grids</a> </li> <li> <a href="http://demo.openlinksw.com/DAV/JS/demo/index.html?pivot">Pivot Tables</a> </li> <li> <a href="http://demo.openlnksw.com/DAV/JS/demo/index.html?timeline">TimeLines</a> </li> <li> <a href="http://demo.openlinksw.com/DAV/JS/demo/index.html?anchor">Extended Anchor Tags</a> </li> <li> <a href="http://demo.openlnksw.com/DAV/JS/demo/index.html?mashups">Map Service Controls</a> (Google, Yahoo!, OpenLayers, Microsoft Visual Earth)</li> <li> <a href="http://demo.openlinksw.com/DAV/JS/demo/index.html?rdf">SVG based RDF Graph Control</a> (Opera 9.x provides best viewing experience at the current time)</li> </ol> <p>OAT also includes a number of prototype applications that are completely developed using OAT Controls and Libraries:</p> <ol> <li> <a href="http://demo.openlnksw.com/isparql/">Visual SPARQL Query Builder</a> </li> <li> <a href="http://demo.openlinksw.com/DAV/JS/qbe/index.html">Visual SQL Query Builder</a> </li> <li> <a href="http://demo.openlinksw.com/DAV/JS/formdesigner/index.html">Web Forms Designer</a> (includes Drag-Drop usage of Data Aware Controls etc.)</li> <li> <a href="http://demo.openlinksw.com/DAV/JS/designer/index.html">Visual DB Designer</a> </li> </ol> <p>Note: Pick "Local DSN" from page initialization dialog's drop-down list control when prompted</p>
OAT: OpenAjax Alliance Compliant Toolkit (Live Links Version)
2007-02-02T15:29:55Z
2007-02-02T10:29:55-05:00
Kingsley Uyi Idehen
kidehen@openlinksw.com
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1095
<p>A quick dump that demonstrates how I integrate tags and links from del.icio.us with links from my local bookmark database via one of my public Data Spaces (this demo uses the <a href="http://myopenlink.net:8890/dataspace/kidehen">kidehen Data Space</a>).</p> <p> <a href="http://www.w3.org/TR/rdf-sparql-query/">SPARQL</a> (query language for the Semantic Web) basically enables me to query a collection of typed links (predicates/properties/attributes) in my Data Space (<a href="http://virtuoso.openlinksw.com/wiki/main/Main/OdsIndex">ODS</a> based of course) without breaking my existing local bookmarks database or the one I maintain at del.icio.us.</p> <p>I am also demonstrating how <a href="http://en.wikipedia.org/wiki/Web_2.0">Web 2.0</a> concepts such as <a href="http://en.wikipedia.org/wiki/Tags">Tagging</a> mesh nicely with the more formal concepts of Topics in the Semantic Web realm. The key to all of this is the ability to generate <a href="http://www.w3.org/TR/rdf-primer/">RDF Data Model</a> Instance Data based on <a href="http://en.wikipedia.org/wiki/Upper_ontology_(computer_science)">Shared Ontologies</a> such as <a href="http://rdfs.org/sioc/spec/">SIOC</a> (from <a href="http://www.semanticweb.org/">DERI</a>'s <a href="http://sioc-project.org/">SIOC Project</a>) and <a href="http://www.w3.org/2004/02/skos/">SKOS</a> (again showing that <a href="http://tomgruber.org/writing/ontology-of-folksonomy.htm">Ontologies and Folksonomies</a> are complimentary).</p> <p>This demo also shows that Ajax also works well in the Semantic Web realm (or <a href="http://www.openlinksw.com/blog/~kidehen/?id=1037">web dimension of interaction 3.0</a>) especially when you have a toolkit with Data Aware controls (for SQL, RDF, and XML) such as OAT (<a href="http://demo.openlinksw.com/DAV/JS/demo/index.html">OpenLink Ajax Toolkit</a>). For instance, we've successfully used this to build a <a href="http://myopenlink.net:8890/isparl/">Visual Query Building Tool for SPARQL</a> (alpha) that really takes a lot of the pain out of constructing SPARQL Queries (there is much more to come on this front re. handling of DISTINCT, FILTER, ORDER BY etc..). </p> <p>For now, take a look at the SPARQL Query dump generated by this <a href="http://myopenlink.net:8890/DAV/home/kidehen/gallery/my_photos/sparql_qbe_sioc_skos_shot1.png">SIOC & SKOS SPARQL QBE Canvas Screenshot</a>. </p> <p>You can cut and paste the queries that follow into the Query Builder or use the screenshot to build your variation of this query sample. Alternatively, you can simply click on *<a href="http://myopenlink.net:8890/sparql?default-graph-uri=http%3A%2F%2Fmyopenlink.net%2Fdataspace&query=PREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+sioc%3A+++%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Fns%23%3E%0D%0APREFIX+dct%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Felements%2F1.1%2F%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0A%0D%0ASELECT+distinct+%3Fforum_name%2C+%3Fowner%2C+%3Fpost%2C+%3Ftitle%2C+%3Flink%2C+%3Furl+%3Ftag%0D%0AFROM+%3Chttp%3A%2F%2Fmyopenlink.net%2Fdataspace%3E%0D%0AWHERE+%7B%0D%0A++++++++%3Fforum+a+sioc%3AForum.%0D%0A++++++++%3Fforum+sioc%3Atype+%22bookmark%22.%0D%0A++++++++%3Fforum+sioc%3Aid+%3Fforum_name.%0D%0A++++++++%3Fforum+sioc%3Ahas_member+%3Fowner.%0D%0A++++++++%3Fowner+sioc%3Aid+%22kidehen%22.%0D%0A++++++++%3Fforum+sioc%3Acontainer_of+%3Fpost+.%0D%0A++++++++%3Fpost++dct%3Atitle+%3Ftitle+.%0D%0A++++++++optional+%7B+%3Fpost+sioc%3Atopic+%3Ftopic.%0D%0A+++++++++++++++++++%3Ftopic+a+skos%3AConcept%3B%0D%0A+++++++++++++++++++++++++skos%3AprefLabel+%3Ftag.+%7D%0D%0A++++++++optional%7B+%3Fpost+sioc%3Alink+%3Flink++%7D+.%0D%0A++++++++optional%7B+%3Fpost+sioc%3Alinks_to+%3Furl+%7D%0D%0A++++++%7D%0D%0AORDER+BY+%3Ftitle&format=text%2Fhtml">This</a>* <a href="http://www.w3.org/TR/rdf-sparql-protocol/">SPARQL Protocol</a> URL to see the query results in a basic HTML Table. And one last thing, you can grab the <a href="http://myopenlink.net:8890/DAV/home/kidehen/SPARQL/tagging_sioc_skos_delicios_my_bookmarks.rq">SPARQL Query File</a> saved into my <a href="http://virtuoso.openlinksw.com/wiki/main/Main/OdsBriefcase">ODS-Briefcase</a> (the <a href="http://en.wikipedia.org/wiki/WebDAV">WebDAV</a> repository aspect of my Data Space). </p> <p> <b>Note the following SPARQL Protocol Endpoints:</b> </p> <ol> <li> <a href="http://myopenlink.net:8890/sparql/">MyOpenLink Data Space</a> </li> <li> <a href="http://myopenlink.net:8890/isparql/">Experimental Data Space SPARQL Query Builder</a> (you need to register at http://myopenlink.net:8890/ods to use this version)</li> <li> <a href="http://demo.openlinksw.com/sparql/">Live Demo Sever</a> </li> <li> <a href="http://demo.openlinksw.com/isparql/">Demo Server SPARQL Query Builder</a> (use: demo for both username and pwd when prompted)</li> </ol> <p>My beautified Version of the SPARQL Generated by QBE (you can cut and paste into "Advanced Query" section of QBE) is presented below:</p> <pre> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX sioc: <http://rdfs.org/sioc/ns#> PREFIX dct: <http://purl.org/dc/elements/1.1/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> <br /> SELECT distinct ?forum_name, ?owner, ?post, ?title, ?link, ?url, ?tag FROM <http://myopenlink.net/dataspace> WHERE { ?forum a sioc:Forum; sioc:type "bookmark"; sioc:id ?forum_name; sioc:has_member ?owner. ?owner sioc:id "kidehen". ?forum sioc:container_of ?post . ?post dct:title ?title . optional { ?post sioc:link ?link } optional { ?post sioc:links_to ?url } optional { ?post sioc:topic ?topic. ?topic a skos:Concept; skos:prefLabel ?tag}. } </pre> <p>Unmodified dump from the QBE (this will be beautified automatically in due course by the QBE):</p> <pre> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX sioc: <http://rdfs.org/sioc/ns#> PREFIX dct: <http://purl.org/dc/elements/1.1/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> <br /> SELECT ?var8 ?var9 ?var13 ?var14 ?var24 ?var27 ?var29 ?var54 ?var56 WHERE { graph ?graph { ?var8 rdf:type sioc:Forum . ?var8 sioc:container_of ?var9 . ?var8 sioc:type "bookmark" . ?var8 sioc:id ?var54 . ?var8 sioc:has_member ?var56 . ?var9 rdf:type sioc:Post . OPTIONAL {?var9 dc:title ?var13} . OPTIONAL {?var9 sioc:links_to ?var14} . OPTIONAL {?var9 sioc:link ?var29} . ?var9 sioc:has_creator ?var37 . OPTIONAL {?var9 sioc:topic ?var24} . ?var24 rdf:type skos:Concept . OPTIONAL {?var24 skos:prefLabel ?var27} . ?var56 rdf:type sioc:User . ?var56 sioc:id "kidehen" . } } </pre> <p> Current missing items re. Visual QBE for SPARQL are:</p> <ol> <li> Ability to Save properly to WebDAV so that I can then expose various saved SPARQL Queries (.rq file) from my Data Space via URIs </li> <li> Handling of DISTINCT, FILTERS (note: OPTIONAL is handled via dotted predicate-links) </li> <li>General tidying up re. click event handling etc. </li> </ol> Note: You can even open up your own account (using our <a href="http://demo.openlinksw.com/ods">Live Demo</a> or <a href="http://myopenlink.net:8890/ods">Live Experiment Data</a> Space servers) which enables you to repeat this demo by doing the following (post registration/sign-up): <ol> <li>Export some bookmarks from your local browser to the usual HTML bookmarks dump file</li> <li>Create an ODS-Bookmarks Instance using your new ODS account</li> <li>Use the ODS-Bookmark Instance to import your local bookmarks from the HTML dump file</li> <li>Repeat the same import sequence using the ODS-Bookmark Instance, but this time pick the del.icio.us option</li> <li>Build your query (change 'kidehen' to your ODS-user-name)</li> <li>That's it you now have Semantic Web presence in the form of a Data Space for your local and del.icio.us hosted bookmarks with tags integrated</li> </ol> <p>Quick Query Builder Tip: You will need to import the following (using the Import Button in the Ontologies & Schemas side-bar); </p> <ol> <li> <a href="http://www.w3.org/1999/02/22-rdf-syntax-ns#">http://www.w3.org/1999/02/22-rdf-syntax-ns#</a> (<a href="http://www.w3.org/TR/rdf-primer/">RDF</a>)</li> <li> <a href="http://rdfs.org/sioc/ns#">http://rdfs.org/sioc/ns#</a> (<a href="http://rdfs.org/sioc/spec/">SIOC</a>)</li> <li> <a href="http://purl.org/dc/elements/1.1/">http://purl.org/dc/elements/1.1/</a> (<a href="http://dublincore.org/">Dublin Core</a>)</li> <li> <a href="http://www.w3.org/2004/02/skos/core#">http://www.w3.org/2004/02/skos/core#</a> (<a href="http://www.w3.org/TR/2005/WD-swbp-skos-core-guide-20050510/">SKOS</a>)</li> </ol> <p>Browser Support: The SPARQL QBE is SVG based and currently works fine with the following browsers; Firefox 1.5/2.0, Camino (Cocoa variant of Firefox for Mac OS X), Webkit (Safari pre-release / advanced sibling), Opera 9.x. We are evaluating the use of the Adobe SVG plugin re. IE 6/7 support.</p> <p>Of course this should be a screencast, but I am the middle of a plethora of things right now :-) </p>
SPARQL, Ajax, Tagging, Folksonomies, Share Ontologies and Semantic Web
2006-12-13T20:09:50Z
2006-12-13T15:09:50-05:00
Kingsley Uyi Idehen
kidehen@openlinksw.com