Welcome to the most feature-rich and most comprehensive in-memory analytic database in town! EXASOL V6 offers data virtualization and flexible, modular data integration so you can now analyze data from more sources using the programming language of your choice, more easily and faster than ever before.
Using the concept of the logical data warehouse, EXASOL V6 includes a data virtualization framework called “virtual schemas” as well as a high-performance data integration framework, which allows you to deploy the database into any heterogeneous infrastructure. We have also placed particular focus on Hadoop-based storage systems, making data resident in these systems available for high-performance data analytics within the EXASOL database. What’s more, now you can customize both frameworks in line with your own specific requirements so you can connect to and analyze data faster than ever before.
What’s more, EXASOL V6 includes support for a wide variety of programming languages. Now, you can deploy your own language and run it in the database, making use of EXASOL’s in-database analytics abilities in your own way. We believe this to be a unique feature among databases on the market today.
- Data virtualization framework with virtual schemas
Now you have transparent access to data from various data sources and can analyze data without having to move full data volumes into EXASOL. Instead data is kept resident in source systems, which avoids redundant data duplication, complex ETL jobs and means you will always have access to the latest information.
- High-performance data integration framework
EXASOL V6 offers fast integration and adoption of data into any heterogeneous environment through support for more data sources than ever before. Through a common integration framework for virtualized data access and imports, you can easily implement and customize any data source adapter on demand and share with other users via GitHub.
- Increased support for Hadoop
Hadoop-based data stored in any HCatalog-supported native data format is now instantly available for analytics in EXASOL through the new data integration framework. Data access is fully parallelized for maximum throughput.
- Pluggable language support
Alongside out-of-the-box support for R, Python, Java and Lua, EXASOL V6 offers a framework to integrate any analytical programming language – you are no longer limited to using the languages provided by EXASOL. Now, you can package up the programming language of your choice, deploy it to your instance of EXASOL and use it for in-database analytics.
- Advanced automation
Now, administrators of your system can completely automate almost all installation and configuration tasks through an easy-to-use API without manual intervention.
- Improved connectivity
EXASOL V6 offers a JSON-based web socket API alongside current support for ODBC, JDBC and .NET. With the API, virtually every platform can be easily connected to EXASOL based on a simple wrapper-like driver or direct web socket connection. Also, a native lightweight Python driver based on this API has been included in EXASOL V6.
- Increases in performance
EXASOL has always maintained a performance advantage, and now with a series of enhancements, the database just got even faster. Faster join, insert & delete, backup & recovery, cluster resizing – these is just a small list of the performance improvements you now get in EXASOL V6.