{"id":"https://openalex.org/W2082317049","doi":"https://doi.org/10.1145/1565694.1565696","title":"Join processing for flash SSDs","display_name":"Join processing for flash SSDs","publication_year":2009,"publication_date":"2009-06-28","ids":{"openalex":"https://openalex.org/W2082317049","doi":"https://doi.org/10.1145/1565694.1565696","mag":"2082317049"},"language":"en","primary_location":{"id":"doi:10.1145/1565694.1565696","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1565694.1565696","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Fifth International Workshop on Data Management on New Hardware","raw_type":"proceedings-article"},"type":"conference-paper","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/A5024989829","display_name":"Jaeyoung Do","orcid":"https://orcid.org/0000-0003-1275-1621"},"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":"Jaeyoung Do","raw_affiliation_strings":["Univ. of Wisconsin-Madison","University of Wisconsin, Madison"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Univ. of Wisconsin-Madison","institution_ids":["https://openalex.org/I135310074"]},{"raw_affiliation_string":"University of Wisconsin, Madison","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5069237428","display_name":"Jignesh M. Patel","orcid":"https://orcid.org/0000-0003-3653-2538"},"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":"Jignesh M. Patel","raw_affiliation_strings":["Univ. of Wisconsin-Madison","University of Wisconsin, Madison"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Univ. of Wisconsin-Madison","institution_ids":["https://openalex.org/I135310074"]},{"raw_affiliation_string":"University of Wisconsin, Madison","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":null,"has_fulltext":false,"cited_by_count":28,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"8"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":1.0,"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/T11181","display_name":"Advanced Data Storage Technologies","score":1.0,"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/T12162","display_name":"Cellular Automata and Applications","score":0.9936000108718872,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9753000140190125,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/flash","display_name":"Flash (photography)","score":0.8043128848075867},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7623705267906189},{"id":"https://openalex.org/keywords/flash-file-system","display_name":"Flash file system","score":0.6705166101455688},{"id":"https://openalex.org/keywords/reuse","display_name":"Reuse","score":0.6539621353149414},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.5954417586326599},{"id":"https://openalex.org/keywords/flash-memory","display_name":"Flash memory","score":0.50065016746521},{"id":"https://openalex.org/keywords/solid-state","display_name":"Solid-state","score":0.44910264015197754},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.43486860394477844},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.36606818437576294},{"id":"https://openalex.org/keywords/embedded-system","display_name":"Embedded system","score":0.35566890239715576},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.11325034499168396}],"concepts":[{"id":"https://openalex.org/C2777526259","wikidata":"https://www.wikidata.org/wiki/Q221836","display_name":"Flash (photography)","level":2,"score":0.8043128848075867},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7623705267906189},{"id":"https://openalex.org/C27670709","wikidata":"https://www.wikidata.org/wiki/Q5457555","display_name":"Flash file system","level":4,"score":0.6705166101455688},{"id":"https://openalex.org/C206588197","wikidata":"https://www.wikidata.org/wiki/Q846574","display_name":"Reuse","level":2,"score":0.6539621353149414},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.5954417586326599},{"id":"https://openalex.org/C2776531357","wikidata":"https://www.wikidata.org/wiki/Q174077","display_name":"Flash memory","level":2,"score":0.50065016746521},{"id":"https://openalex.org/C107814960","wikidata":"https://www.wikidata.org/wiki/Q611957","display_name":"Solid-state","level":2,"score":0.44910264015197754},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.43486860394477844},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.36606818437576294},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.35566890239715576},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.11325034499168396},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C92855701","wikidata":"https://www.wikidata.org/wiki/Q5830907","display_name":"Computer memory","level":3,"score":0.0},{"id":"https://openalex.org/C61696701","wikidata":"https://www.wikidata.org/wiki/Q770766","display_name":"Engineering physics","level":1,"score":0.0},{"id":"https://openalex.org/C548081761","wikidata":"https://www.wikidata.org/wiki/Q180388","display_name":"Waste management","level":1,"score":0.0},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C98986596","wikidata":"https://www.wikidata.org/wiki/Q1143031","display_name":"Semiconductor memory","level":2,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1565694.1565696","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1565694.1565696","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Fifth International Workshop on Data Management on New Hardware","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":19,"referenced_works":["https://openalex.org/W1484813121","https://openalex.org/W1501284171","https://openalex.org/W1564774435","https://openalex.org/W1600795850","https://openalex.org/W1981029608","https://openalex.org/W1990946453","https://openalex.org/W1996964471","https://openalex.org/W2004806949","https://openalex.org/W2007030756","https://openalex.org/W2027578476","https://openalex.org/W2058178853","https://openalex.org/W2112577589","https://openalex.org/W2130642985","https://openalex.org/W2169486917","https://openalex.org/W2171148344","https://openalex.org/W2229005743","https://openalex.org/W2752853835","https://openalex.org/W6669417358","https://openalex.org/W6679817081"],"related_works":["https://openalex.org/W2606330551","https://openalex.org/W2101851311","https://openalex.org/W164278522","https://openalex.org/W2391055460","https://openalex.org/W2085734125","https://openalex.org/W2082238054","https://openalex.org/W1937038249","https://openalex.org/W126194223","https://openalex.org/W1994190181","https://openalex.org/W2378293894"],"abstract_inverted_index":{"Flash":[0],"solid":[1],"state":[2],"drives":[3,14],"(SSDs)":[4],"provide":[5],"an":[6],"attractive":[7],"alternative":[8],"to":[9,64],"traditional":[10],"magnetic":[11,57,70],"hard":[12],"disk":[13],"(HDDs)":[15],"for":[16,33,56,69],"DBMS":[17],"applications.":[18],"Naturally":[19],"there":[20],"is":[21],"substantial":[22],"interest":[23],"in":[24],"redesigning":[25],"critical":[26],"database":[27],"internals,":[28],"such":[29],"as":[30],"join":[31],"algorithms,":[32],"flash":[34,76],"SSDs.":[35,77],"However,":[36],"we":[37,44,62],"must":[38],"carefully":[39],"consider":[40],"the":[41],"lessons":[42],"that":[43,61,67],"have":[45],"learnt":[46],"from":[47],"over":[48],"three":[49],"decades":[50],"of":[51],"designing":[52],"and":[53,72],"tuning":[54],"algorithms":[55],"HDD-based":[58],"systems,":[59],"so":[60],"continue":[63],"reuse":[65],"techniques":[66],"worked":[68],"HDDs":[71],"also":[73],"work":[74],"with":[75]},"counts_by_year":[{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":3}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}