{"id":"https://openalex.org/W6888038739","doi":"https://doi.org/10.18420/btw2023-39","title":"Interactive SQL Queries and Program Code in Presentations","display_name":"Interactive SQL Queries and Program Code in Presentations","publication_year":2023,"publication_date":"2023-01-01","ids":{"openalex":"https://openalex.org/W6888038739","doi":"https://doi.org/10.18420/btw2023-39"},"language":"en","primary_location":{"id":"doi:10.18420/btw2023-39","is_oa":true,"landing_page_url":"https://doi.org/10.18420/btw2023-39","pdf_url":null,"source":{"id":"https://openalex.org/S7407052918","display_name":"Gesellschaft f\u00fcr Informatik (GI)","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article-journal"},"type":"article","indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.18420/btw2023-39","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Schildgen, Johannes","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Schildgen, Johannes","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":null,"display_name":"Heinz, Florian","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Heinz, Florian","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.31244696,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":true,"primary_topic":{"id":"https://openalex.org/T13523","display_name":"Mathematics, Computing, and Information Processing","score":0.1890999972820282,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/T13523","display_name":"Mathematics, Computing, and Information Processing","score":0.1890999972820282,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/T11516","display_name":"Visual and Cognitive Learning Processes","score":0.034299999475479126,"subfield":{"id":"https://openalex.org/subfields/3205","display_name":"Experimental and Cognitive Psychology"},"field":{"id":"https://openalex.org/fields/32","display_name":"Psychology"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T12354","display_name":"Innovations in Educational Methods","score":0.0284000001847744,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.614300012588501},{"id":"https://openalex.org/keywords/flexibility","display_name":"Flexibility (engineering)","score":0.5716999769210815},{"id":"https://openalex.org/keywords/presentation","display_name":"Presentation (obstetrics)","score":0.5709999799728394},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5627999901771545},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.5123000144958496},{"id":"https://openalex.org/keywords/program-code","display_name":"Program code","score":0.446399986743927},{"id":"https://openalex.org/keywords/html5","display_name":"HTML5","score":0.4456000030040741},{"id":"https://openalex.org/keywords/source-code","display_name":"Source code","score":0.4106000065803528}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.817799985408783},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.6445000171661377},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.614300012588501},{"id":"https://openalex.org/C2780598303","wikidata":"https://www.wikidata.org/wiki/Q65921492","display_name":"Flexibility (engineering)","level":2,"score":0.5716999769210815},{"id":"https://openalex.org/C2777601897","wikidata":"https://www.wikidata.org/wiki/Q3409113","display_name":"Presentation (obstetrics)","level":2,"score":0.5709999799728394},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5627999901771545},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.5123000144958496},{"id":"https://openalex.org/C2988963302","wikidata":"https://www.wikidata.org/wiki/Q629206","display_name":"Program code","level":2,"score":0.446399986743927},{"id":"https://openalex.org/C84063617","wikidata":"https://www.wikidata.org/wiki/Q2053","display_name":"HTML5","level":2,"score":0.4456000030040741},{"id":"https://openalex.org/C43126263","wikidata":"https://www.wikidata.org/wiki/Q128751","display_name":"Source code","level":2,"score":0.4106000065803528},{"id":"https://openalex.org/C2777561058","wikidata":"https://www.wikidata.org/wiki/Q2652119","display_name":"Program comprehension","level":4,"score":0.4092000126838684},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.37630000710487366},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.33899998664855957},{"id":"https://openalex.org/C121684516","wikidata":"https://www.wikidata.org/wiki/Q7600677","display_name":"Computer graphics (images)","level":1,"score":0.32899999618530273},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.32499998807907104},{"id":"https://openalex.org/C150569060","wikidata":"https://www.wikidata.org/wiki/Q32110","display_name":"XSLT","level":3,"score":0.30720001459121704},{"id":"https://openalex.org/C2989070954","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database query","level":2,"score":0.29739999771118164},{"id":"https://openalex.org/C2775997480","wikidata":"https://www.wikidata.org/wiki/Q586277","display_name":"Degree (music)","level":2,"score":0.2879999876022339},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.2847000062465668},{"id":"https://openalex.org/C544833334","wikidata":"https://www.wikidata.org/wiki/Q2005","display_name":"JavaScript","level":2,"score":0.2639000117778778},{"id":"https://openalex.org/C149091818","wikidata":"https://www.wikidata.org/wiki/Q2429814","display_name":"Software system","level":3,"score":0.2572999894618988},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.2513999938964844},{"id":"https://openalex.org/C2984968299","wikidata":"https://www.wikidata.org/wiki/Q1077784","display_name":"Software tool","level":3,"score":0.2508000135421753}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.18420/btw2023-39","is_oa":true,"landing_page_url":"https://doi.org/10.18420/btw2023-39","pdf_url":null,"source":{"id":"https://openalex.org/S7407052918","display_name":"Gesellschaft f\u00fcr Informatik (GI)","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article-journal"}],"best_oa_location":{"id":"doi:10.18420/btw2023-39","is_oa":true,"landing_page_url":"https://doi.org/10.18420/btw2023-39","pdf_url":null,"source":{"id":"https://openalex.org/S7407052918","display_name":"Gesellschaft f\u00fcr Informatik (GI)","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article-journal"},"sustainable_development_goals":[{"score":0.4786754846572876,"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Nowadays,":[0],"most":[1],"database":[2],"lectures":[3],"are":[4],"performed":[5],"with":[6,44],"an":[7,42,64,82],"accompanying":[8],"visual":[9],"presentation":[10,18],"that":[11],"further":[12],"illustrates":[13],"the":[14,35,45,72,94,105,109,116],"conveyed":[15],"facts.":[16],"Conventional":[17],"software":[19],"allows":[20],"dynamic":[21],"elements":[22],"up":[23],"to":[24,71,86,118],"a":[25,91],"certain":[26],"level,":[27],"for":[28,58],"example":[29],"revealing":[30],"or":[31,40,51,99],"changing":[32],"parts":[33,89],"of":[34,49,68,75,84,90],"slide":[36,92,111],"step":[37],"by":[38,47],"step,":[39],"even":[41,65],"interaction":[43],"viewers":[46],"means":[48],"polls":[50],"similar":[52],"mechanisms.":[53],"Recently,":[54],"HTML-and":[55],"browser-based":[56],"frameworks":[57],"presentations":[59],"have":[60],"emerged,":[61],"which":[62,129],"allow":[63],"higher":[66],"degree":[67],"flexibility":[69],"due":[70],"manifold":[73],"possibilities":[74],"HTML5":[76],"and":[77,103,123,125],"JavaScript.":[78],"This":[79,114],"paper":[80],"presents":[81],"approach":[83],"how":[85],"interactively":[87],"modify":[88],"during":[93],"presentation,":[95],"like":[96],"SQL-based":[97],"queries":[98],"program":[100],"code":[101],"snippets,":[102],"show":[104,120],"results":[106],"pretty-printed":[107],"on":[108],"corresponding":[110],"in":[112,134],"real-time.":[113],"enables":[115],"lecturer":[117],"easily":[119],"more":[121],"examples,":[122],"answer":[124],"illustrate":[126],"side":[127],"questions,":[128],"they":[130],"did":[131],"not":[132],"prepare":[133],"advance.":[135]},"counts_by_year":[],"updated_date":"2025-11-06T06:51:31.235846","created_date":"2025-10-10T00:00:00"}