Snel: SQL Native Execution for LLVM

02/21/2020
by   Marcelo Mottalli, et al.
0

Snel is a relational database engine featuring Just-In-Time (JIT) compilation of queries and columnar data representation. Snel is designed for fast on-line analytics by leveraging the LLVM compiler infrastructure. It also has custom special methods like resolving histograms as extensions to the SQL language. "Snel" means "SQL Native Execution for LLVM". Unlike traditional database engines, it does not provide a client-server interface. Instead, it exposes its interface as an extension to SQLite, for a simple interactive usage from command line and for embedding in applications. Since Snel tables are read-only, it does not provide features like transactions or updates. This allows queries to be very fast since they don't have the overhead of table locking or ensuring consistency. At its core, Snel is simply a dynamic library that can be used by client applications. It has an SQLite extension for seamless integration with a traditional SQL environment and simple interactive usage from command line.

READ FULL TEXT

page 12

page 22

page 25

page 26

page 27

page 28

research
10/07/2022

Integration of Skyline Queries into Spark SQL

Skyline queries are frequently used in data analytics and multi-criteria...
research
11/14/2020

Synthesis of SQL Queries from South African Local Language Narrations

English remains the language of choice for database courses and widely u...
research
02/23/2023

A Scalable Space-efficient In-database Interpretability Framework for Embedding-based Semantic SQL Queries

AI-Powered database (AI-DB) is a novel relational database system that u...
research
01/19/2020

SQLFlow: A Bridge between SQL and Machine Learning

Industrial AI systems are mostly end-to-end machine learning (ML) workfl...
research
08/11/2020

High-concurrency Custom-build Relational Database System's design and SQL parser design based on Turing-complete automata

Database system is an indispensable part of software projects. It plays ...
research
08/17/2023

SQL Access Patterns for Optimistic Concurrency Control

Transaction processing is of growing importance for mobile and web appli...
research
05/02/2022

A fast in-place interpreter for WebAssembly

WebAssembly (Wasm) is a compact, well-specified bytecode format that off...

Please sign up or login with your details

Forgot password? Click here to reset