Returns the smallest integer greater than or equal to n. @en-us
Process of generating keys/indexes for tables. @en-us
Database tables are composed of individual columns corresponding to the attributes of the object. @en-us
Software program, or the computer on which that program runs, that provides a specific kind of service to a client software. @en-us
Includes one or more triple into the store. @en-us
Validation performed by a person: an user or admin. @en-us
The first part of an ETL process which involves extracting the data from source systems. @en-us
A multidimensional database that holds data. @en-us
Functional operations that can be done by a computer.
Performs decoding operations when you specify field-encoding function. @en-us
Conversion from a datetime format to a different one.
Maps terminological-level (schema-level) entities. @en-us
Operations for manipulating strings. @en-us
An operation that can be used to retain rows in a mapping that do not meet specific conditions. @en-us
This property allows the association between an abstract representation of a Transformation and an encapsulated computational artifact artifact (e.g. code, binary).
Data that contain database violations and are forbidden to get inserted into a table. @en-us
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
Validation performed by a computer. @en-us
Process of analyzing text or data, checking for correct syntax and building a representation based on the input tokens. @en-us
Provides means for matching strings of text, such as particular characters, words, or patterns of characters. @en-us
Instructions performed on graphs. @en-us
Deletes on or more triples into the store.@en-us
Status of a job that had successful performance. @en-us
Exclusion of a single or group of rows by a certain criteria on a table. @en-us
The process of mapping information from a source format to a destination format. @en-us
Functions which return a single result row based on groups of rows. @en-us
Query that locates and displays information requested. @en-us
A machine designed for a purpose. E.g.: Unit of hardware. @en-us
Process of using a known attribute to search for data on a table. @en-us
The instance of a process or group of processes (workflow).
Layer that controls access to data in a computer-based information system. @en-us
Inserts one or more columns according to a certain criteria to a table. @en-us
Changes the name of a certain column. @en-us
The act of validating; finding or testing the truth of something. @en-us
Multiple RDF graphs in a single document/repository and naming them with URIs. @en-us
Preliminary filtering during the extraction phase.
String operation for removing leading and trailing whitespace from a string. @en-us
String operation for converting a string to uppercase. @en-us
The process of manipulating data. @en-us
The process of matching two objects by a similarity measure. @en-us
Stage that is responsible for loading data into the end target. @en-us
The specification of a mapping between source and target fields (e.g. RDB2RDF).
A procedural code that is automatically executed in response to certain events on a particular table or view in a database. @en-us
Transformation of keys with built-in meanings into generic keys. @en-us
Query that does a delete operation on a row, column, table for example. @en-us
COGS: Vocabulary for describing ETL and data transformation activities.
The final product; what the end users see. @en-us
Status of a job that is in the state of being operated. @en-us
Task of finding entries that refer to the same entity across different data sources using computer resources. @en-us
An event, which occurs during the execution of a program, which disrupts the normal flow of the program's instructions. @en-us
A serie of objects placed in line. @en-us
Provides the current execution status of a running process instance (a job). e.g. : fail, running, success. @en-us
Matching based on string similarity measures. @en-us
Sets or re-sets the value stored in the storage location(s) denoted by a variable name. @en-us
A non-recurrent, not-frequent manual process.
Measures used to evaluate the success of a particular activity.
Evaluate a selected function for a particular value of x. @en-us
Query that changes the data of one or more records in a table. @en-us
Instructions applied on one or more columns. @en-us
Information, resulting from computer processing, that is delivered to a user. @en-us
Row Operation that allows combinations (Cartesian product) of all rows in the input streams.@en-us
Applies ongoing changes to one or more tables based on a predefined schedule. @en-us
Job that owns information on when and how often it has to execute operations. @en-us
A sequence of instructions written to perform a specified task for a computer. @en-us
Defines the ordering among two processes
Device that measures or detects a real-world condition and converts the condition into an analog or digital representation. @en-us
A non-recurrent, not frequent automated process.
Copy the contents of the topmost cells of a selected range into the cells below.@en-us
String operation for converting a string to lowercase.@en-us
Converts an expression of one numeric data type to another. @en-us
One of the set of companion tables to a fact table. @en-us
A process used to look up data in a relational table, view or dictionary. @en-us
Maps data properties from source to target.
Filter written in a formal language that can be interpreted by a regular expression processor. @en-us
String operation that returns a zero-based, one-dimensional array containing a specified number of substrings. @en-us
A program or sequence of instructions that is interpreted or carried out by another program rather than by the computer processor. @en-us
Application of a specific order to a set of elemetns. @en-us
A transformation used to create unique primary key values or cycle through a sequential range of numbers to replace missing keys. @en-us
Data that describe data and other structures, such as objects, business rules and processes. @en-us
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
New data are computed based on the user-defined formula. @en-us
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.
The instantiation of an activity or workflow. @en-us
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
To change in position from one point to another. @en-us
The process of looking up for information on a file. @en-us
To copy an object from a buffer or clipboard to a file. @en-us
Value that enables a program to indirectly access a particular object. @en-us
The definition of a semantic equivalence relationship between source and target objects. @en-us
Instructions executed on rows of a table or file. @en-us
Matching by a measure of semantic similarity. @en-us
Action done by a device or user with the function of giving good by providing usefulness. @en-us
Job that was initialized by an user. @en-us
A subroutine that is exclusively associated with a object. @en-us
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
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
Conversion on different units of measurement. @en-us
Allows the retrieving of data from a web service and uses this during the form filling process. @en-us
Matching of data based on a rule or group of rules. @en-us
Database access point as a web service (SPARQL Endpoint) . @en-us
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
First process in a transformation workflow.
Query that inserts data into the database. @en-us
A symbol or function representing a mathematical operation. @en-us
The process of publishing the output of an ETL process. @en-us
Populates the tables in the data warehouse schema and verifies if the data is ready for use. @en-us
A block of arbitrary information, or resource for storing information, which is available to a computer program. @en-us
The structure of a database system described in a formal language supported by the database management system. Describes tables, for example. @en-us
A piece of data that was duplicated. @en-us
Data Source Name (DSN) is a data structure that contains the information about a specific database. @en-us
A calculation performed on a specified input value.
Converts strings between different character sets. @en-us
A database is a collection of information organized into interrelated tables of data and specifications of data objects. @en-us
A construct that is used as a blueprint to create instances of the class. @en-us
Manipulate and manage numeric data. @en-us
Deletes one or more columns according to a certain criteria to a table. @en-us
Round a numeric value to a close number by following a specific rounding criteria. @en-us
A structured object which is used to request information or perform an action in a database. @en-us
Last process in a transformation workflow.
A database, application, file or other storage facility from which the data is derived. @en-us
Status of a job that stops operating or functioning. @en-us
Maps object properties from source to target.
Forces a matching under a certain predefined criteria. @en-us
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
Internal representation of an object suitable for matching its features. @en-us
String operation for concatenating lists or arrays. @en-us
Consists of a stored query accessible as a virtual table composed of the result set of a query. @en-us
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
A predefined format of rows and columns that define a database entity. @en-us
String operation for updating the content of a string. @en-us
Maps an instance-level element from a source to an instance-level element in a target dataset.
Divides a column in one or more other columns. @en-us
Truncates all the tables and data gets loaded again. @en-us
A place where data can be processed before entering the warehouse area. @en-us
Query over a structured or semi-structured data source.
Final error on a execution workflow. @en-us
Row Operation that sorts rows based on a specified fields and on whether they should be sorted in ascending or descending order. @en-us
A table that consists of the measurements, metrics or facts of a process. @en-us