{"id":"https://openalex.org/W3093228195","doi":null,"title":"Persistent Errors in Query Formulation","display_name":"Persistent Errors in Query Formulation","alternate_titles":[],"publication_year":2020,"publication_date":"2020-01-01","ids":{"openalex":"https://openalex.org/W3093228195","mag":"3093228195"},"language":"en","primary_location":{"id":"pmh:oai:jyx.jyu.fi:123456789/71720","doi":null,"is_oa":true,"landing_page_url":"http://urn.fi/URN:ISBN:978-951-39-8290-4","pdf_url":"http://jise.org/Volume30/n3/JISEv30n3p160.pdf","source":{"id":"https://openalex.org/S4306400563","display_name":"Jyv\u00e4skyl\u00e4 University Digital Archive (University of Jyv\u00e4skyl\u00e4)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I94722563","host_organization_name":"University of Jyv\u00e4skyl\u00e4","host_organization_lineage":["https://openalex.org/I94722563"],"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":"http://purl.org/coar/resource_type/c_db06"},"parent_works":[],"lineage":["https://openalex.org/W3093228195"],"child_works_count":0,"type":"dissertation","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://jise.org/Volume30/n3/JISEv30n3p160.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5005256813","display_name":"Toni Taipalus","orcid":"https://orcid.org/0000-0003-4060-3431","observed_orcids":["https://orcid.org/0000-0003-4060-3431"]},"institutions":[],"countries":[],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Toni Taipalus","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5005256813"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":1,"reviewed_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":false,"primary_topic":{"id":"https://openalex.org/T10533","display_name":"Teaching and Learning Programming","score":0.9945999979972839,"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.9945999979972839,"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/T13034","display_name":"Information Systems Education and Curriculum Development","score":0.0006000000284984708,"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/T10286","display_name":"Information Retrieval and Search Behavior","score":0.00039999998989515007,"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.49399998784065247},{"id":"https://openalex.org/keywords/sql-education","display_name":"SQL education","score":0.8199999928474426},{"id":"https://openalex.org/keywords/error-taxonomy","display_name":"error taxonomy","score":0.8259999752044678},{"id":"https://openalex.org/keywords/database-query-languages","display_name":"database query languages","score":0.4390000104904175},{"id":"https://openalex.org/keywords/programming-education","display_name":"programming education","score":0.46000000834465027}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.49468085169792175},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3236209750175476}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:jyx.jyu.fi:123456789/71720","doi":null,"is_oa":true,"landing_page_url":"http://urn.fi/URN:ISBN:978-951-39-8290-4","pdf_url":"http://jise.org/Volume30/n3/JISEv30n3p160.pdf","source":{"id":"https://openalex.org/S4306400563","display_name":"Jyv\u00e4skyl\u00e4 University Digital Archive (University of Jyv\u00e4skyl\u00e4)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I94722563","host_organization_name":"University of Jyv\u00e4skyl\u00e4","host_organization_lineage":["https://openalex.org/I94722563"],"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":"http://purl.org/coar/resource_type/c_db06"},{"id":"mag:3093228195","doi":null,"is_oa":false,"landing_page_url":"https://jyx.jyu.fi/handle/123456789/71720","pdf_url":null,"source":{"id":"https://openalex.org/S4306517221","display_name":"JYU dissertations","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"JYU dissertations","raw_type":null}],"best_oa_location":{"id":"pmh:oai:jyx.jyu.fi:123456789/71720","doi":null,"is_oa":true,"landing_page_url":"http://urn.fi/URN:ISBN:978-951-39-8290-4","pdf_url":"http://jise.org/Volume30/n3/JISEv30n3p160.pdf","source":{"id":"https://openalex.org/S4306400563","display_name":"Jyv\u00e4skyl\u00e4 University Digital Archive (University of Jyv\u00e4skyl\u00e4)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I94722563","host_organization_name":"University of Jyv\u00e4skyl\u00e4","host_organization_lineage":["https://openalex.org/I94722563"],"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":"http://purl.org/coar/resource_type/c_db06"},"sustainable_development_goals":[{"score":0.5385000109672546,"id":"https://metadata.un.org/sdg/4","display_name":"Quality education"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3093228195.pdf","grobid_xml":"https://content.openalex.org/works/W3093228195.grobid-xml"},"referenced_works_count":10,"referenced_works":["https://openalex.org/W105646744","https://openalex.org/W782406479","https://openalex.org/W1964849062","https://openalex.org/W1992389722","https://openalex.org/W2023745308","https://openalex.org/W2047048300","https://openalex.org/W2145114078","https://openalex.org/W2185907055","https://openalex.org/W2473995384","https://openalex.org/W2885090162"],"related_works":["https://openalex.org/W3112836607","https://openalex.org/W2885090162","https://openalex.org/W2121940788","https://openalex.org/W2916040897","https://openalex.org/W1482676634","https://openalex.org/W7161656519","https://openalex.org/W3193751197","https://openalex.org/W3041823931","https://openalex.org/W4287981156","https://openalex.org/W2972483799"],"abstract_inverted_index":{"We":[0],"use":[1],"the":[2,38,57,83,91,97,102,128,137,194,228,238,280],"internet":[3],"daily":[4],"to":[5,50,80,117,213],"query":[6,45,67,119,180,200,217],"data":[7,84],"from":[8],"a":[9,18,55,147,159,162,172,206,209],"myriad":[10],"of":[11,63,130,143,150,161,165,174,177,185,196,208,230,232,277],"databases;":[12],"every":[13,21,24],"search":[14,19],"term":[15],"entered":[16],"in":[17,155,168,216,259],"engine,":[20],"movie":[22],"watched,":[23],"song":[25],"listened,":[26],"ev-ery":[27],"newspaper":[28],"article":[29],"read":[30],"online.":[31],"Although":[32],"we":[33,44,85],"as":[34,43,78],"end-users":[35,79],"only":[36],"see":[37],"rel-atively":[39],"effortless":[40],"user":[41],"interfaces":[42],"data,":[46],"someone":[47],"has":[48,110],"had":[49],"formal-ize":[51],"our":[52],"queries":[53,99,103],"into":[54],"language":[56],"software":[58,92],"understands.":[59],"The":[60],"most":[61,281],"common":[62],"these":[64],"so":[65],"called":[66],"languages":[68],"is":[69,88,240],"Structured":[70],"Query":[71],"Language":[72],"(SQL).":[73],"In":[74],"or-der":[75],"for":[76,95,140,224,283],"us":[77],"retrieve":[81],"exactly":[82],"want,":[86],"it":[87],"crucial":[89],"that":[90],"developers":[93],"responsible":[94],"writing":[96],"underlying":[98],"have":[100],"written":[101],"without":[104],"errors.":[105],"Educational":[106],"SQL":[107,144,151,169,234,247],"research,":[108],"however,":[109],"not":[111],"yet":[112],"thor-oughly":[113],"addressed":[114],"issues":[115],"related":[116],"understanding":[118,142],"formulation":[120,201],"errors":[121,166,178,187,215],"or":[122],"some":[123],"technical":[124],"factors":[125],"which":[126,175,183],"influence":[127],"process":[129],"learning":[131],"SQL.":[132,285],"This":[133],"doctoral":[134],"dissertation":[135],"makes":[136],"following":[138],"contributions":[139,251,262],"increased":[141],"education:":[145],"(i)":[146,252],"systematic":[148],"overview":[149],"teaching":[152,260],"practices":[153],"proposed":[154],"scientific":[156],"literature,":[157],"(ii)":[158,220],"creation":[160,207],"wide":[163],"taxonomy":[164,239],"committed":[167],"learning,":[170],"(iii)":[171,263],"description":[173],"types":[176,184],"halt":[179],"formulation,":[181],"and":[182,204,242,244,253,264],"encountered":[186],"are":[188,279],"usually":[189],"fixed,":[190],"(iv)":[191,265],"evidence":[192],"on":[193,199,274],"effects":[195],"database":[197],"complexity":[198],"success":[202],"rates,":[203],"(v)":[205,254],"planning":[210],"notation":[211],"designed":[212],"mitigate":[214],"formulation.":[218],"Contribu-tion":[219],"presents":[221],"practical":[222],"implications":[223],"research":[225],"by":[226],"allowing":[227],"comparison":[229],"results":[231],"different":[233],"error":[235,248],"studies":[236],"when":[237,269],"used,":[241],"extend-ing":[243],"generalizing":[245],"prior":[246],"studies.":[249],"While":[250],"may":[255,266],"be":[256,267],"directly":[257],"applied":[258],"SQL,":[261],"consid-ered":[268],"making":[270],"an":[271],"informed":[272],"decision":[273],"what":[275],"kind":[276],"databases":[278],"suitable":[282],"practicing":[284]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W3093228195","counts_by_year":[{"year":2023,"cited_by_count":1}],"updated_date":"2026-11-21T10:27:49.728292","created_date":"2020-10-22T00:00:00"}
