Ceil
type: Class
comment: Returns the smallest integer greater than or equal to n. @en-us
subclass of: NumericOperation

KeyGeneration
type: Class
comment: Process of generating keys/indexes for tables. @en-us
subclass of: Operation

Column
type: Class
comment: Database tables are composed of individual columns corresponding to the attributes of the object. @en-us

Server
type: Class
comment: Software program, or the computer on which that program runs, that provides a specific kind of service to a client software. @en-us

InsertTriple
type: Class
comment: Includes one or more triple into the store. @en-us
subclass of: GraphOperation

HumanValidation
type: Class
comment: Validation performed by a person: an user or admin. @en-us
subclass of: Validation

Extraction
type: Class
comment: The first part of an ETL process which involves extracting the data from source systems. @en-us

Cube
type: Class
comment: A multidimensional database that holds data. @en-us

Operation
type: Class
comment: Functional operations that can be done by a computer.
subclass of: Transformation

FieldDecoding
type: Class
comment: Performs decoding operations when you specify field-encoding function. @en-us
subclass of: ValueOperation

DatetimeConversion
type: Class
comment: Conversion from a datetime format to a different one.
subclass of: ValueOperation

TerminologicalMapping
type: Class
comment: Maps terminological-level (schema-level) entities. @en-us
subclass of: Mapping

StringOperation
type: Class
comment: Operations for manipulating strings. @en-us
subclass of: ValueOperation

Filter
type: Class
comment: An operation that can be used to retain rows in a mapping that do not meet specific conditions. @en-us
subclass of: Operation

isExpressedBy
type: Property
comment: This property allows the association between an abstract representation of a Transformation and an encapsulated computational artifact artifact (e.g. code, binary).
domain: Transformation

RejectedData
type: Class
comment: Data that contain database violations and are forbidden to get inserted into a table. @en-us

Event
type: Class
comment: An action that is usually initiated outside the scope of a program and that is handled by a piece of code inside the program. @en-us

AIFB/KIT
type: Agent
member: Benedikt Kämpgen

AutomatedValidation
type: Class
comment: Validation performed by a computer. @en-us
subclass of: Validation

Parsing
type: Class
comment: Process of analyzing text or data, checking for correct syntax and building a representation based on the input tokens. @en-us
subclass of: Extraction

StringFilter
type: Class
comment: Provides means for matching strings of text, such as particular characters, words, or patterns of characters. @en-us
subclass of: Filter

GraphOperation
type: Class
comment: Instructions performed on graphs. @en-us
subclass of: Operation

Log
type: Class
comment: A record of computer activity. @en-us

dependsOn
type: Property
domain: Job
range: Job

FormatRevision
type: Class
comment: Reviews the file format. @en-us
subclass of: ValueOperation

DeleteTriple
type: Class
comment: Deletes on or more triples into the store.@en-us
subclass of: GraphOperation

Success
type: Class
comment: Status of a job that had successful performance. @en-us
subclass of: ExecutionStatus

DeleteRow
type: Class
comment: Exclusion of a single or group of rows by a certain criteria on a table. @en-us
subclass of: RowOperation

MappingProcess
type: Class
comment: The process of mapping information from a source format to a destination format. @en-us
subclass of: Mapping

AggregateRows
type: Class
comment: Functions which return a single result row based on groups of rows. @en-us
subclass of: RowOperation

SelectQuery
type: Class
comment: Query that locates and displays information requested. @en-us
subclass of: Query

Device
type: Class
comment: A machine designed for a purpose. E.g.: Unit of hardware. @en-us

ApplyScript
type: Class
comment: Execution of a script. @en-us
subclass of: Operation

TableLookup
type: Class
comment: Process of using a known attribute to search for data on a table. @en-us
subclass of: Lookup

Job
type: Class
comment: The instance of a process or group of processes (workflow).
subclass of: Execution

DataAccessLayer
type: Class
comment: Layer that controls access to data in a computer-based information system. @en-us
subclass of: Layer

InsertColumn
type: Class
comment: Inserts one or more columns according to a certain criteria to a table. @en-us
subclass of: ColumnOperation

RenameColumn
type: Class
comment: Changes the name of a certain column. @en-us
subclass of: ColumnOperation

Validation
type: Class
comment: The act of validating; finding or testing the truth of something. @en-us
subclass of: Transformation

RDFNamedGraph
type: Class
comment: Multiple RDF graphs in a single document/repository and naming them with URIs. @en-us

Prefiltering
type: Class
comment: Preliminary filtering during the extraction phase.
subclass of: Extraction

