{"id":"https://openalex.org/W2050781086","doi":"https://doi.org/10.1145/1007996.1008055","title":"SQLator","display_name":"SQLator","publication_year":2004,"publication_date":"2004-06-28","ids":{"openalex":"https://openalex.org/W2050781086","doi":"https://doi.org/10.1145/1007996.1008055","mag":"2050781086"},"language":"en","primary_location":{"id":"doi:10.1145/1007996.1008055","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1007996.1008055","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 9th annual SIGCSE conference on Innovation and technology in computer science 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/A5070591850","display_name":"Shazia Sadiq","orcid":"https://orcid.org/0000-0001-6739-4145"},"institutions":[{"id":"https://openalex.org/I165143802","display_name":"The University of Queensland","ror":"https://ror.org/00rqy9422","country_code":"AU","type":"education","lineage":["https://openalex.org/I165143802"]}],"countries":["AU"],"is_corresponding":true,"raw_author_name":"Shazia Sadiq","raw_affiliation_strings":["The University of Queensland, St. Lucia, Australia"],"affiliations":[{"raw_affiliation_string":"The University of Queensland, St. Lucia, Australia","institution_ids":["https://openalex.org/I165143802"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5085238027","display_name":"Maria E. Or\u0142owska","orcid":"https://orcid.org/0000-0002-5234-7925"},"institutions":[{"id":"https://openalex.org/I165143802","display_name":"The University of Queensland","ror":"https://ror.org/00rqy9422","country_code":"AU","type":"education","lineage":["https://openalex.org/I165143802"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Maria Orlowska","raw_affiliation_strings":["The University of Queensland, St. Lucia, Australia"],"affiliations":[{"raw_affiliation_string":"The University of Queensland, St. Lucia, Australia","institution_ids":["https://openalex.org/I165143802"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Wasim Sadiq","orcid":null},"institutions":[{"id":"https://openalex.org/I4210153599","display_name":"Systems, Applications & Products in Data Processing (Australia)","ror":"https://ror.org/04c2m5174","country_code":"AU","type":"company","lineage":["https://openalex.org/I4210132444","https://openalex.org/I4210153599"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Wasim Sadiq","raw_affiliation_strings":["SAP Corporate Research Centre, Brisbane, Australia"],"affiliations":[{"raw_affiliation_string":"SAP Corporate Research Centre, Brisbane, Australia","institution_ids":["https://openalex.org/I4210153599"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5016219439","display_name":"Joe Lin","orcid":null},"institutions":[{"id":"https://openalex.org/I165143802","display_name":"The University of Queensland","ror":"https://ror.org/00rqy9422","country_code":"AU","type":"education","lineage":["https://openalex.org/I165143802"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Joe Lin","raw_affiliation_strings":["The University of Queensland, St. Lucia, Australia"],"affiliations":[{"raw_affiliation_string":"The University of Queensland, St. Lucia, Australia","institution_ids":["https://openalex.org/I165143802"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5070591850"],"corresponding_institution_ids":["https://openalex.org/I165143802"],"apc_list":null,"apc_paid":null,"fwci":1.2465,"has_fulltext":false,"cited_by_count":79,"citation_normalized_percentile":{"value":0.83928915,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":96,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"223","last_page":"227"},"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.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"}},"topics":[{"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/T11106","display_name":"Data Management and Algorithms","score":0.9851999878883362,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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.9847999811172485,"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/computer-science","display_name":"Computer science","score":0.8831140995025635},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.8043383955955505},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.6681811809539795},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5893226265907288},{"id":"https://openalex.org/keywords/correctness","display_name":"Correctness","score":0.4869559705257416},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4782946705818176},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.46739017963409424},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.4655493199825287},{"id":"https://openalex.org/keywords/heuristic","display_name":"Heuristic","score":0.4512809216976166},{"id":"https://openalex.org/keywords/syntax","display_name":"Syntax","score":0.4292924404144287},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.42824438214302063},{"id":"https://openalex.org/keywords/rdf-query-language","display_name":"RDF query language","score":0.42315420508384705},{"id":"https://openalex.org/keywords/function","display_name":"Function (biology)","score":0.4122962951660156},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.3936713635921478},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3620620667934418},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.35358381271362305},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.2940928339958191},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.24880075454711914},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.15796643495559692},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.12379646301269531}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8831140995025635},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8043383955955505},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.6681811809539795},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5893226265907288},{"id":"https://openalex.org/C55439883","wikidata":"https://www.wikidata.org/wiki/Q360812","display_name":"Correctness","level":2,"score":0.4869559705257416},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4782946705818176},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.46739017963409424},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.4655493199825287},{"id":"https://openalex.org/C173801870","wikidata":"https://www.wikidata.org/wiki/Q201413","display_name":"Heuristic","level":2,"score":0.4512809216976166},{"id":"https://openalex.org/C60048249","wikidata":"https://www.wikidata.org/wiki/Q37437","display_name":"Syntax","level":2,"score":0.4292924404144287},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.42824438214302063},{"id":"https://openalex.org/C96956885","wikidata":"https://www.wikidata.org/wiki/Q6138701","display_name":"RDF query language","level":5,"score":0.42315420508384705},{"id":"https://openalex.org/C14036430","wikidata":"https://www.wikidata.org/wiki/Q3736076","display_name":"Function (biology)","level":2,"score":0.4122962951660156},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.3936713635921478},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3620620667934418},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.35358381271362305},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.2940928339958191},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.24880075454711914},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.15796643495559692},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.12379646301269531},{"id":"https://openalex.org/C78458016","wikidata":"https://www.wikidata.org/wiki/Q840400","display_name":"Evolutionary biology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1007996.1008055","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1007996.1008055","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 9th annual SIGCSE conference on Innovation and technology in computer science education","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.6899999976158142,"display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":8,"referenced_works":["https://openalex.org/W30690199","https://openalex.org/W1544708267","https://openalex.org/W1975877325","https://openalex.org/W2039384225","https://openalex.org/W2137158242","https://openalex.org/W2412010644","https://openalex.org/W4245115917","https://openalex.org/W6601253193"],"related_works":["https://openalex.org/W644450836","https://openalex.org/W1548279772","https://openalex.org/W2897196530","https://openalex.org/W3196679839","https://openalex.org/W2353434938","https://openalex.org/W2991108389","https://openalex.org/W2406556739","https://openalex.org/W1504178769","https://openalex.org/W2970853428","https://openalex.org/W275517711"],"abstract_inverted_index":{"SQL":[0,30,98],"(Structured":[1],"Query":[2],"Language)":[3],"is":[4,44,55,74,117],"one":[5],"of":[6,29,67,97,109,150,176,184,202,210],"the":[7,26,56,65,85,112,140,154,163,171,182,200],"essential":[8],"topics":[9],"in":[10,14,152,168],"foundation":[11],"databases":[12,104],"courses":[13],"higher":[15],"education.":[16],"Due":[17],"to":[18,24,63,87,123,162],"its":[19],"apparent":[20],"simple":[21],"syntax,":[22],"learning":[23,50],"use":[25],"full":[27],"power":[28],"can":[31,129],"be":[32],"a":[33,45,61,106,147],"very":[34],"difficult":[35],"activity.":[36],"In":[37],"this":[38,169],"paper,":[39,170],"we":[40],"introduce":[41],"SQLator,":[42],"which":[43,59],"web-based":[46],"interactive":[47],"tool":[48,81],"for":[49],"SQL.":[51],"SQLator's":[52],"key":[53],"function":[54,145],"evaluate":[57,64,72,144],"function,":[58],"allows":[60],"user":[62,128],"correctness":[66],"his/her":[68],"query":[69,107,124,136],"formulation.":[70],"The":[71,80,115,126,142,208],"engine":[73],"based":[75,195],"on":[76,135,192,196],"complex":[77],"heuristic":[78],"algorithms.":[79],"also":[82],"provides":[83],"instructors":[84],"facility":[86],"create":[88],"and":[89,133,174,190,205],"populate":[90],"database":[91],"schemas":[92],"with":[93,105],"an":[94,187],"associated":[95],"pool":[96,108,116],"queries.":[99],"Currently":[100],"it":[101],"hosts":[102],"two":[103,113],"300+":[110],"across":[111],"databases.":[114],"divided":[118],"into":[119],"3":[120],"categories":[121],"according":[122],"complexity.":[125],"SQLator":[127,143,185],"perform":[130],"unlimited":[131],"executions":[132],"evaluations":[134],"formulations":[137],"and/or":[138],"view":[139],"solutions.":[141],"has":[146],"high":[148],"rate":[149],"success":[151],"evaluating":[153],"user's":[155],"statement":[156],"as":[157,186],"correct":[158],"(or":[159],"incorrect)":[160],"corresponding":[161],"question.":[164],"We":[165,178],"will":[166,179],"present":[167],"basic":[172],"architecture":[173],"functions":[175],"SQLator.":[177],"further":[180],"discuss":[181],"value":[183],"educational":[188,193],"technology":[189],"report":[191],"outcomes":[194],"studies":[197],"conducted":[198],"at":[199],"School":[201],"Information":[203],"Technology":[204],"Electrical":[206],"Engineering,":[207],"University":[209],"Queensland.":[211]},"counts_by_year":[{"year":2025,"cited_by_count":5},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":4},{"year":2021,"cited_by_count":6},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":6},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":8}],"updated_date":"2026-04-21T08:09:41.155169","created_date":"2016-06-24T00:00:00"}