{"id":"https://openalex.org/W4407771480","doi":"https://doi.org/10.1145/3641554.3701812","title":"Experience Report on Using LANTERN in Teaching Relational Query Processing","display_name":"Experience Report on Using LANTERN in Teaching Relational Query Processing","publication_year":2025,"publication_date":"2025-02-12","ids":{"openalex":"https://openalex.org/W4407771480","doi":"https://doi.org/10.1145/3641554.3701812"},"language":"en","primary_location":{"id":"doi:10.1145/3641554.3701812","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3641554.3701812","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 56th ACM Technical Symposium on Computer Science Education V. 1","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1145/3641554.3701812","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5061002947","display_name":"Sourav S. Bhowmick","orcid":"https://orcid.org/0000-0003-1957-8016"},"institutions":[{"id":"https://openalex.org/I172675005","display_name":"Nanyang Technological University","ror":"https://ror.org/02e7b5302","country_code":"SG","type":"education","lineage":["https://openalex.org/I172675005"]}],"countries":["SG"],"is_corresponding":true,"raw_author_name":"Sourav S Bhowmick","raw_affiliation_strings":["Nanyang Technological University, Singapore, Singapore"],"affiliations":[{"raw_affiliation_string":"Nanyang Technological University, Singapore, Singapore","institution_ids":["https://openalex.org/I172675005"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100423964","display_name":"Hui Li","orcid":"https://orcid.org/0000-0003-2382-6289"},"institutions":[{"id":"https://openalex.org/I149594827","display_name":"Xidian University","ror":"https://ror.org/05s92vm98","country_code":"CN","type":"education","lineage":["https://openalex.org/I149594827"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Hui Li","raw_affiliation_strings":["Xidian University, Xi'an, China"],"affiliations":[{"raw_affiliation_string":"Xidian University, Xi'an, China","institution_ids":["https://openalex.org/I149594827"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5061002947"],"corresponding_institution_ids":["https://openalex.org/I172675005"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.03141058,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"123","last_page":"129"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9907000064849854,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9907000064849854,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9878000020980835,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9839000105857849,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7766872644424438},{"id":"https://openalex.org/keywords/lantern","display_name":"Lantern","score":0.6796807050704956},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.506791889667511},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.49386245012283325},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.4695867896080017},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.3787902593612671},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3768647611141205},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.12051558494567871}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7766872644424438},{"id":"https://openalex.org/C2777414711","wikidata":"https://www.wikidata.org/wiki/Q862454","display_name":"Lantern","level":3,"score":0.6796807050704956},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.506791889667511},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.49386245012283325},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.4695867896080017},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.3787902593612671},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3768647611141205},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.12051558494567871},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C178790620","wikidata":"https://www.wikidata.org/wiki/Q11351","display_name":"Organic chemistry","level":1,"score":0.0},{"id":"https://openalex.org/C2780378348","wikidata":"https://www.wikidata.org/wiki/Q25351438","display_name":"Ring (chemistry)","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3641554.3701812","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3641554.3701812","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 56th ACM Technical Symposium on Computer Science Education V. 1","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3641554.3701812","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3641554.3701812","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 56th ACM Technical Symposium on Computer Science Education V. 1","raw_type":"proceedings-article"},"sustainable_development_goals":[{"display_name":"Quality Education","score":0.47999998927116394,"id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W1569403765","https://openalex.org/W1594737854","https://openalex.org/W1991271936","https://openalex.org/W2050781086","https://openalex.org/W2071100465","https://openalex.org/W2129741299","https://openalex.org/W2888242042","https://openalex.org/W2963562081","https://openalex.org/W3009936914","https://openalex.org/W3033286267","https://openalex.org/W3034086986","https://openalex.org/W3046744391","https://openalex.org/W3047890686","https://openalex.org/W3168999116","https://openalex.org/W3209496184","https://openalex.org/W4205398141","https://openalex.org/W4282016830","https://openalex.org/W4283705032","https://openalex.org/W4291476001","https://openalex.org/W4323033893","https://openalex.org/W6633961643"],"related_works":["https://openalex.org/W2096359267","https://openalex.org/W3125756434","https://openalex.org/W2184296057","https://openalex.org/W4256058599","https://openalex.org/W2362460270","https://openalex.org/W1793997780","https://openalex.org/W2392799717","https://openalex.org/W2538384344","https://openalex.org/W185198413","https://openalex.org/W2901901036"],"abstract_inverted_index":{"The":[0],"database":[1,118],"systems":[2,119],"course":[3,37,120],"in":[4,35,46,61,106,116],"undergraduate":[5],"computer":[6],"science":[7],"programs":[8],"has":[9],"become":[10],"increasingly":[11],"important":[12],"due":[13],"to":[14,39,71,90,110,143,161,168],"the":[15,23,68,117,134,140,174],"widespread":[16],"use":[17],"of":[18,26,99,113,133,183,193,197],"relational":[19,198],"databases":[20],"(RDBMS)":[21],"and":[22,163,180],"growing":[24],"field":[25],"Data":[27],"Science.":[28],"A":[29],"primary":[30],"learning":[31,196],"objective":[32],"for":[33,88],"students":[34,89,114,160],"this":[36,93],"is":[38],"understand":[40],"how":[41,151],"SQL":[42],"queries":[43],"are":[44],"executed":[45],"practice":[47],"within":[48],"an":[49,52],"RDBMS.":[50],"Typically,":[51],"off-the-shelf":[53],"RDBMS":[54,142],"provides":[55],"a":[56,73,101,128,145,155],"query":[57,199],"execution":[58,135],"plan":[59],"(QEP)":[60,137],"either":[62],"visual":[63],"or":[64],"textual":[65],"format,":[66],"detailing":[67],"steps":[69],"taken":[70],"execute":[72],"given":[74],"query.":[75,147],"However,":[76],"these":[77],"QEPs":[78,166],"contain":[79],"vendor-specific":[80],"implementation":[81],"details":[82],"that":[83,158],"can":[84],"often":[85],"be":[86],"overwhelming":[87],"grasp.":[91],"In":[92],"paper,":[94],"we":[95,172,189],"discuss":[96,190],"our":[97,187],"experience":[98],"using":[100],"state-of-the-art":[102],"tool":[103,157],"called":[104],"lantern":[105,126,152,194],"teaching":[107],"QEP":[108],"s":[109],"two":[111],"cohorts":[112],"enrolled":[115],"at":[121],"Nanyang":[122],"Technological":[123],"University.":[124],"Specifically,":[125],"generates":[127],"natural":[129],"language":[130],"(NL)-based":[131],"description":[132],"strategy":[136],"chosen":[138],"by":[139],"underlying":[141],"process":[144],"user-specified":[146],"We":[148],"emphasize":[149],"on":[150,186],"serves":[153],"as":[154],"supplementary":[156],"allows":[159],"explore":[162],"learn":[164],"about":[165],"related":[167],"their":[169,181],"queries.":[170],"Additionally,":[171],"analyze":[173],"correlation":[175],"between":[176],"students'":[177],"academic":[178],"performance":[179],"usage":[182],"lantern.":[184],"Drawing":[185],"experiences,":[188],"future":[191],"directions":[192],"-augmented":[195],"processing.":[200]},"counts_by_year":[],"updated_date":"2025-12-28T23:10:05.387466","created_date":"2025-10-10T00:00:00"}