{"id":"https://openalex.org/W2981836692","doi":"https://doi.org/10.1145/3361721.3362104","title":"BlocklySQL","display_name":"BlocklySQL","publication_year":2019,"publication_date":"2019-10-23","ids":{"openalex":"https://openalex.org/W2981836692","doi":"https://doi.org/10.1145/3361721.3362104","mag":"2981836692"},"language":"en","primary_location":{"id":"doi:10.1145/3361721.3362104","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3361721.3362104","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 14th Workshop in Primary and Secondary Computing 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/A5066679409","display_name":"Nicolai P\u00f6hner","orcid":"https://orcid.org/0000-0001-5145-6532"},"institutions":[{"id":"https://openalex.org/I25974101","display_name":"University of W\u00fcrzburg","ror":"https://ror.org/00fbnyb24","country_code":"DE","type":"education","lineage":["https://openalex.org/I25974101"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Nicolai P\u00f6hner","raw_affiliation_strings":["University of W\u00fcrzburg, W\u00fcrzburg, Germany"],"affiliations":[{"raw_affiliation_string":"University of W\u00fcrzburg, W\u00fcrzburg, Germany","institution_ids":["https://openalex.org/I25974101"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5056083273","display_name":"Timo Schmidt","orcid":"https://orcid.org/0000-0003-4371-9157"},"institutions":[{"id":"https://openalex.org/I25974101","display_name":"University of W\u00fcrzburg","ror":"https://ror.org/00fbnyb24","country_code":"DE","type":"education","lineage":["https://openalex.org/I25974101"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Timo Schmidt","raw_affiliation_strings":["University of W\u00fcrzburg, W\u00fcrzburg, Germany"],"affiliations":[{"raw_affiliation_string":"University of W\u00fcrzburg, W\u00fcrzburg, Germany","institution_ids":["https://openalex.org/I25974101"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5054201211","display_name":"Andr\u00e9 Greubel","orcid":"https://orcid.org/0000-0002-7915-6520"},"institutions":[{"id":"https://openalex.org/I25974101","display_name":"University of W\u00fcrzburg","ror":"https://ror.org/00fbnyb24","country_code":"DE","type":"education","lineage":["https://openalex.org/I25974101"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Andr\u00e9 Greubel","raw_affiliation_strings":["University of W\u00fcrzburg, W\u00fcrzburg, Germany"],"affiliations":[{"raw_affiliation_string":"University of W\u00fcrzburg, W\u00fcrzburg, Germany","institution_ids":["https://openalex.org/I25974101"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5049502028","display_name":"Martin Hennecke","orcid":"https://orcid.org/0000-0001-5586-0647"},"institutions":[{"id":"https://openalex.org/I25974101","display_name":"University of W\u00fcrzburg","ror":"https://ror.org/00fbnyb24","country_code":"DE","type":"education","lineage":["https://openalex.org/I25974101"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Martin Hennecke","raw_affiliation_strings":["University of W\u00fcrzburg, W\u00fcrzburg, Germany"],"affiliations":[{"raw_affiliation_string":"University of W\u00fcrzburg, W\u00fcrzburg, Germany","institution_ids":["https://openalex.org/I25974101"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5102932511","display_name":"Matthias Ehmann","orcid":"https://orcid.org/0000-0003-0392-8309"},"institutions":[{"id":"https://openalex.org/I54009628","display_name":"University of Bayreuth","ror":"https://ror.org/0234wmv40","country_code":"DE","type":"education","lineage":["https://openalex.org/I54009628"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Matthias Ehmann","raw_affiliation_strings":["University of Bayreuth, Bayreuth, Germany"],"affiliations":[{"raw_affiliation_string":"University of Bayreuth, Bayreuth, Germany","institution_ids":["https://openalex.org/I54009628"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5066679409"],"corresponding_institution_ids":["https://openalex.org/I25974101"],"apc_list":null,"apc_paid":null,"fwci":1.756,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.88977235,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"2"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T14025","display_name":"Educational Technology and Assessment","score":0.7516999840736389,"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/T14025","display_name":"Educational Technology and Assessment","score":0.7516999840736389,"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.7447999715805054,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.6923999786376953,"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/computer-science","display_name":"Computer science","score":0.7950592637062073},{"id":"https://openalex.org/keywords/javascript","display_name":"JavaScript","score":0.7528284788131714},{"id":"https://openalex.org/keywords/block","display_name":"Block (permutation group theory)","score":0.6537721753120422},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6369937658309937},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.4256754219532013},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3527352809906006},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3363747000694275}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7950592637062073},{"id":"https://openalex.org/C544833334","wikidata":"https://www.wikidata.org/wiki/Q2005","display_name":"JavaScript","level":2,"score":0.7528284788131714},{"id":"https://openalex.org/C2777210771","wikidata":"https://www.wikidata.org/wiki/Q4927124","display_name":"Block (permutation group theory)","level":2,"score":0.6537721753120422},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6369937658309937},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.4256754219532013},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3527352809906006},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3363747000694275},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3361721.3362104","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3361721.3362104","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 14th Workshop in Primary and Secondary Computing Education","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":6,"referenced_works":["https://openalex.org/W2084734886","https://openalex.org/W2286501037","https://openalex.org/W2473995384","https://openalex.org/W2912302815","https://openalex.org/W2914184225","https://openalex.org/W7026924637"],"related_works":["https://openalex.org/W2461078469","https://openalex.org/W123790205","https://openalex.org/W2085515337","https://openalex.org/W3087706721","https://openalex.org/W3102852402","https://openalex.org/W4287664162","https://openalex.org/W4385695489","https://openalex.org/W827014118","https://openalex.org/W2498635018","https://openalex.org/W2917568086"],"abstract_inverted_index":{"This":[0],"paper":[1],"introduces":[2],"BlocklySQL,":[3],"a":[4,21],"new":[5],"block-based":[6,26],"editor":[7],"for":[8,23,50],"SQL.":[9],"BlocklySQL":[10,36],"was":[11],"developed":[12],"on":[13],"the":[14,41,51],"basis":[15],"of":[16],"Google's":[17],"JavaScript":[18],"library":[19],"Blockly,":[20],"tool":[22],"developing":[24],"own":[25],"editors,":[27],"which":[28,45],"comes":[29],"with":[30],"several":[31],"technological":[32],"and":[33],"pedagogical":[34],"advantages.":[35],"is":[37],"also":[38],"integrated":[39],"into":[40],"learning":[42],"platform":[43],"dbup2date,":[44],"provides":[46],"daily":[47],"updated":[48],"databases":[49],"use":[52],"in":[53],"CS":[54],"classrooms.":[55]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":1}],"updated_date":"2026-03-06T13:50:29.536080","created_date":"2019-11-01T00:00:00"}