We are currently witnessing the rapid evolution and adoption of various data science frameworks that function external to the database. Any support from conventional RDBMS implementations for data science applications has been limited to procedural paradigms such as user-defined functions (UDFs) that lack exploratory programming support. Therefore, the current status quo is that during the exploratory phase, data scientists usually use the database system as the “data storage” layer of the data science framework, whereby the majority of computation and analysis is performed outside the database, e.g., at the client node. We demonstrate AIDA, an in-database framework for data scientists. AIDA allows users to write interactive Python code using a development environment such as a Jupyter notebook. The actual execution itself takes place inside the database (neardata), where a server component of AIDA, that resides inside the embedded Python interpreter of the RDBMS, manages the data sets and computations. The demonstration will also show the visualization capabilities of AIDA where the progress of computation can be observed through live updates. Our evaluations show that AIDA performs several times faster compared to contemporary external data science frameworks, but is much easier to use for exploratory development compared to database UDFs. PVLDB Reference Format: Joseph Vinish D’silva, Florestan De Moor, Bettina Kemme. Making an RDBMS Data Scientist Friendly: Advanced In-database Interactive Analytics with Visualization Support. PVLDB, 12(12): 1930-1933, 2019. DOI: https://doi.org/10.14778/3352063.3352102
[1]
Hannes Mühleisen,et al.
Best of both worlds: relational databases and statistics
,
2013,
SSDBM.
[2]
Wes McKinney,et al.
pandas: a Foundational Python Library for Data Analysis and Statistics
,
2011
.
[3]
Hannes Mühleisen,et al.
Vectorized UDFs in Column-Stores
,
2016,
SSDBM.
[4]
T. Vincenty.
DIRECT AND INVERSE SOLUTIONS OF GEODESICS ON THE ELLIPSOID WITH APPLICATION OF NESTED EQUATIONS
,
1975
.
[5]
Hannes Mühleisen,et al.
Efficient data management and statistics with zero-copy integration
,
2014,
SSDBM '14.
[6]
Philip A. Bernstein,et al.
Compiling mappings to bridge applications and databases
,
2007,
SIGMOD '07.
[7]
Scott Shenker,et al.
Spark: Cluster Computing with Working Sets
,
2010,
HotCloud.
[8]
Bettina Kemme,et al.
AIDA - Abstraction for Advanced In-Database Analytics
,
2018,
Proc. VLDB Endow..