{"id":"https://openalex.org/W4252571323","doi":"https://doi.org/10.1145/16894.16878","title":"Query processing in main memory database management systems","display_name":"Query processing in main memory database management systems","publication_year":1986,"publication_date":"1986-01-01","ids":{"openalex":"https://openalex.org/W4252571323","doi":"https://doi.org/10.1145/16894.16878"},"language":"en","primary_location":{"id":"doi:10.1145/16894.16878","doi":"https://doi.org/10.1145/16894.16878","is_oa":false,"landing_page_url":"https://doi.org/10.1145/16894.16878","pdf_url":null,"source":{"id":"https://openalex.org/S4393915683","display_name":"ACM SIGMOD International Conference on Management of Data (SIGMOD)","issn_l":"0730-8078","issn":["0730-8078"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1986 ACM SIGMOD international conference on Management of data - SIGMOD '86","raw_type":"proceedings-article"},"volume":null,"type":"conference-paper","is_traditional":true,"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/A5081243476","display_name":"Tobin J. Lehman","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Tobin J. Lehman","raw_affiliation_strings":["Computer Sciences Department, University of Wisconsin, Madison, WI"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Sciences Department, University of Wisconsin, Madison, WI","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5011512061","display_name":"Michael J. Carey","orcid":"https://orcid.org/0000-0003-1561-4059","observed_orcids":["https://orcid.org/0000-0003-1561-4059"]},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Michael J. Carey","raw_affiliation_strings":["Computer Sciences Department, University of Wisconsin, Madison, WI"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Sciences Department, University of Wisconsin, Madison, WI","institution_ids":["https://openalex.org/I135310074"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I135310074"],"apc_list":null,"apc_paid":null,"fwci":4.3202,"has_fulltext":false,"cited_by_count":93,"citation_normalized_percentile":{"value":0.95067265,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":87,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"239","last_page":"250"},"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.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11106","display_name":"Data Management and Algorithms","score":0.00039999998989515007,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11269","display_name":"Algorithms and Data Compression","score":0.0,"subfield":{"id":"https://openalex.org/subfields/2614","display_name":"Theoretical Computer Science"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/query-processing","display_name":"query processing","score":0.9520000219345093},{"id":"https://openalex.org/keywords/selection-algorithm","display_name":"selection algorithm","score":0.6169999837875366},{"id":"https://openalex.org/keywords/join-algorithms","display_name":"join algorithms","score":0.8029999732971191},{"id":"https://openalex.org/keywords/projection","display_name":"projection","score":0.574999988079071},{"id":"https://openalex.org/keywords/hashing","display_name":"hashing","score":0.6700000166893005},{"id":"https://openalex.org/keywords/sort-merge-join","display_name":"sort-merge join","score":0.9879999756813049}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8749222159385681},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.6561869978904724},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.587298572063446},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5559954047203064},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5377253890037537},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.5314050316810608},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5283801555633545},{"id":"https://openalex.org/C123593499","wikidata":"https://www.wikidata.org/wiki/Q6008583","display_name":"In-Memory Processing","level":5,"score":0.4133131802082062},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3431706428527832},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.32648950815200806},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.22321614623069763},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.21371063590049744},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.18939325213432312},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/16894.16878","doi":"https://doi.org/10.1145/16894.16878","is_oa":false,"landing_page_url":"https://doi.org/10.1145/16894.16878","pdf_url":null,"source":{"id":"https://openalex.org/S4393915683","display_name":"ACM SIGMOD International Conference on Management of Data (SIGMOD)","issn_l":"0730-8078","issn":["0730-8078"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1986 ACM SIGMOD international conference on Management of data - SIGMOD '86","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W189943346","https://openalex.org/W4253586667","https://openalex.org/W2115481396","https://openalex.org/W1979648938","https://openalex.org/W7166030930","https://openalex.org/W2372173322","https://openalex.org/W4292080258","https://openalex.org/W2083180471","https://openalex.org/W2222008124","https://openalex.org/W2547410375"],"abstract_inverted_index":{"Most":[0],"previous":[1],"work":[2,22,129],"in":[3,66,86,119,147],"the":[4,14,64,80,109],"area":[5],"of":[6,16,50,82],"main":[7,60,148],"memory":[8,39,61,69,120],"database":[9,71],"systems":[10],"has":[11,144],"focused":[12],"on":[13],"problem":[15,81],"developing":[17],"query":[18,35],"processing":[19,36,83,118,132],"techniques":[20],"that":[21,104,126,137],"well":[23,113,130],"with":[24,45],"a":[25,46,59,68,74,105,145],"very":[26,47],"large":[27],"buffer":[28],"pool.":[29],"In":[30],"this":[31,87],"paper,":[32],"we":[33],"address":[34,79],"issues":[37],"for":[38,58,92,114,131],"resident":[40,70,121],"relational":[41,84],"databases,":[42],"an":[43,56,138],"environment":[44],"different":[48],"set":[49],"costs":[51],"and":[52,95,98,116,134,136],"priorities.":[53],"We":[54,77,102,123],"present":[55],"architecture":[57],"DBMS,":[62],"discussing":[63],"ways":[65],"which":[67],"differs":[72],"from":[73],"disk-based":[75],"database.":[76],"then":[78],"queries":[85],"architecture,":[88],"considering":[89],"alternative":[90],"algorithms":[91],"selection,":[93],"projection,":[94],"join":[96,117,140],"operations":[97],"studying":[99],"their":[100],"performance.":[101],"show":[103,125],"new":[106],"index":[107],"structure,":[108],"T":[110],"Tree,":[111],"works":[112],"selection":[115],"databases.":[122],"also":[124],"hashing":[127],"methods":[128],"projections":[133],"joins,":[135],"old":[139],"method,":[141],"sort-merge,":[142],"still":[143],"place":[146],"memory.":[149]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":1},{"year":2016,"cited_by_count":5},{"year":2015,"cited_by_count":4},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":3}],"updated_date":"2026-11-07T11:25:07.637180","created_date":"2022-05-12T00:00:00"}