Using MariaDB ColumnStore with Power BI for Visualization and Reporting

Author: MariaDB - Bewertung: 4x - Views:78

Like most relational databases, MariaDB’s default storage engine, InnoDB, uses row storage optimized for transaction processing. Today, however, there’s an increasing need for collocated real-time analytics, visualization and reporting – needs better met by a columnar storage engine. To support real-time analytics on billions of rows and terabytes of data, MariaDB databases include MariaDB ColumnStore. This columnar storage engine uses distributed data and massively parallel processing (MPP) to scale out analytical workloads. Further, MariaDB Enterprise Server, available in SkySQL on AWS or GCP as well as on premises, supports partitioning and joining data across InnoDB and ColumnStore, reducing complexity and accelerating query performance. Watch this session to learn about MariaDB’s columnar database architecture and how it can be used in SkySQL to support data warehousing workloads. This session provides a demo that includes ad hoc queries on large data sets using ColumnStore and data visualization using Power BI.

Links:
►Slides: https://mariadb.com/wp-content/uploads/2023/05/OpenWorks-2023-Using-MariaDB-ColumnStore-Todd-Stoffel.pdf
►Try MariaDB with Docker: https://mariadb.me/3qMINkg

Table of Contents
0:00
0:23 Intro
0:53 About MariaDB ColumnStore
3:11 Row-oriented vs. column-oriented
4:39 How indexes work on columns
5:48 Latest Release Enhancements
9:32 Connect to PowerBI: ODBC driver
11:00 Connect PowerBI
14:38 Exploring MariaDB ColumnStore data inside PowerBI
15:34 Visualizing MariaDB ColumnStore data inside PowerBI

►Follow MariaDB on Twitter: https://twitter.com/mariadb
►Subscribe to the MariaDB channel:
https://www.youtube.com/mariadb
►Explore MariaDB Products: https://mariadb.com/products
►Check out the MariaDB DeveloperHub: https://mariadb.com/developers/
►Get in touch with MariaDB experts via Slack: https://mariadb-community.slack.com/

MariaDB is making a big impact on the world. Whether you’re checking your bank account, buying a coffee, shopping online, making a phone call, listening to music, taking out a loan, or ordering takeout–MariaDB is the backbone of applications used every day. Companies small and large, including 75% of the Fortune 500 run MariaDB, touching the lives of billions of people. With massive reach through Linux distributions, enterprise deployments, and public clouds, MariaDB is uniquely positioned as the leading database for modern application development.

#MariaDB #Database #Data #SQL