{"id":"https://openalex.org/W2897477731","doi":"https://doi.org/10.1093/comjnl/bxy113","title":"A Conceptual Approach for Supporting Traffic Data Wrangling Tasks","display_name":"A Conceptual Approach for Supporting Traffic Data Wrangling Tasks","publication_year":2018,"publication_date":"2018-10-12","ids":{"openalex":"https://openalex.org/W2897477731","doi":"https://doi.org/10.1093/comjnl/bxy113","mag":"2897477731"},"language":"en","primary_location":{"id":"doi:10.1093/comjnl/bxy113","is_oa":false,"landing_page_url":"https://doi.org/10.1093/comjnl/bxy113","pdf_url":null,"source":{"id":"https://openalex.org/S44643521","display_name":"The Computer Journal","issn_l":"0010-4620","issn":["0010-4620","1460-2067"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310311648","host_organization_name":"Oxford University Press","host_organization_lineage":["https://openalex.org/P4310311648","https://openalex.org/P4310311647"],"host_organization_lineage_names":["Oxford University Press","University of Oxford"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The Computer Journal","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://research.manchester.ac.uk/en/publications/39623cfb-a983-4552-b919-5b4ba9607eae","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5048808356","display_name":"Sandra Sampaio","orcid":"https://orcid.org/0000-0002-3751-4182"},"institutions":[{"id":"https://openalex.org/I28407311","display_name":"University of Manchester","ror":"https://ror.org/027m9bs27","country_code":"GB","type":"education","lineage":["https://openalex.org/I28407311"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Sandra Sampaio","raw_affiliation_strings":["Information Management Group, School of Computer Science, University of Manchester, Manchester, UK"],"affiliations":[{"raw_affiliation_string":"Information Management Group, School of Computer Science, University of Manchester, Manchester, UK","institution_ids":["https://openalex.org/I28407311"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063359417","display_name":"Mashael Aljubairah","orcid":null},"institutions":[{"id":"https://openalex.org/I28407311","display_name":"University of Manchester","ror":"https://ror.org/027m9bs27","country_code":"GB","type":"education","lineage":["https://openalex.org/I28407311"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Mashael Aljubairah","raw_affiliation_strings":["Information Management Group, School of Computer Science, University of Manchester, Manchester, UK"],"affiliations":[{"raw_affiliation_string":"Information Management Group, School of Computer Science, University of Manchester, Manchester, UK","institution_ids":["https://openalex.org/I28407311"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5053318619","display_name":"Hapsoro Adi Permana","orcid":null},"institutions":[{"id":"https://openalex.org/I28407311","display_name":"University of Manchester","ror":"https://ror.org/027m9bs27","country_code":"GB","type":"education","lineage":["https://openalex.org/I28407311"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Hapsoro Adi Permana","raw_affiliation_strings":["Information Management Group, School of Computer Science, University of Manchester, Manchester, UK"],"affiliations":[{"raw_affiliation_string":"Information Management Group, School of Computer Science, University of Manchester, Manchester, UK","institution_ids":["https://openalex.org/I28407311"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101681609","display_name":"Pedro Sampaio","orcid":"https://orcid.org/0000-0002-5341-1327"},"institutions":[{"id":"https://openalex.org/I28407311","display_name":"University of Manchester","ror":"https://ror.org/027m9bs27","country_code":"GB","type":"education","lineage":["https://openalex.org/I28407311"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Pedro Sampaio","raw_affiliation_strings":["Alliance Manchester Business School, University of Manchester, Manchester, UK"],"affiliations":[{"raw_affiliation_string":"Alliance Manchester Business School, University of Manchester, Manchester, UK","institution_ids":["https://openalex.org/I28407311"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5048808356"],"corresponding_institution_ids":["https://openalex.org/I28407311"],"apc_list":{"value":2635,"currency":"GBP","value_usd":3232},"apc_paid":null,"fwci":0.6352,"has_fulltext":false,"cited_by_count":10,"citation_normalized_percentile":{"value":0.74036401,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"62","issue":"3","first_page":"461","last_page":"480"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9998999834060669,"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.9998999834060669,"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.9897000193595886,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9861000180244446,"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/computer-science","display_name":"Computer science","score":0.8475872278213501},{"id":"https://openalex.org/keywords/python","display_name":"Python (programming language)","score":0.805709958076477},{"id":"https://openalex.org/keywords/scripting-language","display_name":"Scripting language","score":0.7688062787055969},{"id":"https://openalex.org/keywords/implementation","display_name":"Implementation","score":0.5234274864196777},{"id":"https://openalex.org/keywords/visualization","display_name":"Visualization","score":0.4969821274280548},{"id":"https://openalex.org/keywords/domain","display_name":"Domain (mathematical analysis)","score":0.4746564030647278},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.47061780095100403},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4393256604671478},{"id":"https://openalex.org/keywords/subject-matter-expert","display_name":"Subject-matter expert","score":0.4220546782016754},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.37950077652931213},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3444490432739258},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2779831886291504},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.19436734914779663},{"id":"https://openalex.org/keywords/expert-system","display_name":"Expert system","score":0.12414559721946716}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8475872278213501},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.805709958076477},{"id":"https://openalex.org/C61423126","wikidata":"https://www.wikidata.org/wiki/Q187432","display_name":"Scripting language","level":2,"score":0.7688062787055969},{"id":"https://openalex.org/C26713055","wikidata":"https://www.wikidata.org/wiki/Q245962","display_name":"Implementation","level":2,"score":0.5234274864196777},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.4969821274280548},{"id":"https://openalex.org/C36503486","wikidata":"https://www.wikidata.org/wiki/Q11235244","display_name":"Domain (mathematical analysis)","level":2,"score":0.4746564030647278},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.47061780095100403},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4393256604671478},{"id":"https://openalex.org/C105002631","wikidata":"https://www.wikidata.org/wiki/Q4833645","display_name":"Subject-matter expert","level":3,"score":0.4220546782016754},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.37950077652931213},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3444490432739258},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2779831886291504},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.19436734914779663},{"id":"https://openalex.org/C58328972","wikidata":"https://www.wikidata.org/wiki/Q184609","display_name":"Expert system","level":2,"score":0.12414559721946716},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1093/comjnl/bxy113","is_oa":false,"landing_page_url":"https://doi.org/10.1093/comjnl/bxy113","pdf_url":null,"source":{"id":"https://openalex.org/S44643521","display_name":"The Computer Journal","issn_l":"0010-4620","issn":["0010-4620","1460-2067"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310311648","host_organization_name":"Oxford University Press","host_organization_lineage":["https://openalex.org/P4310311648","https://openalex.org/P4310311647"],"host_organization_lineage_names":["Oxford University Press","University of Oxford"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The Computer Journal","raw_type":"journal-article"},{"id":"pmh:oai:pure.atira.dk:openaire/39623cfb-a983-4552-b919-5b4ba9607eae","is_oa":true,"landing_page_url":"https://research.manchester.ac.uk/en/publications/39623cfb-a983-4552-b919-5b4ba9607eae","pdf_url":null,"source":{"id":"https://openalex.org/S4306400662","display_name":"Research Explorer (The University of Manchester)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I28407311","host_organization_name":"University of Manchester","host_organization_lineage":["https://openalex.org/I28407311"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Sampaio, S, Al-Jubairah, M, Permana, H A & Sampaio, P 2018, 'A Conceptual Approach for Supporting Traffic Data Wrangling Tasks', The Computer Journal, vol. 62, no. 3, pp. 461-480. https://doi.org/10.1093/comjnl/bxy113","raw_type":"info:eu-repo/semantics/publishedVersion"},{"id":"pmh:oai:pure.atira.dk:publications/39623cfb-a983-4552-b919-5b4ba9607eae","is_oa":false,"landing_page_url":"https://academic.oup.com/comjnl/advance-article/doi/10.1093/comjnl/bxy113/5158248?guestAccessKey=2029c2f6-7faa-4046-a2d6-67c492905922","pdf_url":null,"source":{"id":"https://openalex.org/S4306400662","display_name":"Research Explorer (The University of Manchester)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I28407311","host_organization_name":"University of Manchester","host_organization_lineage":["https://openalex.org/I28407311"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":""}],"best_oa_location":{"id":"pmh:oai:pure.atira.dk:openaire/39623cfb-a983-4552-b919-5b4ba9607eae","is_oa":true,"landing_page_url":"https://research.manchester.ac.uk/en/publications/39623cfb-a983-4552-b919-5b4ba9607eae","pdf_url":null,"source":{"id":"https://openalex.org/S4306400662","display_name":"Research Explorer (The University of Manchester)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I28407311","host_organization_name":"University of Manchester","host_organization_lineage":["https://openalex.org/I28407311"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Sampaio, S, Al-Jubairah, M, Permana, H A & Sampaio, P 2018, 'A Conceptual Approach for Supporting Traffic Data Wrangling Tasks', The Computer Journal, vol. 62, no. 3, pp. 461-480. https://doi.org/10.1093/comjnl/bxy113","raw_type":"info:eu-repo/semantics/publishedVersion"},"sustainable_development_goals":[{"score":0.5099999904632568,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":43,"referenced_works":["https://openalex.org/W568320136","https://openalex.org/W608507951","https://openalex.org/W760598031","https://openalex.org/W1491178396","https://openalex.org/W1509428113","https://openalex.org/W1513250879","https://openalex.org/W1513660623","https://openalex.org/W1587329505","https://openalex.org/W1595443289","https://openalex.org/W1610496399","https://openalex.org/W1949265207","https://openalex.org/W1993997820","https://openalex.org/W1998430220","https://openalex.org/W2008034909","https://openalex.org/W2011039300","https://openalex.org/W2019358506","https://openalex.org/W2019388967","https://openalex.org/W2028180201","https://openalex.org/W2080731889","https://openalex.org/W2089634871","https://openalex.org/W2089674328","https://openalex.org/W2097565277","https://openalex.org/W2098417174","https://openalex.org/W2120608294","https://openalex.org/W2150593375","https://openalex.org/W2151881411","https://openalex.org/W2165467455","https://openalex.org/W2167679350","https://openalex.org/W2185907055","https://openalex.org/W2321707316","https://openalex.org/W2338990760","https://openalex.org/W2418532740","https://openalex.org/W2476096155","https://openalex.org/W2493640771","https://openalex.org/W2595741287","https://openalex.org/W2724111113","https://openalex.org/W3104305579","https://openalex.org/W4214487305","https://openalex.org/W4232461017","https://openalex.org/W4234670385","https://openalex.org/W4245050711","https://openalex.org/W4256008007","https://openalex.org/W6636177537"],"related_works":["https://openalex.org/W3023169329","https://openalex.org/W4389470870","https://openalex.org/W2782165897","https://openalex.org/W1582950852","https://openalex.org/W4300438041","https://openalex.org/W2054104202","https://openalex.org/W2139703748","https://openalex.org/W2761254753","https://openalex.org/W1024825291","https://openalex.org/W4214505573"],"abstract_inverted_index":{"Data":[0,159],"wrangling":[1,100,112],"(DW)":[2],"is":[3,121,150],"the":[4,31,66,105],"subject":[5],"of":[6,33,69,99,133],"growing":[7],"interest":[8],"given":[9],"its":[10],"potential":[11],"to":[12,29,42,80,151,162,165,171],"improve":[13,30],"data":[14,21,44,84],"quality.":[15],"DW":[16,37,51,58,81,93,134,168],"applies":[17],"interactive":[18],"and":[19,26,56,95,123,126,141],"iterative":[20],"profiling,":[22],"cleaning,":[23],"transformation,":[24],"integration":[25],"visualization":[27],"operations":[28],"quality":[32,45],"data.":[34],"Several":[35],"domain-independent":[36],"tools":[38,52,142],"have":[39],"been":[40],"developed":[41],"tackle":[43],"issues":[46],"across":[47],"domains.":[48],"Using":[49],"generic":[50],"requires":[53],"a":[54,77,87,153],"time-consuming":[55],"costly":[57],"process,":[59],"often":[60],"involving":[61],"advanced":[62],"IT":[63],"knowledge":[64,161],"beyond":[65],"skills":[67],"set":[68,98],"traffic":[70,83,92,155],"analysts.":[71],"In":[72],"this":[73,119],"paper,":[74],"we":[75],"propose":[76],"conceptual":[78,107,115],"approach":[79,116],"for":[82,90,109],"by":[85],"creating":[86],"domain-specific":[88,111],"language":[89],"specifying":[91],"tasks":[94,169],"an":[96],"abstract":[97],"operators":[101],"that":[102],"serve":[103],"as":[104,144],"target":[106],"construct":[108],"mapping":[110],"tasks.":[113],"The":[114],"discussed":[117],"in":[118,137],"paper":[120],"tool-independent":[122],"platform":[124],"agnostic":[125],"can":[127],"be":[128,163],"mapped":[129],"into":[130],"specific":[131],"implementations":[132],"functions":[135],"available":[136],"existing":[138],"scripting":[139],"languages":[140],"such":[143],"R,":[145],"Python,":[146],"Trifacta.":[147],"Our":[148],"aim":[149],"enable":[152],"typical":[154],"analyst":[156],"without":[157],"expert":[158],"Science":[160],"able":[164],"perform":[166],"basic":[167],"relevant":[170],"his":[172],"domain.":[173]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":4},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}