Increasing the speed of DBMS operations using hardware FPGA accelerators
- 作者: Solovyev A.V.1
-
隶属关系:
- Federal Research Center "Computer Science and Control" of the Russian Academy of Sciences
- 期: 卷 75, 编号 2 (2025)
- 页面: 66-74
- 栏目: Information Technologies
- URL: https://journals.rcsi.science/2079-0279/article/view/317032
- DOI: https://doi.org/10.14357/20790279250208
- EDN: https://elibrary.ru/XQCEYD
- ID: 317032
如何引用文章
全文:
详细
The article provides an overview of a way to speed up data processing operations in a DBMS using an FPGA. An overview of FPGA capabilities, FPGA usage architectures is performed, and practical examples of FPGA usage are considered. The advantages and disadvantages of using FPGA are determined. A number of problems and alternative technologies were noted, which significantly slowed down the use of FPGAs in industrial DBMS and data storage systems. Using FPGA to speed up data processing in a DBMS, it can be argued that the approach allows you to speed up database operations related to query processing, data compression and encryption, and parallel data processing. However, the use of FPGAs also complicates the system as a whole, does not allow for flexible and quick reconfiguration of the system's functionality, and increases the total cost of ownership. In further research, it is planned to consider alternative technologies for accelerating data processing operations.
作者简介
A. Solovyev
Federal Research Center "Computer Science and Control" of the Russian Academy of Sciences
Email: soloviev@isa.ru
Doctor of Technical Sciences Moscow, Russia
参考
- Alcaín E., Fernández P.R., Nieto R., Montemayor A.S., Vilas J., Galiana-Bordera A., Martinez-Girones P.M., Prieto-de-la-Lastra,C., Rodriguez-Vila B., Bonet M., Rodriguez-Sanchez C. Hardware Architectures for Real-Time Medical Imaging // Electronics, 10(24): 3118, 2021. doi: 10.3390/electronics10243118. ISSN 2079-9292.
- Nagornov N.N., Lyakhov P.A., Valueva M.V., Bergerman M.V. RNS-Based FPGA Accelerators for High-Quality 3D Medical Image Wavelet Processing Using Scaled Filter Coefficients // IEEE Access, 10: 19215–19231, 2022. doi: 10.1109/ACCESS.2022.3151361. ISSN 2169-3536.
- Huffmire T., Brotherton B., Sherwood T., Kastner R., Levin T., Nguyen T.D., Irvine C. Managing Security in FPGA-Based Embedded Systems // IEEE Design & Test of Computers, 25 (6): 590–598, 2008. doi: 10.1109/MDT.2008.166.
- Babaei A., Schiele G., Zohner M. Reconfigurable Security Architecture (RESA) Based on PUF for FPGA-Based IoT Devices // Sensors, 22(15): 5577, 2022. doi: 10.3390/s22155577. ISSN 1424-8220.
- Simpson P.A. FPGA Design, Best Practices for Team Based Reuse, 2nd edition. Switzerland: Springer International Publishing AG, 2015. ISBN 978-3-319-17924-7.
- Как работает FPGA? : RUVDS.com, habr. URL: https://habr.com/ru/companies/ruvds/articles/736060/. Дата публикации: 18.05.2023.
- Fang J., Mulder Y.T.B., Hidders J. et al. In-memory database acceleration on FPGAs: a survey. The VLDB Journal 29, 33–59, 2020. https://doi.org/10.1007/s00778-019-00581-w.
- Волков Д., Николаенко А. На пути к «железным» СУБД // Открытые системы. СУБД, №02, 2019 : OSP. URL: https://www.osp.ru/os/2019/02/13054946. Дата публикации: 19.05.2019.
- Chen S., Chen Y., Wang Z., Qin W., Zhang J., Nand H., Zhang J., Li J., Zhang X., Liang X., Xu M. Efficient sequencing data compression and FPGA acceleration based on a two-step framework. Front. Genet., 14: 1260531, 2023. doi: 10.3389/fgene.2023.1260531.
- Lu A., Fang Z. SQL2FPGA: Automatic Acceleration of SQL Query Processing on Modern CPU-FPGA Platforms. 2023 IEEE 31st Annual International Symposium on Field-Programmable Custom Computing Machines (FCCM), Marina Del Rey, CA, USA, 184-194, 2023. doi: 10.1109/FCCM57271.2023.00028.
- Owaida M., Sidler D., Kara K., Alonso G. Centaur: A Framework for Hybrid CPU-FPGA Databases. 2017 IEEE 25th Annual International Symposium on Field-Programmable Custom Computing Machines (FCCM), Napa, CA, 211-218, 2017. doi: 10.1109/FCCM.2017.37.
- Wei X. Sailfish: Exploring Heterogeneous Query Acceleration on Discrete CPU-FPGA Architecture. IEEE 39th International Conference on Data Engineering Workshops (ICDEW), Anaheim, CA, USA, 198-204, 2023. doi: 10.1109/ICDEW58674.2023.00036.
- Хасанов В. Ускорение обработки данных 1С на FPGA-ускорителях Xilinx Alveo : rutube. URL: https://rutube.ru/video/c246d709685406649e-5730c23a95e416/. Дата публикации: 2021.
- Oikawa S. Operating System Framework for Transparent Execution on a CPU and FPGA. 2021 IEEE/ACIS 19th International Conference on Software Engineering Research, Management and Applications (SERA), Kanazawa, Japan, 97-101, 2021. doi: 10.1109/SERA51205.2021.9509041.
- Amazon throws SSDs, FPGAs, Nitro chips at Redshift with "AQUA" : TheStack. URL: https://www.thestack.technology/aws-aqua-redshift-ga/. Дата публикации: 15.04.2021.
- Intelligent self-processing for the era of big data. SmartSSD : Samsung. URL: https://semiconductor.samsung.com/emea/ssd/smart-ssd/ (дата обращения: 26.04.2025).
- SmartSSD® Computational Storage Drive : AMD. URL: https://www.amd.com/content/dam/xilinx/publications/product-briefs/xilinx-smartssd-computational-storage-drive-product-brief.pdf (дата обращения: 26.04.2025).
- Samsung представила SmartSSD второго поколения на базе процессоров AMD : overclockers. URL: https://overclockers.ru/blog/TechRanch/show/71223/samsung-predstavila-smartssd-vtorogo-pokoleniya-na-baze-processorov-amd. Дата публикации: 22.07.2022.
- Feng J., Li Z., Chen Q. Towards Exploratory Query Optimization for Template-Based SQL Workloads. 2024 IEEE 40th International Conference on Data Engineering (ICDE), Utrecht, Netherlands, 151-164, 2024. doi: 10.1109/ICDE60146.2024.00019.
- Chen T., Gao J., Tu Y., Xu M. GLO: Towards Generalized Learned Query Optimization. 2024 IEEE 40th International Conference on Data Engineering (ICDE), Utrecht, Netherlands, 4843-4855, 2024. doi: 10.1109/ICDE60146.2024.00368.
- Fang J. Database Acceleration on FPGAs. Dissertation (TU Delft), Delft University of Technology, 2019. https://doi.org/10.4233/uuid:84dfc577-ca6f-43ea-9b24-4dc160c103f5.
- Практическое применение сервера с FPGA. Блог компании Selectel : habr. URL: https://habr.com/ru/companies/selectel/articles/565190/. Дата публикации: 10.07.2021.
补充文件
