{"id":"https://openalex.org/W7140326416","doi":"https://doi.org/10.1109/nvmsa66678.2025.00019","title":"LISA-SQL: Low-Cost in-Storage Accelerator for SQL Databases","display_name":"LISA-SQL: Low-Cost in-Storage Accelerator for SQL Databases","publication_year":2025,"publication_date":"2025-08-20","ids":{"openalex":"https://openalex.org/W7140326416","doi":"https://doi.org/10.1109/nvmsa66678.2025.00019"},"language":null,"primary_location":{"id":"doi:10.1109/nvmsa66678.2025.00019","is_oa":false,"landing_page_url":"https://doi.org/10.1109/nvmsa66678.2025.00019","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2025 IEEE 14th Non-Volatile Memory Systems and Applications Symposium (NVMSA)","raw_type":"proceedings-article"},"type":"article","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/A5076043640","display_name":"Yen-Shi Kuo","orcid":null},"institutions":[{"id":"https://openalex.org/I148366613","display_name":"National Yang Ming Chiao Tung University","ror":"https://ror.org/00se2k293","country_code":"TW","type":"education","lineage":["https://openalex.org/I148366613"]}],"countries":["TW"],"is_corresponding":true,"raw_author_name":"Yen-Shi Kuo","raw_affiliation_strings":["Institute of Electronics, National Yang Ming Chiao Tung University"],"affiliations":[{"raw_affiliation_string":"Institute of Electronics, National Yang Ming Chiao Tung University","institution_ids":["https://openalex.org/I148366613"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073827239","display_name":"Wan-Ching Wang","orcid":null},"institutions":[{"id":"https://openalex.org/I148366613","display_name":"National Yang Ming Chiao Tung University","ror":"https://ror.org/00se2k293","country_code":"TW","type":"education","lineage":["https://openalex.org/I148366613"]}],"countries":["TW"],"is_corresponding":false,"raw_author_name":"Wan-Ching Wang","raw_affiliation_strings":["Institute of Electronics, National Yang Ming Chiao Tung University"],"affiliations":[{"raw_affiliation_string":"Institute of Electronics, National Yang Ming Chiao Tung University","institution_ids":["https://openalex.org/I148366613"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101508203","display_name":"Chunwei Liu","orcid":"https://orcid.org/0000-0002-8924-5092"},"institutions":[{"id":"https://openalex.org/I148366613","display_name":"National Yang Ming Chiao Tung University","ror":"https://ror.org/00se2k293","country_code":"TW","type":"education","lineage":["https://openalex.org/I148366613"]}],"countries":["TW"],"is_corresponding":false,"raw_author_name":"Chun-Wei Liu","raw_affiliation_strings":["Institute of Electronics, National Yang Ming Chiao Tung University"],"affiliations":[{"raw_affiliation_string":"Institute of Electronics, National Yang Ming Chiao Tung University","institution_ids":["https://openalex.org/I148366613"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064046587","display_name":"Chun-Feng Wu","orcid":"https://orcid.org/0000-0002-6367-0517"},"institutions":[{"id":"https://openalex.org/I148366613","display_name":"National Yang Ming Chiao Tung University","ror":"https://ror.org/00se2k293","country_code":"TW","type":"education","lineage":["https://openalex.org/I148366613"]}],"countries":["TW"],"is_corresponding":false,"raw_author_name":"Chun-Feng Wu","raw_affiliation_strings":["Computer Science, National Yang Ming Chiao Tung University"],"affiliations":[{"raw_affiliation_string":"Computer Science, National Yang Ming Chiao Tung University","institution_ids":["https://openalex.org/I148366613"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5130557539","display_name":"Bo-Cheng Lai","orcid":null},"institutions":[{"id":"https://openalex.org/I148366613","display_name":"National Yang Ming Chiao Tung University","ror":"https://ror.org/00se2k293","country_code":"TW","type":"education","lineage":["https://openalex.org/I148366613"]}],"countries":["TW"],"is_corresponding":false,"raw_author_name":"Bo-Cheng Lai","raw_affiliation_strings":["Institute of Electronics, National Yang Ming Chiao Tung University"],"affiliations":[{"raw_affiliation_string":"Institute of Electronics, National Yang Ming Chiao Tung University","institution_ids":["https://openalex.org/I148366613"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5076043640"],"corresponding_institution_ids":["https://openalex.org/I148366613"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.78787325,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"63","last_page":"68"},"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.17790000140666962,"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.17790000140666962,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.06469999998807907,"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/T14455","display_name":"Technology and Education Systems","score":0.051600001752376556,"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/sql","display_name":"SQL","score":0.43459999561309814},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.3057999908924103},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.263700008392334},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.25780001282691956},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.24279999732971191}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6625000238418579},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5012000203132629},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4749999940395355},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.43459999561309814},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.3057999908924103},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.263700008392334},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.25780001282691956},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.24279999732971191},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.24140000343322754},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.24070000648498535}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/nvmsa66678.2025.00019","is_oa":false,"landing_page_url":"https://doi.org/10.1109/nvmsa66678.2025.00019","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2025 IEEE 14th Non-Volatile Memory Systems and Applications Symposium (NVMSA)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W164278522","https://openalex.org/W2034861439","https://openalex.org/W2040811166","https://openalex.org/W2104242181","https://openalex.org/W2143909327","https://openalex.org/W2155256331","https://openalex.org/W2547860654","https://openalex.org/W2614421408","https://openalex.org/W2798607736","https://openalex.org/W2998432270","https://openalex.org/W3089883684","https://openalex.org/W3099436583","https://openalex.org/W3206231896","https://openalex.org/W4293023368","https://openalex.org/W4302028943","https://openalex.org/W4409282514","https://openalex.org/W4414198824"],"related_works":[],"abstract_inverted_index":{"With":[0],"the":[1,89,150,161],"surge":[2],"of":[3],"big":[4],"data,":[5],"database":[6],"systems":[7],"are":[8],"increasingly":[9],"embedded":[10],"in":[11,49,160],"application":[12],"backends":[13],"to":[14,52,133,175,194],"enhance":[15],"user":[16],"experience":[17],"and":[18,56,80,96,111,120,127,144,148,187],"enable":[19],"deeper":[20],"analytics.":[21],"To":[22],"meet":[23],"real-time":[24],"demands,":[25],"data":[26,78,92,106],"centers":[27],"adopt":[28],"accelerators,":[29,181],"yet":[30],"memory":[31,42],"bandwidth":[32,54,129],"has":[33,45],"become":[34],"a":[35,62,98,184],"key":[36],"bottleneck":[37],"as":[38],"processor":[39],"speeds":[40],"outpace":[41],"advancements.":[43],"This":[44],"driven":[46],"growing":[47],"interest":[48],"near-data":[50],"computing":[51],"alleviate":[53],"limitations":[55],"boost":[57],"performance.":[58],"We":[59,76],"propose":[60],"LISA-SQL,":[61],"low-cost,":[63],"FPGA-based":[64],"in-storage":[65,180],"accelerator":[66],"for":[67],"SQL":[68],"databases":[69],"that":[70,103,171],"integrates":[71],"computation":[72],"directly":[73],"within":[74,88],"SSDs.":[75],"optimize":[77],"management":[79],"garbage":[81,189],"collection":[82,190],"through":[83,155],"strategic":[84],"buffer":[85,100,112],"space":[86],"allocation":[87],"SSD,":[90],"anticipating":[91],"transfers":[93],"from":[94],"DRAM,":[95],"implement":[97],"dynamic":[99],"caching":[101],"system":[102],"efficiently":[104],"manages":[105],"flow":[107],"using":[108],"DRAM":[109,126],"mapping":[110,158],"status":[113],"tables.":[114],"Our":[115],"solution":[116],"also":[117],"enhances":[118],"sort":[119],"merge":[121],"join":[122],"operations":[123],"by":[124,192],"utilizing":[125],"SSD":[128],"with":[130],"range":[131],"partitioning":[132],"reduce":[134,138],"latency.":[135],"Furthermore,":[136],"we":[137],"write":[139],"amplification":[140],"via":[141],"trim":[142],"commands":[143],"precise":[145],"logical-to-physical":[146],"mapping,":[147],"bypass":[149],"conventional":[151,179],"Flash":[152],"Translation":[153],"Layer":[154],"an":[156],"internal":[157],"scheme":[159],"accelerator,":[162],"significantly":[163],"cutting":[164],"host-storage":[165],"communication":[166],"overhead.":[167],"Experimental":[168],"results":[169],"show":[170],"LISA-SQL":[172],"achieves":[173],"up":[174,193],"2.34\u00d7":[176],"speedup":[177],"over":[178,183],"3.56\u00d7":[182],"128-thread":[185],"CPU,":[186],"reduces":[188],"overhead":[191],"2.81\u00d7.":[195]},"counts_by_year":[],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2026-03-26T00:00:00"}