{"id":"https://openalex.org/W2152236140","doi":"https://doi.org/10.1145/1651291.1651301","title":"pygrametl","display_name":"pygrametl","publication_year":2009,"publication_date":"2009-11-06","ids":{"openalex":"https://openalex.org/W2152236140","doi":"https://doi.org/10.1145/1651291.1651301","mag":"2152236140"},"language":"en","primary_location":{"id":"doi:10.1145/1651291.1651301","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1651291.1651301","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP","raw_type":"proceedings-article"},"type":"conference-paper","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/A5010748912","display_name":"Christian Thomsen","orcid":"https://orcid.org/0000-0002-0862-0509"},"institutions":[{"id":"https://openalex.org/I891191580","display_name":"Aalborg University","ror":"https://ror.org/04m5j1k67","country_code":"DK","type":"education","lineage":["https://openalex.org/I891191580"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Christian Thomsen","raw_affiliation_strings":["Aalborg University, Aalborg, Denmark"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Aalborg University, Aalborg, Denmark","institution_ids":["https://openalex.org/I891191580"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5061064237","display_name":"Torben Bach Pedersen","orcid":"https://orcid.org/0000-0002-1615-777X"},"institutions":[{"id":"https://openalex.org/I891191580","display_name":"Aalborg University","ror":"https://ror.org/04m5j1k67","country_code":"DK","type":"education","lineage":["https://openalex.org/I891191580"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Torben Bach Pedersen","raw_affiliation_strings":["Aalborg University, Aalborg, Denmark"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Aalborg University, Aalborg, Denmark","institution_ids":["https://openalex.org/I891191580"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I891191580"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":41,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"49","last_page":"56"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9944999814033508,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9944999814033508,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9864000082015991,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"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/T11719","display_name":"Data Quality and Management","score":0.9861999750137329,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8356829881668091},{"id":"https://openalex.org/keywords/python","display_name":"Python (programming language)","score":0.8167126774787903},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5568686723709106},{"id":"https://openalex.org/keywords/graphical-user-interface","display_name":"Graphical user interface","score":0.5474863052368164},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.4518702030181885},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.41296544671058655},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.37008512020111084},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.36687523126602173}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8356829881668091},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.8167126774787903},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5568686723709106},{"id":"https://openalex.org/C37789001","wikidata":"https://www.wikidata.org/wiki/Q782543","display_name":"Graphical user interface","level":2,"score":0.5474863052368164},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.4518702030181885},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.41296544671058655},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.37008512020111084},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.36687523126602173},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1651291.1651301","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1651291.1651301","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP","raw_type":"proceedings-article"},{"id":"pmh:oai:pure.atira.dk:publications/7f49f290-9c46-11de-b96d-000ea68e967b","is_oa":false,"landing_page_url":"https://vbn.aau.dk/da/publications/7f49f290-9c46-11de-b96d-000ea68e967b","pdf_url":null,"source":{"id":"https://openalex.org/S4306401731","display_name":"VBN Forskningsportal (Aalborg Universitet)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I891191580","host_organization_name":"Aalborg University","host_organization_lineage":["https://openalex.org/I891191580"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Thomsen, C & Pedersen, T B 2009, pygrametl: A Powerful Programming Framework for Extract-Transform-Load Programmers. in Proceedings of the 12th ACM International Workshop on Data Warehousing and OLAP (DOLAP). Association for Computing Machinery (ACM), pp. 49-56, ACM 12th International Workshop on Data Warehousing and OLAP, Hong Kong, China, 06/11/2009. https://doi.org/10.1145/1651291.1651301","raw_type":"info:eu-repo/semantics/publishedVersion"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5400000214576721,"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W767111626","https://openalex.org/W1482268585","https://openalex.org/W1556842621","https://openalex.org/W2083755493","https://openalex.org/W2089438716","https://openalex.org/W2152236140","https://openalex.org/W2158275487","https://openalex.org/W2504053860","https://openalex.org/W2973379277","https://openalex.org/W6671423705"],"related_works":["https://openalex.org/W2341492732","https://openalex.org/W3187193180","https://openalex.org/W106542691","https://openalex.org/W1699080303","https://openalex.org/W4297799326","https://openalex.org/W3116064965","https://openalex.org/W2207495067","https://openalex.org/W1906486629","https://openalex.org/W3034716491","https://openalex.org/W4240625990"],"abstract_inverted_index":{"Extract-Transform-Load":[0],"(ETL)":[1],"processes":[2,22],"are":[3,115],"used":[4,73],"for":[5,19,75],"extracting":[6],"data,":[7],"transforming":[8],"it":[9,12],"and":[10,41,50,112],"loading":[11],"into":[13],"data":[14,39],"warehouses":[15],"(DWs).":[16],"Many":[17],"tools":[18,26],"creating":[20],"ETL":[21,54,76,88],"exist.":[23],"The":[24],"dominating":[25],"all":[27],"use":[28],"graphical":[29],"user":[30],"interfaces":[31],"(GUIs)":[32],"where":[33],"the":[34,38,61,66,80,82,92,109],"developer":[35,83],"visually":[36],"defines":[37],"flow":[40],"operations.":[42],"In":[43],"this":[44,48],"paper,":[45],"we":[46,64],"challenge":[47],"approach":[49],"propose":[51],"to":[52,119],"do":[53],"programming":[55,62,96],"by":[56],"writing":[57],"code.":[58],"To":[59],"make":[60],"easy,":[63],"present":[65],"(Python-based)":[67],"framework":[68],"pygrametl":[69,105],"which":[70,91],"offers":[71],"commonly":[72],"functionality":[74],"development.":[77],"By":[78],"using":[79],"framework,":[81],"can":[84,97],"efficiently":[85],"create":[86],"effective":[87],"solutions":[89],"from":[90],"full":[93],"power":[94],"of":[95],"be":[98],"exploited.":[99],"Our":[100],"experiments":[101],"show":[102],"that":[103],"when":[104,117],"is":[106],"used,":[107],"both":[108],"development":[110],"time":[111,114],"running":[113],"short":[116],"compared":[118],"an":[120],"existing":[121],"GUI-based":[122],"tool.":[123]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":5},{"year":2016,"cited_by_count":6},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":5},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":3}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2016-06-24T00:00:00"}