{"id":"https://openalex.org/W9089673","doi":null,"title":"Designing Database Operators for Flash-enabled Memory Hierarchies.","display_name":"Designing Database Operators for Flash-enabled Memory Hierarchies.","publication_year":2010,"publication_date":"2010-01-01","ids":{"openalex":"https://openalex.org/W9089673","mag":"9089673"},"language":"en","primary_location":{"id":"pmh:oai:CiteSeerX.psu:10.1.1.188.3200","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.188.3200","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://sites.computer.org/debull/A10dec/hp-paper.pdf","raw_type":"text"},"volume":null,"type":"article","is_traditional":true,"indexed_in":[],"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/A5041862671","display_name":"Goetz Graefe","orcid":"https://orcid.org/0000-0003-0194-6466","observed_orcids":["https://orcid.org/0000-0003-0194-6466"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Goetz Graefe","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0003-0194-6466","affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5070468115","display_name":"Stavros Harizopoulos","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Stavros Harizopoulos","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5050764028","display_name":"Harumi Kuno","orcid":"https://orcid.org/0009-0007-3553-0254","observed_orcids":["https://orcid.org/0009-0007-3553-0254"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Harumi Kuno","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063179800","display_name":"Mehul A. Shah","orcid":"https://orcid.org/0000-0002-0312-0388","observed_orcids":["https://orcid.org/0000-0002-0312-0388"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mehul A. Shah","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0002-0312-0388","affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087105600","display_name":"Dimitris Tsirogiannis","orcid":"https://orcid.org/0009-0002-6826-1584","observed_orcids":["https://orcid.org/0009-0002-6826-1584"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Dimitris Tsirogiannis","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5113681033","display_name":"Janet L. Wiener","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Janet L. Wiener","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.0773,"has_fulltext":false,"cited_by_count":11,"citation_normalized_percentile":{"value":0.83620781,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":97},"biblio":{"volume":"33","issue":null,"first_page":"21","last_page":"27"},"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.7621999979019165,"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.7621999979019165,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.23659999668598175,"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.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"}}],"keywords":[{"id":"https://openalex.org/keywords/flash-memory","display_name":"flash memory","score":0.9950000047683716},{"id":"https://openalex.org/keywords/query-processing","display_name":"query processing","score":0.7860000133514404},{"id":"https://openalex.org/keywords/memory-hierarchy","display_name":"memory hierarchy","score":0.7739999890327454},{"id":"https://openalex.org/keywords/join-algorithms","display_name":"join algorithms","score":0.7049999833106995},{"id":"https://openalex.org/keywords/ssd","display_name":"SSD","score":0.47099998593330383},{"id":"https://openalex.org/keywords/tpc-h","display_name":"TPC-H","score":0.6439999938011169},{"id":"https://openalex.org/keywords/i-o-reduction","display_name":"I/O reduction","score":0.4909999966621399}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9068899154663086},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.6476584672927856},{"id":"https://openalex.org/C27670709","wikidata":"https://www.wikidata.org/wiki/Q5457555","display_name":"Flash file system","level":4,"score":0.5137015581130981},{"id":"https://openalex.org/C2776531357","wikidata":"https://www.wikidata.org/wiki/Q174077","display_name":"Flash memory","level":2,"score":0.5081524848937988},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.48176905512809753},{"id":"https://openalex.org/C153083717","wikidata":"https://www.wikidata.org/wiki/Q6535263","display_name":"Leverage (statistics)","level":2,"score":0.4766281843185425},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4638652205467224},{"id":"https://openalex.org/C88548561","wikidata":"https://www.wikidata.org/wiki/Q347599","display_name":"sort","level":2,"score":0.4133760929107666},{"id":"https://openalex.org/C9390403","wikidata":"https://www.wikidata.org/wiki/Q3966","display_name":"Computer hardware","level":1,"score":0.276799738407135},{"id":"https://openalex.org/C92855701","wikidata":"https://www.wikidata.org/wiki/Q5830907","display_name":"Computer memory","level":3,"score":0.24110934138298035},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.18281644582748413},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1329495906829834},{"id":"https://openalex.org/C98986596","wikidata":"https://www.wikidata.org/wiki/Q1143031","display_name":"Semiconductor memory","level":2,"score":0.0954524576663971}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:CiteSeerX.psu:10.1.1.188.3200","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.188.3200","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://sites.computer.org/debull/A10dec/hp-paper.pdf","raw_type":"text"},{"id":"mag:9089673","doi":null,"is_oa":false,"landing_page_url":"http://sites.computer.org/debull/A10dec/p21.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S62003192","display_name":"IEEE Data(base) Engineering Bulletin","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"IEEE Data(base) Engineering Bulletin","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W652459597","https://openalex.org/W1564774435","https://openalex.org/W1974796034","https://openalex.org/W1974897895","https://openalex.org/W1981029608","https://openalex.org/W1990946453","https://openalex.org/W2029125495","https://openalex.org/W2036358022","https://openalex.org/W2043934800","https://openalex.org/W2058178853","https://openalex.org/W2064619860","https://openalex.org/W2075345089","https://openalex.org/W2097904740","https://openalex.org/W2110160586","https://openalex.org/W2113689712","https://openalex.org/W2141048674","https://openalex.org/W2150708794","https://openalex.org/W2158237121","https://openalex.org/W2169333950","https://openalex.org/W2169486917","https://openalex.org/W2229005743"],"related_works":["https://openalex.org/W1992379444","https://openalex.org/W2044752022","https://openalex.org/W2083211480","https://openalex.org/W7096263223","https://openalex.org/W2375374991","https://openalex.org/W2382010046","https://openalex.org/W2149743995","https://openalex.org/W7100106760","https://openalex.org/W2160607819","https://openalex.org/W2361546130"],"abstract_inverted_index":{"Flash":[0],"memory":[1,20,30,78,140,151,173],"affects":[2],"not":[3],"only":[4],"storage":[5],"options":[6],"but":[7],"also":[8],"query":[9,23,92,126,168],"processing.":[10],"In":[11,111],"this":[12],"paper,":[13,117],"we":[14,118],"analyze":[15],"the":[16,49,112,116,132,145,155],"use":[17,119],"of":[18,53,115,149,162,175,188],"flash":[19,29,54,139,150,177],"for":[21,98],"database":[22,167],"processing,":[24],"including":[25],"algorithms":[26,46,69,137],"that":[27,47,70,131,190],"combine":[28,138],"and":[31,41,45,60,64,79,85,105,141,159,179],"traditional":[32,142,163,180],"disk":[33,181],"drives.":[34],"We":[35],"first":[36],"focus":[37],"on":[38],"flash-resident":[39],"databases":[40],"present":[42],"data":[43],"structures":[44],"leverage":[48,71],"fast":[50,146,156],"random":[51],"reads":[52],"to":[55,75,96,107,129,185],"speed":[56],"up":[57,95],"selection,":[58],"projection,":[59],"join":[61],"operations.":[62],"FlashScan":[63],"FlashJoin":[65],"are":[66],"two":[67],"such":[68],"a":[72,124,171],"column-based":[73],"layout":[74],"significantly":[76],"reduce":[77],"I/O":[80],"requirements.":[81],"Experiments":[82],"with":[83],"Postgres":[84],"an":[86],"enterprise":[87],"SSD":[88],"drive":[89],"show":[90],"improved":[91],"runtimes":[93],"by":[94],"6x":[97],"queries":[99],"ranging":[100],"from":[101],"simple":[102],"relational":[103],"scans":[104],"joins":[106],"full":[108],"TPC-H":[109],"queries.":[110],"second":[113],"part":[114],"external":[120,135],"merge":[121],"sort":[122,136],"as":[123,152,154],"prototypical":[125],"execution":[127],"algorithm":[128],"demonstrate":[130],"most":[133],"advantageous":[134],"disk,":[143],"exploiting":[144],"access":[147],"latency":[148],"well":[153],"transfer":[157],"bandwidth":[158],"inexpensive":[160],"capacity":[161],"disks.":[164],"Looking":[165],"forward,":[166],"processing":[169],"in":[170],"three-level":[172],"hierarchy":[174],"RAM,":[176],"memory,":[178],"can":[182],"be":[183],"generalized":[184],"any":[186],"number":[187],"levels":[189],"future":[191],"hardware":[192],"may":[193],"feature.":[194],"1":[195]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":3},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2012,"cited_by_count":1}],"updated_date":"2026-09-21T07:43:02.447757","created_date":"2016-06-24T00:00:00"}