{"id":"https://openalex.org/W2760451554","doi":"https://doi.org/10.1145/3125659.3125688","title":"Database Query Analyzer (DBQA)","display_name":"Database Query Analyzer (DBQA)","publication_year":2017,"publication_date":"2017-09-27","ids":{"openalex":"https://openalex.org/W2760451554","doi":"https://doi.org/10.1145/3125659.3125688","mag":"2760451554"},"language":"en","primary_location":{"id":"doi:10.1145/3125659.3125688","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3125659.3125688","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 18th Annual Conference on Information Technology 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/A5000931506","display_name":"Ryan Hardt","orcid":"https://orcid.org/0000-0003-4201-3195"},"institutions":[{"id":"https://openalex.org/I124727415","display_name":"University of Wisconsin\u2013Eau Claire","ror":"https://ror.org/03mnm0t94","country_code":"US","type":"education","lineage":["https://openalex.org/I124727415"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Ryan Hardt","raw_affiliation_strings":["University of Wisconsin - Eau Claire, Eau Claire, WI, USA"],"affiliations":[{"raw_affiliation_string":"University of Wisconsin - Eau Claire, Eau Claire, WI, USA","institution_ids":["https://openalex.org/I124727415"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5086555820","display_name":"Esther Gutzmer","orcid":null},"institutions":[{"id":"https://openalex.org/I124727415","display_name":"University of Wisconsin\u2013Eau Claire","ror":"https://ror.org/03mnm0t94","country_code":"US","type":"education","lineage":["https://openalex.org/I124727415"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Esther Gutzmer","raw_affiliation_strings":["University of Wisconsin - Eau Claire, Eau Claire, WI, USA"],"affiliations":[{"raw_affiliation_string":"University of Wisconsin - Eau Claire, Eau Claire, WI, USA","institution_ids":["https://openalex.org/I124727415"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5000931506"],"corresponding_institution_ids":["https://openalex.org/I124727415"],"apc_list":null,"apc_paid":null,"fwci":0.2072,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.57278264,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"147","last_page":"152"},"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.9993000030517578,"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.9993000030517578,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9962000250816345,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9850000143051147,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.8901588320732117},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.7430126667022705},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7155470848083496},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.6168409585952759},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.6098026037216187},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5509572625160217},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.46195435523986816},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.45549190044403076},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.42959505319595337},{"id":"https://openalex.org/keywords/syntax","display_name":"Syntax","score":0.42603030800819397},{"id":"https://openalex.org/keywords/data-manipulation-language","display_name":"Data manipulation language","score":0.4193613827228546},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.4181930720806122},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.4175720512866974},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3974452018737793},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3492323160171509},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.3243495225906372},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.2415369153022766},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.1965549886226654}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8901588320732117},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.7430126667022705},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7155470848083496},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.6168409585952759},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.6098026037216187},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5509572625160217},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.46195435523986816},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.45549190044403076},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.42959505319595337},{"id":"https://openalex.org/C60048249","wikidata":"https://www.wikidata.org/wiki/Q37437","display_name":"Syntax","level":2,"score":0.42603030800819397},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.4193613827228546},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.4181930720806122},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.4175720512866974},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3974452018737793},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3492323160171509},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.3243495225906372},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.2415369153022766},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.1965549886226654},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3125659.3125688","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3125659.3125688","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 18th Annual Conference on Information Technology Education","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.699999988079071,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W1964523235","https://openalex.org/W2020126579","https://openalex.org/W2055447088","https://openalex.org/W2095026299","https://openalex.org/W2132032354","https://openalex.org/W2286501037","https://openalex.org/W2473995384"],"related_works":["https://openalex.org/W2750425440","https://openalex.org/W2809743883","https://openalex.org/W619366292","https://openalex.org/W2912795851","https://openalex.org/W4210641636","https://openalex.org/W2377373248","https://openalex.org/W106036922","https://openalex.org/W621362137","https://openalex.org/W218121808","https://openalex.org/W2557197178"],"abstract_inverted_index":{"While":[0,57],"SQL":[1,23,68,94,138],"has":[2],"a":[3,8,36,98],"relatively":[4],"simple":[5],"syntax":[6,72],"with":[7,51,115],"small":[9],"set":[10],"of":[11,66,131],"commands,":[12],"it":[13],"allows":[14],"for":[15,137,154],"complex":[16,132],"query":[17,69,78,107],"construction":[18],"that":[19,41,87],"is":[20,24],"deceptively":[21],"challenging.":[22],"often":[25],"the":[26,45,64,85,129,151],"first":[27],"declarative":[28],"programming":[29,49,121],"language":[30],"learned":[31],"by":[32,83],"students,":[33],"which":[34,52,144],"requires":[35],"different":[37],"analysis":[38],"approach":[39,105],"than":[40],"used":[42],"to":[43,61,106,109,113,123,148,156],"understand":[44,128],"procedural":[46,118],"or":[47,70,119],"object-oriented":[48,120],"paradigms":[50],"students":[53,155],"are":[54],"more":[55,111],"familiar.":[56],"some":[58],"tools":[59,75],"exist":[60],"help":[62,124],"assess":[63],"correctness":[65],"an":[67,93],"address":[71],"errors,":[73],"few":[74],"focus":[76],"on":[77,92],"semantics.":[79],"DBQA":[80,134],"does":[81],"so":[82],"illustrating":[84],"effects":[86],"clauses":[88],"and":[89,122,142],"conditions":[90],"have":[91,145],"SELECT":[95],"statement":[96],"using":[97],"visualized,":[99],"data-oriented":[100],"approach.":[101],"We":[102],"expect":[103],"DBQA's":[104],"evaluation":[108],"feel":[110],"familiar":[112],"those":[114,125],"experience":[116],"in":[117],"users":[126],"better":[127],"semantics":[130],"queries.":[133],"includes":[135],"support":[136],"queries":[139],"containing":[140],"JOINs":[141],"subqueries,":[143],"been":[146],"shown":[147],"be":[149],"among":[150],"most":[152],"difficult":[153],"construct.":[157]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2020,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}