language en

Description of a Data Source

Release 2022-06-23

This version:
http://dqm.faw.jku.at/ontologies/dsd/3.0.0
Revision:
3.0.0
Issued on:
2022-04-14
Authors:
Lisa Ehrlinger
Publisher:
Institute for Application-oriented Knowledge Processing, Johannes Kepler University Linz
Imported Ontologies:
void
Download serialization:
JSON-LD RDF/XML N-Triples TTL
License:
http://insertlicenseURIhere.org
Cite as:
Lisa Ehrlinger. Description of a Data Source. Revision: 3.0.0. Retrieved from: http://dqm.faw.jku.at/ontologies/dsd/3.0.0
Provenance of this page
Ontology Specification Draft

Abstract

To ensure comparability between schemas from different data models, the Description of a Data Source (DSD) vocabulary has been developed.

Introduction back to ToC

Namespace declarations

Table 1: Namespaces used in the document
dsd<http://dqm.faw.jku.at/ontologies/dsd#>
schema<http://schema.org>
void<http://rdfs.org/ns/void>
owl<http://www.w3.org/2002/07/owl>
rdf<http://www.w3.org/1999/02/22-rdf-syntax-ns>
terms<http://purl.org/dc/terms>
schema1<https://schema.org>
xml<http://www.w3.org/XML/1998/namespace>
xsd<http://www.w3.org/2001/XMLSchema>
rdfs<http://www.w3.org/2000/01/rdf-schema>
vann<http://purl.org/vocab/vann>
foaf<http://xmlns.com/foaf/0.1>

Description of a Data Source: Overview back to ToC

This ontology has the following classes and properties.

Classes

Object Properties

Data Properties

Description of a Data Source: Description back to ToC

A data source consists of arbitrary many instances of the class Concept that represents real-world objects. Concepts can be related to each other with instances of the class Association. Properties of concepts and associations are described by the class Attribute, which is defined by a xsd:Datatype.

Relationships between dsd classes are described by a set of OWL object properties and data type properties with the prefix dsd. A Datasourcecontains several concepts that are linked by the hasComponent property. Concepts consist of attributes, connected by the hasAttribute property, and include key attributes expressed by hasPrimaryKey and hasForeignKey, which in turn consist of attributes and refer to others keys.

Inheritance and aggregation associations are composed of parents and childs (hasParent, hasChild) or aggregations and components (has Aggregation, hasAggregationComponent).

Cross-reference for Description of a Data Source classes, object properties and data properties back to ToC

This section provides details for each class and property defined by Description of a Data Source.

Classes

Aggregation associationc back to ToC or Class ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#AggregationAssociation

Describes the relationship between an aggregation that is composed out of several components.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#AggregationAssociation
has super-classes
Association c
is in domain of
hasAggregation op, hasAggregationComponent op, is disjoint dp
is disjoint with
Inheritance association c, Reference association c

Associationc back to ToC or Class ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#Association

Is defined by
http://dqm.faw.jku.at/ontologies/dsd#Association
has sub-classes
Aggregation association c, Inheritance association c, Reference association c
is in domain of
has association descriptor dp, hasAssociationMember op

Attributec back to ToC or Class ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#Attribute

An Attribute describes a property of a Concept.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#Attribute
is in domain of
has attribute descriptor dp, isAttributeOf op, isOfDataType op
is in range of
consistsOfAttributes op, hasAttribute op

Conceptc back to ToC or Class ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#Concept

A Concept defines a part of a data source that can be e.g. a class in an object oriented source or a table in a relational database.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#Concept
is in domain of
has concept descriptor dp
is in range of
has child op, hasAggregation op, hasAggregationComponent op, hasAssociationMember op, hasParent op, references from op
has keys
has primary key op

Data model typec back to ToC or Class ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#DatasourceType

Provides pre-defined Datasource Type Instances.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#DatasourceType
is in range of
isOfDatasourceType op
has members
c s v file ni, excel sheet ni, no s q l d b ni, o o d b ni, plain text ni, r d f store ni, relational d b ni, x m l file ni
is disjoint with
Datasource c, Stakeholder c

Datasourcec back to ToC or Class ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#Datasource

A generic class for a data source. Could be anything from RDF-Triple Store, relational Datasource, comma separated list or just semi-structured text files.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#Datasource
is in domain of
has schema op, isOfDatasourceType op
is in range of
is schema of op
is disjoint with
Data model type c, Stakeholder c

Foreign keyc back to ToC or Class ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#ForeignKey

References to a Primary key and consists of one or more Attributes.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#ForeignKey
is in domain of
has f k descriptor dp
is in range of
has foreign key op

