This section describes how you can do advanced analytics and work with data science and machine learning in Exasol.
Exasol provides you with several ways to do more advanced analytics than what can be achieved with standard SQL.
-
Exasol AI Lab is a scalable platform that seamlessly integrates AI models into your data workflow. It streamlines common data science and AI tasks, including data loading, preparation, exploration, model training, and deployment.
For an introduction and tutorial videos explaining Exasol AI Lab, see Exasol AI Lab.
To get started immediately with Exasol AI Lab, visit the Exasol AI Lab GitHub repository.
-
User defined functions (UDFs) allow you to program your own analysis, processing, or generation functions and to execute them in parallel within an Exasol cluster. By incorporating UDFs in your workflows you can solve problems that are not solvable with plain SQL in a very efficient and elegant way. UDF scripts provide you with a highly flexible interface for implementing nearly any requirement.
To learn more about how to use UDFs for advanced analytics, see Data Science UDF Examples.
For tutorials on how to train and predict in R using UDFs, see Train and Predict with R and UDFs.
To learn more about UDFs, see UDF Scripts.
-
Skyline is an SQL extension for data analysis developed by Exasol. The Skyline extension can help you with issues such as data flooding and empty results, and with correlating many dimensions when working with large data volumes with multi-criteria optimization.
For more information and an example on how to use the Skyline extension, see Skyline.
