{"id":"https://openalex.org/W2435355301","doi":"https://doi.org/10.1145/2882903.2912569","title":"Design Tradeoffs of Data Access Methods","display_name":"Design Tradeoffs of Data Access Methods","publication_year":2016,"publication_date":"2016-06-16","ids":{"openalex":"https://openalex.org/W2435355301","doi":"https://doi.org/10.1145/2882903.2912569","mag":"2435355301"},"language":"en","primary_location":{"id":"doi:10.1145/2882903.2912569","is_oa":true,"landing_page_url":"https://doi.org/10.1145/2882903.2912569","pdf_url":"http://dl.acm.org/ft_gateway.cfm?id=2912569&type=pdf","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2016 International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"http://dl.acm.org/ft_gateway.cfm?id=2912569&type=pdf","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5053040916","display_name":"Manos Athanassoulis","orcid":"https://orcid.org/0000-0003-1837-0010"},"institutions":[{"id":"https://openalex.org/I2801851002","display_name":"Harvard University Press","ror":"https://ror.org/006v7bf86","country_code":"US","type":"other","lineage":["https://openalex.org/I136199984","https://openalex.org/I2801851002"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Manos Athanassoulis","raw_affiliation_strings":["Harvard University, Cambridge, MA, USA"],"affiliations":[{"raw_affiliation_string":"Harvard University, Cambridge, MA, USA","institution_ids":["https://openalex.org/I2801851002"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5026905380","display_name":"Stratos Idreos","orcid":"https://orcid.org/0000-0002-8271-9187"},"institutions":[{"id":"https://openalex.org/I2801851002","display_name":"Harvard University Press","ror":"https://ror.org/006v7bf86","country_code":"US","type":"other","lineage":["https://openalex.org/I136199984","https://openalex.org/I2801851002"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Stratos Idreos","raw_affiliation_strings":["Harvard University, Cambridge, MA, USA"],"affiliations":[{"raw_affiliation_string":"Harvard University, Cambridge, MA, USA","institution_ids":["https://openalex.org/I2801851002"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5053040916"],"corresponding_institution_ids":["https://openalex.org/I2801851002"],"apc_list":null,"apc_paid":null,"fwci":3.839,"has_fulltext":true,"cited_by_count":24,"citation_normalized_percentile":{"value":0.9391564,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":91,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"2195","last_page":"2200"},"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.9997000098228455,"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.9997000098228455,"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/T11106","display_name":"Data Management and Algorithms","score":0.9983999729156494,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T10742","display_name":"Peer-to-Peer Network Technologies","score":0.9957000017166138,"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.8480715155601501},{"id":"https://openalex.org/keywords/data-access","display_name":"Data access","score":0.7159293293952942},{"id":"https://openalex.org/keywords/nosql","display_name":"NoSQL","score":0.6578465104103088},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5316344499588013},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5295955538749695},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.4473247230052948},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4390292167663574},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.4343971014022827},{"id":"https://openalex.org/keywords/access-method","display_name":"Access method","score":0.41550391912460327},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.4111122786998749},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.197829931974411},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.09568700194358826}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8480715155601501},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.7159293293952942},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.6578465104103088},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5316344499588013},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5295955538749695},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.4473247230052948},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4390292167663574},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.4343971014022827},{"id":"https://openalex.org/C70000936","wikidata":"https://www.wikidata.org/wiki/Q4672467","display_name":"Access method","level":2,"score":0.41550391912460327},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.4111122786998749},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.197829931974411},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.09568700194358826}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2882903.2912569","is_oa":true,"landing_page_url":"https://doi.org/10.1145/2882903.2912569","pdf_url":"http://dl.acm.org/ft_gateway.cfm?id=2912569&type=pdf","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2016 International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/2882903.2912569","is_oa":true,"landing_page_url":"https://doi.org/10.1145/2882903.2912569","pdf_url":"http://dl.acm.org/ft_gateway.cfm?id=2912569&type=pdf","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2016 International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education","score":0.4099999964237213}],"awards":[{"id":"https://openalex.org/G3144188400","display_name":"The RUM Conjecture and the Big Data Access Wizard","funder_award_id":"158936","funder_id":"https://openalex.org/F4320320924","funder_display_name":"Schweizerischer Nationalfonds zur F\u00f6rderung der Wissenschaftlichen Forschung"},{"id":"https://openalex.org/G3598902390","display_name":"La gazette et le colonel. Edouard Secr\u00e9tan, la Gazette de Lausanne et le lib\u00e9ralisme vaudois 1874-1917.","funder_award_id":"45259","funder_id":"https://openalex.org/F4320320924","funder_display_name":"Schweizerischer Nationalfonds zur F\u00f6rderung der Wissenschaftlichen Forschung"},{"id":"https://openalex.org/G4038711533","display_name":null,"funder_award_id":"P2ELP2_158936","funder_id":"https://openalex.org/F4320320924","funder_display_name":"Schweizerischer Nationalfonds zur F\u00f6rderung der Wissenschaftlichen Forschung"},{"id":"https://openalex.org/G4096930039","display_name":null,"funder_award_id":"IIS-1452595","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G4462275839","display_name":"CAREER: Evolutionary Data Systems","funder_award_id":"1452595","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G7040092462","display_name":"Word Formation as a Structuring Device of the English and Italian Lexicons: A Large-Scale Exploration.","funder_award_id":"58936","funder_id":"https://openalex.org/F4320320924","funder_display_name":"Schweizerischer Nationalfonds zur F\u00f6rderung der Wissenschaftlichen Forschung"},{"id":"https://openalex.org/G8420551860","display_name":"The Changing Meaning of Sovereignty in International Relations: A Predicate Analysis of Diplomatic Documents.","funder_award_id":"52595","funder_id":"https://openalex.org/F4320320924","funder_display_name":"Schweizerischer Nationalfonds zur F\u00f6rderung der Wissenschaftlichen Forschung"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320320924","display_name":"Schweizerischer Nationalfonds zur F\u00f6rderung der Wissenschaftlichen Forschung","ror":"https://ror.org/00yjd3n13"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2435355301.pdf","grobid_xml":"https://content.openalex.org/works/W2435355301.grobid-xml"},"referenced_works_count":95,"referenced_works":["https://openalex.org/W67853643","https://openalex.org/W175906072","https://openalex.org/W1494049834","https://openalex.org/W1501548698","https://openalex.org/W1504483039","https://openalex.org/W1533567700","https://openalex.org/W1547206386","https://openalex.org/W1633222579","https://openalex.org/W1739920298","https://openalex.org/W1851390469","https://openalex.org/W1890458195","https://openalex.org/W1916385248","https://openalex.org/W1963674762","https://openalex.org/W1967373117","https://openalex.org/W1967601791","https://openalex.org/W1970298499","https://openalex.org/W1973922778","https://openalex.org/W1978177071","https://openalex.org/W1981988185","https://openalex.org/W1982945449","https://openalex.org/W1989037929","https://openalex.org/W1997741691","https://openalex.org/W2008627910","https://openalex.org/W2014515453","https://openalex.org/W2019998825","https://openalex.org/W2029814178","https://openalex.org/W2030062409","https://openalex.org/W2035735180","https://openalex.org/W2036557187","https://openalex.org/W2066796814","https://openalex.org/W2068739275","https://openalex.org/W2070991879","https://openalex.org/W2072764742","https://openalex.org/W2073688105","https://openalex.org/W2075018787","https://openalex.org/W2077720176","https://openalex.org/W2077850713","https://openalex.org/W2080234606","https://openalex.org/W2087946700","https://openalex.org/W2088398920","https://openalex.org/W2089527922","https://openalex.org/W2096229429","https://openalex.org/W2108490710","https://openalex.org/W2108783070","https://openalex.org/W2109024523","https://openalex.org/W2111234995","https://openalex.org/W2111451400","https://openalex.org/W2111967617","https://openalex.org/W2112735105","https://openalex.org/W2116435146","https://openalex.org/W2117098610","https://openalex.org/W2117156932","https://openalex.org/W2117546628","https://openalex.org/W2117716920","https://openalex.org/W2118269922","https://openalex.org/W2118995957","https://openalex.org/W2119368079","https://openalex.org/W2123845384","https://openalex.org/W2124222502","https://openalex.org/W2127241402","https://openalex.org/W2139072600","https://openalex.org/W2139086035","https://openalex.org/W2140980002","https://openalex.org/W2151181047","https://openalex.org/W2153231238","https://openalex.org/W2155256331","https://openalex.org/W2155512447","https://openalex.org/W2155595639","https://openalex.org/W2158347038","https://openalex.org/W2159886933","https://openalex.org/W2160404300","https://openalex.org/W2165663045","https://openalex.org/W2167631575","https://openalex.org/W2243512312","https://openalex.org/W2259014610","https://openalex.org/W2294000809","https://openalex.org/W2337480916","https://openalex.org/W2344304035","https://openalex.org/W2406217447","https://openalex.org/W2489110754","https://openalex.org/W2624304035","https://openalex.org/W3002580249","https://openalex.org/W3023647491","https://openalex.org/W3138367763","https://openalex.org/W4205806386","https://openalex.org/W4252446498","https://openalex.org/W6602782649","https://openalex.org/W6630343179","https://openalex.org/W6659467978","https://openalex.org/W6677581237","https://openalex.org/W6677729785","https://openalex.org/W6677991595","https://openalex.org/W6697313945","https://openalex.org/W6713343388","https://openalex.org/W6983205581"],"related_works":["https://openalex.org/W2295775753","https://openalex.org/W2603313942","https://openalex.org/W4381416854","https://openalex.org/W4306877231","https://openalex.org/W4385834214","https://openalex.org/W2143602713","https://openalex.org/W4386408829","https://openalex.org/W2621972978","https://openalex.org/W3006323926","https://openalex.org/W3120589159"],"abstract_inverted_index":{"Database":[0],"researchers":[1],"and":[2,11,35,55,58,96,119,128],"practitioners":[3],"have":[4,146],"been":[5,23],"building":[6],"methods":[7,21,69,75,144],"to":[8,27,29,49,125,141],"store,":[9],"access,":[10],"update":[12,117],"data":[13,42,83],"for":[14],"more":[15,70],"than":[16,72],"five":[17],"decades.":[18],"Designing":[19],"access":[20,68,93,143],"has":[22],"a":[24,112],"constant":[25],"effort":[26],"adapt":[28],"the":[30,64,78,101,154],"ever":[31],"changing":[32],"underlying":[33],"hardware":[34],"workload":[36],"requirements.":[37],"The":[38],"recent":[39,90],"explosion":[40],"in":[41,47,92,100],"system":[43],"designs":[44,127],"-":[45,61],"including,":[46],"addition":[48],"traditional":[50],"SQL":[51],"systems,":[52],"NoSQL,":[53],"NewSQL,":[54],"other":[56],"relational":[57],"non-relational":[59],"systems":[60],"makes":[62],"understanding":[63],"tradeoffs":[65],"of":[66,80,114,156],"designing":[67],"important":[71],"ever.":[73],"Access":[74],"are":[76],"at":[77],"core":[79],"any":[81],"new":[82,137],"system.":[84],"In":[85,133],"this":[86],"tutorial":[87],"we":[88,97,135],"survey":[89],"developments":[91],"method":[94],"design":[95,102],"place":[98],"them":[99],"space":[103],"where":[104],"each":[105],"approach":[106],"focuses":[107],"primarily":[108],"on":[109,139],"one":[110],"or":[111],"subset":[113],"read":[115],"performance,":[116,118],"memory":[120],"utilization.":[121],"We":[122],"discuss":[123,136],"how":[124,140],"utilize":[126],"lessons-learned":[129],"from":[130],"past":[131],"research.":[132],"addition,":[134],"ideas":[138],"build":[142],"that":[145],"tunable":[147],"behavior,":[148],"as":[149],"well":[150],"as,":[151],"what":[152],"is":[153],"scenery":[155],"open":[157],"research":[158],"problems.":[159]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":3},{"year":2019,"cited_by_count":6},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":4}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2025-10-10T00:00:00"}