Inheritance associationc back to ToC or Class ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#InheritanceAssociation

Describes the relationship between several child Concepts and their parent.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#InheritanceAssociation
has super-classes
Association c
is in domain of
has child op, hasParent op, is disjoint dp
is disjoint with
Aggregation association c, Reference association c

Primary keyc back to ToC or Class ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#PrimaryKey

Identifies a Concept and consists of one or more Attributes.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#PrimaryKey
is in range of
has primary key op

Reference associationc back to ToC or Class ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#ReferenceAssociation

Describes a regular relationship between two or more Concepts.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#ReferenceAssociation
has super-classes
Association c
is in domain of
references from op
is disjoint with
Aggregation association c, Inheritance association c

Schemac back to ToC or Class ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#Schema

A Schema groups multiple concepts. It is an optional hierachy level between a Datasource and the concepts.
is in domain of
is schema of op
is in range of
has schema op

Stakeholderc back to ToC or Class ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#Stakeholder

A stakeholder has access to a Datasource or a Concept of a Datasource. A stakeholder is typically a department of a company but can also be a person or a organization.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#Stakeholder
is in range of
providesAccess op
is disjoint with
Datasource c, Data model type c

Object Properties

consistsOfAttributesop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#consistsOfAttribute

A Primary or Foreign Key consists of one or several Attributes.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#consistsOfAttribute
has domain
Foreign key c or Primary key c
has range
Attribute c

has childop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#hasChild

Describes the connection between an InheritanceAssociation and one of its childs.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#hasChild
has super-properties
hasAssociationMember op
has domain
Inheritance association c
has range
Concept c

has foreign keyop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#hasForeignKey

Is defined by
http://dqm.faw.jku.at/ontologies/dsd#hasForeignKey
has domain
Association c or Concept c
has range
Foreign key c

has primary keyop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#hasPrimaryKey

Is defined by
http://dqm.faw.jku.at/ontologies/dsd#hasPrimaryKey

has characteristics: functional

has domain
Association c or Concept c
has range
Primary key c

has schemaop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#hasSchema

has characteristics: inverse functional

has domain
Datasource c
has range
Schema c
is inverse of
is schema of op

hasAggregationop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#hasAggregation

Describes the connection between an AggregationAssociation and its Aggregation.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#hasAggregation

has characteristics: functional

has super-properties
hasAssociationMember op
has domain
Aggregation association c
has range
Concept c

hasAggregationComponentop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#hasAggregationComponent

Describes the connection between an AggregationAssociation and one of its components.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#hasAggregationComponent
has super-properties
hasAssociationMember op
has domain
Aggregation association c
has range
Concept c

hasAssociationMemberop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#hasAssociationMember

Describes the edges from an Association to its Members (Parent, Child, Aggregation, Component).
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#hasAssociationMember
has super-properties
top object property
has sub-properties
has child op, hasAggregation op, hasAggregationComponent op, hasParent op
has domain
Association c
has range
Concept c

hasAttributeop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#hasAttribute

Describes the number of Attributes a Concept or Association comprises.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#hasAttribute
has domain
Association c or Concept c
has range
Attribute c
is inverse of
isAttributeOf op

hasComponentop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#hasComponent

Describes the number of components a Datasource comprises.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#hasComponent
has domain
Datasource c or Schema c
has range
Association c or Attribute c or Concept c or Foreign key c or Primary key c
is inverse of
isComponentOf op

hasParentop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#hasParent

Describes the connection between an InheritanceAssociation and a parent Concept.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#hasParent
has super-properties
hasAssociationMember op
has domain
Inheritance association c
has range
Concept c

is schema ofop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#isSchemaOf

has characteristics: functional

has domain
Schema c
has range
Datasource c
is inverse of
has schema op

isAttributeOfop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#isAttributeOf

Describes an Attributes's connection to its Concept or Association.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#isAttributeOf
has domain
Attribute c
has range
Association c or Concept c
is inverse of
hasAttribute op

isComponentOfop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#isComponentOf

Describes a components connection to its Datasource.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#isComponentOf
has domain
Association c or Attribute c or Concept c or Foreign key c or Primary key c
has range
Datasource c or Schema c
is inverse of
hasComponent op

isOfDatasourceTypeop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#isOfDatasourceType

Describes the type of datasource a Datasource has. This Ontology provides some Individuals that can be used.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#isOfDatasourceType

has characteristics: functional, asymmetric

has domain
Datasource c
has range
Data model type c

isOfDataTypeop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#isOfDataType

Describes an Attribute with an XLS Datatype.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#isOfDataType

has characteristics: functional, asymmetric

