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

marrowyung
marrowyung used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
David FavorFractional CTO
Distinguished Expert 2018

Commented:
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 ?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial