Institute for Application-oriented Knowledge Processeing, Johannes Kepler University Linz, Austria
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.
Cite this vocabulary as: Ehrlinger, L. The Data Source Description vocabulary 4.0.0.
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.
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
has Foreign Key
Describes the connection between an InheritanceAssociation and a parent Concept.
has Primary Key
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
is Schema of
A ForeignKey or Concept references to another Concept or a PrimaryKey.
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
An Association describes a relationship between two instances of the class Concept. There are three disjoint subclasses of Association for Aggregation, Inheritance, and Reference.
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 strutural part of a Data Source. Example: Corresponds to a table or a view from a relational database; a class in object-oriented structures.
Concept
A generic class for representing data sources. Example: An instance of this class can represent a data source, e.g., a relational information system, a comma separated list, semi-structured text files or a graph. Optionally, an object property referencing an instance of Data Source Type may be present.
Data source
This class provides instances of the most common data source types. These instances may be referenced from an instance of the class Data Source.
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 the class Schema provide an optional hierarchy level between an instance of Data Source and instances of Concept. Schemas allow the grouping of Concepts and are very common in enterprise databases.
Schema