Johannes Schrott
Lisa Ehrlinger
https://www.jku.at/faw
Institute for Application-oriented Knowledge Processeing, Johannes Kepler University Linz, Austria
2015-09-17
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.<br><img src="https://dqm.faw.jku.at/ontologies/dsd/4.0.0/DSD4.png" style="width: calc(100%); max-width: 1000px">
LGPL-2.1 license
2023-03-27
The Data Source Description Vocabulary
dsd
https://w3id.org/dsd#
Cite this vocabulary as: Ehrlinger, L. The Data Source Description vocabulary 4.0.0.
2023-03-27
4.0.0
stable
A Primary or Foreign Key consists of one or several Attributes.
consists of Attributes
Describes the connection between an AggregationAssociation and its Aggregation.
has Aggregation
Describes the connection between an AggregationAssociation and one of its components.
has Aggregation Component
Describes the edges from an Association to its Members (Parent, Child, Aggregation, Component).
has Association Member
Describes the number of Attributes a Concept or Association comprises.
has Attribute
Describes the connection between an InheritanceAssociation and one of its childs.
has Child
Describes the number of components a Datasource comprises.
has Component
Connects an Association or an Concept with its foreign key.
has Foreign Key
Describes the connection between an InheritanceAssociation and a parent Concept.
has Parent
Connects an Association or an Concept with it primary key.
has Primary Key
Describes the schemas a data source may consist of.
has Schema
Describes an Attributes's connection to its Concept or Association.
is Attribute of
Describes a components connection to its Datasource.
is Component of
Describes an Attribute with an XLS Datatype.
is of Data Type
Describes the type of a Data Source. This vocabulary provides some Individuals that can be used.
is of Data Source Type
Describes to which data source a schema belongs to.
is Schema of
A PrimaryKey, Concept or any kind of Association references to another Concept, ForeignKey or Association.
referencesTo
Gives a value of the average (character) length of instances of this concept. E.g., row entries in a MySQL DB.
Average length of instance
Describes the constraint that is defined on a foreign key, which action should be carried out if the referenced primary key is deleted.
Constraint on Delete
Describes which constraint is defined on a foreign key if the referenced primary key content is updated.
Constraint on Update
Provides an default value for an attribute.
Default Value
Provides annotations for an association.
has Association Descriptor
Provides annotations for an attribute.
has Attribute Descriptor
Provides annotations for a concept.
has Concept Descriptor
Foreign key descriptor: A textual description of what should happen if the reference of this foreign key is modified (updated/deleted).
has Foreign Key Descriptor
If the attribute automatically increments on a new insertion of a new value.
automatically increments
Defines whether an inheritance association is complete. If property is set to FALSE, the association is incomplete.
is Complete
Describes whether the children of an inheritance association are disjoint. If property is set to FALSE, the children are overlapping.
is Disjoint
If the attribute can contain NULL values.
is Nullable
Describes if an attribute is unique or not.
is Unique
Maximum character length of this attribute, given in the number of bits.
Maximum Character Length
Number of instances of a concept/association.
Number of Instances
The ordinal position of the attribute to the concept, this information might not always be available (depending on the data source).
Ordinal Position
Describes the relationship between an aggregation that is composed out of several components.
Aggregation association
A dsd:Association describes a relationship between two instances of dsd:Concept. There are three dsd:Association subclasses for aggregation, inheritance, and reference associations.
Association
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.
Attribute
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.
Concept
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.
Data source
This class provides instances of the most common data source types, which can be assigned to instance of dsd:DataSource.
Data source type
References to a Primary key and consists of one or more Attributes.
Foreign key
Describes the relationship between several child Concepts and their parent.
Inheritance association
Identifies a Concept and consists of one or more Attributes.
Primary key
Describes a regular relationship between two or more Concepts.
Reference association
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.
Schema