%0 Conference Paper %1 Krikellas2010-cd %A Krikellas, K %A Viglas, S D %A Cintra, M %B Data Engineering (ICDE), 2010 IEEE 26th International Conference on %D 2010 %K Code_generation Database_systems Engines Expose HIQUE Hardware Heuristic_algorithms Informatics Optimizing_compilers Proposals Prototypes Query_compilation Query_processing SQL SQL_query_engines System_performance database_query_evaluation generating_code high_level_languages higher_level_programming highly_efficient_code holistic_integrated_query_engine holistic_query_evaluation program_compilers query-_and_hardware_specific_source_code query_processing query_processing_techniques %P 613--624 %T Generating code for holistic query evaluation %X We present the application of customized code generation to database query evaluation. The idea is to use a collection of highly efficient code templates and dynamically instantiate them to create query- and hardware-specific source code. The source code is compiled and dynamically linked to the database server for processing. Code generation diminishes the bloat of higher-level programming abstractions necessary for implementing generic, interpreted, SQL query engines. At the same time, the generated code is customized for the hardware it will run on. We term this approach holistic query evaluation. We present the design and development of a prototype system called HIQUE, the Holistic Integrated Query Engine, which incorporates our proposals. We undertake a detailed experimental study of the system's performance. The results show that HIQUE satisfies its design objectives, while its efficiency surpasses that of both well-established and currently-emerging query processing techniques.

@inproceedings{Krikellas2010-cd, abstract = {We present the application of customized code generation to database query evaluation. The idea is to use a collection of highly efficient code templates and dynamically instantiate them to create query- and hardware-specific source code. The source code is compiled and dynamically linked to the database server for processing. Code generation diminishes the bloat of higher-level programming abstractions necessary for implementing generic, interpreted, SQL query engines. At the same time, the generated code is customized for the hardware it will run on. We term this approach holistic query evaluation. We present the design and development of a prototype system called HIQUE, the Holistic Integrated Query Engine, which incorporates our proposals. We undertake a detailed experimental study of the system's performance. The results show that HIQUE satisfies its design objectives, while its efficiency surpasses that of both well-established and currently-emerging query processing techniques.}, added-at = {2015-04-10T18:02:47.000+0200}, author = {Krikellas, K and Viglas, S D and Cintra, M}, biburl = {https://www.bibsonomy.org/bibtex/2d57867853993f9d15b4416d94a3622f4/christophv}, booktitle = {Data Engineering ({ICDE)}, 2010 {IEEE} 26th International Conference on}, interhash = {bb9f5c5c9add476be5ae94d184debc4c}, intrahash = {d57867853993f9d15b4416d94a3622f4}, keywords = {Code_generation Database_systems Engines Expose HIQUE Hardware Heuristic_algorithms Informatics Optimizing_compilers Proposals Prototypes Query_compilation Query_processing SQL SQL_query_engines System_performance database_query_evaluation generating_code high_level_languages higher_level_programming highly_efficient_code holistic_integrated_query_engine holistic_query_evaluation program_compilers query-_and_hardware_specific_source_code query_processing query_processing_techniques}, month = mar, pages = {613--624}, timestamp = {2016-01-04T14:22:08.000+0100}, title = {Generating code for holistic query evaluation}, year = 2010 }