DuckDB-Wasm: Fast Analytical Processing for the Web

André Kohn; Hannes Mühleisen; Dominik Moritz; Thomas Neumann; Mark Raasveldt

doi:10.14778/3554821.3554847

DuckDB-Wasm: Fast Analytical Processing for the Web

André Kohn
, Hannes Mühleisen
, Dominik Moritz
, Thomas Neumann
, Mark Raasveldt

Informatics 25 - Chair of Data Science and Engineering

Technical University of Munich
Centrum Wiskunde and Informatica (CWI)
Carnegie Mellon University

Research output: Contribution to journal › Conference article › peer-review

14 Scopus citations

Abstract

We introduce DuckDB-Wasm, a WebAssembly version of the database system DuckDB, to provide fast analytical processing for the Web. DuckDB-Wasm evaluates SQL queries asynchronously in web workers, supports efficient user-defined functions written in JavaScript, and features a browser-agnostic filesystem that reads local and remote data in pages. DuckDB-Wasm outperforms previous data processing libraries for the Web in the TPC-H benchmark at multiple scale factors. We demonstrate the capabilities of an analytical database in the browser using an interactive SQL shell.

Original language	English
Pages (from-to)	3574-3577
Number of pages	4
Journal	Proceedings of the VLDB Endowment
Volume	15
Issue number	12
DOIs	https://doi.org/10.14778/3554821.3554847
State	Published - 2022
Event	48th International Conference on Very Large Data Bases, VLDB 2022 - Sydney, Australia Duration: 5 Sep 2022 → 9 Sep 2022

Access to Document

10.14778/3554821.3554847

Cite this

@article{79457f3a3c6d4e2785570f5219e7a807,

title = "DuckDB-Wasm: Fast Analytical Processing for the Web",

abstract = "We introduce DuckDB-Wasm, a WebAssembly version of the database system DuckDB, to provide fast analytical processing for the Web. DuckDB-Wasm evaluates SQL queries asynchronously in web workers, supports efficient user-defined functions written in JavaScript, and features a browser-agnostic filesystem that reads local and remote data in pages. DuckDB-Wasm outperforms previous data processing libraries for the Web in the TPC-H benchmark at multiple scale factors. We demonstrate the capabilities of an analytical database in the browser using an interactive SQL shell.",

author = "Andr{\'e} Kohn and Hannes M{\"u}hleisen and Dominik Moritz and Thomas Neumann and Mark Raasveldt",

note = "Publisher Copyright: {\textcopyright} 2022, VLDB Endowment. All rights reserved.; 48th International Conference on Very Large Data Bases, VLDB 2022 ; Conference date: 05-09-2022 Through 09-09-2022",

year = "2022",

doi = "10.14778/3554821.3554847",

language = "English",

volume = "15",

pages = "3574--3577",

journal = "Proceedings of the VLDB Endowment",

issn = "2150-8097",

publisher = "VLDB Endowment",

number = "12",

}

TY - JOUR

T1 - DuckDB-Wasm

T2 - 48th International Conference on Very Large Data Bases, VLDB 2022

AU - Kohn, André

AU - Mühleisen, Hannes

AU - Moritz, Dominik

AU - Neumann, Thomas

AU - Raasveldt, Mark

PY - 2022

Y1 - 2022

N2 - We introduce DuckDB-Wasm, a WebAssembly version of the database system DuckDB, to provide fast analytical processing for the Web. DuckDB-Wasm evaluates SQL queries asynchronously in web workers, supports efficient user-defined functions written in JavaScript, and features a browser-agnostic filesystem that reads local and remote data in pages. DuckDB-Wasm outperforms previous data processing libraries for the Web in the TPC-H benchmark at multiple scale factors. We demonstrate the capabilities of an analytical database in the browser using an interactive SQL shell.

AB - We introduce DuckDB-Wasm, a WebAssembly version of the database system DuckDB, to provide fast analytical processing for the Web. DuckDB-Wasm evaluates SQL queries asynchronously in web workers, supports efficient user-defined functions written in JavaScript, and features a browser-agnostic filesystem that reads local and remote data in pages. DuckDB-Wasm outperforms previous data processing libraries for the Web in the TPC-H benchmark at multiple scale factors. We demonstrate the capabilities of an analytical database in the browser using an interactive SQL shell.

UR - https://www.scopus.com/pages/publications/85137985227

U2 - 10.14778/3554821.3554847

DO - 10.14778/3554821.3554847

M3 - Conference article

AN - SCOPUS:85137985227

SN - 2150-8097

VL - 15

SP - 3574

EP - 3577

JO - Proceedings of the VLDB Endowment

JF - Proceedings of the VLDB Endowment

IS - 12

Y2 - 5 September 2022 through 9 September 2022

ER -

DuckDB-Wasm: Fast Analytical Processing for the Web

Abstract

Access to Document

Other files and links

Fingerprint

Cite this