{"schema_version":"4ort.packet/1","entity":{"entity_id":"extract-transform-load","kg_uuid":"903cf864-5992-4c25-9592-7f6c18fafcdc","wikidata_id":"Q1276130","name":"extract, transform, load","description":"procedure for copying data from one or more sources, then transforming the data at the source system, and lastly copying into a destination system which represents the data differently from the source(s)","type":"Thing","url":"https://4ort.xyz/entity/extract-transform-load"},"status":"complete","as_of":{"copy_written_at":"2026-11-17T18:02:39Z","last_source_edit_seen":"2026-11-11T10:21:55Z","stale_possible":false,"claims_refreshed_at":"2026-11-11T10:22:02Z","source_revision":2567914024},"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/Q1276130#P31","source_edition":"2026-11-11T10:22:02Z","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":"P31","label":"instance of","value":"field of study","value_id":"Q1047113","value_raw":"Q1047113","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q1276130#P31","source_edition":"2026-11-11T10:22:02Z","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":"P31","label":"instance of","value":"field of study","value_id":"Q2267705","value_raw":"Q2267705","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q1276130#P31","source_edition":"2026-11-11T10:22:02Z","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/Q1276130#P279","source_edition":"2026-11-11T10:22:02Z","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":"P361","label":"part of","value":"data warehouse","value_id":"Q193351","value_raw":"Q193351","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q1276130#P361","source_edition":"2026-11-11T10:22:02Z","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/Q1276130#P366","source_edition":"2026-11-11T10:22:02Z","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/Q1276130#P527","source_edition":"2026-11-11T10:22:02Z","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/Q1276130#P527","source_edition":"2026-11-11T10:22:02Z","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/Q1276130#P527","source_edition":"2026-11-11T10:22:02Z","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":"P1482","label":"Stack Exchange tag","value":"https://stackoverflow.com/tags/etl","value_id":null,"value_raw":"https://stackoverflow.com/tags/etl","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q1276130#P1482","source_edition":"2026-11-11T10:22:02Z","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, load, transform","value_id":"Q19818626","value_raw":"Q19818626","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q1276130#P1889","source_edition":"2026-11-11T10:22:02Z","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":"P2179","label":"ACM Classification Code (2012)","value":"10003215","value_id":null,"value_raw":"10003215","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q1276130#P2179","source_edition":"2026-11-11T10:22:02Z","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":"P3095","label":"practiced by","value":"data engineer","value_id":"Q104659813","value_raw":"Q104659813","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q1276130#P3095","source_edition":"2026-11-11T10:22:02Z","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":"P3553","label":"Zhihu topic ID","value":"19598046","value_id":null,"value_raw":"19598046","rank":"normal","current":null,"qualifiers":[{"field":"P1810","label":"subject named as","value":"ETL"}],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q1276130#P3553","source_edition":"2026-11-11T10:22:02Z","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":"P5555","label":"schematic","value":"Conventional ETL Diagram.jpg","value_id":null,"value_raw":"Conventional ETL Diagram.jpg","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q1276130#P5555","source_edition":"2026-11-11T10:22:02Z","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":"P6366","label":"Microsoft Academic ID (discontinued)","value":"2777362200","value_id":null,"value_raw":"2777362200","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q1276130#P6366","source_edition":"2026-11-11T10:22:02Z","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":"P10565","label":"Encyclopedia of China (Third Edition) old ID (2021)","value":"220245","value_id":null,"value_raw":"220245","rank":"normal","current":null,"qualifiers":[{"field":"P1810","label":"subject named as","value":"抽取、转换与装载"}],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q1276130#P10565","source_edition":"2026-11-11T10:22:02Z","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":"P10565","label":"Encyclopedia of China (Third Edition) old ID (2021)","value":"548075","value_id":null,"value_raw":"548075","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q1276130#P10565","source_edition":"2026-11-11T10:22:02Z","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":"P14541","label":"Encyclopedia of China (Third Edition) ID (2026)","value":"3ScOgZ","value_id":null,"value_raw":"3ScOgZ","rank":"normal","current":null,"qualifiers":[{"field":"P1810","label":"subject named as","value":"抽取、转换与装载"},{"field":"P5017","label":"last update","value":"2024-12-04"}],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q1276130#P14541","source_edition":"2026-11-11T10:22:02Z","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":"P14541","label":"Encyclopedia of China (Third Edition) ID (2026)","value":"nrPO","value_id":null,"value_raw":"nrPO","rank":"normal","current":null,"qualifiers":[{"field":"P1810","label":"subject named as","value":"ETL"},{"field":"P5017","label":"last update","value":"2023-01-10"}],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q1276130#P14541","source_edition":"2026-11-11T10:22:02Z","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","P361","P366","P527","P1482","P1889","P2179","P3095","P3553","P5555","P6366","P10565","P14541"]}],"routes":{"entity_page":"https://4ort.xyz/entity/extract-transform-load","packet_api":"https://4ort.xyz/api/v1/entities/extract-transform-load/packet","facts_jsonld":"https://4ort.xyz/entity/extract-transform-load/facts.json","changes_api":"https://4ort.xyz/api/v1/knowledge/get_entity_changes?entity=extract-transform-load","attention_api":"https://4ort.xyz/api/v1/knowledge/get_attention?entity=extract-transform-load","wikidata":"https://www.wikidata.org/wiki/Q1276130","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":[]}