{"schema_version":"4ort.packet/1","entity":{"entity_id":"extract-load-transform","kg_uuid":"db9d4ccb-cffc-4e84-a32f-b652ff039e16","wikidata_id":"Q19818626","name":"extract, load, transform","description":"procedure which retrieves large amounts of data from external sources, then load them into one or more local target systems, and lastly transform them on the target system","type":"Thing","url":"https://4ort.xyz/entity/extract-load-transform"},"status":"complete","as_of":{"copy_written_at":"2026-11-14T14:24:52Z","last_source_edit_seen":"2026-08-23T22:36:58Z","stale_possible":false,"claims_refreshed_at":"2026-10-25T23:00:09Z","source_revision":2554966942},"facts":[{"field":"P31","label":"instance of","value":"type of process","value_id":"Q116505632","value_raw":"Q116505632","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q19818626#P31","source_edition":"2026-10-25T23:00:09Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P279","label":"subclass of","value":"data processing","value_id":"Q6661985","value_raw":"Q6661985","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q19818626#P279","source_edition":"2026-10-25T23:00:09Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P366","label":"has use","value":"data integration","value_id":"Q386824","value_raw":"Q386824","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q19818626#P366","source_edition":"2026-10-25T23:00:09Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P527","label":"has part(s)","value":"data extraction","value_id":"Q5227287","value_raw":"Q5227287","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q19818626#P527","source_edition":"2026-10-25T23:00:09Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P527","label":"has part(s)","value":"data transformation","value_id":"Q4272815","value_raw":"Q4272815","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q19818626#P527","source_edition":"2026-10-25T23:00:09Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P527","label":"has part(s)","value":"data loading","value_id":"Q124476957","value_raw":"Q124476957","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q19818626#P527","source_edition":"2026-10-25T23:00:09Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P1889","label":"different from","value":"extract, transform, load","value_id":"Q1276130","value_raw":"Q1276130","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q19818626#P1889","source_edition":"2026-10-25T23:00:09Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}}],"unknowns":[],"omitted":{"facts":0,"reason":null},"licences":[{"source":"wikidata","source_name":"Wikidata","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"fields":["P31","P279","P366","P527","P1889"]}],"routes":{"entity_page":"https://4ort.xyz/entity/extract-load-transform","packet_api":"https://4ort.xyz/api/v1/entities/extract-load-transform/packet","facts_jsonld":"https://4ort.xyz/entity/extract-load-transform/facts.json","changes_api":"https://4ort.xyz/api/v1/knowledge/get_entity_changes?entity=extract-load-transform","attention_api":"https://4ort.xyz/api/v1/knowledge/get_attention?entity=extract-load-transform","wikidata":"https://www.wikidata.org/wiki/Q19818626","official_website":null},"trust_rules":{"wikidata-reference-support/2":"From the references in our copy of the statement: high = it cites a source (stated in P248, or a reference URL that is not Wikipedia); medium = only 'imported from Wikimedia project' or a Wikipedia URL; unscored = our copy holds no reference (older copies dropped references, so this is not evidence that Wikidata has none). Wikidata may hold more references than our copy shows. Reference support, not a probability."},"notes":[]}