{"id":"https://openalex.org/W4293098056","doi":"https://doi.org/10.1145/3478432.3499263","title":"I-Rex","display_name":"I-Rex","publication_year":2022,"publication_date":"2022-02-23","ids":{"openalex":"https://openalex.org/W4293098056","doi":"https://doi.org/10.1145/3478432.3499263"},"language":"en","primary_location":{"id":"doi:10.1145/3478432.3499263","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3478432.3499263","pdf_url":null,"source":{"id":"https://openalex.org/S4363608669","display_name":"Proceedings of the 53rd ACM Technical Symposium on Computer Science Education V. 2","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":"Proceedings of the 53rd ACM Technical Symposium on Computer Science Education V. 2","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/A5103206063","display_name":"Yihao Hu","orcid":"https://orcid.org/0009-0003-3048-3867"},"institutions":[{"id":"https://openalex.org/I170897317","display_name":"Duke University","ror":"https://ror.org/00py81415","country_code":"US","type":"education","lineage":["https://openalex.org/I170897317"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Yihao Hu","raw_affiliation_strings":["Duke University, Durham, NC, USA"],"affiliations":[{"raw_affiliation_string":"Duke University, Durham, NC, USA","institution_ids":["https://openalex.org/I170897317"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087858861","display_name":"Zhengjie Miao","orcid":"https://orcid.org/0009-0008-2371-1186"},"institutions":[{"id":"https://openalex.org/I170897317","display_name":"Duke University","ror":"https://ror.org/00py81415","country_code":"US","type":"education","lineage":["https://openalex.org/I170897317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zhengjie Miao","raw_affiliation_strings":["Duke University, Durham, NC, USA"],"affiliations":[{"raw_affiliation_string":"Duke University, Durham, NC, USA","institution_ids":["https://openalex.org/I170897317"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064968323","display_name":"Zhiming Leong","orcid":null},"institutions":[{"id":"https://openalex.org/I170897317","display_name":"Duke University","ror":"https://ror.org/00py81415","country_code":"US","type":"education","lineage":["https://openalex.org/I170897317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zhiming Leong","raw_affiliation_strings":["Duke University, Durham, NC, USA"],"affiliations":[{"raw_affiliation_string":"Duke University, Durham, NC, USA","institution_ids":["https://openalex.org/I170897317"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006356480","display_name":"Haechan Lim","orcid":null},"institutions":[{"id":"https://openalex.org/I170897317","display_name":"Duke University","ror":"https://ror.org/00py81415","country_code":"US","type":"education","lineage":["https://openalex.org/I170897317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Haechan Lim","raw_affiliation_strings":["Duke University, Durham, NC, USA"],"affiliations":[{"raw_affiliation_string":"Duke University, Durham, NC, USA","institution_ids":["https://openalex.org/I170897317"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5033332702","display_name":"Zachary Zheng","orcid":null},"institutions":[{"id":"https://openalex.org/I170897317","display_name":"Duke University","ror":"https://ror.org/00py81415","country_code":"US","type":"education","lineage":["https://openalex.org/I170897317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zachary Zheng","raw_affiliation_strings":["Duke University, Durham, NC, USA"],"affiliations":[{"raw_affiliation_string":"Duke University, Durham, NC, USA","institution_ids":["https://openalex.org/I170897317"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110322079","display_name":"Sudeepa Roy","orcid":null},"institutions":[{"id":"https://openalex.org/I170897317","display_name":"Duke University","ror":"https://ror.org/00py81415","country_code":"US","type":"education","lineage":["https://openalex.org/I170897317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sudeepa Roy","raw_affiliation_strings":["Duke University, Durham, NC, USA"],"affiliations":[{"raw_affiliation_string":"Duke University, Durham, NC, USA","institution_ids":["https://openalex.org/I170897317"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010307971","display_name":"K Stephens","orcid":"https://orcid.org/0000-0002-3058-7418"},"institutions":[{"id":"https://openalex.org/I170897317","display_name":"Duke University","ror":"https://ror.org/00py81415","country_code":"US","type":"education","lineage":["https://openalex.org/I170897317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kristin Stephens-Martinez","raw_affiliation_strings":["Duke University, Durham, NC, USA"],"affiliations":[{"raw_affiliation_string":"Duke University, Durham, NC, USA","institution_ids":["https://openalex.org/I170897317"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5113873534","display_name":"Jun Yang","orcid":null},"institutions":[{"id":"https://openalex.org/I170897317","display_name":"Duke University","ror":"https://ror.org/00py81415","country_code":"US","type":"education","lineage":["https://openalex.org/I170897317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jun Yang","raw_affiliation_strings":["Duke University, Durham, NC, USA"],"affiliations":[{"raw_affiliation_string":"Duke University, Durham, NC, USA","institution_ids":["https://openalex.org/I170897317"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":8,"corresponding_author_ids":["https://openalex.org/A5103206063"],"corresponding_institution_ids":["https://openalex.org/I170897317"],"apc_list":null,"apc_paid":null,"fwci":0.4284,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.47623862,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"1180","last_page":"1180"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9824000000953674,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9824000000953674,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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.9596999883651733,"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"}},{"id":"https://openalex.org/T11948","display_name":"Machine Learning in Materials Science","score":0.9569000005722046,"subfield":{"id":"https://openalex.org/subfields/2505","display_name":"Materials Chemistry"},"field":{"id":"https://openalex.org/fields/25","display_name":"Materials Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/debugger","display_name":"Debugger","score":0.9191124439239502},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.875717282295227},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7736284732818604},{"id":"https://openalex.org/keywords/debugging","display_name":"Debugging","score":0.7717874050140381},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.6686785221099854},{"id":"https://openalex.org/keywords/trace","display_name":"TRACE (psycholinguistics)","score":0.5654662847518921},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.516026496887207},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.47626635432243347},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.43326711654663086},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4089148938655853},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3081951439380646},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.15244874358177185}],"concepts":[{"id":"https://openalex.org/C2778485113","wikidata":"https://www.wikidata.org/wiki/Q193231","display_name":"Debugger","level":3,"score":0.9191124439239502},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.875717282295227},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7736284732818604},{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.7717874050140381},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.6686785221099854},{"id":"https://openalex.org/C75291252","wikidata":"https://www.wikidata.org/wiki/Q1315756","display_name":"TRACE (psycholinguistics)","level":2,"score":0.5654662847518921},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.516026496887207},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.47626635432243347},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.43326711654663086},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4089148938655853},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3081951439380646},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.15244874358177185},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"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/3478432.3499263","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3478432.3499263","pdf_url":null,"source":{"id":"https://openalex.org/S4363608669","display_name":"Proceedings of the 53rd ACM Technical Symposium on Computer Science Education V. 2","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":"Proceedings of the 53rd ACM Technical Symposium on Computer Science Education V. 2","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.7200000286102295,"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2115737686","https://openalex.org/W1970548936","https://openalex.org/W2367232817","https://openalex.org/W2382501300","https://openalex.org/W2580141483","https://openalex.org/W4301301234","https://openalex.org/W2951098239","https://openalex.org/W4254102710","https://openalex.org/W2765675213","https://openalex.org/W107403514"],"abstract_inverted_index":{"Despite":[0],"the":[1,54,74,91,137,189,192],"enduring":[2],"popularity":[3],"of":[4,28,56,93,104,139,167],"SQL":[5,29,47,133,168,179],"(Structured":[6],"Query":[7],"Language),":[8],"it":[9],"is":[10,24],"challenging":[11],"to":[12,52],"learn":[13,136],"and":[14,39,72,143,181,187],"debug,":[15],"even":[16],"for":[17,119,164],"people":[18],"with":[19,31],"considerable":[20],"programming":[21],"experience.":[22],"There":[23],"also":[25,156],"a":[26,57,129,146,159,165,171],"lack":[27],"tools":[30],"advanced":[32],"debugger":[33,48],"features":[34],"like":[35],"breakpoints,":[36],"stepped":[37],"execution,":[38,135],"variable":[40],"watching.":[41],"We":[42,155],"present":[43],"I-Rex,":[44],"an":[45,84],"interactive":[46],"that":[49],"enables":[50],"users":[51],"trace":[53,131],"evaluation":[55],"query":[58,134,141,147],"by":[59,89],"its":[60,70],"constituent":[61],"blocks,":[62],"visualizing":[63],"how":[64,126,158,176],"each":[65],"block":[66],"computes":[67],"results":[68,92],"from":[69],"inputs,":[71],"exploring":[73],"dependencies":[75],"among":[76],"these":[77],"blocks.":[78],"I-Rex":[79,113,127,163,177],"can":[80,161],"be":[81],"integrated":[82],"into":[83],"autograder,":[85],"which":[86,109],"typically":[87],"works":[88],"comparing":[90],"submitted":[94],"queries":[95,98],"against":[96],"reference":[97],"over":[99,170],"test":[100,107],"database":[101],"instances.":[102],"Instead":[103],"showing":[105],"full":[106],"instances,":[108],"often":[110],"overwhelm":[111],"students,":[112],"automatically":[114],"generates":[115],"small,":[116],"illustrative":[117],"instances":[118],"debugging.":[120],"In":[121],"this":[122],"demo,":[123],"we":[124,174],"show":[125,157],"helps":[128],"student":[130],"complex":[132],"semantics":[138],"various":[140],"constructs,":[142],"understand":[144],"why":[145],"produces":[148],"(or":[149],"does":[150],"not":[151],"produce)":[152],"certain":[153],"results.":[154],"teacher":[160],"customize":[162],"set":[166],"exercises":[169],"database.":[172],"Overall,":[173],"demonstrate":[175],"supports":[178],"learning":[180],"debugging,":[182],"thereby":[183],"increasing":[184],"students'":[185],"self-reliance":[186],"reducing":[188],"burden":[190],"on":[191],"teaching":[193],"staff.":[194]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2022-08-26T00:00:00"}