Back to Search
Start Over
AxleDB: A novel programmable query processing platform on FPGA
- Source :
- Recercat. Dipósit de la Recerca de Catalunya, instname, UPCommons. Portal del coneixement obert de la UPC, Universitat Politècnica de Catalunya (UPC)
- Publisher :
- Elsevier
-
Abstract
- With the rise of Big Data, providing high-performance query processing capabilities through the acceleration of the database analytic has gained significant attention. Leveraging Field Programmable Gate Array (FPGA) technology, this approach can lead to clear benefits. In this work, we present the design and implementation of AxleDB: An FPGA-based platform that enables fast query processing for database systems by melding novel database-specific accelerators with commercial-off-the-shelf (COTS) storage using modern interfaces, in a novel, unified, and a programmable environment. AxleDB can perform a large subset of SQL queries through its set of instructions that can map compute-intensive database operations, such as filter, arithmetic, aggregate, group by, table join, or sort, on to the specialized high-throughput accelerators. To minimize the amount of SSD I/O operations required, AxleDB also supports hardware MinMax indexing for databases. We evaluated AxleDB with five decision support queries from the TPC-H benchmark suite and achieved a speedup from 1.8X to 34.2X and energy efficiency from 2.8X to 62.1X, in comparison to the state-of-the-art DBMS, i.e., PostgreSQL and MonetDB. The research leading to these results has received funding from the European Union Seventh Framework Program (FP7) (under the AXLE project GA number 318633), the Ministry of Economy and Competitiveness of Spain (under contract number TIN2015-65316-p), Turkish Ministry of Development TAM Project (number 2007K120610), and Bogazici University Scientific Projects (number 7060).
- Subjects :
- SQL
Computer Networks and Communications
View
Computer science
Bases de dades--Gestió
02 engineering and technology
Query optimization
01 natural sciences
Hardware
Artificial Intelligence
0103 physical sciences
0202 electrical engineering, electronic engineering, information engineering
Query by Example
computer.programming_language
010302 applied physics
business.industry
Database query processing
Reconfigurable computing
Processament en paral·lel (Ordinadors)
Search engine indexing
Materialized view
Querying (Computer science)
Enginyeria electrònica [Àrees temàtiques de la UPC]
InformationSystems_DATABASEMANAGEMENT
Hardware accelerators
020202 computer hardware & architecture
Hardware and Architecture
Embedded system
Table (database)
Sargable
business
computer
Software
Ordinadors--Dispositius de memòria
Subjects
Details
- Database :
- OpenAIRE
- Journal :
- Recercat. Dipósit de la Recerca de Catalunya, instname, UPCommons. Portal del coneixement obert de la UPC, Universitat Politècnica de Catalunya (UPC)
- Accession number :
- edsair.doi.dedup.....dd046994d204332b68dc419b0a512dc6