Title
MonetDB/DataCell: online analytics in a streaming column-store
Abstract
In DataCell, we design streaming functionalities in a modern relational database kernel which targets big data analytics. This includes exploitation of both its storage/execution engine and its optimizer infrastructure. We investigate the opportunities and challenges that arise with such a direction and we show that it carries significant advantages for modern applications in need for online analytics such as web logs, network monitoring and scientific data management. The major challenge then becomes the efficient support for specialized stream features, e.g., multi-query processing and incremental window-based processing as well as exploiting standard DBMS functionalities in a streaming environment such as indexing. This demo presents DataCell, an extension of the MonetDB open-source column-store for online analytics. The demo gives users the opportunity to experience the features of DataCell such as processing both stream and persistent data and performing window based processing. The demo provides a visual interface to monitor the critical system components, e.g., how query plans transform from typical DBMS query plans to online query plans, how data flows through the query plans as the streams evolve, how DataCell maintains intermediate results in columnar form to avoid repeated evaluation of the same stream portions, etc. The demo also provides the ability to interactively set the test scenarios and various DataCell knobs.
Year
DOI
Venue
2012
10.14778/2367502.2367535
PVLDB
Keywords
Field
DocType
various datacell knob,multi-query processing,big data analytics,online analytics,persistent data,incremental window-based processing,scientific data management,typical dbms query,data flow,query plan,relational database,network monitoring,stream function,indexation
Query optimization,Data mining,Relational database,Computer science,Sargable,Search engine indexing,Network monitoring,Analytics,Big data,Data management,Database
Journal
Volume
Issue
ISSN
5
12
2150-8097
Citations 
PageRank 
References 
7
0.48
17
Authors
4
Name
Order
Citations
PageRank
Erietta Liarou118410.81
Stratos Idreos2107963.03
Stefan Manegold31656123.43
Martin L. Kersten43243509.01