{"id":"https://openalex.org/W4366549947","doi":"https://doi.org/10.1145/3544548.3580868","title":"Governor: Turning Open Government Data Portals into Interactive Databases","display_name":"Governor: Turning Open Government Data Portals into Interactive Databases","publication_year":2023,"publication_date":"2023-04-19","ids":{"openalex":"https://openalex.org/W4366549947","doi":"https://doi.org/10.1145/3544548.3580868"},"language":"en","primary_location":{"id":"doi:10.1145/3544548.3580868","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3544548.3580868","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2023 CHI Conference on Human Factors in Computing Systems","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/A5028224881","display_name":"Chang Liu","orcid":"https://orcid.org/0000-0002-3105-9174"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Chang Liu","raw_affiliation_strings":["School of Computer Science, University of Waterloo, Canada"],"affiliations":[{"raw_affiliation_string":"School of Computer Science, University of Waterloo, Canada","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010326270","display_name":"Arif Usta","orcid":"https://orcid.org/0000-0001-6713-6621"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Arif Usta","raw_affiliation_strings":["School of Computer Science, University of Waterloo, Canada"],"affiliations":[{"raw_affiliation_string":"School of Computer Science, University of Waterloo, Canada","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018820623","display_name":"Jian Zhao","orcid":"https://orcid.org/0000-0001-5008-4319"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Jian Zhao","raw_affiliation_strings":["School of Computer Science, University of Waterloo, Canada"],"affiliations":[{"raw_affiliation_string":"School of Computer Science, University of Waterloo, Canada","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5023876520","display_name":"Semih Saliho\u011flu","orcid":"https://orcid.org/0000-0002-8112-4501"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Semih Salihoglu","raw_affiliation_strings":["School of Computer Science, University of Waterloo, Canada"],"affiliations":[{"raw_affiliation_string":"School of Computer Science, University of Waterloo, Canada","institution_ids":["https://openalex.org/I151746483"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5028224881"],"corresponding_institution_ids":["https://openalex.org/I151746483"],"apc_list":null,"apc_paid":null,"fwci":2.2394,"has_fulltext":false,"cited_by_count":9,"citation_normalized_percentile":{"value":0.88097871,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"16"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9993000030517578,"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.9993000030517578,"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.9990000128746033,"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.993399977684021,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/upload","display_name":"Upload","score":0.864546537399292},{"id":"https://openalex.org/keywords/governor","display_name":"Governor","score":0.7977597117424011},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7590343952178955},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.6093498468399048},{"id":"https://openalex.org/keywords/open-data","display_name":"Open data","score":0.5126734972000122},{"id":"https://openalex.org/keywords/government","display_name":"Government (linguistics)","score":0.48122310638427734},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.47190314531326294},{"id":"https://openalex.org/keywords/trace","display_name":"TRACE (psycholinguistics)","score":0.45903611183166504},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.16274693608283997}],"concepts":[{"id":"https://openalex.org/C71901391","wikidata":"https://www.wikidata.org/wiki/Q7126699","display_name":"Upload","level":2,"score":0.864546537399292},{"id":"https://openalex.org/C2781233147","wikidata":"https://www.wikidata.org/wiki/Q3229617","display_name":"Governor","level":2,"score":0.7977597117424011},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7590343952178955},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.6093498468399048},{"id":"https://openalex.org/C2780535194","wikidata":"https://www.wikidata.org/wiki/Q309901","display_name":"Open data","level":2,"score":0.5126734972000122},{"id":"https://openalex.org/C2778137410","wikidata":"https://www.wikidata.org/wiki/Q2732820","display_name":"Government (linguistics)","level":2,"score":0.48122310638427734},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.47190314531326294},{"id":"https://openalex.org/C75291252","wikidata":"https://www.wikidata.org/wiki/Q1315756","display_name":"TRACE (psycholinguistics)","level":2,"score":0.45903611183166504},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.16274693608283997},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C146978453","wikidata":"https://www.wikidata.org/wiki/Q3798668","display_name":"Aerospace engineering","level":1,"score":0.0},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3544548.3580868","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3544548.3580868","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2023 CHI Conference on Human Factors in Computing Systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320334593","display_name":"Natural Sciences and Engineering Research Council of Canada","ror":"https://ror.org/01h531d29"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":37,"referenced_works":["https://openalex.org/W1959365993","https://openalex.org/W2064766209","https://openalex.org/W2124293601","https://openalex.org/W2143677795","https://openalex.org/W2145154883","https://openalex.org/W2152191782","https://openalex.org/W2537262135","https://openalex.org/W2610332888","https://openalex.org/W2616147950","https://openalex.org/W2750991217","https://openalex.org/W2798664493","https://openalex.org/W2890036314","https://openalex.org/W2926805670","https://openalex.org/W2948163032","https://openalex.org/W2950817225","https://openalex.org/W2952342347","https://openalex.org/W2963174348","https://openalex.org/W2969723769","https://openalex.org/W2998702515","https://openalex.org/W3011590361","https://openalex.org/W3014616325","https://openalex.org/W3032215537","https://openalex.org/W3035461111","https://openalex.org/W3102543979","https://openalex.org/W3108941002","https://openalex.org/W3162028309","https://openalex.org/W3174181645","https://openalex.org/W3196867679","https://openalex.org/W3196877232","https://openalex.org/W3196904276","https://openalex.org/W3197661828","https://openalex.org/W3203841973","https://openalex.org/W4210312918","https://openalex.org/W4226451059","https://openalex.org/W4301391075","https://openalex.org/W4312453576","https://openalex.org/W6967422778"],"related_works":["https://openalex.org/W2364421152","https://openalex.org/W2350316906","https://openalex.org/W2362311891","https://openalex.org/W2353428922","https://openalex.org/W2099688617","https://openalex.org/W2382143911","https://openalex.org/W2382810175","https://openalex.org/W4255895656","https://openalex.org/W2107650963","https://openalex.org/W3212327361"],"abstract_inverted_index":{"The":[0],"launch":[1],"of":[2,14,20,59,109],"open":[3,11,53],"governmental":[4],"data":[5,12,21,54],"portals":[6],"(OGDPs)":[7],"has":[8],"popularized":[9],"the":[10,18,37,42,52,83,107,122,136],"movement":[13],"last":[15],"decade.":[16],"Although":[17],"amount":[19],"in":[22,82,125,143,148],"OGDPs":[23,71],"is":[24],"increasing,":[25],"their":[26,100,115],"functionalities":[27],"are":[28],"limited":[29],"to":[30,50,69,74,96,117,121],"finding":[31,144],"datasets":[32],"with":[33,130],"titles/descriptions":[34],"and":[35,56,90,93,114,135,141,145],"downloading":[36],"actual":[38,80],"files.":[39],"This":[40],"hinders":[41],"end":[43,75],"users,":[44],"especially":[45],"those":[46],"without":[47,88],"technical":[48],"skills,":[49],"find":[51],"tables":[55,95,111,124,147],"make":[57,70],"use":[58],"them.":[60],"We":[61,127],"present":[62],"Governor,":[63],"an":[64],"open-sourced[17]":[65],"web":[66],"application":[67],"developed":[68],"more":[72],"accessible":[73],"users":[76,97,113],"by":[77],"facilitating":[78],"searching":[79],"records":[81],"tables,":[84],"previewing":[85],"them":[86],"directly":[87],"downloading,":[89],"suggesting":[91],"joinable":[92],"unionable":[94],"based":[98],"on":[99],"latest":[101],"working":[102],"tables.":[103],"Governor":[104,129],"also":[105],"manages":[106],"provenance":[108],"integrated":[110],"allowing":[112],"collaborators":[116],"easily":[118],"trace":[119],"back":[120],"original":[123],"OGDP.":[126,149],"evaluate":[128],"a":[131],"two-part":[132],"user":[133],"study":[134],"results":[137],"demonstrate":[138],"its":[139],"value":[140],"effectiveness":[142],"integrating":[146]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":2}],"updated_date":"2026-04-14T08:04:32.555800","created_date":"2025-10-10T00:00:00"}