Accessing WWW Conference Data

See also:

• Prose write-up of WWW Conference Data via SqlDB.
• RDF Access to Relational Databases

Goals

• Make SQL data available to RDF.
• Keep SQL data available to SQL:
  • keeps data access efficient.
  • eases transition to semantic web.
• Make updates to SQL data.

Approaches

Dual-availability:

• 1. Keep SLQ data authoritative.
• 2. Keep RDF data authoritative.

Migration tool:

• A. Hack one-off scripts tailored to specific schema.
• B. Declaritively describe database and write script once.

FeDeRate takes the 1 B approach.

Database Description

user: xxx
password: yyy
database: WWW2005
queryHost: localhost
schemaNS: http://www.w3.org/2004/10/18-RDF-WWW2005/#

predicateMap: http://www.w3.org/2004/10/18-RDF-WWW2005/#wrote => Author.paper
predicateMap: http://www.w3.org/2004/10/18-RDF-WWW2005/#authorName => Author.name
predicateMap: http://www.w3.org/2004/10/18-RDF-WWW2005/#paperName => Paper.name
predicateMap: http://www.w3.org/2004/10/18-RDF-WWW2005/#paperEmail => Paper.email
predicateMap: http://www.w3.org/2004/10/18-RDF-WWW2005/#inSession => Paper.session
predicateMap: http://www.w3.org/2004/10/18-RDF-WWW2005/#start => Program.start1
predicateMap: http://www.w3.org/2004/10/18-RDF-WWW2005/#end => Program.end1

auth.group.Paper.email: registered

Implementations

• cwm — probably bit-rotted
• FeDeRate — nobody but me touches it.

Testbeds

Data:

• drug research example
• WWW2005 conference data
• W3C ACLs DB

Languages:

• Algae
• SPARQL — very little additional work

Examples

When/where are all the papers by Bing Liu?

PREFIX w5: <http://www.w3.org/2004/10/18-RDF-WWW2005/#>
SELECT ?name ?roomDesc ?start ?end
 WHERE { ?author   w5:authorName       "Bing Liu" .
         ?author   w5:wrote            ?paper .
         ?paper    w5:paperName        ?name . 
         ?paper    w5:inSession        ?session .
         ?program  w5:Program_session  ?session .
         ?program  w5:start            ?start .
         ?program  w5:end              ?end .
         ?session  w5:Session_room     ?room .
         ?room     w5:Room_description ?roomDesc }

• inspection interface
• SPARQL XML results format
• RDF/XML

Security

• Require particular auth to reference a particular field:
  

  auth.group.Paper.email: registered

• Could extend to specific tuples or more complex logic.

Graph Transformations

Hide structure as well as protected fields.

Implemented in Algae rules:

interface (sqlDB:W3Cacls
           API  (?sub     acl:memberOf                ?super) 
           impl (#?g1     sqlDB:idInclusions.id       ?sub .
                  ?g1     sqlDB:idInclusions.groupId  ?super)) 
interface (sqlDB:W3Cacls
           API  (?a       acl:accessor                ?principal) 
           impl (?a       sqlDB:acls.id               ?principal)) 

ToDo

• describe and handle many to many tables:
  

  many2many: PaperAuthors paper=> Paper._id author => Author._id

• push constraints into SQL where possible.
• work out tricky disjunction paths problem.