{"id":"https://openalex.org/W4404910547","doi":"https://doi.org/10.1145/3649165.3690103","title":"An Interactive Visual Presentation of Core Database Design Concepts","display_name":"An Interactive Visual Presentation of Core Database Design Concepts","publication_year":2024,"publication_date":"2024-12-02","ids":{"openalex":"https://openalex.org/W4404910547","doi":"https://doi.org/10.1145/3649165.3690103"},"language":"en","primary_location":{"id":"doi:10.1145/3649165.3690103","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3649165.3690103","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2024 on ACM Virtual Global Computing Education Conference V. 1","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://vtechworks.lib.vt.edu/bitstreams/b78ab477-f688-47fd-8d6e-187f151171c0/download","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Noha Abdelaziz","orcid":"https://orcid.org/0009-0006-8567-8129"},"institutions":[{"id":"https://openalex.org/I91041137","display_name":"Assiut University","ror":"https://ror.org/01jaj8n65","country_code":"EG","type":"education","lineage":["https://openalex.org/I91041137"]}],"countries":["EG"],"is_corresponding":false,"raw_author_name":"Noha Abdelaziz","raw_affiliation_strings":["Faculty of Computers and Information, Assiut University, Assiut, Egypt"],"raw_orcid":"https://orcid.org/0009-0006-8567-8129","affiliations":[{"raw_affiliation_string":"Faculty of Computers and Information, Assiut University, Assiut, Egypt","institution_ids":["https://openalex.org/I91041137"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5051529556","display_name":"Mohammed F. Farghally","orcid":"https://orcid.org/0000-0002-9596-5352"},"institutions":[{"id":"https://openalex.org/I859038795","display_name":"Virginia Tech","ror":"https://ror.org/02smfhw86","country_code":"US","type":"education","lineage":["https://openalex.org/I859038795"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mohammed Farghally","raw_affiliation_strings":["Department of Computer Science, Virginia Tech, Blacksburg, VA, USA"],"raw_orcid":"https://orcid.org/0000-0002-9596-5352","affiliations":[{"raw_affiliation_string":"Department of Computer Science, Virginia Tech, Blacksburg, VA, USA","institution_ids":["https://openalex.org/I859038795"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100770114","display_name":"Mostafa Mohammed","orcid":"https://orcid.org/0000-0002-0652-2817"},"institutions":[{"id":"https://openalex.org/I63190737","display_name":"University at Buffalo, State University of New York","ror":"https://ror.org/01y64my43","country_code":"US","type":"education","lineage":["https://openalex.org/I63190737"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mostafa Mohammed","raw_affiliation_strings":["Department of Computer Science and Engineering, The State University of New York at Buffalo, Buffalo, NY, USA"],"raw_orcid":"https://orcid.org/0000-0002-0652-2817","affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering, The State University of New York at Buffalo, Buffalo, NY, USA","institution_ids":["https://openalex.org/I63190737"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5109244101","display_name":"Taysir Hassan A. Soliman","orcid":"https://orcid.org/0000-0002-7635-4089"},"institutions":[{"id":"https://openalex.org/I91041137","display_name":"Assiut University","ror":"https://ror.org/01jaj8n65","country_code":"EG","type":"education","lineage":["https://openalex.org/I91041137"]}],"countries":["EG"],"is_corresponding":false,"raw_author_name":"Taysir Soliman","raw_affiliation_strings":["Faculty of Computers and Information, Assiut University, Assiut, Egypt"],"raw_orcid":"https://orcid.org/0000-0002-7635-4089","affiliations":[{"raw_affiliation_string":"Faculty of Computers and Information, Assiut University, Assiut, Egypt","institution_ids":["https://openalex.org/I91041137"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.6244,"has_fulltext":true,"cited_by_count":2,"citation_normalized_percentile":{"value":0.7209527,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"5","last_page":"11"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9958999752998352,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9958999752998352,"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9861999750137329,"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/T11450","display_name":"Model-Driven Software Engineering Techniques","score":0.9829999804496765,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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.7762148380279541},{"id":"https://openalex.org/keywords/presentation","display_name":"Presentation (obstetrics)","score":0.6608930230140686},{"id":"https://openalex.org/keywords/core","display_name":"Core (optical fiber)","score":0.4896154999732971},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.44595906138420105},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4041789770126343}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7762148380279541},{"id":"https://openalex.org/C2777601897","wikidata":"https://www.wikidata.org/wiki/Q3409113","display_name":"Presentation (obstetrics)","level":2,"score":0.6608930230140686},{"id":"https://openalex.org/C2164484","wikidata":"https://www.wikidata.org/wiki/Q5170150","display_name":"Core (optical fiber)","level":2,"score":0.4896154999732971},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.44595906138420105},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4041789770126343},{"id":"https://openalex.org/C126838900","wikidata":"https://www.wikidata.org/wiki/Q77604","display_name":"Radiology","level":1,"score":0.0},{"id":"https://openalex.org/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","level":0,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3649165.3690103","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3649165.3690103","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2024 on ACM Virtual Global Computing Education Conference V. 1","raw_type":"proceedings-article"},{"id":"pmh:oai:vtechworks.lib.vt.edu:10919/124019","is_oa":true,"landing_page_url":"https://hdl.handle.net/10919/124019","pdf_url":"https://vtechworks.lib.vt.edu/bitstreams/b78ab477-f688-47fd-8d6e-187f151171c0/download","source":{"id":"https://openalex.org/S4306400248","display_name":"VTechWorks (Virginia Tech)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I859038795","host_organization_name":"Virginia Tech","host_organization_lineage":["https://openalex.org/I859038795"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Article - Refereed"}],"best_oa_location":{"id":"pmh:oai:vtechworks.lib.vt.edu:10919/124019","is_oa":true,"landing_page_url":"https://hdl.handle.net/10919/124019","pdf_url":"https://vtechworks.lib.vt.edu/bitstreams/b78ab477-f688-47fd-8d6e-187f151171c0/download","source":{"id":"https://openalex.org/S4306400248","display_name":"VTechWorks (Virginia Tech)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I859038795","host_organization_name":"Virginia Tech","host_organization_lineage":["https://openalex.org/I859038795"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Article - Refereed"},"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320325647","display_name":"Assiut University","ror":"https://ror.org/01jaj8n65"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4404910547.pdf","grobid_xml":"https://content.openalex.org/works/W4404910547.grobid-xml"},"referenced_works_count":37,"referenced_works":["https://openalex.org/W431956692","https://openalex.org/W1512840853","https://openalex.org/W1536696051","https://openalex.org/W1972978214","https://openalex.org/W1976467438","https://openalex.org/W1995529329","https://openalex.org/W2005815869","https://openalex.org/W2009304616","https://openalex.org/W2022765017","https://openalex.org/W2048947920","https://openalex.org/W2055447088","https://openalex.org/W2056642597","https://openalex.org/W2071100465","https://openalex.org/W2116016329","https://openalex.org/W2134835128","https://openalex.org/W2142855189","https://openalex.org/W2306437611","https://openalex.org/W2322519571","https://openalex.org/W2326773255","https://openalex.org/W2466627406","https://openalex.org/W2584736212","https://openalex.org/W2592914592","https://openalex.org/W2753439427","https://openalex.org/W2782733505","https://openalex.org/W2788557217","https://openalex.org/W2907345679","https://openalex.org/W2965391501","https://openalex.org/W2999367731","https://openalex.org/W3006066646","https://openalex.org/W3008234786","https://openalex.org/W3112836607","https://openalex.org/W3135485138","https://openalex.org/W3136162592","https://openalex.org/W3211756673","https://openalex.org/W4229977739","https://openalex.org/W4388933170","https://openalex.org/W7027717352"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W4387426029","https://openalex.org/W4254162896","https://openalex.org/W4388792380","https://openalex.org/W1477999932","https://openalex.org/W4386731653","https://openalex.org/W2376001620","https://openalex.org/W2925303117"],"abstract_inverted_index":{"Database":[0],"design":[1,76,87,235],"is":[2],"a":[3,51,60,93,102,136,142,161],"core":[4],"topic":[5],"in":[6,79,110,141,146,229],"Computer":[7],"Science":[8],"(CS)":[9],"curricula":[10],"at":[11,185],"the":[12,47,117,129,147,167,186,189,194],"university":[13],"level.":[14],"Students":[15],"often":[16],"encounter":[17],"difficulties":[18,32,78],"and":[19,49,99,202,214],"misconceptions":[20],"while":[21],"learning":[22,31,77,200],"these":[23,30,40],"concepts.":[24,236],"Previous":[25],"research":[26],"attempted":[27],"to":[28,135,170,198,216,225],"address":[29,73],"through":[33],"interactive":[34,64],"visual":[35],"demonstrations.":[36],"However,":[37],"most":[38],"of":[39,62,96,128,131,166,188,196,232],"resources":[41],"are":[42,89],"not":[43],"well":[44],"integrated":[45],"into":[46],"curriculum,":[48],"lack":[50],"proper":[52],"educational":[53],"evaluation.":[54],"In":[55],"this":[56],"paper,":[57],"we":[58,67],"present":[59,121],"set":[61],"online":[63,112],"visualizations":[65],"that":[66,72,152,209,220],"name":[68],"DataBase":[69],"Visualizations":[70],"(DBVs),":[71],"common":[74],"database":[75,83,86,139,227,234],"an":[80,111,125],"introductory":[81],"undergraduate":[82,138,226],"course.":[84],"Core":[85],"concepts":[88],"visualized":[90],"step-by-step,":[91],"facilitating":[92,114],"deep":[94],"understanding":[95],"relationship":[97],"establishment":[98],"mapping":[100],"onto":[101],"relational":[103],"schema.":[104],"DBVs":[105,132,197,210,221],"could":[106],"be":[107,223],"easily":[108],"embedded":[109],"eTextbook":[113],"integration":[115],"with":[116],"existing":[118],"curriculum.":[119],"We":[120,218],"our":[122],"findings":[123],"from":[124],"evaluation":[126],"study":[127],"effectiveness":[130],"when":[133],"applied":[134],"semester-long":[137],"course":[140],"large":[143],"public":[144],"institution":[145],"middle":[148],"east.":[149],"Results":[150],"indicate":[151,208],"intervention":[153,180],"group":[154,172,181],"students":[155,173,182],"had":[156],"significantly":[157],"higher":[158],"scores":[159],"on":[160],"post-test":[162],"offered":[163],"as":[164],"part":[165],"final":[168],"compared":[169],"control":[171],"using":[174],"primarily":[175],"traditional":[176],"textual":[177],"content.":[178],"Furthermore,":[179],"were":[183,211],"surveyed":[184],"end":[187],"semester":[190],"asking":[191],"them":[192],"about":[193],"value":[195],"their":[199,230],"process":[201],"suggestions":[203],"for":[204],"improvement.":[205],"Survey":[206],"results":[207],"clear,":[212],"engaging,":[213],"easy":[215],"use.":[217],"believe":[219],"will":[222],"helpful":[224],"instructors":[228],"teaching":[231],"basic":[233]},"counts_by_year":[{"year":2025,"cited_by_count":2}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}