W3C home > Mailing lists > Public > www-rdf-interest@w3.org > September 2000

Possible RDBMS solution

From: Craig Pugsley <craig.pugsley@mimesweeper.com>
Date: Fri, 29 Sep 2000 10:08:49 +0100
Message-ID: <06B823D16FE8C14DB1F06CCBE6A6F3D25C3B6D@BELL.mimesweeper.com>
To: "'www-rdf-interest@w3.org'" <www-rdf-interest@w3.org>
I've been browsing around various locations on the web looking for a way to
represent RDF graphs in a database. I came across the page
http://www-db.stanford.edu/~melnik/rdf/db.html
<http://www-db.stanford.edu/~melnik/rdf/db.html>  and found some of the
examples useful, but slightly too complex for that majority of the work I
will be carrying out. Therefore, I would like to propose the db model I have
been using, and have found to be simple, minimalist, and functional.
 
Contributed by: Craig Pugsley
 
Data: September 29th 2000
 
Brief summary: Another simple design that captures a minimalist version of
an RDF graph. Very functional and compact. Treats the resources and
statements explicitly in an attempt to highlight the "resources can be
anything" ethos. The nature of my work also required x- and y-coord fields
in which to hold the graphical position of the nodes when modelling. 
 
Schema:
CREATE TABLE Resources {
    ID int,
    Type varchar(50),
    Value varchar(255),
    XCoord int,
    YCoord int
}
CREATE TABLE Statements {
    SubjectID int,
    ObjectID int,
    Predicate varchar(255),
    StatementURI varchar(255)
}
Hope this helps in some way!
 
CraigP
 


**********************************************************************
This email and any files transmitted are confidential and intended
solely for the use of the individual or entity to which they are
addressed.  If you have received this email in error, please notify
Content Technologies:  Tel: +44 (0) 118 930 1300

This message has been scanned for email content security threats
by MAILsweeper, one of Content Technologies MIMEsweeper 
family of products. Be sure your organization is free from email and
web content security threats. For information on policy-based
content security go to http://www.mimesweeper.com

Tel: 	+44 (0) 118 930 1300	                Fax: 	+44 (0) 118 930 1301
Email: 	info@mimesweeper.com	                Support: msw.support@mimesweeper.com
Web:	http://www.mimesweeper.com	Web:	http://www.contentsecurity.com

MIMEsweeper:  Policy-based Content Security
**********************************************************************
Received on Friday, 29 September 2000 05:11:08 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Monday, 7 December 2009 10:51:44 GMT