• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar
  • Skip to secondary sidebar
  • Skip to footer

Technologies.org

Technology Trends: Follow the Money

  • Technology Events 2023-2024
  • Sponsored Post
    • Make a Contribution
  • Technology Jobs
  • Technology Markets
    • Venture Capital
  • About
  • Contact

MariaDB Community Server 10.5 turns into analytics powerhouse with cloud-native storage

June 24, 2020 By admin Leave a Comment

MariaDB Gives the Power of Analytics to Millions for Free

MariaDB® Corporation today announced the general availability of MariaDB Community Server 10.5, a major new release that brings high-performance analytics to the hands of millions using the popular open source database. In a push to mainstream analytics and to make it as popular as MariaDB’s transactional engine, the company added a new, native columnar storage engine to the community database server and a new, native MariaDB Python Connector and Microsoft Power BI integration. Together, these new capabilities provide traditional MariaDB users and data scientists around the world with powerful analytics. All new analytical capabilities in MariaDB Community Server 10.5 are available for free with unrestricted use to broaden adoption of hybrid transactional and analytical processing, and modern analytical approaches.

MariaDB is one of the top five most used databases globally with a user base of tens of millions. It has replaced MySQL as the default on nearly all major Linux distributions and has been downloaded over one billion times on Docker Hub. With the release of MariaDB Community Server 10.5, MariaDB users can extend the traditional transactional capabilities of the database to now perform interactive analytics at scale on hundreds of billions of rows.

“Data analytics are a core component of any modern application,” said Gregory Dorman, vice president of distributed systems and analytics, MariaDB Corporation. “Customers expect applications to give them insights, historical comparisons, predictions and automation in order to make better, smarter decisions and deliver a more intuitive experience. With the new native, fully integrated analytical capabilities, MariaDB community users now have an out-of-the-box, cost-effective solution for storing and accessing massive amounts of data in split seconds. It will transform how everyone around the world views and uses MariaDB to start building modern everyday applications.”

MariaDB’s modern architecture enables new flexibility

MariaDB achieves high-performance analytics using MariaDB ColumnStore, which stores data in a columnar format for up to 10x data compression on disk and uses parallel query to perform interactive analytics in real time. MariaDB first released ColumnStore in 2016 and has delivered significant advancements in the technology to add additional performance improvements, streaming capabilities, faster import and query times, and cloud-native storage. Over the years, ColumnStore has grown in popularity and received several community contributions, including a new data type for TIMESTAMP. By integrating ColumnStore as a native storage engine in MariaDB Server – similar to other native storage engines such as InnoDB, MyRocks, Spider and Aria – users can simply add columnar tables to existing databases to introduce or supercharge analytics while improving transactional performance. Benefits include:

Modern data warehousing: Traditional data warehouses have proven to be complex and expensive. Hadoop implementations have fallen short with the lack of real-time analytics. Many public cloud options are expensive and difficult to integrate with transactional data. MariaDB Community Server 10.5 delivers a modern data warehousing solution for interactive, ad hoc analytics on low-cost, cloud object storage. MariaDB leverages a cloud-native, disaggregated architecture for analytics using an API compatible with AWS S3 object storage for up to 70% cost savings over block storage, 99.999999999% durability and 99.99% availability, storage across multiple availability zones, and unlimited storage capacity.
Smart transactions: Modern applications require access to vast amounts of data optimized for analytical queries and machine learning models so that transactions can be augmented with data-driven insights – transforming standard transactions into smart transactions. MariaDB Community Server 10.5 enables the use of row and columnar storage together in one database, making it easy to turn every transaction into a smart transaction, augmented by data and insights from vast amounts of additional data. Developers can now quickly deliver modern applications by leveraging their existing skill sets, including standard SQL, to blend transactions and analytics – previously only achievable with expensive legacy systems and hardware.
Faster analytical queries for growing datasets: Applications experiencing a surge in users and transactions result in rapidly growing databases with changing query patterns, complex indexes to avoid performance problems and slow query times – all of which impact customer experience. The situation often grows worse when reports or analytical queries need to run at the same time. Separating active transactional data and historical data by moving unused data to columnar tables dramatically reduces the time for analytical queries and immediately restores performance to the application.
Even more options to connect and analyze data in MariaDB

MariaDB Server is compatible with the widely used MySQL database protocol and therefore supports native integrations with all leading BI and data analysis tools and frameworks. This compatibility also enables access to data in any MariaDB storage engine, including ColumnStore. In addition, MariaDB released two new, native connectors to make data analysis with MariaDB easier and faster.

Supporting data analysis with Python: Python is one of the most popular programming languages in the world. It has long been used for web development, but recently has seen a surge in use for data analysis. According to the Python Software Foundation’s 2019 developer survey, 59% of respondents stated they use Python for data analysis, followed by web development at 51% and machine learning at 40%. The native MariaDB connector makes it easy and fast for anyone running data analysis using Python to connect to transactional and analytical data stored in MariaDB.
Power BI integration for powerful analysis and data visualization: MariaDB makes data analysis and visualization even easier with a new integration with Microsoft’s Power BI. With the new adapter, Power BI users can quickly analyze and aggregate data natively in MariaDB then run interactive reports that are highly visual and easy to share within the business.
Availability