Trim
type: Class
comment: String operation for removing leading and trailing whitespace from a string. @en-us
subclass of: StringOperation

Uppercase
type: Class
comment: String operation for converting a string to uppercase. @en-us
subclass of: StringOperation

Transformation
type: Class
comment: The process of manipulating data. @en-us
subclass of: Thing

SimilarityMatching
type: Class
comment: The process of matching two objects by a similarity measure. @en-us
subclass of: AutomatedMatching

Loading
type: Class
comment: Stage that is responsible for loading data into the end target. @en-us

MappingFile
type: Class
comment: The specification of a mapping between source and target fields (e.g. RDB2RDF).

Trigger
type: Class
comment: A procedural code that is automatically executed in response to certain events on a particular table or view in a database. @en-us

KeyRestructuring
type: Class
comment: Transformation of keys with built-in meanings into generic keys. @en-us
subclass of: RowOperation

DeleteQuery
type: Class
comment: Query that does a delete operation on a row, column, table for example. @en-us
subclass of: Query

Formula
type: Class
comment: A rule or principle. @en-us

DERI, NUI Galway
type: Agent
member: André Freitas

COGS Vocabulary
type: SemanticAsset
type: Ontology
creator: Benedikt Kämpgen
creator: André Freitas
creator: Timothy Lebo
created: 2014-03-10
description: COGS: Vocabulary for describing ETL and data transformation activities.
modified: 2014-03-10
part of: vocab.deri.ie
publisher: DERI, NUI Galway
status: UnderDevelopment
preferred namespace prefix: cogs
preferred namespace uri: http://vocab.deri.ie/cogs#

StagingAreaArtifact
type: Class
comment: The final product; what the end users see. @en-us

Running
type: Class
comment: Status of a job that is in the state of being operated. @en-us
subclass of: ExecutionStatus

RDFGraph
type: Class
comment: A set of RDF triples. @en-us

AutomatedMatching
type: Class
comment: Task of finding entries that refer to the same entity across different data sources using computer resources. @en-us
subclass of: MappingProcess

Exception
type: Class
comment: An event, which occurs during the execution of a program, which disrupts the normal flow of the program's instructions. @en-us

Row
type: Class
comment: A serie of objects placed in line. @en-us

ExecutionStatus
type: Class
comment: Provides the current execution status of a running process instance (a job). e.g. : fail, running, success. @en-us

StringSimilarity
type: Class
comment: Matching based on string similarity measures. @en-us
subclass of: SimilarityMatching

Assignment
type: Class
comment: Sets or re-sets the value stored in the storage location(s) denoted by a variable name. @en-us
subclass of: ValueOperation

ManualAdHocProcess
type: Class
comment: A non-recurrent, not-frequent manual process.
subclass of: AdHocProcess

PerformanceIndicator
type: Class
comment: Measures used to evaluate the success of a particular activity.

ValueOperation
type: Class
comment: Evaluate a selected function for a particular value of x. @en-us
subclass of: Operation

Rule
type: Class
comment: A principle or formula. @en-us

UpdateQuery
type: Class
comment: Query that changes the data of one or more records in a table. @en-us
subclass of: Query

ColumnOperation
type: Class
comment: Instructions applied on one or more columns. @en-us
subclass of: Operation

Output
type: Class
comment: Information, resulting from computer processing, that is delivered to a user. @en-us

JoinRows
type: Class
comment: Row Operation that allows combinations (Cartesian product) of all rows in the input streams.@en-us
subclass of: RowOperation

IncrementalLoad
type: Class
comment: Applies ongoing changes to one or more tables based on a predefined schedule. @en-us
subclass of: Loading

ScheduledJob
type: Class
comment: Job that owns information on when and how often it has to execute operations. @en-us
subclass of: Job

Program
type: Class
comment: A sequence of instructions written to perform a specified task for a computer. @en-us

precededBy
type: Property
comment: Defines the ordering among two processes
sub property of: topObjectProperty

Sensor
type: Class
comment: Device that measures or detects a real-world condition and converts the condition into an analog or digital representation. @en-us

InsertRow
type: Class
comment: Inclusion of a row on a table. @en-us
subclass of: RowOperation

Layer
type: Class
comment: Each individual level. @en-us

AutomatedAdHocProcess
type: Class
comment: A non-recurrent, not frequent automated process.
subclass of: AdHocProcess

FillDown
type: Class
comment: Copy the contents of the topmost cells of a selected range into the cells below.@en-us
subclass of: ColumnOperation

Lowercase
type: Class
comment: String operation for converting a string to lowercase.@en-us
subclass of: StringOperation

