MariaDB embraces big data with general availability of ColumnStore 1.0

MariaDB embraces big data with general availability of ColumnStore 1.0

Pluggable Columnar Engine Option Delivers Single SQL Interface for Analytic and Transactional Workloads

MariaDB® Corporation, the company behind the fastest growing open source database, announced the general availability of MariaDB ColumnStore 1.0, a powerful open source columnar storage engine.

With this release, MariaDB has united transactional and analytic processing with a single front end to deliver an enterprise-grade solution that simplifies high-performance, big data analytics.

Aziz Vahora, head of data management at Pinger said:

“MariaDB ColumnStore is the future of data warehousing. ColumnStore allows us to store more data and analyze it faster. Every day, Pinger’s mobile applications process millions of text messages and phone calls. We also process more than 1.5 billion rows of logs per day. Analytic scalability and performance is critical to our business. MariaDB’s ColumnStore manages massive amounts of data and will scale with Pinger as we grow.”

Data warehousing and analytics are undergoing massive transformation driven by cloud computing, cost of compute, distributed deployments and big data. But in spite of all the innovation designed to reduce cost and complexity, enterprises continue to be confronted with two imperfect options for big data analytics: build a costly, proprietary data warehouse on premise with vendors like Teradata and Vertica, or get locked into potentially uncontrollable costs with cloud-based solutions like Redshift.

David Thompson, Vice President of Engineering at MariaDB said:

“Data warehouses are famously expensive and complex – requiring proprietary hardware which makes it nearly impossible to deploy on the cloud, or on commodity hardware. MariaDB ColumnStore makes data analytics more accessible, on premise, in the cloud or in a hybrid deployment. Costing on average 90% less per TB per year than the leading data warehouses and offering a scalable solution for the cloud, MariaDB ColumnStore presents a new, open source model for big data analytics that is designed to meet today’s enterprise needs.”

New features and benefits of ColumnStore 1.0 include:

Lower Cost of Ownership and Better Price Performance
• Compared to the licensing and hardware costs of proprietary data warehouses like Teradata and Vertica, MariaDB ColumnStore, an open source solution, provides exponentially better cost per performance for analytics. Additionally ColumnStore’s flexible deployment options mean businesses can deploy in the cloud, or on premise with commodity hardware as opposed to solutions like Redshift which require a commitment to cloud only deployments.

• Rather than buying and maintaining a third platform for data warehousing, MariaDB users simply turn on the columnar engine for a particular dataset and run analytics from the same front end as their transactional system.

• ColumnStore’s advanced data compression is more efficient at storing big data, requiring less hardware and making big data analytics more affordable.

Easier Enterprise Analytics

• Unlike Hadoop solutions, ColumnStore offers full ANSI SQL capabilities including queries for complex joins, aggregation and window functions. This makes it easy for data analysts to run their existing enterprise queries without modification.

• MariaDB ColumnStore simplifies enterprise administration and execution by accessing all the same security capabilities delivered in MariaDB Server, including encryption for data in motion, role-based access and auditability. ColumnStore also offers an out-of-the-box connection with BI tools through ODBC/JDBC, as well as the standard MariaDB connectors.

• ColumnStore’s automated partitioning, combined with the elimination of the need to create indexes and views, makes it easier to setup, deploy and manage.

Faster, More Efficient Queries

• Compared to row-based storage, columnar storage reduces disk I/O with compression, making read-intensive (i.e., analytic) workloads significantly faster.

• MariaDB ColumnStore distributes the queries into series of parallel operations, resulting in extremely fast and scalable query results.

• “The demand for robust analytics technologies has exploded as companies look to derive greater value from increasing data volume,” said Jason Stamper, analyst, Data Platforms & Analytics, 451 Research. “MariaDB’s ColumnStore is a new option for high-performance analytics to big data, which aims to enable faster and more efficient queries while eliminating delays and reducing enterprise data warehousing expenses.”

MariaDB ColumnStore is now available for download. For customers wanting to get started immediately, the MariaDB professional services team is offering a new program called MariaDB ColumnStore JumpStart, which delivers a ready-to-use ColumnStore environment in 3 – 5 days. Contact MariaDB to learn more. Register today to learn more about MariaDB ColumnStore during an upcoming webinar on December 20.

[su_button url=”https://mariadb.com/” target=”blank” style=”flat” background=”#df2027″ color=”#ffffff” size=”10″ radius=”15″ icon=”icon: arrow-circle-right”]Click here to find out more about MariaDB[/su_button]

Georgina Turner image

Georgina Turner

Sales Manager

Read the Latest Issue

Follow us on X

Follow us on X

Click Here

Follow us on LinkedIn

Follow us on LinkedIn

Click Here

Advertise here

Reach decision makers and amplify your marketing

Advertise here

Click Here

Related News

Graphic displaying a lockdown solution

Netgenium debuts next gen display and touchscreen technologies

Power-over-Ethernet (PoE) solutions specialist Netgenium will be showcasing its new range of IP…

ICT® Launches New TSL Access Reader Series

Integrated Control Technology (ICT®), a leading manufacturer of intelligent access control and…
Image Provided by Paxton

Paxton Partners with Skills for Security

The security technology manufacturer Paxton is proud to announce a partnership with Skills for Security…
Image Provided by ICT

ICT and Ingram Micro sign distribution agreement MEA

Integrated Control Technology (ICT), award-winning global manufacturer of intelligent electronic access control and security solutions..
Image Provided by Toshiba

Toshiba launches new HDD Innovation Lab

Toshiba Electronics Europe GmbH (Toshiba) has inaugurated a new HDD Innovation Laboratory (HDD Innovation Lab) at its site in Düsseldorf..
Image Provided by Verkada

Verkada Doubles Down on the Channel with Strategic New Hire

Verkada, a leader in cloud-based physical security, today announced the appointment of Micah Deriso as Head of Global Channel…
Image Provided by IPSA

IPSA Appoint Frontline Hero as Ambassador

Abdullah, the courageous security officer praised for foiling a horrific knife attack at Leicester Square, has been appointed as…
Image Provided by Codelocks

New Surface Latch from Codelocks

Codelocks is expanding its Gate Solutions by Codelocks range with the introduction of the new Codelocks’ Surface Latch…
Image provided by Genetec

Nicholas Smith to Lead Genetec UK and Ireland Operations

Genetec, provider of enterprise physical security software, announced the appointment of Nicholas Smith as its new Regional Sales Director…

News Desk

View all the latest, product, project and people news

News Desk

Click Here

Technology News

Keep up-to-date with the latest product innovation

Technology News

Click Here

Industry Sectors

Discover technology in action in all applications

Industry Sectors

Click Here

Enter The Awards

Showcase personal or organisation excellence

Advertise With Us

Reach decision makers and amplify your marketing

Advertise With Us

Click Here
Scroll to Top