The Data Source Description Vocabulary

Metadata

IRI
https://w3id.org/dsd
Title

The Data Source Description Vocabulary

Publisher
Institute for Application-oriented Knowledge Processeing, Johannes Kepler University Linz, Austria
Creator
Lisa Ehrlinger ( lisa.ehrlinger@scch.at)
Contributor
Johannes Schrott ( johannes.schrott@jku.at)
Date Created

2015-09-17

Date Modified

2023-03-27

Date Issued

2023-03-27

License
Version Iri
ns1:4.0.0
Version Info

4.0.0

Preferred Namespace Prefix

dsd

Preferred Namespace Uri
dsd:
Description

The Data Source Description Vocabulary (DSD) allows the representation of data sources and their internal structure independently of their type. The figure below provides an overview on OWL classes and object properties present in the vocabulary. For simplicity, inverse object properties and some subclasses are not shown. Additionally, a distinction between "essential" OWL classes, that are required for the description of data sources, and "optional" classes, which provide additional non-necessary features, is being made.

The vocabulary is available for download at https://w3id.org/dsd/DSD4.ttl.

Classes

Aggregation association c

IRI https://w3id.org/dsd#AggregationAssociation
Is Defined By dsd:AggregationAssociation c
Description

Describes the relationship between an aggregation that is composed out of several components.

Sub Class Of dsd:Association c
In Domain Of

Association c

IRI https://w3id.org/dsd#Association
Is Defined By dsd:Association c
Description

A dsd:Association describes a relationship between two instances of dsd:Concept. There are three dsd:Association subclasses for aggregation, inheritance, and reference associations.

In Domain Of
Super Class Of

Attribute c

IRI https://w3id.org/dsd#Attribute
Is Defined By dsd:Attribute c
Description

An Attribute describes a property of a Concept. DSD also provides OWL data properties for the description of certain attribute characteristics, such as, nullable or unique. Example: If a Concept represents a relational table, its attributes correspond to the columns.

In Domain Of
In Range Of

Concept c

IRI https://w3id.org/dsd#Concept
Is Defined By dsd:Concept c
Description

A representation of a structural part of a data source. Example: A dsd:Concept can represent a table or a view of a relational database or a class in object-oriented structures.

In Domain Of dsd:hasConceptDescriptor dp
In Range Of

Data source c

IRI https://w3id.org/dsd#Datasource
Is Defined By dsd:Datasource c
Description

A generic class for representing data sources. Example: A dsd:DataSource can represent structured data such as relational databases, semi-structured data like XML files, or NoSQL databases such as graph databases or wide-column stores. A dsd:DataSource can be assigned to an instance of dsd:DataSourceType.

In Domain Of
In Range Of dsd:isSchemaOf op

Data source type c

IRI https://w3id.org/dsd#DatasourceType
Is Defined By dsd:DatasourceType c
Description

This class provides instances of the most common data source types, which can be assigned to instance of dsd:DataSource.

In Range Of dsd:isOfDatasourceType op

Foreign key c

IRI https://w3id.org/dsd#ForeignKey
Is Defined By dsd:ForeignKey c
Description

References to a Primary key and consists of one or more Attributes.

In Domain Of dsd:hasFKDescriptor dp
In Range Of dsd:hasForeignKey op

Inheritance association c

IRI https://w3id.org/dsd#InheritanceAssociation
Is Defined By dsd:InheritanceAssociation c
Description

Describes the relationship between several child Concepts and their parent.

Sub Class Of dsd:Association c
In Domain Of

Primary key c

IRI https://w3id.org/dsd#PrimaryKey
Is Defined By dsd:PrimaryKey c
Description

Identifies a Concept and consists of one or more Attributes.

In Range Of dsd:hasPrimaryKey op

Reference association c

IRI https://w3id.org/dsd#ReferenceAssociation
Is Defined By dsd:ReferenceAssociation c
Description

Describes a regular relationship between two or more Concepts.

Sub Class Of dsd:Association c

Schema c

IRI https://w3id.org/dsd#Schema
Description

Instances of dsd:Schema provide an optional hierarchy level between an instance of dsd:DataSource and instances of dsd:Concept. Schemas allow the grouping of concepts and are very common in enterprise databases.

In Domain Of dsd:isSchemaOf op
In Range Of dsd:hasSchema op

Object Properties

consists of Attributes op

IRI https://w3id.org/dsd#consistsOfAttribute
Is Defined By dsd:consistsOfAttribute op
Description

A Primary or Foreign Key consists of one or several Attributes.

Domain dsd:ForeignKey c or dsd:PrimaryKey c
Range dsd:Attribute c

has Aggregation op

