July 3, 2006

Oracle, graphical data models, and RDF

I wrote recently of Cogito’s high-performance engine for modeling graphs. Oracle has taken a very different approach to the same problem, and last Monday I drove over to Burlington to be briefed on it.

Name an approach to data management, and Oracle has probably

(At least, that’s the general template; truth be told, most of the important cases deviate in some way or other.)

In the case of graphs, it appears that Oracle first productized direct support in a “Network Data Model” in Oracle10g Release 1. Not to be confused with prerelational CODASYL systems and the like, this is just a way of representing things like map elements (roads, power lines, etc.) that utility companies might care about. Life sciences companies also used this functionality in several ways, but asked Oracle to support the RDF standard (Resource Description Framework).

The basic element of an RDF model is a graph edge – two nodes and a relationship arc, each of which has a URI (Uniform Resource Identifier). In RDF lingo these are (subject, property, object) triples. RDF support was released about 9 months ago in Oracle10g Release 2. Applications seem to be focused on the usual life sciences suspects – pathway tracking, symptom/datapoint relationship tracking, ontology management, etc.* And yes, it’s integrated into SQL, so that you can (for example) intersect the results of RDF and standard SQL queries in a single statement.

*Obviously, RDF is tied into the Tim Berners-Lee’s whole Semantic Web vision. And at least in principle it could be used for a form of MDM as well. But so far as I could tell, that’s still all futures at this point.

The database support for the RDF extension to SQL amounts to half a dozen tables or so, to represent nodes, edges, and so on. The two core tables (using names from this overview, which are not the actual names used in the system) are IdTriples, which stores the actual arcs/triples, and UriMap, which associates URIs with objects (and subjects and properties). Processing thus consists mainly of joining the IdTriples table to itself, and also to UriMap. These are accelerated by all sorts of relational performance goodness from the Oracle infrastructure, especially materialized join views.

So what do I think about all this? Well, it all sounds pretty smart. But that’s what one would expect me to think. Historically I’ve been a huge fan of Oracle’s text-search-in-SQL, OLAP-in-SQL, and so on. And generally I’ve turned out to be rather lonely in my enthusiasm. So on this one, while the story certainly sounds good, I think I’ll wait and see if Oracle can do a better job of being fully competitive than it did in those other areas. Also, I’d be more inclined to give them the benefit of the doubt if they hadn’t allowed themselves to fall behind in supporting XML.

Other links, with thanks to Oracle’s Susie Stephens, include:

Other URLs you may be interested in include:

Comments

2 Responses to “Oracle, graphical data models, and RDF”

  1. DBMS2 — DataBase Management System Services»Blog Archive » Bulletin on Cogito on December 27th, 2006 5:47 pm

    […] My Bulletin on Cogito — i.e., a short-short white paper — is now available for download. Thankfully, it turned out to be pretty consistent with what I previously wrote on the company and its technology. The conclusion to the paper bears quoting here: […]

  2. DBMS2 — DataBase Management System Services » Blog Archive » RDF “definitely has legs” on April 25th, 2008 12:05 am

    […] that the US government is going nuts for RDF. And I continue to get confirmation of something I first noted last year — Oracle is pushing RDF heavily, especially in the life sciences […]

Leave a Reply




Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:

Login

Search our blogs and white papers

Monash Research blogs

User consulting

Building a short list? Refining your strategic plan? We can help.

Vendor advisory

We tell vendors what's happening -- and, more important, what they should do about it.

Monash Research highlights

Learn about white papers, webcasts, and blog highlights, by RSS or email.