By introducing SQL functions for JSON, developers can now use a single database for both structured and semi-structured data – and administrators don’t have to worry about losing transactions, data integrity and reliability. It’s the best of both worlds!
In this blog post, we show how to connect Tableau to MariaDB TX or MariaDB AX and how to create advanced visualizations in Tableau using data in MariaDB.
Learn how Billy Mobile deployed MariaDB ColumnStore for fast, interactive analysis of big data that easily integrates with Tableau for data visualization.
There are many great unique features of MariaDB ColumnStore, one of which is the speed in which you can get data from CSV files into MariaDB ColumnStore using the tool ‘cpimport’. But what if your data is in another format? Or you wish to stream data into MariaDB ColumnStore from another application? This is where MariaDB ColumnStore’s new write API comes into play.
Today, the market wants an enterprise open source data warehouse for modern analytical workloads. We call it MariaDB AX. It’s for everything from traditional business intelligence/reporting and data mining to modern analytics, including decision support systems and recommendation engines. Learn what it takes to be an enterprise open solution for modern analytics and data warehousing.
In order to have faster time to insight and time to action it’s critical that:
Organizations make data available for analysis as soon as it arrives, and;
Applications stream data from data sources to analytics platform seamlessly.
The new MariaDB AX includes MariaDB ColumnStore Data Adapters, enables easy integration with data from various sources such as web/mobile services, IoT, sensors, social networks, device logs and machine learning model output.
I'm excited that our second major GA release of MariaDB ColumnStore 1.1 is now available for download. In this blog, I review some of the major features that make up this release. Our focus for this release was to enable greater extensibility and to provide some additional features that have come up as we have worked with prospects and customers.
Perhaps one of the most important InnoDB changes coming in MariaDB Server 10.3 is Instant ADD COLUMN for InnoDB tables. Normally, adding a column to a table requires the full table to be rebuilt. With instant
ADD COLUMN, all that is needed is a special kind of an
UPDATE of table metadata. For a large table, instead of taking several hours, the operation would be completed in the blink of an eye.