Requirements/DDLCoverage

From RDB2RDF
Jump to: navigation, search

Coverage of DDL part of SQL

Topic: based on ISSUE-3 this page gathers the DDL statements we plan to support in R2RML.

Responsible: Juan


Tables

  • CREATE TABLE table_name
    • Tables may be mapped to a Class. They may also mapped to a Property if they are binary relations.
  • DESCRIBE table_name
    • Lists all the fields in a table, its data types and keys. Useful to identify specific properties

Views

  • CREATE VIEW
    • Because it is a virtual table, it inherits the properties of a table (may be mapped to a Class)

Datatypes

  • Data types need to be mapped. More discussion needed to identify which vendor specific ones.

Integrity constraints

  • PRIMARY KEY
    • Primary Keys may be mapped to OWL Functional Property or Cardinality of 1
  • FOREIGN KEY (attributes) REFERENCES table (attributes)
    • Foreign Keys may be mapped to OWL Object Properties. The current table may be the domain and the referenced table may be the domain
  • UNIQUE
    • Attribute that has UNIQUE constraint may be mapped to a Property with a Cardinality or OWL Inverse Functional Property
  • NULL
    • Attribute that has NULL constraint may be mapped to a Property with a Cardinality of 0
  • NOT NULL
    • Attribute that has NOT NULL constraint may be mapped to a Property with a Cardinality of 1
  • CHECK
    • Attribute that has a CHECK constraint may be mapped to a Property that has a range of an enumerated datatype (OWL oneOf)

Indexes

Triggers

Functions