{"id":"https://openalex.org/W7095314968","doi":null,"title":"Computer Assisted Assessment of SQL Query Skills. Retrieved 1st September, 2006. http://www.sci.usq.edu.au/research/workingpapers/sc-mc-0610.ps","display_name":"Computer Assisted Assessment of SQL Query Skills. Retrieved 1st September, 2006. http://www.sci.usq.edu.au/research/workingpapers/sc-mc-0610.ps","alternate_titles":[],"publication_year":null,"publication_date":null,"ids":{"openalex":"https://openalex.org/W7095314968"},"language":"en","primary_location":{"id":"pmh:oai:CiteSeerX.psu:10.1.1.296.727","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.296.727","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://crpit.com/confpapers/CRPITV63Dekeyser.pdf","raw_type":"text"},"parent_works":[],"lineage":["https://openalex.org/W7095314968"],"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/A5044570142","display_name":"Stijn Dekeyser","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Stijn Dekeyser","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5077546613","display_name":"Michael de RAADT","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Michael Raadt","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5088439469","display_name":"Tien Yu Lee","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Tien Yu Lee","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":true,"primary_topic":{"id":"https://openalex.org/T10533","display_name":"Teaching and Learning Programming","score":0.9276999831199646,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"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/T10533","display_name":"Teaching and Learning Programming","score":0.9276999831199646,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"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/T14025","display_name":"Educational Technology and Assessment","score":0.03579999879002571,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.008700000122189522,"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/sql","display_name":"SQL","score":0.5509999990463257},{"id":"https://openalex.org/keywords/computer-based-testing","display_name":"computer-based testing","score":0.8220000267028809},{"id":"https://openalex.org/keywords/query-writing","display_name":"query writing","score":0.4339999854564667},{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.8360000252723694},{"id":"https://openalex.org/keywords/automated-assessment","display_name":"automated assessment","score":0.6819999814033508},{"id":"https://openalex.org/keywords/semantic-feedback","display_name":"semantic feedback","score":0.9589999914169312},{"id":"https://openalex.org/keywords/peer-review","display_name":"peer review","score":0.9710000157356262},{"id":"https://openalex.org/keywords/database-education","display_name":"database education","score":0.8569999933242798}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8684999942779541},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5928000211715698},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5842000246047974},{"id":"https://openalex.org/C12713177","wikidata":"https://www.wikidata.org/wiki/Q1900281","display_name":"Perspective (graphical)","level":2,"score":0.46939998865127563},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.46480000019073486},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.43070000410079956},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.40049999952316284},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.38760000467300415},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.3582000136375427},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.34769999980926514},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.33709999918937683},{"id":"https://openalex.org/C117667704","wikidata":"https://www.wikidata.org/wiki/Q2011708","display_name":"Object Query Language","level":5,"score":0.33500000834465027},{"id":"https://openalex.org/C96956885","wikidata":"https://www.wikidata.org/wiki/Q6138701","display_name":"RDF query language","level":5,"score":0.3061999976634979},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.30390000343322754},{"id":"https://openalex.org/C48103436","wikidata":"https://www.wikidata.org/wiki/Q599031","display_name":"State (computer science)","level":2,"score":0.2955999970436096},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.2937999963760376},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2874999940395355},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.2865000069141388},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.2815000116825104},{"id":"https://openalex.org/C2778625365","wikidata":"https://www.wikidata.org/wiki/Q5227393","display_name":"Database application","level":2,"score":0.2750999927520752},{"id":"https://openalex.org/C2989070954","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database query","level":2,"score":0.2648000121116638},{"id":"https://openalex.org/C32977378","wikidata":"https://www.wikidata.org/wiki/Q604737","display_name":"Data control language","level":5,"score":0.2644999921321869}],"mesh":[],"locations_count":1,"locations":[{"id":"pmh:oai:CiteSeerX.psu:10.1.1.296.727","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.296.727","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://crpit.com/confpapers/CRPITV63Dekeyser.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.9235000014305115,"display_name":"Quality education"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W1606424393","https://openalex.org/W2020126579","https://openalex.org/W1608013224","https://openalex.org/W4220675766","https://openalex.org/W6964977191","https://openalex.org/W2809284492","https://openalex.org/W2529969364","https://openalex.org/W2084734886","https://openalex.org/W2547115911","https://openalex.org/W4293218583"],"abstract_inverted_index":{"Structured":[0],"Query":[1],"Language":[2],"(SQL)":[3],"is":[4,14,29],"the":[5,27,85,99,105,116,120],"dominant":[6],"language":[7,28],"for":[8,143,154],"querying":[9,72],"relational":[10],"databases":[11],"today,":[12],"and":[13,34,68,79,90,101,133,151],"an":[15],"essential":[16],"topic":[17],"in":[18,22,46],"introductory":[19],"database":[20,88,131],"courses":[21],"higher":[23],"education.":[24],"Even":[25],"though":[26],"syntactically":[30],"simple,":[31],"relatively":[32],"concise,":[33],"highly":[35],"structured,":[36],"students":[37,62],"experience":[38,142],"many":[39],"difficulties":[40],"while":[41],"learning":[42,141],"to":[43,60,64,69,136],"express":[44],"queries":[45],"SQL.":[47],"In":[48,74],"recent":[49],"years":[50],"a":[51,95,111,139],"small":[52],"number":[53],"of":[54,87,119],"software":[55],"tools":[56,82],"have":[57],"been":[58],"proposed":[59],"help":[61],"learn":[63],"write":[65],"query":[66],"statements":[67],"assess":[70],"their":[71],"skills.":[73],"this":[75],"paper":[76],"we":[77,107],"compare":[78],"evaluate":[80],"existing":[81],"mainly":[83],"from":[84,94],"perspective":[86],"theory":[89],"practice,":[91],"but":[92],"also":[93],"pedagogical":[96],"perspective.":[97],"Addressing":[98],"deficiencies":[100],"opportunities":[102],"uncovered":[103],"by":[104,122],"evaluation,":[106],"then":[108],"introduce":[109],"SQLify,":[110],"new":[112],"tool":[113],"that":[114],"extends":[115],"current":[117],"state":[118],"art":[121],"incorporating":[123],"semantic":[124],"feedback,":[125],"enhanced":[126],"automatic":[127],"assessment":[128,149],"based":[129],"on":[130],"theory,":[132],"peer":[134],"review":[135],"arrive":[137],"at":[138],"richer":[140],"students,":[144],"as":[145,147],"well":[146],"consistent":[148],"results":[150],"reduced":[152],"marking":[153],"instructors.":[155]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W7095314968","counts_by_year":[],"updated_date":"2026-11-14T11:04:58.165337","created_date":"2025-10-27T00:00:00"}
