{"id":"https://openalex.org/W4281782428","doi":"https://doi.org/10.1145/3531072.3535320","title":"Teaching Data Models with TriQL","display_name":"Teaching Data Models with TriQL","publication_year":2022,"publication_date":"2022-06-07","ids":{"openalex":"https://openalex.org/W4281782428","doi":"https://doi.org/10.1145/3531072.3535320"},"language":"en","primary_location":{"id":"doi:10.1145/3531072.3535320","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3531072.3535320","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"1st International Workshop on Data Systems Education","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/A5014235464","display_name":"Abdussalam Alawini","orcid":"https://orcid.org/0000-0003-1106-7190"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Abdussalam Alawini","raw_affiliation_strings":["University of Illinois at Urbana-Champaign, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Illinois at Urbana-Champaign, USA","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101177583","display_name":"P. V. Siva Rao","orcid":null},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Peilin Rao","raw_affiliation_strings":["Carnegie Mellon University, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Carnegie Mellon University, USA","institution_ids":["https://openalex.org/I74973139"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101177584","display_name":"Leyao Zhou","orcid":null},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Leyao Zhou","raw_affiliation_strings":["University of Illinois at Urbana-Champaign, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Illinois at Urbana-Champaign, USA","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5002394711","display_name":"Lujia Kang","orcid":null},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Lujia Kang","raw_affiliation_strings":["University of Illinois at Urbana-Champaign, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Illinois at Urbana-Champaign, USA","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5045711030","display_name":"Ping-Che Ho","orcid":"https://orcid.org/0000-0001-9148-428X"},"institutions":[{"id":"https://openalex.org/I4210158349","display_name":"Pure Storage (United States)","ror":"https://ror.org/058x40223","country_code":"US","type":"company","lineage":["https://openalex.org/I4210158349"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ping-Che Ho","raw_affiliation_strings":["Pure Storage, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Pure Storage, USA","institution_ids":["https://openalex.org/I4210158349"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.2621,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.93659935,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"16","last_page":"21"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9976999759674072,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9976999759674072,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9950000047683716,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9937999844551086,"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/computer-science","display_name":"Computer science","score":0.8539147973060608},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.7791006565093994},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.7260497808456421},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.6460199952125549},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6335132122039795},{"id":"https://openalex.org/keywords/graph-database","display_name":"Graph database","score":0.580534815788269},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.5647146701812744},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5579549074172974},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.5145149230957031},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.49615296721458435},{"id":"https://openalex.org/keywords/database-testing","display_name":"Database testing","score":0.48447322845458984},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.47776734828948975},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.4723709225654602},{"id":"https://openalex.org/keywords/database-theory","display_name":"Database theory","score":0.4492161273956299},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.35929808020591736},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.1440790891647339}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8539147973060608},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.7791006565093994},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.7260497808456421},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.6460199952125549},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6335132122039795},{"id":"https://openalex.org/C176225458","wikidata":"https://www.wikidata.org/wiki/Q595971","display_name":"Graph database","level":3,"score":0.580534815788269},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.5647146701812744},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5579549074172974},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.5145149230957031},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.49615296721458435},{"id":"https://openalex.org/C78161392","wikidata":"https://www.wikidata.org/wiki/Q5227414","display_name":"Database testing","level":4,"score":0.48447322845458984},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.47776734828948975},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.4723709225654602},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.4492161273956299},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.35929808020591736},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.1440790891647339}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3531072.3535320","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3531072.3535320","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"1st International Workshop on Data Systems Education","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.44999998807907104,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":11,"referenced_works":["https://openalex.org/W1655340442","https://openalex.org/W2510119520","https://openalex.org/W2514180210","https://openalex.org/W2595180720","https://openalex.org/W2790986560","https://openalex.org/W2793593730","https://openalex.org/W2799141030","https://openalex.org/W2886783363","https://openalex.org/W2943537813","https://openalex.org/W4236151674","https://openalex.org/W6637060961"],"related_works":["https://openalex.org/W2460926837","https://openalex.org/W1558507836","https://openalex.org/W2188578519","https://openalex.org/W2547170823","https://openalex.org/W2386848747","https://openalex.org/W2007986108","https://openalex.org/W1502610062","https://openalex.org/W1588786827","https://openalex.org/W2607324466","https://openalex.org/W2141686985"],"abstract_inverted_index":{"With":[0],"the":[1,12,25,49,67,82,110],"abundance":[2],"of":[3,84,115],"database":[4,35,45,55,69,118,150,158,169,184],"systems":[5,70],"implementing":[6,94],"various":[7],"data":[8,29,78,96],"models,":[9,17,170],"such":[10],"as":[11],"relational,":[13],"graph,":[14],"and":[15,31,40,57,59,112,129,143,174,186],"document-oriented":[16,132],"learners":[18,136],"often":[19],"find":[20],"it":[21,86],"challenging":[22],"to":[23,32,89,92,141,155,166],"understand":[24],"trade-offs":[26],"between":[27],"different":[28],"models":[30],"decide":[33],"which":[34],"system":[36,105],"they":[37],"should":[38],"learn":[39,109],"why.":[41],"Additionally,":[42],"most":[43],"introductory":[44],"courses":[46],"focus":[47],"on":[48],"predominant":[50],"relational":[51,68,123],"model":[52],"for":[53,106],"teaching":[54],"design":[56,142],"programming,":[58],"do":[60],"not":[61],"discuss":[62],"other":[63,95],"emerging":[64],"databases.":[65],"While":[66],"still":[71],"play":[72],"a":[73,104,137,145,148,172],"vital":[74],"role":[75],"in":[76],"modern":[77],"systems,":[79,119],"especially":[80],"with":[81],"emergence":[83],"NewSQL,":[85],"is":[87],"crucial":[88],"introduce":[90,102],"students":[91],"databases":[93],"models.":[97],"In":[98],"this":[99],"paper,":[100],"we":[101],"TriQL,":[103],"helping":[107],"novices":[108],"schema":[111,151],"query":[113,146],"languages":[114],"three":[116],"major":[117],"including":[120],"MySQL":[121],"(a":[122,126,131],"database),":[124,128],"Neo4J":[125],"graph":[127],"MongoDB":[130],"database).":[133],"TriQL":[134,161],"offers":[135],"graphical":[138],"user":[139],"interface":[140],"execute":[144],"against":[147],"generic":[149],"without":[152],"requiring":[153],"them":[154],"have":[156],"any":[157],"programming":[159],"experience.":[160],"follows":[162],"an":[163],"interactive":[164],"approach":[165],"learning":[167,176],"new":[168],"supporting":[171],"dynamic":[173],"agile":[175],"environment":[177],"that":[178],"can":[179],"be":[180],"easily":[181],"integrated":[182],"into":[183],"labs":[185],"homework":[187],"assignments.":[188]},"counts_by_year":[{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}