Preferred Name

database extract, transform, and load process

Definitions

A planned process which takes as input a database and fills another database by extracting concretizations of information entities from the first, transforming them, and loading the transformed concretizations into the second.

ID

http://purl.obolibrary.org/obo/IAO_0000650

alternative term

ETL

definition

A planned process which takes as input a database and fills another database by extracting concretizations of information entities from the first, transforming them, and loading the transformed concretizations into the second.

definition source

WEB:https://en.wikipedia.org/wiki/Extract,_transform,_load

editor note

Alan Ruttenberg 12/21/16: Maybe this definition instead: A planned process which takes as input a database and copies concretizations from the first, optionally transforms then copies the result to the second

Alan Ruttenberg 12/21/16: We don't define database in IAO, currently, as the bare word is ambiguous. Reasonable interpretations of the word might be the material entity, an information structure, an information content entity. However this definition commits, at least, to there being some material thing which bear concretizations of information entities and that there are new concretizations created during the process. We consider the ETL process in terms of information entities rather than the concretizations. No committment is made as to whether the specified output.

editor preferred label

database extract, transform, and load process

has_specified_input

http://purl.obolibrary.org/obo/IAO_0000030

has_specified_output

http://purl.obolibrary.org/obo/IAO_0000030

isDefinedBy

https://github.com/information-artifact-ontology/IAO

label

database extract, transform, and load process

page

https://en.wikipedia.org/wiki/Extract,_transform,_load

prefixIRI

IAO:0000650

prefLabel

database extract, transform, and load process

term editor

PERSON:Alan Ruttenberg

term tracker item

https://github.com/information-artifact-ontology/IAO/issues/187

subClassOf

http://purl.obolibrary.org/obo/OBI_0000011

Delete Subject Author Type Created
No notes to display
Create New Mapping

Delete Mapping To Ontology Source
http://purl.obolibrary.org/obo/IAO_0000650 Information Artifact Ontology / 信息工具本体 LOOM
http://purl.obolibrary.org/obo/IAO_0000650 Information Artifact Ontology / 信息工具本体 SAME_URI
http://purl.obolibrary.org/obo/IAO_0000650 Informed Consent Ontology / 知情同意本体 LOOM
http://purl.obolibrary.org/obo/IAO_0000650 Informed Consent Ontology / 知情同意本体 SAME_URI