Data Science Foundation

HEAVY.AI provides an integrated data science foundation built on several open-source components of the PyData stack. This set of tools is integrated with Heavy Immerse and allows users to switch from dashboards to an integrated notebook environment connected to HeavyDB in the background. You can switch from visual data exploration with Immerse to a deeper dive on a specific dataset, build predictive models using standard python-based data science libraries and tools, and push results back into HeavyDB for use with Immerse.
Several components make up the HEAVY.AI data science foundation.
JupyterLab
HEAVY.AI provides deep integration with JupyterLab, the next-generation version of the most popular notebook environment and workflow used by data scientists for interactive computing. You can access JupyterLab by clicking an icon in Immerse.
JupyterLab access in Immerse
JupyterLab access from SQLEditor
In addition to the seamless integration with Immerse, you can also use JupyterLab with HEAVY.AI by creating an explicit connection object, either via the heavyai API.
1
>>> from heavyai import connect
2
>>> con = connect(user="admin", password="HyperInteractive", host="localhost",
3
...               dbname="heavyai")
4
>>> con
5
Connection(mapd://admin:***@localhost:6274/HEAVY.AI?protocol=binary)
Copied!
or via the Ibis-heavyai API, which builds on heavyai.
1
con = ibis.heavyai.connect(
2
    host='localhost',
3
    database='ibis_testing',
4
    user='admin',
5
    password='HyperInteractive',
6
)
Copied!
For more information, see the JupyterLab documentation.
Ibis
Ibis is a productivity API for working in Python and analyzing data in remote SQL-based data stores such as HeavyDB. Inspired by the pandas toolkit for data analysis, Ibis provides a Pythonic API that compiles to SQL. Combined with HeavyDB scale and speed, Ibis offers a familiar but more powerful method for analyzing very large datasets "in-place."uh b
Ibis supports multiple SQL databases backends, and also supports pandas as a native backend. Combined with Altair, this integration allows you to explore multiple datasets across different data sources.
Altair
​Altair is another key component of the HEAVY.AI data science foundation. Building on the same Vega data visualization engine used by Immerse for geospatial charts, Altair provides a pythonic API over Vega-Lite, a subset of the full Vega specification for declarative charting based on the "Grammar of Graphics" paradigm. The HEAVY.AI data science foundation goes further and includes interface code to enable Altair to transparently use Ibis expressions instead of pandas data frames. This allows data visualization over much larger datasets in HEAVY.AI without writing SQL code.
NVIDIA RAPIDs
The Nvidia RAPIDs toolkit is a collection of foundational libraries for GPU-accelerated data science and machine learning. It includes popular algorithms for clustering, classification, and linear models, as well as a GPU-based dataframe (cudf). HEAVY.AI allows configurable output to cudf from any query (including via Ibis or pyomnisci), so you can quickly run machine-learning algorithms on top of query results from HEAVY.AI.
Other Tools and Utilities
In addition, the data science foundation Docker container includes Facebook's Prophet library for forecasting, and Prefect, a lightweight but powerful workflow engine that enables you to build and manage workflows in Python.

Text Widget

Next - Data Science

JupyterLab Installation and Configuration

Last modified 16d ago

Export as PDF

Copy link

Contents

Other Tools and Utilities