{"id":"https://openalex.org/W2099210599","doi":"https://doi.org/10.1145/1265530.1265551","title":"A crash course on database queries","display_name":"A crash course on database queries","publication_year":2007,"publication_date":"2007-06-11","ids":{"openalex":"https://openalex.org/W2099210599","doi":"https://doi.org/10.1145/1265530.1265551","mag":"2099210599"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/1265530.1265551","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"proceedings-article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://documentserver.uhasselt.be//bitstream/1942/7736/1/peking.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5089823917","display_name":"Jan Van den Bussche","orcid":"https://orcid.org/0000-0003-0072-3252"},"institutions":[{"id":"https://openalex.org/I878454856","display_name":"Hasselt University","ror":"https://ror.org/04nbhqj75","country_code":"BE","type":"funder","lineage":["https://openalex.org/I878454856"]}],"countries":["BE"],"is_corresponding":false,"raw_author_name":"Jan Van den Bussche","raw_affiliation_strings":[" Hasselt University"],"affiliations":[{"raw_affiliation_string":" Hasselt University","institution_ids":["https://openalex.org/I878454856"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110598353","display_name":"Dirk Van Gucht","orcid":null},"institutions":[{"id":"https://openalex.org/I592451","display_name":"Indiana University","ror":"https://ror.org/01kg8sb98","country_code":"US","type":"funder","lineage":["https://openalex.org/I4407990318","https://openalex.org/I592451"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Dirk Van Gucht","raw_affiliation_strings":["Indiana University"],"affiliations":[{"raw_affiliation_string":"Indiana University","institution_ids":["https://openalex.org/I592451"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5022558461","display_name":"Stijn Vansummeren","orcid":"https://orcid.org/0000-0001-7793-9049"},"institutions":[{"id":"https://openalex.org/I878454856","display_name":"Hasselt University","ror":"https://ror.org/04nbhqj75","country_code":"BE","type":"funder","lineage":["https://openalex.org/I878454856"]}],"countries":["BE"],"is_corresponding":false,"raw_author_name":"Stijn Vansummeren","raw_affiliation_strings":[" Hasselt University"],"affiliations":[{"raw_affiliation_string":" Hasselt University","institution_ids":["https://openalex.org/I878454856"]}]}],"institution_assertions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.751,"has_fulltext":true,"fulltext_origin":"ngrams","cited_by_count":24,"citation_normalized_percentile":{"value":0.785878,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":90},"biblio":{"volume":"146","issue":null,"first_page":"143","last_page":"154"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10126","display_name":"Logic, programming, and type systems","score":0.9993,"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"}},"topics":[{"id":"https://openalex.org/T10126","display_name":"Logic, programming, and type systems","score":0.9993,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9983,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9937,"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/course","display_name":"Course (navigation)","score":0.7488681},{"id":"https://openalex.org/keywords/reflection","display_name":"Reflection","score":0.6402812},{"id":"https://openalex.org/keywords/expressive-power","display_name":"Expressive power","score":0.4251446}],"concepts":[{"id":"https://openalex.org/C183469790","wikidata":"https://www.wikidata.org/wiki/Q333501","display_name":"Crash","level":2,"score":0.89577854},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8420935},{"id":"https://openalex.org/C2777552389","wikidata":"https://www.wikidata.org/wiki/Q1962728","display_name":"Course (navigation)","level":2,"score":0.7488681},{"id":"https://openalex.org/C65682993","wikidata":"https://www.wikidata.org/wiki/Q1056451","display_name":"Reflection (computer programming)","level":2,"score":0.6402812},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.58285534},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4333938},{"id":"https://openalex.org/C195818886","wikidata":"https://www.wikidata.org/wiki/Q5421724","display_name":"Expressive power","level":2,"score":0.4251446},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3334727},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C1276947","wikidata":"https://www.wikidata.org/wiki/Q333","display_name":"Astronomy","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/1265530.1265551","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},{"is_oa":true,"landing_page_url":"http://hdl.handle.net/1942/7736","pdf_url":"https://documentserver.uhasselt.be//bitstream/1942/7736/1/peking.pdf","source":{"id":"https://openalex.org/S4306401926","display_name":"Document Server@UHasselt (UHasselt)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_indexed_in_scopus":false,"is_core":false,"host_organization":"https://openalex.org/I878454856","host_organization_name":"Hasselt University","host_organization_lineage":["https://openalex.org/I878454856"],"host_organization_lineage_names":["Hasselt University"],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true}],"best_oa_location":{"is_oa":true,"landing_page_url":"http://hdl.handle.net/1942/7736","pdf_url":"https://documentserver.uhasselt.be//bitstream/1942/7736/1/peking.pdf","source":{"id":"https://openalex.org/S4306401926","display_name":"Document Server@UHasselt (UHasselt)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_indexed_in_scopus":false,"is_core":false,"host_organization":"https://openalex.org/I878454856","host_organization_name":"Hasselt University","host_organization_lineage":["https://openalex.org/I878454856"],"host_organization_lineage_names":["Hasselt University"],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true},"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":66,"referenced_works":["https://openalex.org/W1481729347","https://openalex.org/W1500120746","https://openalex.org/W1507881659","https://openalex.org/W1557561422","https://openalex.org/W1558832481","https://openalex.org/W1563866436","https://openalex.org/W1595148527","https://openalex.org/W1595479588","https://openalex.org/W1605914096","https://openalex.org/W1606507025","https://openalex.org/W172857819","https://openalex.org/W1769844539","https://openalex.org/W178270839","https://openalex.org/W1829301681","https://openalex.org/W1869733288","https://openalex.org/W1888032506","https://openalex.org/W1908950999","https://openalex.org/W1966814918","https://openalex.org/W1975284402","https://openalex.org/W1979629711","https://openalex.org/W1979966822","https://openalex.org/W1981870753","https://openalex.org/W1989783863","https://openalex.org/W1995362929","https://openalex.org/W1997533292","https://openalex.org/W2000487974","https://openalex.org/W2004943427","https://openalex.org/W2005835473","https://openalex.org/W2019376542","https://openalex.org/W2021589354","https://openalex.org/W2033229728","https://openalex.org/W2035512098","https://openalex.org/W2036378583","https://openalex.org/W2037575886","https://openalex.org/W2045522022","https://openalex.org/W2055069928","https://openalex.org/W2060439566","https://openalex.org/W2065419751","https://openalex.org/W2075994573","https://openalex.org/W2092632814","https://openalex.org/W2094455839","https://openalex.org/W2102699068","https://openalex.org/W2113675087","https://openalex.org/W2114766826","https://openalex.org/W2130872776","https://openalex.org/W2131300191","https://openalex.org/W2134356404","https://openalex.org/W2143127574","https://openalex.org/W2151856838","https://openalex.org/W2154273644","https://openalex.org/W2157821258","https://openalex.org/W2161001883","https://openalex.org/W2161421551","https://openalex.org/W2163976959","https://openalex.org/W2166822586","https://openalex.org/W2170812622","https://openalex.org/W2173322574","https://openalex.org/W2258030721","https://openalex.org/W2294680933","https://openalex.org/W2495828588","https://openalex.org/W2597834528","https://openalex.org/W2673028924","https://openalex.org/W2912959941","https://openalex.org/W2916031840","https://openalex.org/W3098197594","https://openalex.org/W4249075482"],"related_works":["https://openalex.org/W626940945","https://openalex.org/W4362648715","https://openalex.org/W4318717247","https://openalex.org/W2952186872","https://openalex.org/W2736755255","https://openalex.org/W2317874921","https://openalex.org/W2267656092","https://openalex.org/W2046693005","https://openalex.org/W2026516036","https://openalex.org/W2009385780"],"abstract_inverted_index":{"Complex":[0],"database":[1,59],"queries,":[2],"like":[3],"programs":[4],"in":[5],"general,":[6],"can":[7,10,48],"\"crash\",":[8],"i.e.,":[9],"raise":[11],"runtime":[12],"errors.":[13],"We":[14,33],"want":[15,25],"to":[16,26,62],"avoid":[17],"crashes":[18],"without":[19],"losing":[20],"expressive":[21],"power,":[22],"or":[23],"we":[24],"correctly":[27],"predict":[28],"the":[29,55],"absence":[30],"of":[31,58],"crashes.":[32],"show":[34],"how":[35],"concepts":[36],"and":[37,46],"techniques":[38],"from":[39],"programming":[40],"language":[41],"theory,":[42],"notably":[43],"type":[44],"systems":[45],"reflection,":[47],"be":[49],"adaptedto":[50],"this":[51],"end.":[52],"Of":[53],"course,":[54],"specific":[56],"nature":[57],"queries":[60],"(asopposed":[61],"general":[63],"programs),":[64],"also":[65],"requires":[66],"some":[67],"new":[68,71],"methods,":[69],"andraises":[70],"questions.":[72]},"abstract_inverted_index_v3":null,"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2099210599","counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":4},{"year":2012,"cited_by_count":3}],"updated_date":"2025-03-19T02:54:35.638976","created_date":"2016-06-24"}