{"id":"https://openalex.org/W2150375884","doi":"https://doi.org/10.1145/2811222.2811229","title":"Towards a Programmable Semantic Extract-Transform-Load Framework for Semantic Data Warehouses","display_name":"Towards a Programmable Semantic Extract-Transform-Load Framework for Semantic Data Warehouses","publication_year":2015,"publication_date":"2015-10-22","ids":{"openalex":"https://openalex.org/W2150375884","doi":"https://doi.org/10.1145/2811222.2811229","mag":"2150375884"},"language":"en","primary_location":{"id":"doi:10.1145/2811222.2811229","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2811222.2811229","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 Eighteenth International Workshop on Data Warehousing and OLAP","raw_type":"proceedings-article"},"type":"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/A5083809693","display_name":"Rudra Pratap Deb Nath","orcid":"https://orcid.org/0000-0001-8807-1927"},"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":true,"raw_author_name":"Rudra Pratap Deb Nath","raw_affiliation_strings":["Aalborg University, Aalborg, Denmark"],"affiliations":[{"raw_affiliation_string":"Aalborg University, Aalborg, Denmark","institution_ids":["https://openalex.org/I891191580"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5015313855","display_name":"Katja Hose","orcid":"https://orcid.org/0000-0001-7025-8099"},"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":"Katja Hose","raw_affiliation_strings":["Aalborg University, Aalborg, Denmark"],"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"],"affiliations":[{"raw_affiliation_string":"Aalborg University, Aalborg, Denmark","institution_ids":["https://openalex.org/I891191580"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5083809693"],"corresponding_institution_ids":["https://openalex.org/I891191580"],"apc_list":null,"apc_paid":null,"fwci":8.8965,"has_fulltext":false,"cited_by_count":41,"citation_normalized_percentile":{"value":0.97708949,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"15","last_page":"24"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9993000030517578,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9993000030517578,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T11719","display_name":"Data Quality and Management","score":0.9976999759674072,"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.9973999857902527,"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/computer-science","display_name":"Computer science","score":0.8568532466888428},{"id":"https://openalex.org/keywords/semantic-analytics","display_name":"Semantic analytics","score":0.7129977941513062},{"id":"https://openalex.org/keywords/semantic-computing","display_name":"Semantic computing","score":0.6177903413772583},{"id":"https://openalex.org/keywords/semantic-technology","display_name":"Semantic technology","score":0.6050524711608887},{"id":"https://openalex.org/keywords/semantic-integration","display_name":"Semantic integration","score":0.59339439868927},{"id":"https://openalex.org/keywords/semantic-grid","display_name":"Semantic grid","score":0.5468917489051819},{"id":"https://openalex.org/keywords/semantic-web-stack","display_name":"Semantic Web Stack","score":0.5272530317306519},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.4983940124511719},{"id":"https://openalex.org/keywords/semantic-web","display_name":"Semantic Web","score":0.4981257915496826},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4849269688129425},{"id":"https://openalex.org/keywords/sparql","display_name":"SPARQL","score":0.45847347378730774},{"id":"https://openalex.org/keywords/semantic-data-model","display_name":"Semantic data model","score":0.4228830337524414},{"id":"https://openalex.org/keywords/semantic-query","display_name":"Semantic query","score":0.4107191264629364},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.37074851989746094},{"id":"https://openalex.org/keywords/rdf","display_name":"RDF","score":0.3483532667160034},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.07276415824890137}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8568532466888428},{"id":"https://openalex.org/C148792806","wikidata":"https://www.wikidata.org/wiki/Q7449046","display_name":"Semantic analytics","level":4,"score":0.7129977941513062},{"id":"https://openalex.org/C511149849","wikidata":"https://www.wikidata.org/wiki/Q7449051","display_name":"Semantic computing","level":3,"score":0.6177903413772583},{"id":"https://openalex.org/C6881194","wikidata":"https://www.wikidata.org/wiki/Q7449091","display_name":"Semantic technology","level":4,"score":0.6050524711608887},{"id":"https://openalex.org/C110903229","wikidata":"https://www.wikidata.org/wiki/Q7449064","display_name":"Semantic integration","level":4,"score":0.59339439868927},{"id":"https://openalex.org/C103692084","wikidata":"https://www.wikidata.org/wiki/Q1765824","display_name":"Semantic grid","level":3,"score":0.5468917489051819},{"id":"https://openalex.org/C167379230","wikidata":"https://www.wikidata.org/wiki/Q1026884","display_name":"Semantic Web Stack","level":3,"score":0.5272530317306519},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.4983940124511719},{"id":"https://openalex.org/C2129575","wikidata":"https://www.wikidata.org/wiki/Q54837","display_name":"Semantic Web","level":2,"score":0.4981257915496826},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4849269688129425},{"id":"https://openalex.org/C41009113","wikidata":"https://www.wikidata.org/wiki/Q54871","display_name":"SPARQL","level":4,"score":0.45847347378730774},{"id":"https://openalex.org/C90312973","wikidata":"https://www.wikidata.org/wiki/Q7449052","display_name":"Semantic data model","level":2,"score":0.4228830337524414},{"id":"https://openalex.org/C2778816267","wikidata":"https://www.wikidata.org/wiki/Q21015578","display_name":"Semantic query","level":4,"score":0.4107191264629364},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.37074851989746094},{"id":"https://openalex.org/C147497476","wikidata":"https://www.wikidata.org/wiki/Q54872","display_name":"RDF","level":3,"score":0.3483532667160034},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.07276415824890137},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/2811222.2811229","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2811222.2811229","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 Eighteenth International Workshop on Data Warehousing and OLAP","raw_type":"proceedings-article"},{"id":"pmh:oai:pure.atira.dk:publications/0ca944cc-6593-4f09-b4c7-b1358ad35e89","is_oa":false,"landing_page_url":"https://vbn.aau.dk/da/publications/0ca944cc-6593-4f09-b4c7-b1358ad35e89","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":"Nath , R , Hose , K & Pedersen , T B 2015 , Towards a Programmable Semantic Extract-Transform-Load Framework for Semantic Data Warehouses . in ACM Eighteenth International Workshop On Data Warehousing and OLAP (DOLAP 2015) . vol. 23 , Association for Computing Machinery , pp. 15-24 , ACM Eighteenth International Workshop On Data Warehousing and OLAP , Melbourne , Australia , 23/10/2015 . https://doi.org/10.1145/2811222.2811229","raw_type":"contributionToPeriodical"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/8","display_name":"Decent work and economic growth","score":0.5099999904632568}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":19,"referenced_works":["https://openalex.org/W33719067","https://openalex.org/W106589471","https://openalex.org/W1487885696","https://openalex.org/W1502767276","https://openalex.org/W1568351876","https://openalex.org/W1605942749","https://openalex.org/W1968927660","https://openalex.org/W1972793074","https://openalex.org/W1982600306","https://openalex.org/W2004505745","https://openalex.org/W2063753658","https://openalex.org/W2079216133","https://openalex.org/W2128769945","https://openalex.org/W2139452609","https://openalex.org/W2143326402","https://openalex.org/W2163581738","https://openalex.org/W2756641662","https://openalex.org/W3010624202","https://openalex.org/W6681005018"],"related_works":["https://openalex.org/W2280628760","https://openalex.org/W2165366845","https://openalex.org/W2084998560","https://openalex.org/W2779831736","https://openalex.org/W1990650227","https://openalex.org/W2594063224","https://openalex.org/W1997451603","https://openalex.org/W2373133917","https://openalex.org/W4306317373","https://openalex.org/W2150375884"],"abstract_inverted_index":{"In":[0],"order":[1],"to":[2,20,139],"create":[3,59],"better":[4,159],"decisions":[5],"for":[6,33,105],"business":[7],"analytics,":[8],"organizations":[9],"increasingly":[10],"use":[11,153],"external":[12],"data,":[13],"structured,":[14],"semi-structured":[15],"and":[16,90,92,103,107,111,121,130,164],"unstructured,":[17],"in":[18,45],"addition":[19],"the":[21,46],"(mostly":[22],"structured)":[23],"internal":[24],"data.":[25,72],"Current":[26],"Extract-Transform-Load":[27],"(ETL)":[28],"tools":[29,52,91,145],"are":[30],"not":[31,41],"suitable":[32],"this":[34],"\"open":[35],"world":[36],"scenario\"":[37],"because":[38],"they":[39],"do":[40],"consider":[42],"semantic":[43,67,119,124],"issues":[44],"integration":[47],"process.":[48],"Also,":[49],"current":[50],"ETL":[51,81],"neither":[53],"support":[54],"processing":[55],"semantic-aware":[56,116],"data":[57,117],"nor":[58],"a":[60,66,77,97,123,140,151],"Semantic":[61,80,86],"Data":[62],"Warehouse":[63],"(DW)":[64],"as":[65],"repository":[68],"of":[69,99,127],"semantically":[70],"integrated":[71],"This":[73],"paper":[74],"describes":[75],"SETL:":[76],"(Python-based)":[78],"programmable":[79],"framework.":[82],"SETL":[83,138,157],"builds":[84],"on":[85,150],"Web":[87],"(SW)":[88],"standards":[89],"supports":[93,115],"developers":[94],"by":[95],"offering":[96],"number":[98],"powerful":[100],"modules,":[101],"classes":[102],"methods":[104],"(dimensional":[106],"semantic)":[108],"DW":[109],"constructs":[110],"tasks.":[112],"Thus":[113],"it":[114],"sources,":[118],"integration,":[120],"creating":[122],"DW,":[125],"composed":[126],"an":[128],"ontology":[129],"its":[131],"instances.":[132],"A":[133],"comprehensive":[134],"experimental":[135],"evaluation":[136],"comparing":[137],"solution":[141],"made":[142],"with":[143],"traditional":[144],"(requiring":[146],"much":[147],"more":[148],"hand-coding)":[149],"concrete":[152],"case,":[154],"shows":[155],"that":[156],"provides":[158],"performance,":[160],"knowledge":[161],"base":[162],"quality":[163],"programmer":[165],"productivity.":[166]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":2},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":7},{"year":2019,"cited_by_count":5},{"year":2018,"cited_by_count":5},{"year":2017,"cited_by_count":8},{"year":2016,"cited_by_count":6},{"year":2015,"cited_by_count":1}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}