Our tech blogs

If you’re stumped about schemas, perplexed about Python, or simply want no-nonsense technical advice to optimize your data analytics platform, this is the place for you. Each week our team of tech writers will be grappling with all the burning issues around data analytics and finding practical solutions– so you don’t have to.

What is Exasol’s cluster architecture?

This article gives a detailed overview of the Exasol cluster architecture. Exasol cluster nodes: hardware Our clusters are built with commodity Intel servers without particularly expensive components. SAS hard drives and Ethernet cards are sufficient. There’s no need...

read more

How to use Exasol’s Automatic Table Reorganization

One of Exasol’s key features is the low maintenance effort when compared to many other database systems. Automatic Table Reorganization is one example: Exasol offers CREATE OR REPLACE TABLE and the DELETE_PERCENTAGE is zero after the table is created. The...

read more

How to install an Exasol 6.1 Cluster on VirtualBox

You start by installing the latest version of VirtualBox. Then you need to download an ISO file with the latest Exasol version. The machine hosting VirtualBox should have at least 16 GB RAM and 80 GB free disk space in order to run a 2+1 cluster with 3 data nodes and...

read more

How to get distribution right in our analytics database

Our analytics database uses a clustered shared-nothing architecture with many sophisticated internal mechanisms delivering outstanding performance. All without the need for much admin. But getting the distribution of rows between cluster nodes right is one of the few...

read more

How does Exasol analytics database stack up against Oracle

Okay, I know what you’re thinking, how can a guy from Exasol really give an impartial opinion on Oracle’s database? But I’m not here to sell you anything and I definitely don’t work in marketing. What follows is simply my personal experience and opinion as someone...

read more

Controlling space in football

Controlling space in football – data modelling with our analytics database, and visual analysis in Tableau Football isn’t just about controlling the ball – in fact a player only has contact with the ball for an average of two minutes per game – it’s...

read more

Migrating from Netezza

Migrating from Netezza: an SQL Script to help you import data from Netezza into Exasol’s analytics database Whether you’re planning to migrate away from Netezza and are exploring different migration paths or you’ve already decided to migrate data across to us, we’ve...

read more

How to use DbVisualizer with Oracle, PostgreSQL and Exasol

As a database developer or administrator, it’s unlikely that you’ll work with only one platform. It’s quite useful to have one single tool to handle multiple different database platforms –that’s the ambition of DbVisualizer. Let’s assume you’re a database...

read more

Playing in the Champions League of Sports Analytics

If you’re looking to build a system for sports analytics, think about Exasol’s analytics database. With its great performance and analytical capabilities an Exasol database can easily handle huge volumes of event and tracking data. But as my last blog explained,...

read more

Automatic indexes in Exasol

An Exasol database will automatically create, maintain and drop indexes, following the core idea to deliver great performance without requiring much administrative efforts. Like Exasol’s tables, the indexes are always compressed and users don’t need to configure...

read more

Building clusters in the sky – Exasol Cloud Wizard

In modern day cloud architectures, one of the main priorities for any team is making the configuration and installation as simple and straight forward as possible. The Exasol Cloud Wizard addresses this demand. The Exasol Cloud Wizard is currently available for Amazon...

read more

Next level unit-testing with JUnit5

In our Java-based Open Source repositories we at Exasol use JUnit as our testing framework. Like most organizations we used JUnit4 for a long time. But for all new projects we have switched to JUnit5. We’re also migrating existing tests in established projects...

read more

Don’t let Python slither out of your control

Don’t let Python slither out of your control – how to load data science languages in and out of our relational database A recent study of different job listings revealed which data science skills are most in demand for data scientists. It was no surprise that over 70%...

read more

Interactive Text Mining with Exasol and INDREX-MM

Text mining work-loads rarely require full scans of all table data, but do often require full scans of a small subset of the columns. Our base table layout from (Kilias et al., 2015) supports such work flows. Summary. Textual data is a core source of information in...

read more

Setting Light to Apache Spark with SQL

In the case of Apache Spark, there seems to be a real need to shed light on it in order to understand how it interacts with other technologies and how to integrate it in your existing IT environment. Apache Spark – is it really the Swiss Army Knife for analytics? Or...

read more

Get in touch

Ready for the next steps or just want to chat about what we can do for you?