{"id":"https://openalex.org/W2187606973","doi":null,"title":"Topes: enabling end-user programmers to validate and reformat data","display_name":"Topes: enabling end-user programmers to validate and reformat data","alternate_titles":[],"publication_year":2009,"publication_date":"2009-01-01","ids":{"openalex":"https://openalex.org/W2187606973","mag":"2187606973"},"language":"en","primary_location":{"id":"mag:2187606973","doi":null,"is_oa":false,"landing_page_url":"http://reports-archive.adm.cs.cmu.edu/anon/isr2009/CMU-ISR-09-105.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W2187606973"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":[],"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/A5039863061","display_name":"Mary Shaw","orcid":"https://orcid.org/0000-0003-1337-4557","observed_orcids":["https://orcid.org/0000-0003-1337-4557"]},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Mary Shaw","raw_affiliation_strings":["Carnegie Mellon University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Carnegie Mellon University","institution_ids":["https://openalex.org/I74973139"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5112258462","display_name":"Christopher P. Scaffidi","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Christopher Scaffidi","raw_affiliation_strings":["Carnegie Mellon University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Carnegie Mellon University","institution_ids":["https://openalex.org/I74973139"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I74973139"],"apc_list":null,"apc_paid":null,"fwci":1.753,"has_fulltext":false,"cited_by_count":6,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.86014775,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":86,"max":93},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9955999851226807,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9955999851226807,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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.00039999998989515007,"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"}},{"id":"https://openalex.org/T10470","display_name":"Usability and User Interface Design","score":0.00039999998989515007,"subfield":{"id":"https://openalex.org/subfields/1709","display_name":"Human-Computer Interaction"},"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/tope","display_name":"TOPE","score":0.7020000219345093},{"id":"https://openalex.org/keywords/end-user-programming","display_name":"end-user programming","score":0.9760000109672546},{"id":"https://openalex.org/keywords/data-validation","display_name":"data validation","score":0.8140000104904175},{"id":"https://openalex.org/keywords/data-categories","display_name":"data categories","score":0.7260000109672546},{"id":"https://openalex.org/keywords/data-entry-automation","display_name":"data entry automation","score":0.3970000147819519}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7390569448471069},{"id":"https://openalex.org/C2778707766","wikidata":"https://www.wikidata.org/wiki/Q202064","display_name":"Phone","level":2,"score":0.6566221117973328},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.5643362402915955},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.538480818271637},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.4905380606651306},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.47673001885414124},{"id":"https://openalex.org/C157486923","wikidata":"https://www.wikidata.org/wiki/Q1376436","display_name":"String (physics)","level":2,"score":0.44367411732673645},{"id":"https://openalex.org/C182306322","wikidata":"https://www.wikidata.org/wiki/Q1779371","display_name":"Order (exchange)","level":2,"score":0.41863399744033813},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.34664928913116455},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.23215916752815247},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.18791934847831726},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","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/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","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":"mag:2187606973","doi":null,"is_oa":false,"landing_page_url":"http://reports-archive.adm.cs.cmu.edu/anon/isr2009/CMU-ISR-09-105.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":111,"referenced_works":["https://openalex.org/W7830157","https://openalex.org/W72571502","https://openalex.org/W95622558","https://openalex.org/W107061913","https://openalex.org/W139507382","https://openalex.org/W150601485","https://openalex.org/W323714017","https://openalex.org/W1497542708","https://openalex.org/W1500842519","https://openalex.org/W1502282368","https://openalex.org/W1506845741","https://openalex.org/W1507830038","https://openalex.org/W1522006088","https://openalex.org/W1537033052","https://openalex.org/W1537257884","https://openalex.org/W1540823594","https://openalex.org/W1551326568","https://openalex.org/W1557561422","https://openalex.org/W1558416165","https://openalex.org/W1560679009","https://openalex.org/W1571785228","https://openalex.org/W1577231857","https://openalex.org/W1577807563","https://openalex.org/W1606909255","https://openalex.org/W1610496399","https://openalex.org/W1649645444","https://openalex.org/W1713170780","https://openalex.org/W1767136531","https://openalex.org/W1800049145","https://openalex.org/W1808011207","https://openalex.org/W1813976027","https://openalex.org/W1964071625","https://openalex.org/W1966833950","https://openalex.org/W1970188685","https://openalex.org/W1984315811","https://openalex.org/W1992016565","https://openalex.org/W1992154356","https://openalex.org/W2000756694","https://openalex.org/W2011851251","https://openalex.org/W2013016844","https://openalex.org/W2015806650","https://openalex.org/W2016208194","https://openalex.org/W2018365488","https://openalex.org/W2024880014","https://openalex.org/W2032553192","https://openalex.org/W2034957383","https://openalex.org/W2054445012","https://openalex.org/W2058969248","https://openalex.org/W2064189581","https://openalex.org/W2071718761","https://openalex.org/W2073965851","https://openalex.org/W2080579313","https://openalex.org/W2082810026","https://openalex.org/W2088722209","https://openalex.org/W2093495548","https://openalex.org/W2098162425","https://openalex.org/W2101728371","https://openalex.org/W2102480769","https://openalex.org/W2103700531","https://openalex.org/W2103746998","https://openalex.org/W2103862636","https://openalex.org/W2105016726","https://openalex.org/W2105710547","https://openalex.org/W2106895292","https://openalex.org/W2107387337","https://openalex.org/W2107658650","https://openalex.org/W2112338634","https://openalex.org/W2115494521","https://openalex.org/W2115770258","https://openalex.org/W2118349261","https://openalex.org/W2118587067","https://openalex.org/W2120184974","https://openalex.org/W2120514094","https://openalex.org/W2121528215","https://openalex.org/W2121866145","https://openalex.org/W2123448890","https://openalex.org/W2124739719","https://openalex.org/W2125287837","https://openalex.org/W2126650630","https://openalex.org/W2129194414","https://openalex.org/W2131050047","https://openalex.org/W2132887549","https://openalex.org/W2135342207","https://openalex.org/W2135473121","https://openalex.org/W2137235241","https://openalex.org/W2138368560","https://openalex.org/W2141946720","https://openalex.org/W2141997418","https://openalex.org/W2146045419","https://openalex.org/W2146908974","https://openalex.org/W2147026797","https://openalex.org/W2147437931","https://openalex.org/W2148242152","https://openalex.org/W2150797121","https://openalex.org/W2151487645","https://openalex.org/W2151799802","https://openalex.org/W2154316249","https://openalex.org/W2154652861","https://openalex.org/W2154941560","https://openalex.org/W2157504474","https://openalex.org/W2167852913","https://openalex.org/W2170917596","https://openalex.org/W2171955640","https://openalex.org/W2395077608","https://openalex.org/W2759794735","https://openalex.org/W2890851524","https://openalex.org/W2894982825","https://openalex.org/W3009577598","https://openalex.org/W3083034919","https://openalex.org/W3122000667","https://openalex.org/W3141429908"],"related_works":["https://openalex.org/W2138368560","https://openalex.org/W6922049693","https://openalex.org/W6959489340","https://openalex.org/W2126650630","https://openalex.org/W6940606120","https://openalex.org/W6884748530","https://openalex.org/W2103746998","https://openalex.org/W2143213581","https://openalex.org/W1767136531","https://openalex.org/W7101000221"],"abstract_inverted_index":{"Millions":[0],"of":[1,98,128,170,256,275,295,348,367],"people":[2,51],"rely":[3],"on":[4],"software":[5,41,158],"for":[6,46,148,184,207,283,288,375],"help":[7,217,245],"with":[8,240,247,322],"everyday":[9],"tasks.":[10],"For":[11],"example,":[12,176],"a":[13,17,23,29,177,182,211,253,259,262,276,292,364],"teacher":[14],"might":[15,27,180],"create":[16,28,205,219],"spreadsheet":[18],"to":[19,32,156,204,221,244,270],"compute":[20],"grades,":[21],"and":[22,61,73,150,261,272,290,305,312,317,331],"human":[24],"resources":[25],"worker":[26],"web":[30,178,196],"form":[31,179,197],"collect":[33],"contact":[34],"information":[35],"from":[36,67],"co-workers.":[37],"\r\nYet,":[38],"too":[39],"often,":[40],"applications":[42,85,330],"offer":[43,200],"poor":[44],"support":[45],"automating":[47],"certain":[48],"activities,":[49],"which":[50],"must":[52],"do":[53,86,215],"manually.":[54],"In":[55],"particular,":[56],"many":[57],"tasks":[58],"require":[59],"validating":[60,149,289],"reformatting":[62,151,291],"short":[63],"human-readable":[64],"strings":[65,124,152,209,314],"drawn":[66],"categories":[68,79,297],"such":[69,123,230,356],"as":[70,130,231],"company":[71],"names":[72],"employee":[74],"ID":[75],"numbers.":[76],"These":[77],"string-containing":[78],"have":[80,181],"three":[81],"traits":[82],"that":[83,96,114,145,224,355],"existing":[84],"not":[87,154],"reflect.":[88],"First,":[89],"each":[90,97,108,140],"category":[91,109,141],"can":[92,101,110,310,321,358],"be":[93,102,359],"multi-format":[94],"in":[95,144],"its":[99,146,160],"instances":[100,274],"written":[103],"several":[104],"different":[105,333],"ways.":[106],"Second,":[107],"include":[111],"questionable":[112],"values":[113],"are":[115,126,132,153,162,225,280,327],"unusual":[116,226],"yet":[117],"still":[118],"valid.":[119],"During":[120],"user":[121],"tasks,":[122,249],"often":[125],"worthy":[127],"double-checking,":[129],"they":[131,216,320,362],"neither":[133],"obviously":[134,137],"valid":[135],"nor":[136,214],"invalid.":[138],"Third,":[139],"is":[142],"application-agnostic":[143,349],"rules":[147,161,287],"specific":[155],"one":[157],"application\u2014rather,":[159],"agreed":[163],"upon":[164],"implicitly":[165],"or":[166,173,193],"explicitly":[167],"by":[168,300,332,339],"members":[169],"an":[171],"organization":[172],"society.":[174],"\r\nFor":[175],"field":[183],"entering":[185],"Carnegie":[186],"Mellon":[187],"office":[188,235],"phone":[189,236],"numbers":[190,237],"like":[191],"8-3564":[192],"412-268-3564.":[194],"Current":[195],"design":[198],"tools":[199],"no":[201],"convenient":[202],"way":[203],"code":[206,220],"putting":[208],"into":[210],"consistent":[212],"format,":[213],"users":[218,246,309],"detect":[222],"inputs":[223],"but":[227],"maybe":[228],"valid,":[229],"7-3564":[232],"(since":[233],"our":[234],"rarely":[238],"start":[239],"7).":[241],"\r\nIn":[242],"order":[243],"their":[248],"this":[250],"dissertation":[251],"presents":[252],"new":[254,346],"kind":[255],"abstraction":[257],"called":[258],"tope":[267],"supporting":[263,376],"development":[264],"environment.":[265],"Each":[266],"describes":[268],"how":[269],"validate":[271,311],"reformat":[273,313],"data":[277,296],"category.":[278],"Topes":[279],"sufficiently":[281],"expressive":[282],"creating":[284,304],"useful,":[285],"accurate":[286],"wide":[293],"range":[294],"commonly":[298],"encountered":[299],"end":[301,308],"users.":[302],"By":[303],"applying":[306],"topes,":[307],"more":[315],"quickly":[316],"effectively":[318],"than":[319],"currently-practiced":[323],"techniques.":[324],"Tope":[325],"implementations":[326],"reusable":[328],"across":[329],"people,":[334],"highlighting":[335],"the":[336],"leverage":[337],"provided":[338],"end-user":[340],"programming":[341],"research":[342],"aimed":[343],"at":[344],"developing":[345],"kinds":[347],"abstractions.":[350],"The":[351],"topes":[352],"model":[353,363],"demonstrates":[354],"abstractions":[357],"successful":[360],"if":[361],"shallow":[365],"level":[366],"semantics,":[368],"thereby":[369],"retaining":[370],"usability":[371],"without":[372],"sacrificing":[373],"usefulness":[374],"users'":[377],"real-world":[378],"goals.":[379]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2187606973","counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-11-21T10:27:49.728292","created_date":"2016-06-24T00:00:00"}
