OBD:OBD-SQL-Schema

From NCBO Wiki

Jump to: navigation, search

OBDSQL is just one possible physical repository for OBD Annotations. Other possibilities are a triplestore or in-memory objects.

It is important to stress that the user of the OBD API (either the OBD:Java API or the OBD:Web Services layer) is never exposed to any SQL. The actual implementation is provided by the OBDSQLShard implementation (see Shard UML diagram for more details)

Contents

Source

The SQL DDL source is in GForge svn

Core Schema

The following documentation is auto-generated from the schema.

This is the core metamodel for OBD graphs. The basic tables are node and link


Schema Diagram

Core Schema plus Views

Views can be materialized for efficiency

Views are partitioned into sub-schemas as follows

OBD Core View

OBD core view

OBD Pre-Joins View

Convenience views, pre-joined tables


OBD Annotation View

OBD annotation model

OBD Aggregate View

aggregate queries and summary reports

OBD Graph Topology View

graph structure

OBD Statistical View

statistical and information-theoretic measures

SQL API

RDF Mapping

SPARQL Endpoint not yet open on public server

Personal tools