{"id":"https://openalex.org/W4281868556","doi":"https://doi.org/10.1145/3531072.3535325","title":"Instructional Design for Teaching Relational Query Optimization to Undergraduates","display_name":"Instructional Design for Teaching Relational Query Optimization to Undergraduates","publication_year":2022,"publication_date":"2022-06-07","ids":{"openalex":"https://openalex.org/W4281868556","doi":"https://doi.org/10.1145/3531072.3535325"},"language":"en","primary_location":{"id":"doi:10.1145/3531072.3535325","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3531072.3535325","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"1st International Workshop on Data Systems Education","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/A5080407760","display_name":"Karen Davis","orcid":"https://orcid.org/0000-0003-2327-4429"},"institutions":[{"id":"https://openalex.org/I83328450","display_name":"Miami University","ror":"https://ror.org/05nbqxr67","country_code":"US","type":"education","lineage":["https://openalex.org/I83328450"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Karen Collins Davis","raw_affiliation_strings":["Miami University, USA"],"affiliations":[{"raw_affiliation_string":"Miami University, USA","institution_ids":["https://openalex.org/I83328450"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5080407760"],"corresponding_institution_ids":["https://openalex.org/I83328450"],"apc_list":null,"apc_paid":null,"fwci":0.5527,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.66192606,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"44","last_page":"50"},"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.9697999954223633,"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.9697999954223633,"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.9064000248908997,"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.8140588402748108},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6863533854484558},{"id":"https://openalex.org/keywords/scope","display_name":"Scope (computer science)","score":0.6551352143287659},{"id":"https://openalex.org/keywords/relation","display_name":"Relation (database)","score":0.5534030199050903},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.5484699010848999},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.529957115650177},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4759666323661804},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.34728801250457764},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.29770100116729736},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.28280261158943176},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.23553812503814697}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8140588402748108},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6863533854484558},{"id":"https://openalex.org/C2778012447","wikidata":"https://www.wikidata.org/wiki/Q1034415","display_name":"Scope (computer science)","level":2,"score":0.6551352143287659},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.5534030199050903},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.5484699010848999},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.529957115650177},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4759666323661804},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.34728801250457764},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.29770100116729736},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.28280261158943176},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.23553812503814697}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3531072.3535325","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3531072.3535325","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"1st International Workshop on Data Systems Education","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality Education","score":0.8500000238418579,"id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2573939812","https://openalex.org/W2120098008","https://openalex.org/W2898886863","https://openalex.org/W1639806124","https://openalex.org/W2902831276","https://openalex.org/W2165259096","https://openalex.org/W2356335648","https://openalex.org/W2540682188","https://openalex.org/W2545844851","https://openalex.org/W4385834214"],"abstract_inverted_index":{"This":[0],"paper":[1],"discusses":[2],"learning":[3,27,77,140],"outcomes,":[4,78],"instructional":[5,114],"materials,":[6],"software":[7],"tools,":[8],"and":[9,41,45,48,79,97,101,131,144],"experiences":[10],"in":[11,16],"teaching":[12],"relational":[13],"query":[14,34],"optimization":[15,93],"an":[17,122],"undergraduate":[18],"database":[19,90],"systems":[20],"course.":[21],"The":[22,55,113],"pre-requisite":[23],"topics":[24],"for":[25,43,125],"the":[26,49,80,108,126,129,132,162],"module":[28,56,81,155],"are":[29,73],"basic":[30],"familiarity":[31],"with":[32,65,83,161],"SQL":[33],"writing,":[35],"data":[36],"structures":[37],"(e.g.,":[38],"search":[39],"trees":[40],"algorithms":[42,103],"linear":[44],"binary":[46],"searching),":[47],"mathematical":[50],"definition":[51],"of":[52,89,99,110,134,150],"a":[53,62,84],"relation.":[54],"is":[57,157],"designed":[58],"to":[59,75,120,138,146],"fit":[60],"within":[61],"6-week":[63],"period":[64],"two":[66],"80-minute":[67],"class":[68],"sessions":[69],"per":[70],"week.":[71],"Quizzes":[72],"used":[74],"reinforce":[76],"culminates":[82],"multi-phase":[85],"project":[86],"covering":[87],"computation":[88],"statistics,":[91],"logical":[92],"using":[94],"algebraic":[95],"transformations,":[96],"performance":[98],"selection":[100],"join":[102],"as":[104,106],"well":[105],"computing":[107],"cost":[109],"execution":[111],"trees.":[112],"design":[115,156],"poses":[116],"several":[117],"challenges:":[118],"how":[119,137,145],"define":[121],"appropriate":[123],"scope":[124],"material":[127],"given":[128],"duration":[130],"level":[133],"student":[135,151],"preparation,":[136],"scaffold":[139],"complex,":[141],"inter-twined":[142],"topics,":[143],"create":[147],"effective":[148],"assessments":[149],"learning.":[152],"One":[153],"possible":[154],"illustrated":[158],"here,":[159],"along":[160],"lessons":[163],"learned":[164],"from":[165],"deploying":[166],"it.":[167]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}