{"id":"https://openalex.org/W2787642979","doi":"https://doi.org/10.1109/ice.2017.8280052","title":"User interface support for a big ETL data processing pipeline an application scenario on highway toll charging models","display_name":"User interface support for a big ETL data processing pipeline an application scenario on highway toll charging models","publication_year":2017,"publication_date":"2017-06-01","ids":{"openalex":"https://openalex.org/W2787642979","doi":"https://doi.org/10.1109/ice.2017.8280052","mag":"2787642979"},"language":"en","primary_location":{"id":"doi:10.1109/ice.2017.8280052","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ice.2017.8280052","pdf_url":null,"source":{"id":"https://openalex.org/S4306498191","display_name":"2017 International Conference on Engineering, Technology and Innovation (ICE/ITMC)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2017 International Conference on Engineering, Technology and Innovation (ICE/ITMC)","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/A5056572758","display_name":"Paulo Figueiras","orcid":"https://orcid.org/0000-0002-6068-1982"},"institutions":[{"id":"https://openalex.org/I83558840","display_name":"Universidade Nova de Lisboa","ror":"https://ror.org/02xankh89","country_code":"PT","type":"education","lineage":["https://openalex.org/I83558840"]}],"countries":["PT"],"is_corresponding":true,"raw_author_name":"Paulo Figueiras","raw_affiliation_strings":["Universidade Nova de Lisboa, Lisboa, Lisboa, PT"],"affiliations":[{"raw_affiliation_string":"Universidade Nova de Lisboa, Lisboa, Lisboa, PT","institution_ids":["https://openalex.org/I83558840"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5074702276","display_name":"R\u00faben Costa","orcid":"https://orcid.org/0000-0002-6142-1840"},"institutions":[{"id":"https://openalex.org/I83558840","display_name":"Universidade Nova de Lisboa","ror":"https://ror.org/02xankh89","country_code":"PT","type":"education","lineage":["https://openalex.org/I83558840"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Ruben Costa","raw_affiliation_strings":["Universidade Nova de Lisboa, Lisboa, Lisboa, PT"],"affiliations":[{"raw_affiliation_string":"Universidade Nova de Lisboa, Lisboa, Lisboa, PT","institution_ids":["https://openalex.org/I83558840"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5004101570","display_name":"Guilherme Guerreiro","orcid":"https://orcid.org/0000-0003-1261-6884"},"institutions":[{"id":"https://openalex.org/I83558840","display_name":"Universidade Nova de Lisboa","ror":"https://ror.org/02xankh89","country_code":"PT","type":"education","lineage":["https://openalex.org/I83558840"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Guilherme Guerreiro","raw_affiliation_strings":["Universidade Nova de Lisboa, Lisboa, Lisboa, PT"],"affiliations":[{"raw_affiliation_string":"Universidade Nova de Lisboa, Lisboa, Lisboa, PT","institution_ids":["https://openalex.org/I83558840"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057532482","display_name":"Hugo Antunes","orcid":null},"institutions":[{"id":"https://openalex.org/I83558840","display_name":"Universidade Nova de Lisboa","ror":"https://ror.org/02xankh89","country_code":"PT","type":"education","lineage":["https://openalex.org/I83558840"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Hugo Antunes","raw_affiliation_strings":["Universidade Nova de Lisboa, Lisboa, Lisboa, PT"],"affiliations":[{"raw_affiliation_string":"Universidade Nova de Lisboa, Lisboa, Lisboa, PT","institution_ids":["https://openalex.org/I83558840"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5043926638","display_name":"Antonio De Rosa","orcid":"https://orcid.org/0000-0002-1392-4881"},"institutions":[{"id":"https://openalex.org/I83558840","display_name":"Universidade Nova de Lisboa","ror":"https://ror.org/02xankh89","country_code":"PT","type":"education","lineage":["https://openalex.org/I83558840"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Antonio Rosa","raw_affiliation_strings":["Universidade Nova de Lisboa, Lisboa, Lisboa, PT"],"affiliations":[{"raw_affiliation_string":"Universidade Nova de Lisboa, Lisboa, Lisboa, PT","institution_ids":["https://openalex.org/I83558840"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5041536184","display_name":"Ricardo Jardim\u2010Gon\u00e7alves","orcid":"https://orcid.org/0000-0002-3703-6854"},"institutions":[{"id":"https://openalex.org/I83558840","display_name":"Universidade Nova de Lisboa","ror":"https://ror.org/02xankh89","country_code":"PT","type":"education","lineage":["https://openalex.org/I83558840"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Ricardo Jardim-Goncalves","raw_affiliation_strings":["Universidade Nova de Lisboa, Lisboa, Lisboa, PT"],"affiliations":[{"raw_affiliation_string":"Universidade Nova de Lisboa, Lisboa, Lisboa, PT","institution_ids":["https://openalex.org/I83558840"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5056572758"],"corresponding_institution_ids":["https://openalex.org/I83558840"],"apc_list":null,"apc_paid":null,"fwci":0.8322,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.76371308,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"1437","last_page":"1444"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10698","display_name":"Transportation Planning and Optimization","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/3313","display_name":"Transportation"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T10698","display_name":"Transportation Planning and Optimization","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/3313","display_name":"Transportation"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10524","display_name":"Traffic control and management","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/2207","display_name":"Control and Systems Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11344","display_name":"Traffic Prediction and Management Techniques","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/2215","display_name":"Building and Construction"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/toll","display_name":"Toll","score":0.9288138151168823},{"id":"https://openalex.org/keywords/transport-engineering","display_name":"Transport engineering","score":0.658222496509552},{"id":"https://openalex.org/keywords/traffic-congestion","display_name":"Traffic congestion","score":0.6550953388214111},{"id":"https://openalex.org/keywords/toll-road","display_name":"Toll road","score":0.5279777646064758},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.4719005525112152},{"id":"https://openalex.org/keywords/decision-support-system","display_name":"Decision support system","score":0.46899154782295227},{"id":"https://openalex.org/keywords/flow-network","display_name":"Flow network","score":0.4567060172557831},{"id":"https://openalex.org/keywords/congestion-pricing","display_name":"Congestion pricing","score":0.42782434821128845},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.25479841232299805}],"concepts":[{"id":"https://openalex.org/C2778025104","wikidata":"https://www.wikidata.org/wiki/Q408004","display_name":"Toll","level":2,"score":0.9288138151168823},{"id":"https://openalex.org/C22212356","wikidata":"https://www.wikidata.org/wiki/Q775325","display_name":"Transport engineering","level":1,"score":0.658222496509552},{"id":"https://openalex.org/C2779888511","wikidata":"https://www.wikidata.org/wiki/Q244156","display_name":"Traffic congestion","level":2,"score":0.6550953388214111},{"id":"https://openalex.org/C2778636371","wikidata":"https://www.wikidata.org/wiki/Q16939396","display_name":"Toll road","level":3,"score":0.5279777646064758},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.4719005525112152},{"id":"https://openalex.org/C107327155","wikidata":"https://www.wikidata.org/wiki/Q330268","display_name":"Decision support system","level":2,"score":0.46899154782295227},{"id":"https://openalex.org/C114809511","wikidata":"https://www.wikidata.org/wiki/Q1412924","display_name":"Flow network","level":2,"score":0.4567060172557831},{"id":"https://openalex.org/C8007445","wikidata":"https://www.wikidata.org/wiki/Q13743387","display_name":"Congestion pricing","level":3,"score":0.42782434821128845},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.25479841232299805},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0},{"id":"https://openalex.org/C54355233","wikidata":"https://www.wikidata.org/wiki/Q7162","display_name":"Genetics","level":1,"score":0.0},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/ice.2017.8280052","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ice.2017.8280052","pdf_url":null,"source":{"id":"https://openalex.org/S4306498191","display_name":"2017 International Conference on Engineering, Technology and Innovation (ICE/ITMC)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2017 International Conference on Engineering, Technology and Innovation (ICE/ITMC)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5199999809265137,"display_name":"Sustainable cities and communities","id":"https://metadata.un.org/sdg/11"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320320300","display_name":"European Commission","ror":"https://ror.org/00k4n6c32"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W41868933","https://openalex.org/W250961080","https://openalex.org/W568012446","https://openalex.org/W577896627","https://openalex.org/W2011916156","https://openalex.org/W2018821139","https://openalex.org/W2089177159","https://openalex.org/W2169191293","https://openalex.org/W2202064371","https://openalex.org/W2249437948","https://openalex.org/W2541639660","https://openalex.org/W2549626580","https://openalex.org/W2589332586","https://openalex.org/W2604061734","https://openalex.org/W2611529361","https://openalex.org/W3122548282","https://openalex.org/W3129849971","https://openalex.org/W6609567582","https://openalex.org/W6615901917","https://openalex.org/W6616800098","https://openalex.org/W6733738268","https://openalex.org/W6735945897","https://openalex.org/W6737297785"],"related_works":["https://openalex.org/W243480392","https://openalex.org/W2115535212","https://openalex.org/W1573127926","https://openalex.org/W2186853378","https://openalex.org/W65202228","https://openalex.org/W765831689","https://openalex.org/W875833606","https://openalex.org/W1510238760","https://openalex.org/W3023977068","https://openalex.org/W2058261044"],"abstract_inverted_index":{"Urban":[0],"and":[1,16,28,33,36,82,109,134,163,166,203,214,233],"national":[2,185],"road":[3,95,121,145],"networks":[4],"in":[5,12,66],"many":[6],"countries":[7],"are":[8],"severely":[9],"congested,":[10],"resulting":[11],"increased":[13,30],"travel":[14,23,72,132],"times":[15],"number":[17,37],"of":[18,38,60,173,192],"stops,":[19],"unexpected":[20],"delays,":[21],"greater":[22],"costs,":[24],"inconvenience":[25],"to":[26,68,93,117,126,179,187,211,218],"drivers":[27,124],"passengers,":[29],"air":[31],"pollution":[32],"noise":[34],"level":[35],"traffic":[39,42,83,181],"accidents.":[40],"Expanding":[41],"network":[43,63,113,146],"capacities":[44],"by":[45,79,251],"building":[46],"more":[47,152],"roads":[48,129,186],"is":[49,64,115,178],"extremely":[50],"costly":[51],"as":[52,54,89,205,207,217],"well":[53,206],"environmentally":[55],"damaging.":[56],"More":[57],"efficient":[58,91],"usage":[59],"the":[61,70,174,190],"existing":[62],"vital":[65],"order":[67],"sustain":[69],"growing":[71],"demand.":[73],"Congestion":[74],"pricing":[75,194],"has":[76,106,147],"been":[77,102,148],"advocated":[78],"transport":[80],"economists":[81],"planners":[84],"for":[85,168,223,236,248],"a":[86,107,151,252],"long":[87],"time":[88,133],"an":[90,229,241],"means":[92],"reduce":[94],"congestion,":[96],"however":[97],"such":[98],"practices":[99],"have":[100],"not":[101],"widely":[103],"adopted.":[104],"Portugal":[105],"good":[108],"underused":[110],"toll":[111,141,246],"highway":[112],"that":[114],"close":[116],"congested":[118],"free":[119,128],"urban/national":[120,144],"networks.":[122],"Portuguese":[123],"choose":[125],"use":[127,154],"disregarding":[130],"safety,":[131],"other":[135],"aspects,":[136],"basing":[137],"their":[138],"decision":[139],"only":[140],"prices.":[142],"Therefore,":[143],"suffering":[149],"from":[150,182],"intensive":[153],"than":[155],"it":[156],"was":[157],"projected":[158],"for,":[159],"increasing":[160],"maintenance":[161],"costs":[162],"reducing":[164],"safety":[165],"comfort":[167],"users.":[169],"The":[170],"main":[171],"objective":[172],"application":[175,242],"scenario":[176,243],"presented":[177],"transfer":[180],"urban":[183],"/":[184],"highways,":[188,249],"through":[189],"adoption":[191],"congestion":[193,224],"technologies.":[195],"To":[196],"this":[197],"end,":[198],"innovative":[199],"Big":[200],"Data":[201],"processing":[202],"mining":[204],"optimization":[208],"techniques":[209],"need":[210],"be":[212],"developed":[213],"applied":[215],"so":[216],"support":[219],"real-time":[220],"decision-making":[221],"capabilities":[222],"pricing.":[225],"This":[226],"paper":[227],"presents":[228],"ETL":[230],"(extract,":[231],"transform":[232],"load)":[234],"architecture":[235],"intelligent":[237],"transportation":[238],"systems,":[239],"addressing":[240],"on":[244],"dynamic":[245],"charging":[247],"supported":[250],"novel":[253],"Web":[254],"User":[255],"Interface.":[256]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2021,"cited_by_count":4},{"year":2019,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}