IRI https://w3id.org/dsd#hasAggregation
Is Defined By dsd:hasAggregation op
Description

Describes the connection between an AggregationAssociation and its Aggregation.

Sub Property Of dsd:hasAssociationMember op
Domain dsd:AggregationAssociation c
Range dsd:Concept c

has Aggregation Component op

IRI https://w3id.org/dsd#hasAggregationComponent
Is Defined By dsd:hasAggregationComponent op
Description

Describes the connection between an AggregationAssociation and one of its components.

Sub Property Of dsd:hasAssociationMember op
Domain dsd:AggregationAssociation c
Range dsd:Concept c

has Association Member op

IRI https://w3id.org/dsd#hasAssociationMember
Is Defined By dsd:hasAssociationMember op
Description

Describes the edges from an Association to its Members (Parent, Child, Aggregation, Component).

Sub Property Of owl:topObjectProperty op
Super Property Of
Domain dsd:Association c
Range dsd:Concept c

has Attribute op

IRI https://w3id.org/dsd#hasAttribute
Is Defined By dsd:hasAttribute op
Description

Describes the number of Attributes a Concept or Association comprises.

Domain dsd:Concept c or dsd:Association c
Range dsd:Attribute c

has Child op

IRI https://w3id.org/dsd#hasChild
Is Defined By dsd:hasChild op
Description

Describes the connection between an InheritanceAssociation and one of its childs.

Sub Property Of dsd:hasAssociationMember op
Domain dsd:InheritanceAssociation c
Range dsd:Concept c

has Component op

IRI https://w3id.org/dsd#hasComponent
Is Defined By dsd:hasComponent op
Description

Describes the number of components a Datasource comprises.

Domain dsd:Datasource c or dsd:Schema c
Range dsd:Attribute c or dsd:Concept c or dsd:ForeignKey c or dsd:Association c or dsd:PrimaryKey c

has Foreign Key op

IRI https://w3id.org/dsd#hasForeignKey
Is Defined By dsd:hasForeignKey op
Description

Connects an Association or an Concept with its foreign key.

Domain dsd:Association c or dsd:Concept c
Range dsd:ForeignKey c

has Parent op

IRI https://w3id.org/dsd#hasParent
Is Defined By dsd:hasParent op
Description

Describes the connection between an InheritanceAssociation and a parent Concept.

Sub Property Of dsd:hasAssociationMember op
Domain dsd:InheritanceAssociation c
Range dsd:Concept c

has Primary Key op

IRI https://w3id.org/dsd#hasPrimaryKey
Is Defined By dsd:hasPrimaryKey op
Description

Connects an Association or an Concept with it primary key.

Domain dsd:Concept c or dsd:Association c
Range dsd:PrimaryKey c

has Schema op

IRI https://w3id.org/dsd#hasSchema
Description

Describes the schemas a data source may consist of.

Domain dsd:Datasource c
Range dsd:Schema c

is Attribute of op

IRI https://w3id.org/dsd#isAttributeOf
Is Defined By dsd:isAttributeOf op
Description

Describes an Attributes's connection to its Concept or Association.

Domain dsd:Attribute c
Range dsd:Concept c or dsd:Association c

is Component of op

IRI https://w3id.org/dsd#isComponentOf
Is Defined By dsd:isComponentOf op
Description

Describes a components connection to its Datasource.

Domain dsd:Attribute c or dsd:PrimaryKey c or dsd:ForeignKey c or dsd:Concept c or dsd:Association c
Range dsd:Schema c or dsd:Datasource c

is of Data Type op

IRI https://w3id.org/dsd#isOfDataType
Is Defined By dsd:isOfDataType op
Description

Describes an Attribute with an XLS Datatype.

Domain dsd:Attribute c

is of Data Source Type op

IRI https://w3id.org/dsd#isOfDatasourceType
Is Defined By dsd:isOfDatasourceType op
Description

Describes the type of a Data Source. This vocabulary provides some Individuals that can be used.

Domain dsd:Datasource c
Range dsd:DatasourceType c

is Schema of op

IRI https://w3id.org/dsd#isSchemaOf
Description

Describes to which data source a schema belongs to.

Domain dsd:Schema c
Range dsd:Datasource c

referencesTo op

IRI https://w3id.org/dsd#referencesTo
Is Defined By dsd:referencesTo op
Description

A PrimaryKey, Concept or any kind of Association references to another Concept, ForeignKey or Association.

