{"id":"https://openalex.org/W1750113778","doi":"https://doi.org/10.1007/978-1-4899-7993-3_158-3","title":"Extraction, Transformation, and Loading","display_name":"Extraction, Transformation, and Loading","publication_year":2017,"publication_date":"2017-01-01","ids":{"openalex":"https://openalex.org/W1750113778","doi":"https://doi.org/10.1007/978-1-4899-7993-3_158-3","mag":"1750113778"},"language":"en","primary_location":{"id":"doi:10.1007/978-1-4899-7993-3_158-3","doi":"https://doi.org/10.1007/978-1-4899-7993-3_158-3","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4899-7993-3_158-3","pdf_url":null,"source":{"id":"https://openalex.org/S4306509343","display_name":"Encyclopedia of Database Systems","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Encyclopedia of Database Systems","raw_type":"book-chapter"},"volume":{"id":"https://openalex.org/W2518732252","display_name":"Encyclopedia of Database Systems"},"type":"reference-entry","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5072082268","display_name":"Alkis Simitsis","orcid":"https://orcid.org/0009-0006-6078-5323","observed_orcids":["https://orcid.org/0009-0006-6078-5323"]},"institutions":[{"id":"https://openalex.org/I1324840837","display_name":"Hewlett-Packard (United States)","ror":"https://ror.org/059rn9488","country_code":"US","type":"company","lineage":["https://openalex.org/I1324840837"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Alkis Simitsis","raw_affiliation_strings":["HP Labs, Palo Alto, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"HP Labs, Palo Alto, CA, USA","institution_ids":["https://openalex.org/I1324840837"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5042575189","display_name":"Panos Vassiliadis","orcid":"https://orcid.org/0000-0003-0085-6776","observed_orcids":["https://orcid.org/0000-0003-0085-6776"]},"institutions":[{"id":"https://openalex.org/I194019607","display_name":"University of Ioannina","ror":"https://ror.org/01qg3j183","country_code":"GR","type":"education","lineage":["https://openalex.org/I194019607"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Panos Vassiliadis","raw_affiliation_strings":["University of Ioannina, Ioannina, Greece"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Ioannina, Ioannina, Greece","institution_ids":["https://openalex.org/I194019607"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5072082268"],"corresponding_institution_ids":["https://openalex.org/I1324840837"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":16,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"9"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.951200008392334,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.951200008392334,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.0210999995470047,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.01489999983459711,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/etl","display_name":"ETL","score":0.8629999756813049},{"id":"https://openalex.org/keywords/english-language-teaching","display_name":"English language teaching","score":0.9879999756813049},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"data warehouse","score":0.9079999923706055},{"id":"https://openalex.org/keywords/etl-tools","display_name":"ETL tools","score":0.8140000104904175},{"id":"https://openalex.org/keywords/data-integration","display_name":"data integration","score":0.8690000176429749}],"concepts":[{"id":"https://openalex.org/C4725764","wikidata":"https://www.wikidata.org/wiki/Q844704","display_name":"Extraction (chemistry)","level":2,"score":0.6930657625198364},{"id":"https://openalex.org/C204241405","wikidata":"https://www.wikidata.org/wiki/Q461499","display_name":"Transformation (genetics)","level":3,"score":0.6770875453948975},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.3678227663040161},{"id":"https://openalex.org/C43617362","wikidata":"https://www.wikidata.org/wiki/Q170050","display_name":"Chromatography","level":1,"score":0.18657812476158142},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.09073033928871155},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-1-4899-7993-3_158-3","doi":"https://doi.org/10.1007/978-1-4899-7993-3_158-3","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4899-7993-3_158-3","pdf_url":null,"source":{"id":"https://openalex.org/S4306509343","display_name":"Encyclopedia of Database Systems","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Encyclopedia of Database Systems","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W155672256","https://openalex.org/W1482268585","https://openalex.org/W1572120187","https://openalex.org/W1590198000","https://openalex.org/W1604131870","https://openalex.org/W1966294080","https://openalex.org/W1967093902","https://openalex.org/W1971518725","https://openalex.org/W1992673035","https://openalex.org/W2008896880","https://openalex.org/W2037460328","https://openalex.org/W2063753658","https://openalex.org/W2078783226","https://openalex.org/W2096347930","https://openalex.org/W2102729946","https://openalex.org/W2106039833","https://openalex.org/W2108971776","https://openalex.org/W2122822096","https://openalex.org/W2128731098","https://openalex.org/W2149877754","https://openalex.org/W2158643472","https://openalex.org/W2159686758","https://openalex.org/W2163857507","https://openalex.org/W2166006219","https://openalex.org/W2170634549","https://openalex.org/W4372267129"],"related_works":["https://openalex.org/W7100437784","https://openalex.org/W4244468490","https://openalex.org/W2405186200","https://openalex.org/W7100886649","https://openalex.org/W144747761","https://openalex.org/W7096592962","https://openalex.org/W1525786584","https://openalex.org/W2363759074","https://openalex.org/W2387662534","https://openalex.org/W1997153461"],"abstract_inverted_index":null,"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":4}],"updated_date":"2026-10-10T09:11:00.788812","created_date":"2016-06-24T00:00:00"}