has domain
Attribute c

providesAccessop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#providesAccess

A datasource or part of a datasource (e.g. a concept) may provide access to one or more stakeholder.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#providesAccess

has characteristics: asymmetric

has domain
Association c or Concept c or Datasource c
has range
Stakeholder c

references fromop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#referencesFrom

Is defined by
http://dqm.faw.jku.at/ontologies/dsd#referencesFrom

has characteristics: asymmetric

has super-properties
top object property
has domain
Reference association c
has range
Concept c

referencesToop back to ToC or Object Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#referencesTo

A ForeignKey or Concept references to another Concept or a PrimaryKey.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#referencesTo
has super-properties
top object property
has domain
Concept c or Primary key c or Reference association c
has range
Concept c or Foreign key c or Reference association c

Data Properties

avg instance lengthdp back to ToC or Data Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#avgInstanceLength

Gives a value of the average (character) length of instances of this concept. E.g., row entries in a MySQL DB.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#avgInstanceLength
has super-properties
has concept descriptor dp

constraint on deletedp back to ToC or Data Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#constraintOnDelete

Describes the constraint that is defined on a foreign key, which action should be carried out if the referenced primary key is deleted.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#constraintOnDelete
has super-properties
has f k descriptor dp
has range
string

constraint on updatedp back to ToC or Data Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#constraintOnUpdate

Describes which constraint is defined on a foreign key if the referenced primary key content is updated.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#constraintOnUpdate
has super-properties
has f k descriptor dp
has range
string

default valuedp back to ToC or Data Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#defaultValue

Provides an default value for an attribute.

has characteristics: functional

has super-properties
has attribute descriptor dp
has range
string

has association descriptordp back to ToC or Data Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#hasAssociationDescriptor

Provides annotations for an association.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#hasAssociationDescriptor
has sub-properties
is complete dp, is disjoint dp
has domain
Association c

has attribute descriptordp back to ToC or Data Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#hasAttributeDescriptor

Provides annotations for an attribute.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#hasAttributeDescriptor
has sub-properties
default value dp, is auto increment dp, is nullable dp, is unique dp, max character length dp, ordinal position dp
has domain
Attribute c

has concept descriptordp back to ToC or Data Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#hasConceptDescriptor

Provides annotations for a concept.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#hasConceptDescriptor
has sub-properties
avg instance length dp, no of instances dp
has domain
Concept c

has f k descriptordp back to ToC or Data Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#hasFKDescriptor

Foreign key descriptor: A textual description of what should happen if the reference of this foreign key is modified (updated/deleted).
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#hasFKDescriptor
has sub-properties
constraint on delete dp, constraint on update dp
has domain
Foreign key c

is auto incrementdp back to ToC or Data Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#isAutoIncrement

If the attribute automatically increments on a new insertion of a new value.

has characteristics: functional

has super-properties
has attribute descriptor dp
has range
boolean

is completedp back to ToC or Data Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#isComplete

Defines whether an inheritance association is complete. If property is set to FALSE, the association is incomplete.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#isComplete

has characteristics: functional

has super-properties
has association descriptor dp
has domain
Aggregation association c or Inheritance association c
has range
boolean

is disjointdp back to ToC or Data Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#isDisjoint

Describes whether the children of an inheritance association are disjoint. If property is set to FALSE, the children are overlapping.
Is defined by
http://dqm.faw.jku.at/ontologies/dsd#isDisjoint

has characteristics: functional

has super-properties
has association descriptor dp
has domain
Aggregation association c
Inheritance association c
has range
boolean

is nullabledp back to ToC or Data Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#isNullable

If the attribute can contain NULL values.

has characteristics: functional

has super-properties
has attribute descriptor dp
has range
boolean

is uniquedp back to ToC or Data Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#isUnique

Describes if an attribute is unique or not.

has characteristics: functional

has super-properties
has attribute descriptor dp
has range
boolean

max character lengthdp back to ToC or Data Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#maxCharacterLength

Maximum character length of this attribute, given in the number of bits.

has characteristics: functional

has super-properties
has attribute descriptor dp
has range
integer

no of instancesdp back to ToC or Data Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#noOfInstances

Number of instances of a concept/association.

has characteristics: functional

has super-properties
has concept descriptor dp
has range
non negative integer

ordinal positiondp back to ToC or Data Property ToC

IRI: http://dqm.faw.jku.at/ontologies/dsd#ordinalPosition

The ordinal position of the attribute to the concept, this information might not always be available (depending on the data source).

has characteristics: functional

has super-properties
has attribute descriptor dp
has range
positive integer

Legend back to ToC

c: Classes
op: Object Properties
dp: Data Properties