MariaDB Community Server 10.5 including ColumnStore is available immediately for free direct download on the MariaDB website now and through Docker Hub by the end of June. MariaDB Connector/Python and MariaDB Power BI adapter can be downloaded from mariadb.com. For customers interested in MariaDB for demanding production environments with built-in high availability and massively parallel processing (MPP), please contact MariaDB for early access to MariaDB Enterprise Server 10.5.

About MariaDB Corporation
MariaDB frees companies from the costs, constraints and complexity of proprietary databases, enabling them to reinvest in what matters most – rapidly developing innovative, customer-facing applications. MariaDB uses pluggable, purpose-built storage engines to support workloads that previously required a variety of specialized databases. With complexity and constraints eliminated, enterprises can now depend on a single complete database for all their needs, whether on commodity hardware or their cloud of choice. Deployed in minutes for transactional, analytical or hybrid use cases, MariaDB delivers unmatched operational agility without sacrificing key enterprise features including real ACID compliance and full SQL. Trusted by organizations such as Deutsche Bank, DBS Bank, Nasdaq, Red Hat, ServiceNow, Verizon and Walgreens – MariaDB meets the same core requirements as proprietary databases at a fraction of the cost. No wonder it’s the fastest growing open source database.

Filed Under: Tech

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Market Analysis

The Growing Tin Market: Prospects for Future Demand and Sustainability
Prospects for the Growing Lithium Market in the Coming Years
DevOps and Agile: Integrating Development and Operations
China’s Use of Golden Shares: From Reducing State Role to Quietly Controlling Tech Giants
Why Amazon Acquired One Medical: Disrupting the Healthcare Industry with Technology-Enabled Care
The End of an Era: Why China is No Longer Viable as the World’s Factory
Cloudflare’s FedRAMP authorization opens up a huge market opportunity in the US government sector

Market Research Media

How plunging birthrates threaten national economies
Agile Leadership: Leading Agile Teams for Success
Chinese Brands Reach New Heights of Popularity in the West Amid Growing Political Tensions
Unrestricted Streaming: How VPNs Can Enhance Media Consumption Experience
How the world’s biggest companies have built and defended their moats
Virtual Learning Environments: A Game-Changer in Education?
Streaming video, training, and gaming coming together to form a cohesive and diverse media and entertainment ecosystem

Secondary Sidebar

Tech Events

Upcoming Technology Events of 2023
Space Symposium 2023, April 17-20, Broadmoor, Colorado Springs, Colorado
The Yugabyte’s third annual Distributed SQL Summit (DSS) Asia, March 28, 2023
NVIDIA GTC, a global conference for the era of AI and the metaverse, March 20-23, 2023
Splash User Conference and Partner Summit will take place from April 17 to 20, 2023 in Washington, D.C.

Venture Capital

African Venture Investment Soars to Record High, Fueled by Tech Startups
Pitchly Secures $7 Million Series A Funding for SaaS-Based Data Enablement Solution
Agile Project Management: Roles and Responsibilities
Candidly, a student debt and savings optimization platform, has raised $20.5 million in a Series B round of financing
GameTech Startups Attracting Venture Capital Funding: The Importance of VPN Security

Footer

Recent Posts

  • Hydrogen Technology: The Key to a Sustainable Future for the Cruise and Shipping Industries
  • Regenerative Finance: Shifting Towards Sustainable and Equitable Financial Systems
  • Why Arm Ltd May Build Its Own Semiconductor
  • Dragonfly Announces New Kubernetes Operator for In-Memory Datastore for Simplified Operations and Increased Performance
  • Cosmic Crops Return: Seeds Sent to Space to Develop Resilient Crops for a Warming World
  • AI Developer
  • Nvidia’s Lead in AI: Disrupting the Tech Industry
  • Canva Launches Brand Management Features and AI-Powered Design Tools to Empower Creatives and Professionals
  • Cloudflare Enters Fraud Detection Market with Cloudflare Fraud Detection
  • Devices utilizing Wi-Fi HaLow technology are gaining momentum

App Coding

Creating a Responsive User Interface: Design Principles
A developer’s job isn't just to churn out code every day
A code for a file-based JAMstack CMS system using JavaScript
Deploying Applications in Kubernetes: A Step-by-Step Guide
Maximizing Your Coding Skills with ChatGPT: A Guide

API Coding

API governance is essential for ensuring the secure and reliable use of APIs
How to Build API in Next.js
Running a corporate website as an API
Streamlining Your Workflow with API Integrations: Benefits and Best Practices
How to recognize malware API

Blockchaining

The Future of Supply Chain Management with Blockchain Technology
Exploring the Potential of Blockchain Technology: A Comprehensive Overview
Experience the Future of Blockchain at Cybertech 2023
What are DLT ledgers?
Corporate leaders should embrace the potential of blockchain technology before it gets used against them

Event Calendar

PCIM Europe 2023, May 9-11, 2023, Nuremberg Exhibition Center, Nuremberg, Germany
Interwire Trade Exposition, May 9-11, 2023, Georgia World Congress Center, Atlanta, GA
ProMat 2023, the leading trade show for the manufacturing and supply chain industry, March 20-23 2023, Chicago’s McCormick Place
Prints 2023, Printing Conference, March 3, 2023
Milan Design Week 2023, April 17-23 2023, Milan, Italy

Copyright © 2022 Technologies.org

Media Partners: Market Analysis & Market Research and Exclusive Domains

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
Cookie SettingsAccept
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT