{"id":"https://openalex.org/W4284894236","doi":"https://doi.org/10.1145/3502717.3532156","title":"DBSnap 2","display_name":"DBSnap 2","publication_year":2022,"publication_date":"2022-07-07","ids":{"openalex":"https://openalex.org/W4284894236","doi":"https://doi.org/10.1145/3502717.3532156"},"language":"en","primary_location":{"id":"doi:10.1145/3502717.3532156","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3502717.3532156","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 27th ACM Conference on on Innovation and Technology in Computer Science Education Vol. 2","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/A5045989690","display_name":"Yasin N. Silva","orcid":null},"institutions":[{"id":"https://openalex.org/I1925986","display_name":"Loyola University Chicago","ror":"https://ror.org/04b6x2g63","country_code":"US","type":"education","lineage":["https://openalex.org/I1925986"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yasin N. Silva","raw_affiliation_strings":["Loyola University Chicago, Chicago, IL, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Loyola University Chicago, Chicago, IL, USA","institution_ids":["https://openalex.org/I1925986"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055442482","display_name":"Alexis Loza","orcid":null},"institutions":[{"id":"https://openalex.org/I55732556","display_name":"Arizona State University","ror":"https://ror.org/03efmqc40","country_code":"US","type":"education","lineage":["https://openalex.org/I55732556"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alexis Loza","raw_affiliation_strings":["Arizona State University, Glendale, AZ, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Arizona State University, Glendale, AZ, USA","institution_ids":["https://openalex.org/I55732556"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5014315681","display_name":"Humberto Razente","orcid":"https://orcid.org/0000-0001-9687-5730"},"institutions":[{"id":"https://openalex.org/I80850581","display_name":"Universidade Federal de Uberl\u00e2ndia","ror":"https://ror.org/04x3wvr31","country_code":"BR","type":"education","lineage":["https://openalex.org/I80850581"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Humberto Razente","raw_affiliation_strings":["Universidade Federal de Uberl\u00e2ndia, Uberl\u00e2ndia, Brazil"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universidade Federal de Uberl\u00e2ndia, Uberl\u00e2ndia, Brazil","institution_ids":["https://openalex.org/I80850581"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.4375,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.71305036,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"601","last_page":"602"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10533","display_name":"Teaching and Learning Programming","score":0.9930999875068665,"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.9930999875068665,"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/T10743","display_name":"Software Testing and Debugging Techniques","score":0.927299976348877,"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"}},{"id":"https://openalex.org/T11450","display_name":"Model-Driven Software Engineering Techniques","score":0.916700005531311,"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.40837976336479187}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.40837976336479187}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3502717.3532156","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3502717.3532156","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 27th ACM Conference on on Innovation and Technology in Computer Science Education Vol. 2","raw_type":"proceedings-article"},{"id":"pmh:oai:ecommons.luc.edu:cs_facpubs-1290","is_oa":false,"landing_page_url":"https://ecommons.luc.edu/cs_facpubs/290","pdf_url":null,"source":{"id":"https://openalex.org/S4306402030","display_name":"Loyola eCommons (Loyola University of Chicago)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1925986","host_organization_name":"Loyola University Chicago","host_organization_lineage":["https://openalex.org/I1925986"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Computer Science: Faculty Publications and Other Works","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W1600117431","https://openalex.org/W2040715754","https://openalex.org/W2054962089","https://openalex.org/W2071194258","https://openalex.org/W2095718689","https://openalex.org/W2120640415","https://openalex.org/W4284894236"],"related_works":["https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2376932109","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W1596801655","https://openalex.org/W2387147530","https://openalex.org/W2373011076","https://openalex.org/W1532762289","https://openalex.org/W2277606789"],"abstract_inverted_index":{"Block-based":[0],"environments":[1,34],"for":[2],"creating":[3],"computer":[4,13],"programs":[5],"have":[6,42],"become":[7],"very":[8],"useful":[9],"learning":[10],"tools":[11,41,52],"in":[12],"science":[14],"as":[15],"they":[16],"enable":[17,149],"focusing":[18],"on":[19,27],"the":[20,96,106,124,140,144,150],"logic":[21],"of":[22,50,86,92,98,108,126,134,146,153],"a":[23,39,55,90],"program":[24],"rather":[25],"than":[26],"its":[28],"syntactical":[29],"details.":[30],"While":[31],"most":[32],"block-based":[33],"support":[35,107],"conventional":[36],"(imperative)":[37],"instructions,":[38],"few":[40],"been":[43],"proposed":[44],"to":[45,61,94],"create":[46,62],"database":[47,63,75,109,113],"queries.":[48,102],"One":[49],"these":[51],"is":[53],"DBSnap,":[54],"highly":[56],"dynamic":[57],"and":[58,68,74,100,116,121,128,148],"open-source":[59],"tool":[60],"query":[64,154],"trees":[65],"by":[66],"dragging":[67],"connecting":[69],"visual":[70,130],"blocks":[71],"representing":[72],"datasets":[73],"operators.":[76],"In":[77],"this":[78],"paper,":[79],"we":[80],"introduce":[81],"DBSnap":[82,87,135],"2,":[83],"an":[84],"extension":[85],"that":[88],"provides":[89],"set":[91],"improvements":[93,104],"facilitate":[95],"creation":[97,125,145],"simple":[99],"complex":[101],"The":[103,132],"include":[105],"views":[110],"(a":[111],"key":[112],"concept),":[114],"saving":[115],"importing":[117],"queries,":[118],"inserting,":[119],"updating,":[120],"deleting":[122],"data,":[123],"charts,":[127],"various":[129],"improvements.":[131],"demonstration":[133],"2":[136],"will":[137],"show":[138],"how":[139],"new":[141],"features":[142],"simplify":[143],"queries":[147],"graphical":[151],"visualization":[152],"results.":[155]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2022,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2022-07-09T00:00:00"}