{"id":"https://openalex.org/W2734474333","doi":"https://doi.org/10.23919/mipro.2017.7973632","title":"ETLator - a scripting ETL framework","display_name":"ETLator - a scripting ETL framework","publication_year":2017,"publication_date":"2017-05-01","ids":{"openalex":"https://openalex.org/W2734474333","doi":"https://doi.org/10.23919/mipro.2017.7973632","mag":"2734474333"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.23919/mipro.2017.7973632","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"proceedings-article","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/A5020278690","display_name":"Miran Radoni\u0107","orcid":null},"institutions":[{"id":"https://openalex.org/I181343428","display_name":"University of Zagreb","ror":"https://ror.org/00mv6sv71","country_code":"HR","type":"funder","lineage":["https://openalex.org/I181343428"]}],"countries":["HR"],"is_corresponding":false,"raw_author_name":"Miran Radonic","raw_affiliation_strings":["Faculty of Electrical Engineering and Computing, University of Zagreb, Zagreb, Croatia"],"affiliations":[{"raw_affiliation_string":"Faculty of Electrical Engineering and Computing, University of Zagreb, Zagreb, Croatia","institution_ids":["https://openalex.org/I181343428"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5067736091","display_name":"Igor Mekterovi\u0107","orcid":"https://orcid.org/0000-0002-9813-1935"},"institutions":[{"id":"https://openalex.org/I181343428","display_name":"University of Zagreb","ror":"https://ror.org/00mv6sv71","country_code":"HR","type":"funder","lineage":["https://openalex.org/I181343428"]}],"countries":["HR"],"is_corresponding":false,"raw_author_name":"Igor Mekterovic","raw_affiliation_strings":["Faculty of Electrical Engineering and Computing, University of Zagreb, Zagreb, Croatia"],"affiliations":[{"raw_affiliation_string":"Faculty of Electrical Engineering and Computing, University of Zagreb, Zagreb, Croatia","institution_ids":["https://openalex.org/I181343428"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.698,"has_fulltext":true,"fulltext_origin":"ngrams","cited_by_count":6,"citation_normalized_percentile":{"value":0.751727,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":81,"max":82},"biblio":{"volume":null,"issue":null,"first_page":"1349","last_page":"1354"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9984,"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"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9984,"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.9982,"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"}},{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9927,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/python","display_name":"Python","score":0.8145956}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.84595084},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.8145956},{"id":"https://openalex.org/C61423126","wikidata":"https://www.wikidata.org/wiki/Q187432","display_name":"Scripting language","level":2,"score":0.754778},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.60562},{"id":"https://openalex.org/C56666940","wikidata":"https://www.wikidata.org/wiki/Q788790","display_name":"Documentation","level":2,"score":0.52352095},{"id":"https://openalex.org/C544833334","wikidata":"https://www.wikidata.org/wiki/Q2005","display_name":"JavaScript","level":2,"score":0.46465033},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.44828075},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.43880376},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.39629084},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3747279}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.23919/mipro.2017.7973632","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":7,"referenced_works":["https://openalex.org/W2078783226","https://openalex.org/W2083755493","https://openalex.org/W2108971776","https://openalex.org/W2233932428","https://openalex.org/W2604649857","https://openalex.org/W332208005","https://openalex.org/W767111626"],"related_works":["https://openalex.org/W4389470870","https://openalex.org/W4300438041","https://openalex.org/W3023169329","https://openalex.org/W2782165897","https://openalex.org/W2761254753","https://openalex.org/W2188981919","https://openalex.org/W2139703748","https://openalex.org/W2054104202","https://openalex.org/W1582950852","https://openalex.org/W1024825291"],"abstract_inverted_index":{"ETL":[0,21,53,56,82,122,131,143,155,176,192],"(Extract":[1],"Transform":[2],"Load)":[3],"process":[4,22,28],"is":[5,23,84,87],"the":[6,17,24,41,44,48,147,196],"industry":[7],"standard":[8],"term":[9],"for":[10,40,103],"data":[11,180],"extraction,":[12],"transformation":[13,72],"and":[14,32,38,50,65,94,145,151,160,173,194],"loading":[15],"into":[16],"Data":[18],"Warehouse":[19],"(DW).":[20],"most":[25],"resource":[26],"demanding":[27],"in":[29],"DW":[30],"implementation":[31],"typically":[33],"has":[34],"to":[35,149],"be":[36],"evolved":[37],"maintained":[39],"duration":[42],"of":[43,52,79,167],"DW.":[45],"To":[46],"facilitate":[47],"development":[49,86,193],"maintenance":[51],"processes":[54],"many":[55,108],"tools":[57,83],"have":[58],"been":[59],"developed":[60],"featuring":[61],"Graphical":[62],"User":[63],"Interfaces":[64],"various":[66,141],"built-in":[67],"functionalities":[68],"(parallelism,":[69],"logging,":[70],"rich":[71],"libraries,":[73],"documentation":[74],"generation,":[75],"etc.).":[76],"The":[77],"downside":[78],"such":[80],"GUI":[81,197],"that":[85,189],"carried":[88],"out":[89],"heavily":[90],"using":[91],"mouse":[92],"operations":[93],"less":[95],"by":[96,135,178],"writing":[97,136],"programming":[98],"code,":[99],"which":[100],"feels":[101],"unnatural":[102],"some":[104],"developers,":[105],"especially":[106],"with":[107,157],"similar,":[109],"repetitive":[110],"tasks.":[111],"In":[112],"this":[113],"paper":[114],"we":[115,187],"present":[116],"an":[117,121],"alternative":[118],"approach":[119],"-":[120],"framework":[123],"\"ETLator\"":[124],"based":[125],"on":[126],"Python":[127,137],"scripting":[128],"language":[129],"where":[130],"tasks":[132,156,162,177],"are":[133],"defined":[134],"code.":[138],"ETLator":[139,169,190],"implements":[140],"typical":[142],"transformations":[144],"allows":[146],"user":[148],"simply":[150],"efficiently":[152],"define":[153],"complex":[154],"multiple":[158],"sources":[159],"parallel":[161],"whilst":[163],"leveraging":[164],"full":[165],"flexibility":[166],"Python.":[168],"also":[170],"provides":[171],"logging":[172],"can":[174],"document":[175],"generating":[179],"flow":[181],"images.":[182],"On":[183],"a":[184],"test":[185],"case":[186],"show":[188],"simplifies":[191],"rivals":[195],"approach.":[198]},"abstract_inverted_index_v3":null,"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2734474333","counts_by_year":[{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1}],"updated_date":"2025-04-16T17:04:52.051614","created_date":"2017-07-21"}