NumericCast
type: Class
comment: Converts an expression of one numeric data type to another. @en-us
subclass of: NumericOperation

DimensionTable
type: Class
comment: One of the set of companion tables to a fact table. @en-us
subclass of: Table

Lookup
type: Class
comment: A process used to look up data in a relational table, view or dictionary. @en-us
subclass of: Transformation

RDFDataPropertyMapping
type: Class
comment: Maps data properties from source to target.
subclass of: TerminologicalMapping

RegexFilter
type: Class
comment: Filter written in a formal language that can be interpreted by a regular expression processor. @en-us
subclass of: Filter

Split
type: Class
comment: String operation that returns a zero-based, one-dimensional array containing a specified number of substrings. @en-us
subclass of: StringOperation

RESTLookup
type: Class
comment: Lookup on a REST service. @en-us
subclass of: Lookup

Script
type: Class
comment: A program or sequence of instructions that is interpreted or carried out by another program rather than by the computer processor. @en-us

Order
type: Class
comment: Application of a specific order to a set of elemetns. @en-us
subclass of: Operation

StoredProcedure
type: Class
comment: A transformation used to create unique primary key values or cycle through a sequential range of numbers to replace missing keys. @en-us

Metadata
type: Class
comment: Data that describe data and other structures, such as objects, business rules and processes. @en-us

DataStream
type: Class
comment: A sequence of digitally encoded coherent signals (packets of data) used to transmit or receive information that is in the process of being transmitted. @en-us

ApplyFormula
type: Class
comment: New data are computed based on the user-defined formula. @en-us
subclass of: NumericOperation

DataMart
type: Class
comment: Data mart is a process-oriented subset of the overall organization’s data based on a foundation of atomic data, and that depends only on the structure of the data-measurement events, not on the anticipated user’s questions.

Execution
type: Class
comment: The instantiation of an activity or workflow. @en-us

DestructiveMerge
type: Class
comment: Inputs the incoming data to the target data if the primary key of an incoming record matches with the key of an existing record, updating the matching target record. If the incoming record is a new record without a match with any existing record, it adds the incoming record to the target table. @en-us
subclass of: Loading

Move
type: Class
comment: To change in position from one point to another. @en-us
subclass of: Operation

FileLookup
type: Class
comment: The process of looking up for information on a file. @en-us
subclass of: Lookup

Paste
type: Class
comment: To copy an object from a buffer or clipboard to a file. @en-us
subclass of: Operation

ObjectReference
type: Class
comment: Value that enables a program to indirectly access a particular object. @en-us

Mapping
type: Class
comment: The definition of a semantic equivalence relationship between source and target objects. @en-us
subclass of: Transformation

André Freitas
type: Person

RowOperation
type: Class
comment: Instructions executed on rows of a table or file. @en-us
subclass of: Operation

SemanticSimilarity
type: Class
comment: Matching by a measure of semantic similarity. @en-us
subclass of: SimilarityMatching

Service
type: Class
comment: Action done by a device or user with the function of giving good by providing usefulness. @en-us

Benedikt Kämpgen
type: Person

ManuallyStartedJob
type: Class
comment: Job that was initialized by an user. @en-us
subclass of: Job

Method
type: Class
comment: A subroutine that is exclusively associated with a object. @en-us

MergeRow
type: Class
comment: Row Operation that allows the comparison of two streams of rows. It is often used in situations where the source system of a data warehouse does not contain a date of last update. @en-us
subclass of: RowOperation

DataManagementLayer
type: Class
comment: Layer responsible for the development, execution and supervision of plans, policies, programs and practices that control, protect, deliver and enhance the value of data and information assets. @en-us
subclass of: Layer

PresentationArea
type: Class
comment: What the user sees. @en-us
subclass of: DataAccessLayer

UnitConversion
type: Class
comment: Conversion on different units of measurement. @en-us
subclass of: ValueOperation

WebServiceLookup
type: Class
comment: Allows the retrieving of data from a web service and uses this during the form filling process. @en-us
subclass of: Lookup

RulesBasedMatching
type: Class
comment: Matching of data based on a rule or group of rules. @en-us
subclass of: AutomatedMatching

Endpoint
type: Class
comment: Database access point as a web service (SPARQL Endpoint) . @en-us

AdHocProcess
type: Class
comment: Process that seeks a solution designed for a specific problem or task, non-generalizable, and not intended to be able to be adapted to other purposes. @en-us
subclass of: Execution

hasStartPoint
type: Property
comment: First process in a transformation workflow.
domain: Transformation
range: Transformation

