Over a million developers have joined DZone.

MariaDB Energizes the Data Warehouse With Open-Source Analytics Solution

DZone's Guide to

MariaDB Energizes the Data Warehouse With Open-Source Analytics Solution

MariaDB AX has unleashed fast, scalable analytics with platform mobility, eliminating the need for traditional data warehouses.

· Database Zone ·
Free Resource

Download "Why Your MySQL Needs Redis" and discover how to extend your current MySQL or relational database to a Redis database.

MariaDB® Corporation has introduced new product enhancements to MariaDB AX to deliver a modern approach to data warehousing that enables customers to perform fast and scalable analytics more cost-effectively. MariaDB AX expands the MariaDB Server, creating a solution that enables high-performance analytics with distributed storage and parallel processing and scales with existing commodity hardware on premises or across any cloud platform.

“MariaDB AX is a powerful, open-source solution for performing custom and complex analytics,” says David Thompson, VP of Engineering at MariaDB Corporation. “In order to fully realize the power of big data, our customers need the ability to gather insights in near-real-time, regardless of where the data is coming from. With MariaDB AX, it’s easier than ever to ingest and analyze streaming data from disparate sources, while ensuring the highest level of reliability through new high availability and backup capabilities.”

Data warehouses are traditionally expensive and complex to operate. Driven by the need for more meaningful and timely analytics that meet hardware and cost pressures, companies are reassessing their data warehouse and analytics strategy. Built for performance and scalability, MariaDB AX uses a distributed and columnar open-source storage engine with parallel query processing that allows customers to store more data and analyze it faster. MariaDB AX supports a wide range of advanced analytic use cases across every industry; for example, identifying health trends to inform healthcare programs and policy, behavioral analysis to inform customer service and sales strategies, and analysis of financial anomalies to inform fraud programs.

MariaDB AX includes new features that enable easy, high-performance data analytics, such as:

  • Simpler and streamlined data ingestion: Make data available for analysis quickly and easily. MariaDB AX, with the introduction of data adapters and direct access to the underlying storage engine, removes the need for complex, time-consuming batch processes to import data. By reducing the time it takes to make data available for analysis, organizations can realize a faster time-to-insight and the competitive advantages it brings. New data adapters include:

    • Bulk data adapters: Develop applications and services to continuously collect and write large amounts of data to MariaDB AX for analysis, or publish machine learning results to MariaDB AX for data scientists and others to view or further analyze via SQL.

    • Streaming data adapter for MariaDB MaxScale: Analyze operational data in near real time, within seconds of being created. When MariaDB TX is deployed for operational workloads, the data adapter uses MariaDB MaxScale and change-data-capture streams to replicate data from the operational environment to MariaDB AX automatically and continuously.

    • Streaming data adapter for Apache Kafka: Combine and analyze data from multiple sources by aggregating data from web, mobile, and Internet of Things applications. The data adapter, currently in beta, consumes messages published to Apache Kafka topics and writes the data to MariaDB AX, enabling data scientists to analyze related data from multiple sources.

  • More powerful, custom analytics: Extend the analytical capabilities of MariaDB AX by creating custom analytical functions for relational and non-relational data such as JSON. The introduction of an API for creating user-defined aggregate and window functions, combined with support for text and binary data, enables data scientists to analyze structured, semi-structured and unstructured data using custom analytical functions.

  • Improved high availability and disaster recovery: Ensure data is always available for analysis and simplify the process of backing up and restoring data. MariaDB AX adds support for GlusterFS to provide data high availability without the need for an expensive SAN, while a new tool automatically uses multiple, concurrent connections to backup and restore distributed data on multiple servers from a single location.

“Like so many organizations today, for us, data is the lifeblood of our operations,” says Patrice Linel, Head of Scientific Computing at Genus plc, the parent company of ABS Global and PIC, helping farmers produce better quality meat and milk more efficiently and sustainably. “With the new data ingestion capabilities in MariaDB AX, we are freed from the manual, time-consuming practice of moving massive amounts of genetic data from its source format for analysis. Now with MariaDB AX, we can queue and instantly move data directly from Python into MariaDB where real-time analytics happens. The effort saved is substantial and the data is always the most current."

MariaDB AX is available for download now.

Read "Developing Apps Using Active-Active Redis Enterprise" and discover the advantages over other active-actve databases.

database ,data warehouse ,data ingestion ,mariadb ,scalability ,data analytics

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}