{"id":"https://openalex.org/W2534674944","doi":"https://doi.org/10.1080/10494820.2016.1244084","title":"Recommender system for learning SQL using hints","display_name":"Recommender system for learning SQL using hints","publication_year":2016,"publication_date":"2016-10-17","ids":{"openalex":"https://openalex.org/W2534674944","doi":"https://doi.org/10.1080/10494820.2016.1244084","mag":"2534674944"},"language":"en","primary_location":{"id":"doi:10.1080/10494820.2016.1244084","is_oa":false,"landing_page_url":"https://doi.org/10.1080/10494820.2016.1244084","pdf_url":null,"source":{"id":"https://openalex.org/S90466346","display_name":"Interactive Learning Environments","issn_l":"1049-4820","issn":["1049-4820","1744-5191"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320547","host_organization_name":"Taylor & Francis","host_organization_lineage":["https://openalex.org/P4310320547"],"host_organization_lineage_names":["Taylor & Francis"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Interactive Learning Environments","raw_type":"journal-article"},"type":"article","indexed_in":["arxiv","crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/1807.02637","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Dejan Lavbi\u010d","orcid":"https://orcid.org/0000-0003-2390-4160"},"institutions":[{"id":"https://openalex.org/I153976015","display_name":"University of Ljubljana","ror":"https://ror.org/05njb9z20","country_code":"SI","type":"education","lineage":["https://openalex.org/I153976015"]}],"countries":["SI"],"is_corresponding":true,"raw_author_name":"Dejan Lavbi\u010d","raw_affiliation_strings":["Faculty of Computer and Information Science, University of Ljubljana, Ljubljana, Slovenia"],"raw_orcid":"https://orcid.org/0000-0003-2390-4160","affiliations":[{"raw_affiliation_string":"Faculty of Computer and Information Science, University of Ljubljana, Ljubljana, Slovenia","institution_ids":["https://openalex.org/I153976015"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Tadej Matek","orcid":null},"institutions":[{"id":"https://openalex.org/I153976015","display_name":"University of Ljubljana","ror":"https://ror.org/05njb9z20","country_code":"SI","type":"education","lineage":["https://openalex.org/I153976015"]}],"countries":["SI"],"is_corresponding":false,"raw_author_name":"Tadej Matek","raw_affiliation_strings":["Faculty of Computer and Information Science, University of Ljubljana, Ljubljana, Slovenia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Computer and Information Science, University of Ljubljana, Ljubljana, Slovenia","institution_ids":["https://openalex.org/I153976015"]}]},{"author_position":"last","author":{"id":null,"display_name":"Alja\u017e Zrnec","orcid":null},"institutions":[{"id":"https://openalex.org/I153976015","display_name":"University of Ljubljana","ror":"https://ror.org/05njb9z20","country_code":"SI","type":"education","lineage":["https://openalex.org/I153976015"]}],"countries":["SI"],"is_corresponding":false,"raw_author_name":"Alja\u017e Zrnec","raw_affiliation_strings":["Faculty of Computer and Information Science, University of Ljubljana, Ljubljana, Slovenia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Computer and Information Science, University of Ljubljana, Ljubljana, Slovenia","institution_ids":["https://openalex.org/I153976015"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I153976015"],"apc_list":null,"apc_paid":null,"fwci":2.7622,"has_fulltext":false,"cited_by_count":16,"citation_normalized_percentile":{"value":0.92390089,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":"25","issue":"8","first_page":"1048","last_page":"1064"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13034","display_name":"Information Systems Education and Curriculum Development","score":0.2615000009536743,"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"}},"topics":[{"id":"https://openalex.org/T13034","display_name":"Information Systems Education and Curriculum Development","score":0.2615000009536743,"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/T10470","display_name":"Usability and User Interface Design","score":0.10040000081062317,"subfield":{"id":"https://openalex.org/subfields/1709","display_name":"Human-Computer Interaction"},"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/T10533","display_name":"Teaching and Learning Programming","score":0.04989999905228615,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7807000279426575},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.5437999963760376},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.5291000008583069},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5288000106811523},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.4657999873161316},{"id":"https://openalex.org/keywords/recommender-system","display_name":"Recommender system","score":0.42500001192092896},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4083999991416931},{"id":"https://openalex.org/keywords/path","display_name":"Path (computing)","score":0.361299991607666}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8949999809265137},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7807000279426575},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.5437999963760376},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.5291000008583069},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5288000106811523},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.4657999873161316},{"id":"https://openalex.org/C557471498","wikidata":"https://www.wikidata.org/wiki/Q554950","display_name":"Recommender system","level":2,"score":0.42500001192092896},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4083999991416931},{"id":"https://openalex.org/C2777735758","wikidata":"https://www.wikidata.org/wiki/Q817765","display_name":"Path (computing)","level":2,"score":0.361299991607666},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.35989999771118164},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3276999890804291},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.32280001044273376},{"id":"https://openalex.org/C120936955","wikidata":"https://www.wikidata.org/wiki/Q2155640","display_name":"Empirical research","level":2,"score":0.3215000033378601},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.30809998512268066},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.29030001163482666},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2896000146865845},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.2879999876022339},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.28459998965263367},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.2718999981880188},{"id":"https://openalex.org/C114724005","wikidata":"https://www.wikidata.org/wiki/Q5001740","display_name":"Business Intelligence Markup Language","level":5,"score":0.2700999975204468},{"id":"https://openalex.org/C74672266","wikidata":"https://www.wikidata.org/wiki/Q815859","display_name":"Language acquisition","level":2,"score":0.25940001010894775},{"id":"https://openalex.org/C49774154","wikidata":"https://www.wikidata.org/wiki/Q131765","display_name":"Multimedia","level":1,"score":0.2549999952316284},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.250900000333786}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1080/10494820.2016.1244084","is_oa":false,"landing_page_url":"https://doi.org/10.1080/10494820.2016.1244084","pdf_url":null,"source":{"id":"https://openalex.org/S90466346","display_name":"Interactive Learning Environments","issn_l":"1049-4820","issn":["1049-4820","1744-5191"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320547","host_organization_name":"Taylor & Francis","host_organization_lineage":["https://openalex.org/P4310320547"],"host_organization_lineage_names":["Taylor & Francis"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Interactive Learning Environments","raw_type":"journal-article"},{"id":"pmh:oai:arXiv.org:1807.02637","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1807.02637","pdf_url":"https://arxiv.org/pdf/1807.02637","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:1807.02637","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1807.02637","pdf_url":"https://arxiv.org/pdf/1807.02637","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W11018705","https://openalex.org/W151501290","https://openalex.org/W1976373002","https://openalex.org/W2018951244","https://openalex.org/W2039029631","https://openalex.org/W2040990302","https://openalex.org/W2051339053","https://openalex.org/W2105715011","https://openalex.org/W2108583193","https://openalex.org/W2122219993","https://openalex.org/W2133013897","https://openalex.org/W2140039549","https://openalex.org/W2150794602","https://openalex.org/W2159720343","https://openalex.org/W2160133757","https://openalex.org/W2163640453","https://openalex.org/W2164654716","https://openalex.org/W2165079349","https://openalex.org/W2172010324","https://openalex.org/W3003642164","https://openalex.org/W4231572712"],"related_works":[],"abstract_inverted_index":{"Today\u2019s":[0],"software":[1],"industry":[2],"requires":[3],"individuals":[4],"who":[5],"are":[6],"proficient":[7],"in":[8,99],"as":[9,13,19,26],"many":[10],"programming":[11],"languages":[12],"possible.":[14],"Structured":[15],"query":[16,33],"language":[17,34,85],"(SQL),":[18],"an":[20,128],"adopted":[21],"standard,":[22],"is":[23,28,66,141],"no":[24],"exception,":[25],"it":[27],"the":[29,41,84,94,108,118,123,137],"most":[30],"widely":[31],"used":[32],"to":[35,48,57,76,107],"retrieve":[36],"and":[37,62,87,110,134],"manipulate":[38],"data.":[39],"However,":[40],"process":[42],"of":[43,83,93,139],"learning":[44,100],"SQL":[45,61,101],"turns":[46],"out":[47],"be":[49],"challenging.":[50],"The":[51,90],"need":[52],"for":[53,146],"a":[54,73],"computer-aided":[55],"solution":[56,109,120],"help":[58,77],"users":[59,78,98,147],"learn":[60],"improve":[63],"their":[64,104],"proficiency":[65],"vital.":[67],"In":[68],"this":[69],"study,":[70],"we":[71,126],"present":[72],"new":[74],"approach":[75,96],"conceptualize":[79],"basic":[80],"building":[81],"blocks":[82],"faster":[86],"more":[88],"efficiently.":[89],"adaptive":[91],"design":[92],"proposed":[95],"aids":[97],"by":[102,122],"supporting":[103],"own":[105],"path":[106],"employing":[111],"successful":[112],"previous":[113],"attempts,":[114],"while":[115],"not":[116],"enforcing":[117],"ideal":[119],"provided":[121],"instructor.":[124],"Furthermore,":[125],"perform":[127],"empirical":[129],"evaluation":[130],"with":[131,148],"93":[132],"participants":[133],"demonstrate":[135],"that":[136],"employment":[138],"hints":[140],"successful,":[142],"being":[143],"especially":[144],"beneficial":[145],"lower":[149],"prior":[150],"knowledge.":[151]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2016-10-28T00:00:00"}