{"id":"https://openalex.org/W6906585247","doi":"https://doi.org/10.18420/btw2025-55","title":"Plaquette: Visualizing Redundancies in Relational Data","display_name":"Plaquette: Visualizing Redundancies in Relational Data","publication_year":2025,"publication_date":"2025-01-01","ids":{"openalex":"https://openalex.org/W6906585247","doi":"https://doi.org/10.18420/btw2025-55"},"language":"en","primary_location":{"id":"doi:10.18420/btw2025-55","is_oa":true,"landing_page_url":"https://doi.org/10.18420/btw2025-55","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/btw2025-55","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"K\u00f6hnen, Christoph","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"K\u00f6hnen, Christoph","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":null,"display_name":"Zumbr\u00e4gel, Jens","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zumbr\u00e4gel, Jens","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":null,"display_name":"Scherzinger, Stefanie","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Scherzinger, Stefanie","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":3,"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.39024968,"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/T10799","display_name":"Data Visualization and Analytics","score":0.6360999941825867,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T10799","display_name":"Data Visualization and Analytics","score":0.6360999941825867,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T11875","display_name":"Statistics Education and Methodologies","score":0.13030000030994415,"subfield":{"id":"https://openalex.org/subfields/2613","display_name":"Statistics and Probability"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.05429999902844429,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/intuition","display_name":"Intuition","score":0.6071000099182129},{"id":"https://openalex.org/keywords/visualization","display_name":"Visualization","score":0.6039000153541565},{"id":"https://openalex.org/keywords/analogy","display_name":"Analogy","score":0.5203999876976013},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.49709999561309814},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4465000033378601},{"id":"https://openalex.org/keywords/functional-dependency","display_name":"Functional dependency","score":0.3982999920845032}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7196999788284302},{"id":"https://openalex.org/C132010649","wikidata":"https://www.wikidata.org/wiki/Q189222","display_name":"Intuition","level":2,"score":0.6071000099182129},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.6039000153541565},{"id":"https://openalex.org/C521332185","wikidata":"https://www.wikidata.org/wiki/Q185816","display_name":"Analogy","level":2,"score":0.5203999876976013},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.49709999561309814},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4465000033378601},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.3982999920845032},{"id":"https://openalex.org/C172367668","wikidata":"https://www.wikidata.org/wiki/Q6504956","display_name":"Data visualization","level":3,"score":0.391400009393692},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.38600000739097595},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.3537999987602234},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.336899995803833},{"id":"https://openalex.org/C152124472","wikidata":"https://www.wikidata.org/wiki/Q1204361","display_name":"Redundancy (engineering)","level":2,"score":0.335099995136261},{"id":"https://openalex.org/C12713177","wikidata":"https://www.wikidata.org/wiki/Q1900281","display_name":"Perspective (graphical)","level":2,"score":0.31310001015663147},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.29170000553131104},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.27810001373291016},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.2687999904155731},{"id":"https://openalex.org/C177877439","wikidata":"https://www.wikidata.org/wiki/Q7604413","display_name":"Statistical relational learning","level":3,"score":0.2605000138282776}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.18420/btw2025-55","is_oa":true,"landing_page_url":"https://doi.org/10.18420/btw2025-55","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/btw2025-55","is_oa":true,"landing_page_url":"https://doi.org/10.18420/btw2025-55","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":[{"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education","score":0.7723484039306641}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Functional":[0],"dependencies":[1,21],"are":[2,94],"a":[3,39,125,144],"fundamental":[4],"topic":[5],"in":[6,25,127,158],"database":[7],"education,":[8],"yet":[9],"students":[10],"often":[11],"find":[12],"the":[13,63,80,137],"concept":[14,89,138],"abstract.":[15],"To":[16],"foster":[17],"understanding":[18],"of":[19,42,82,90,109,139],"functional":[20,83,112,140],"that":[22,47,105],"capture":[23],"redundancies":[24,43,70,157],"relational":[26],"data,":[27,50,160],"we":[28,66,76],"propose":[29],"an":[30],"educational":[31],"software":[32],"tool":[33,37],"called":[34],"Plaquette.":[35,164],"This":[36],"offers":[38],"novel":[40],"visualization":[41],"by":[44,78,86],"coloring":[45],"cells":[46],"contain":[48],"redundant":[49],"where":[51],"deeper":[52],"hues":[53],"indicate":[54],"stronger":[55],"redundancies.":[56],"In":[57,73],"analogy":[58],"to":[59,68,97,152],"plaque":[60,123],"tests":[61],"at":[62],"dentist's":[64],"office,":[65],"refer":[67],"these":[69],"as":[71],"\"plaque\".":[72],"our":[74,88,148],"demo,":[75],"begin":[77],"recapping":[79],"definition":[81],"dependencies,":[84],"followed":[85],"introducing":[87],"plaque.":[91],"Demo":[92],"participants":[93,130],"then":[95],"invited":[96],"interact":[98],"with":[99,118],"Plaquette,":[100],"and":[101,111],"assess":[102],"sample":[103],"scenarios":[104,117],"showcase":[106],"small":[107],"examples":[108],"relations":[110],"dependencies.":[113,141],"By":[114],"swiping":[115],"through":[116],"correct":[119],"but":[120],"also":[121],"fake":[122],"on":[124],"tablet":[126],"Tinder-style":[128],"interaction,":[129],"can":[131],"playfully":[132],"improve":[133],"their":[134],"intuition":[135],"for":[136],"Beyond":[142],"contributing":[143],"new":[145],"teaching":[146],"tool,":[147],"ultimate":[149],"goal":[150],"is":[151],"assist":[153],"data":[154],"analysts":[155],"explore":[156],"real-world":[159],"using":[161],"tools":[162],"like":[163]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}