{"id":"https://openalex.org/W2274222329","doi":"https://doi.org/10.1145/2839509.2844638","title":"chidb","display_name":"chidb","publication_year":2016,"publication_date":"2016-02-17","ids":{"openalex":"https://openalex.org/W2274222329","doi":"https://doi.org/10.1145/2839509.2844638","mag":"2274222329"},"language":"en","primary_location":{"id":"doi:10.1145/2839509.2844638","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2839509.2844638","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 47th ACM Technical Symposium on Computing Science 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/A5019993482","display_name":"Borja Sotomayor","orcid":null},"institutions":[{"id":"https://openalex.org/I39422238","display_name":"University of Illinois Chicago","ror":"https://ror.org/02mpq6x41","country_code":"US","type":"education","lineage":["https://openalex.org/I39422238"]},{"id":"https://openalex.org/I40347166","display_name":"University of Chicago","ror":"https://ror.org/024mw5h28","country_code":"US","type":"education","lineage":["https://openalex.org/I40347166"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Borja Sotomayor","raw_affiliation_strings":["University of Chicago, Chicago, IL, USA"],"affiliations":[{"raw_affiliation_string":"University of Chicago, Chicago, IL, USA","institution_ids":["https://openalex.org/I40347166","https://openalex.org/I39422238"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5034853790","display_name":"Adam Shaw","orcid":null},"institutions":[{"id":"https://openalex.org/I40347166","display_name":"University of Chicago","ror":"https://ror.org/024mw5h28","country_code":"US","type":"education","lineage":["https://openalex.org/I40347166"]},{"id":"https://openalex.org/I39422238","display_name":"University of Illinois Chicago","ror":"https://ror.org/02mpq6x41","country_code":"US","type":"education","lineage":["https://openalex.org/I39422238"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Adam Shaw","raw_affiliation_strings":["University of Chicago, Chicago, IL, USA"],"affiliations":[{"raw_affiliation_string":"University of Chicago, Chicago, IL, USA","institution_ids":["https://openalex.org/I40347166","https://openalex.org/I39422238"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5019993482"],"corresponding_institution_ids":["https://openalex.org/I39422238","https://openalex.org/I40347166"],"apc_list":null,"apc_paid":null,"fwci":0.5791,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.69624477,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"407","last_page":"412"},"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.9972000122070312,"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.9972000122070312,"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/T12490","display_name":"Software Engineering and Design Patterns","score":0.9930999875068665,"subfield":{"id":"https://openalex.org/subfields/3303","display_name":"Development"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10126","display_name":"Logic, programming, and type systems","score":0.9559999704360962,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.852204442024231},{"id":"https://openalex.org/keywords/compiler","display_name":"Compiler","score":0.8409073948860168},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.8000103831291199},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.7086399793624878},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5553367733955383},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"Relational algebra","score":0.4769119918346405},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.47212108969688416},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.32309120893478394},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.31169769167900085}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.852204442024231},{"id":"https://openalex.org/C169590947","wikidata":"https://www.wikidata.org/wiki/Q47506","display_name":"Compiler","level":2,"score":0.8409073948860168},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8000103831291199},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.7086399793624878},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5553367733955383},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.4769119918346405},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.47212108969688416},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.32309120893478394},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.31169769167900085}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2839509.2844638","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2839509.2844638","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 47th ACM Technical Symposium on Computing Science Education","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5699999928474426,"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":7,"referenced_works":["https://openalex.org/W1595906644","https://openalex.org/W1812005020","https://openalex.org/W1995994586","https://openalex.org/W2016235562","https://openalex.org/W2216848248","https://openalex.org/W3005595343","https://openalex.org/W4248986373"],"related_works":["https://openalex.org/W2085988990","https://openalex.org/W2056340443","https://openalex.org/W1639806124","https://openalex.org/W3022423983","https://openalex.org/W12347151","https://openalex.org/W196537285","https://openalex.org/W2163168510","https://openalex.org/W2164688391","https://openalex.org/W1989374494","https://openalex.org/W3022939710"],"abstract_inverted_index":{"We":[0],"present":[1],"chidb,":[2],"a":[3,16,29,35,43,56],"medium":[4],"to":[5,71,78,121],"large-scale":[6],"programming":[7,87],"project":[8,83,103],"where":[9],"students":[10],"implement":[11],"the":[12,60,64,85,123],"main":[13],"components":[14],"of":[15,37,59,107,127],"relational":[17,61],"database":[18,30],"management":[19],"system,":[20],"including":[21],"B-tree":[22],"data":[23],"structures":[24],"for":[25,93,111],"tables":[26],"and":[27,34,39,42,73,80,89,119,125],"indexes,":[28],"machine":[31],"with":[32],"registers":[33],"selection":[36],"high-level":[38],"low-level":[40],"instructions,":[41],"SQL":[44,51],"compiler":[45],"targeting":[46],"that":[47,66],"machine.":[48],"Moreover,":[49],"chidb's":[50],"compiler's":[52],"internal":[53],"representation":[54],"is":[55,75,90,115],"direct":[57],"encoding":[58],"algebra,":[62],"whereby":[63],"theory":[65],"might":[67],"otherwise":[68],"be":[69],"relegated":[70],"notes":[72],"blackboards":[74],"directly":[76],"connected":[77],"practice":[79],"experience.":[81],"The":[82],"uses":[84],"C":[86],"language":[88],"demonstrably":[91],"suitable":[92],"use":[94],"in":[95],"advanced":[96,112],"undergraduate":[97],"courses;":[98],"we":[99],"have":[100],"administered":[101],"this":[102],"through":[104],"five":[105],"iterations":[106],"our":[108],"databases":[109],"course":[110],"undergraduates.":[113],"chidb":[114],"freely":[116],"available":[117],"online":[118],"customizable":[120],"suit":[122],"needs":[124],"tastes":[126],"any":[128],"particular":[129],"instructor.":[130]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2016-06-24T00:00:00"}