Sub Property Of owl:topObjectProperty op
Domain dsd:Concept c or dsd:Association c or dsd:PrimaryKey c
Range dsd:Concept c or dsd:Association c or dsd:ForeignKey c
dsd:ForeignKey c dsd:PrimaryKey c dsd:Association c dsd:Concept c dsd:Datasource c dsd:Schema c dsd:Association c dsd:Attribute c dsd:Concept c dsd:ForeignKey c dsd:PrimaryKey c dsd:Association c dsd:Concept c dsd:Association c dsd:Concept c dsd:Association c dsd:Concept c dsd:Association c dsd:Attribute c dsd:Concept c dsd:ForeignKey c dsd:PrimaryKey c dsd:Datasource c dsd:Schema c dsd:Concept c dsd:PrimaryKey c dsd:Association c dsd:Concept c dsd:ForeignKey c dsd:Association c

Datatype Properties

Average length of instance dp

IRI https://w3id.org/dsd#avgInstanceLength
Is Defined By dsd:avgInstanceLength dp
Description

Gives a value of the average (character) length of instances of this concept. E.g., row entries in a MySQL DB.

Sub Property Of dsd:hasConceptDescriptor dp

Constraint on Delete dp

IRI https://w3id.org/dsd#constraintOnDelete
Is Defined By dsd:constraintOnDelete dp
Description

Describes the constraint that is defined on a foreign key, which action should be carried out if the referenced primary key is deleted.

Sub Property Of dsd:hasFKDescriptor dp
Range xsd:string

Constraint on Update dp

IRI https://w3id.org/dsd#constraintOnUpdate
Is Defined By dsd:constraintOnUpdate dp
Description

Describes which constraint is defined on a foreign key if the referenced primary key content is updated.

Sub Property Of dsd:hasFKDescriptor dp
Range xsd:string

Default Value dp

IRI https://w3id.org/dsd#defaultValue
Description
Sub Property Of dsd:hasAttributeDescriptor dp
Range xsd:string

has Association Descriptor dp

IRI https://w3id.org/dsd#hasAssociationDescriptor
Is Defined By dsd:hasAssociationDescriptor dp
Description

Provides annotations for an association.

Super Property Of
Domain dsd:Association c

has Attribute Descriptor dp

IRI https://w3id.org/dsd#hasAttributeDescriptor
Is Defined By dsd:hasAttributeDescriptor dp
Description

Provides annotations for an attribute.

Super Property Of
Domain dsd:Attribute c

has Concept Descriptor dp

IRI https://w3id.org/dsd#hasConceptDescriptor
Is Defined By dsd:hasConceptDescriptor dp
Description

Provides annotations for a concept.

Super Property Of
Domain dsd:Concept c

has Foreign Key Descriptor dp

IRI https://w3id.org/dsd#hasFKDescriptor
Is Defined By dsd:hasFKDescriptor dp
Description

Foreign key descriptor: A textual description of what should happen if the reference of this foreign key is modified (updated/deleted).

Super Property Of
Domain dsd:ForeignKey c

automatically increments dp

IRI https://w3id.org/dsd#isAutoIncrement
Description
  • dsd:isAutoIncrement dp
  • If the attribute automatically increments on a new insertion of a new value.

Sub Property Of dsd:hasAttributeDescriptor dp
Range xsd:boolean

is Complete dp

IRI https://w3id.org/dsd#isComplete
Is Defined By dsd:isComplete dp
Description

Defines whether an inheritance association is complete. If property is set to FALSE, the association is incomplete.

Sub Property Of dsd:hasAssociationDescriptor dp
Domain dsd:AggregationAssociation c or dsd:InheritanceAssociation c
Range xsd:boolean

is Disjoint dp

IRI https://w3id.org/dsd#isDisjoint
Is Defined By dsd:isDisjoint dp
Description

Describes whether the children of an inheritance association are disjoint. If property is set to FALSE, the children are overlapping.

Sub Property Of dsd:hasAssociationDescriptor dp
Domain
Range xsd:boolean

is Nullable dp

IRI https://w3id.org/dsd#isNullable
Description
Sub Property Of dsd:hasAttributeDescriptor dp
Range xsd:boolean

is Unique dp

IRI https://w3id.org/dsd#isUnique
Description
  • dsd:isUnique dp
  • Describes if an attribute is unique or not.

Sub Property Of dsd:hasAttributeDescriptor dp
Range xsd:boolean

Maximum Character Length dp

IRI https://w3id.org/dsd#maxCharacterLength
Description
Sub Property Of dsd:hasAttributeDescriptor dp
Range xsd:integer

Number of Instances dp

IRI https://w3id.org/dsd#noOfInstances
Description
Sub Property Of dsd:hasConceptDescriptor dp
Range xsd:nonNegativeInteger

Ordinal Position dp

IRI https://w3id.org/dsd#ordinalPosition
Description
  • dsd:ordinalPosition dp
  • The ordinal position of the attribute to the concept, this information might not always be available (depending on the data source).

