is it necessary to setup up MySQL/MariaDB data warehouse for BI use ?

hi,

right now we are analysis the need of data warehouse and data mart as well as ETL.

our oracle database has some ETL by batch process, we don't know what it is but in system diagram we have ETL.

and we use replicate technology to replicate data from OLTP to 2x other DB for reporting purpose but we do not use the oracle data warehouse builder to create a data warehouse.

question now is, why and when should we use mariaDB AX to create a separate data warehouse for reporting purpose as existing model already can handle loading, why need to redesign one using MariaDB AX to do reporting ?

data mart on MySQL/MariaDB is REALLY necessary ? can it be done on MySQL and MariaDB?

please share your thought.
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David FavorLinux/LXD/WordPress/Hosting SavantCommented:
Best you define what you mean by BI.

1) data mart on MySQL/MariaDB is REALLY necessary?

Only you can answer this, based on your requirements.

2) can it be done on MySQL and MariaDB?

Best to either stick with MariaDB or MySQL 8 as your starting point.

If you're using Oracle, likely best to stick with latest MariaDB running in Oracle mode... so you only have to deal with one SQL dialect.

Your main challenge here will be mixing Oracle + MariaDB replication. Whether this will work or not, you'll have to research.

If you can tolerate desync of data between Oracle + MariaDB, just do a nightly data dump on your Oracle side + on MariaDB side, drop all data + restore databases.

Tip: Any database project can be done on MariaDB.
marrowyungSenior Technical architecture (Data)Author Commented:
hi,

"Best you define what you mean by BI."

business intelligent

"Only you can answer this, based on your requirements."

at this moment, it is as simple as we don't have it currently, do we need one ?  no new requirement yet.

"Your main challenge here will be mixing Oracle + MariaDB replication. Whether this will work or not, you'll have to research."

once we migrate Oracle to MariaB, we will dismiss Oracle, no more oracle. so no replication will be setup between oracle and MariaDB

so question is, once we remove all Oracle and replace it with MariaDB TX, do we need to setup MariaDB AX, the OLAP solution from MariaDB for a new data warehouse solution ?

"Tip: Any database project can be done on MariaDB."

is it possible to create data mart in MariaDB AX solution ? someone told me it is just a columestore engine !
marrowyungSenior Technical architecture (Data)Author Commented:
hi,

any update for me ?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Business Intelligence (BI)

From novice to tech pro — start learning today.