InsertQuery
type: Class
comment: Query that inserts data into the database. @en-us
subclass of: Query

Operator
type: Class
comment: A symbol or function representing a mathematical operation. @en-us

Publication
type: Class
comment: The process of publishing the output of an ETL process. @en-us

InitialLoad
type: Class
comment: Populates the tables in the data warehouse schema and verifies if the data is ready for use. @en-us
subclass of: Loading

File
type: Class
comment: A block of arbitrary information, or resource for storing information, which is available to a computer program. @en-us

Schema
type: Class
comment: The structure of a database system described in a formal language supported by the database management system. Describes tables, for example. @en-us

Copy
type: Class
comment: A piece of data that was duplicated. @en-us
subclass of: Operation

DSN
type: Class
comment: Data Source Name (DSN) is a data structure that contains the information about a specific database. @en-us

ValueCalculation
type: Class
comment: A calculation performed on a specified input value.
subclass of: ValueOperation

CharacterSetConversion
type: Class
comment: Converts strings between different character sets. @en-us
subclass of: ValueOperation

Timothy Lebo
type: Person

Database
type: Class
comment: A database is a collection of information organized into interrelated tables of data and specifications of data objects. @en-us

Class
comment: A construct that is used as a blueprint to create instances of the class. @en-us

NumericOperation
type: Class
comment: Manipulate and manage numeric data. @en-us
subclass of: ValueOperation

DeleteColumn
type: Class
comment: Deletes one or more columns according to a certain criteria to a table. @en-us
subclass of: ColumnOperation

HumanMatching
type: Class
comment: Matching based on a human decision.
subclass of: MappingProcess

Round
type: Class
comment: Round a numeric value to a close number by following a specific rounding criteria. @en-us
subclass of: NumericOperation

Query
type: Class
comment: A structured object which is used to request information or perform an action in a database. @en-us

hasEndPoint
type: Property
comment: Last process in a transformation workflow.
domain: Transformation
range: Transformation

Input
type: Class
comment: Any data entered into a computer.@en-us

Source
type: Class
comment: A database, application, file or other storage facility from which the data is derived. @en-us
subclass of: DataManagementLayer

Fail
type: Class
comment: Status of a job that stops operating or functioning. @en-us
subclass of: ExecutionStatus

RDFObjectPropertyMapping
type: Class
comment: Maps object properties from source to target.
subclass of: TerminologicalMapping

PredefinedMatching
type: Class
comment: Forces a matching under a certain predefined criteria. @en-us
subclass of: MappingProcess

ConstructiveMerge
type: Class
comment: If the primary key of an incoming record matches with the key of an existing Record, leaves the existing Record, adds the incoming record and marks the added record as superseding the old record. @en-us
subclass of: Loading

Deduplication
type: Class
comment: Elimination of redundant data. @en-us
subclass of: RowOperation

ObjectRepresentation
type: Class
comment: Internal representation of an object suitable for matching its features. @en-us

Append
type: Class
comment: String operation for concatenating lists or arrays. @en-us
subclass of: StringOperation

View
type: Class
comment: Consists of a stored query accessible as a virtual table composed of the result set of a query. @en-us

TransformationProcess
type: Class
comment: Process that applies a series of rules or functions to the extracted data from the source to derive the data for loading into the end target. @en-us
subclass of: Transformation

Table
type: Class
comment: A predefined format of rows and columns that define a database entity. @en-us

Replace
type: Class
comment: String operation for updating the content of a string. @en-us
subclass of: StringOperation

associatedEndpoint
type: Property
range: Endpoint

RDFInstanceMapping
type: Class
comment: Maps an instance-level element from a source to an instance-level element in a target dataset.
subclass of: Mapping

SplitColumn
type: Class
comment: Divides a column in one or more other columns. @en-us
subclass of: ColumnOperation

FullRefresh
type: Class
comment: Truncates all the tables and data gets loaded again. @en-us
subclass of: Loading

StaggingArea
type: Class
comment: A place where data can be processed before entering the warehouse area. @en-us
subclass of: DataManagementLayer

Query
type: Class
comment: Query over a structured or semi-structured data source.
subclass of: Operation

LastError
type: Class
comment: Final error on a execution workflow. @en-us

SortRow
type: Class
comment: Row Operation that sorts rows based on a specified fields and on whether they should be sorted in ascending or descending order. @en-us
subclass of: RowOperation

FactTable
type: Class
comment: A table that consists of the measurements, metrics or facts of a process. @en-us
subclass of: Table

associatedGraph
type: Property
range: RDFNamedGraph