Sub Property Of dsd:hasAttributeDescriptor dp
Range xsd:positiveInteger
dsd:AggregationAssociation c dsd:InheritanceAssociation c

Functional Properties

has Aggregation fp

IRI https://w3id.org/dsd#hasAggregation
Is Defined By dsd:hasAggregation op
Description

Describes the connection between an AggregationAssociation and its Aggregation.

Sub Property Of dsd:hasAssociationMember op
Domain dsd:AggregationAssociation c
Range dsd:Concept c

has Primary Key fp

IRI https://w3id.org/dsd#hasPrimaryKey
Is Defined By dsd:hasPrimaryKey op
Description

Connects an Association or an Concept with it primary key.

Domain dsd:Concept c or dsd:Association c
Range dsd:PrimaryKey c

is of Data Type fp

IRI https://w3id.org/dsd#isOfDataType
Is Defined By dsd:isOfDataType op
Description

Describes an Attribute with an XLS Datatype.

Domain dsd:Attribute c

is of Data Source Type fp

IRI https://w3id.org/dsd#isOfDatasourceType
Is Defined By dsd:isOfDatasourceType op
Description

Describes the type of a Data Source. This vocabulary provides some Individuals that can be used.

Domain dsd:Datasource c
Range dsd:DatasourceType c

is Schema of fp

IRI https://w3id.org/dsd#isSchemaOf
Description

Describes to which data source a schema belongs to.

Domain dsd:Schema c
Range dsd:Datasource c

Default Value fp

IRI https://w3id.org/dsd#defaultValue
Description
Sub Property Of dsd:hasAttributeDescriptor dp
Range xsd:string

automatically increments fp

IRI https://w3id.org/dsd#isAutoIncrement
Description
  • dsd:isAutoIncrement dp
  • If the attribute automatically increments on a new insertion of a new value.

Sub Property Of dsd:hasAttributeDescriptor dp
Range xsd:boolean

is Complete fp

IRI https://w3id.org/dsd#isComplete
Is Defined By dsd:isComplete dp
Description

Defines whether an inheritance association is complete. If property is set to FALSE, the association is incomplete.

Sub Property Of dsd:hasAssociationDescriptor dp
Domain dsd:AggregationAssociation c or dsd:InheritanceAssociation c
Range xsd:boolean

is Disjoint fp

IRI https://w3id.org/dsd#isDisjoint
Is Defined By dsd:isDisjoint dp
Description

Describes whether the children of an inheritance association are disjoint. If property is set to FALSE, the children are overlapping.

Sub Property Of dsd:hasAssociationDescriptor dp
Domain
Range xsd:boolean

is Nullable fp

IRI https://w3id.org/dsd#isNullable
Description
Sub Property Of dsd:hasAttributeDescriptor dp
Range xsd:boolean

is Unique fp

IRI https://w3id.org/dsd#isUnique
Description
  • dsd:isUnique dp
  • Describes if an attribute is unique or not.

Sub Property Of dsd:hasAttributeDescriptor dp
Range xsd:boolean

Maximum Character Length fp

IRI https://w3id.org/dsd#maxCharacterLength
Description
Sub Property Of dsd:hasAttributeDescriptor dp
Range xsd:integer

Number of Instances fp

IRI https://w3id.org/dsd#noOfInstances
Description
Sub Property Of dsd:hasConceptDescriptor dp
Range xsd:nonNegativeInteger

Ordinal Position fp

IRI https://w3id.org/dsd#ordinalPosition
Description
  • dsd:ordinalPosition dp
  • The ordinal position of the attribute to the concept, this information might not always be available (depending on the data source).

Sub Property Of dsd:hasAttributeDescriptor dp
Range xsd:positiveInteger
dsd:Association c dsd:Concept c dsd:AggregationAssociation c dsd:InheritanceAssociation c

Namespaces

bibo
http://purl.org/ontology/bibo/
dcterms
http://purl.org/dc/terms/
dsd
https://w3id.org/dsd#
foaf
http://xmlns.com/foaf/0.1/
ns1
https://w3id.org/dsd/
owl
http://www.w3.org/2002/07/owl#
rdf
http://www.w3.org/1999/02/22-rdf-syntax-ns#
rdfs
http://www.w3.org/2000/01/rdf-schema#
schema
http://schema.org/
sw
http://www.w3.org/2003/06/sw-vocab-status/ns#
vann
http://purl.org/vocab/vann/
xsd
http://www.w3.org/2001/XMLSchema#

Legend

c Classes
op Object Properties
dp Datatype Properties
fp Functional Properties

made by p y LODE 3.0.4

Table of Contents