{"id":"https://openalex.org/W1982103025","doi":"https://doi.org/10.1007/s13222-013-0139-5","title":"\u201eGib mir so viel Gold, wie die Metzger im Nachbardorf zusammen besitzen und ich lasse den Piloten frei!\u201c \u2013 Spielbasiertes Lernen von SQL-Grundlagen","display_name":"\u201eGib mir so viel Gold, wie die Metzger im Nachbardorf zusammen besitzen und ich lasse den Piloten frei!\u201c \u2013 Spielbasiertes Lernen von SQL-Grundlagen","publication_year":2013,"publication_date":"2013-09-26","ids":{"openalex":"https://openalex.org/W1982103025","doi":"https://doi.org/10.1007/s13222-013-0139-5","mag":"1982103025"},"language":"de","primary_location":{"id":"doi:10.1007/s13222-013-0139-5","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s13222-013-0139-5","pdf_url":null,"source":{"id":"https://openalex.org/S73012565","display_name":"Datenbank-Spektrum","issn_l":"1610-1995","issn":["1610-1995","1618-2162"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Datenbank-Spektrum","raw_type":"journal-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/A5030002526","display_name":"Johannes Schildgen","orcid":"https://orcid.org/0000-0002-2450-0152"},"institutions":[{"id":"https://openalex.org/I153267046","display_name":"University of Kaiserslautern","ror":"https://ror.org/04zrf7b53","country_code":"DE","type":"education","lineage":["https://openalex.org/I153267046"]},{"id":"https://openalex.org/I4387152675","display_name":"Rheinland-Pf\u00e4lzische Technische Universit\u00e4t Kaiserslautern-Landau","ror":"https://ror.org/01qrts582","country_code":null,"type":"education","lineage":["https://openalex.org/I4387152675"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Johannes Schildgen","raw_affiliation_strings":["AG Heterogene Informationssysteme, TU Kaiserslautern, Postfach 3049, 67663, Kaiserslautern, Deutschland","TU Kaiserslautern"],"affiliations":[{"raw_affiliation_string":"AG Heterogene Informationssysteme, TU Kaiserslautern, Postfach 3049, 67663, Kaiserslautern, Deutschland","institution_ids":["https://openalex.org/I153267046"]},{"raw_affiliation_string":"TU Kaiserslautern","institution_ids":["https://openalex.org/I153267046","https://openalex.org/I4387152675"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5023255725","display_name":"Stefan De\u00dfloch","orcid":"https://orcid.org/0000-0002-1816-3049"},"institutions":[{"id":"https://openalex.org/I153267046","display_name":"University of Kaiserslautern","ror":"https://ror.org/04zrf7b53","country_code":"DE","type":"education","lineage":["https://openalex.org/I153267046"]},{"id":"https://openalex.org/I4387152675","display_name":"Rheinland-Pf\u00e4lzische Technische Universit\u00e4t Kaiserslautern-Landau","ror":"https://ror.org/01qrts582","country_code":null,"type":"education","lineage":["https://openalex.org/I4387152675"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Stefan De\u00dfloch","raw_affiliation_strings":["AG Heterogene Informationssysteme, TU Kaiserslautern, Postfach 3049, 67663, Kaiserslautern, Deutschland","TU Kaiserslautern"],"affiliations":[{"raw_affiliation_string":"AG Heterogene Informationssysteme, TU Kaiserslautern, Postfach 3049, 67663, Kaiserslautern, Deutschland","institution_ids":["https://openalex.org/I153267046"]},{"raw_affiliation_string":"TU Kaiserslautern","institution_ids":["https://openalex.org/I153267046","https://openalex.org/I4387152675"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5030002526"],"corresponding_institution_ids":["https://openalex.org/I153267046","https://openalex.org/I4387152675"],"apc_list":{"value":2380,"currency":"EUR","value_usd":2890},"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.22548828,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":95},"biblio":{"volume":"13","issue":"3","first_page":"243","last_page":"249"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12826","display_name":"Education Methods and Technologies","score":0.9901999831199646,"subfield":{"id":"https://openalex.org/subfields/3304","display_name":"Education"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T12826","display_name":"Education Methods and Technologies","score":0.9901999831199646,"subfield":{"id":"https://openalex.org/subfields/3304","display_name":"Education"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10731","display_name":"Educational Games and Gamification","score":0.9779000282287598,"subfield":{"id":"https://openalex.org/subfields/3204","display_name":"Developmental and Educational Psychology"},"field":{"id":"https://openalex.org/fields/32","display_name":"Psychology"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5812360048294067},{"id":"https://openalex.org/keywords/humanities","display_name":"Humanities","score":0.4524567723274231},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.39975762367248535},{"id":"https://openalex.org/keywords/art","display_name":"Art","score":0.31368663907051086},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.17340219020843506}],"concepts":[{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5812360048294067},{"id":"https://openalex.org/C15708023","wikidata":"https://www.wikidata.org/wiki/Q80083","display_name":"Humanities","level":1,"score":0.4524567723274231},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.39975762367248535},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.31368663907051086},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.17340219020843506}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/s13222-013-0139-5","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s13222-013-0139-5","pdf_url":null,"source":{"id":"https://openalex.org/S73012565","display_name":"Datenbank-Spektrum","issn_l":"1610-1995","issn":["1610-1995","1618-2162"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Datenbank-Spektrum","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Decent work and economic growth","score":0.4300000071525574,"id":"https://metadata.un.org/sdg/8"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":3,"referenced_works":["https://openalex.org/W623286280","https://openalex.org/W1498250013","https://openalex.org/W2098577953"],"related_works":["https://openalex.org/W3183948672","https://openalex.org/W3173606202","https://openalex.org/W3110381201","https://openalex.org/W2948807893","https://openalex.org/W2935909890","https://openalex.org/W2899084033","https://openalex.org/W2778153218","https://openalex.org/W2758277628","https://openalex.org/W2748952813","https://openalex.org/W1531601525"],"abstract_inverted_index":null,"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2021,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}
