Do Oracle users like Data Vault?
Currently tweaking datavault4dbt to work with Oracle. How come Oracle users are less interested in Data Vault than snowflake users?
6
8 comments
Because Oracle is from its roots all purpose database with some support for Kimball and Inmon approach, but Snowflake from its roots count on Data Vault.
For example, I spent one year building a real-time data solution in Oracle using DV. Then it has taken half year to reimplement it in Postgres+airflow.
If I would have had Snowflake... I would need just 4 commands.
6
• Jul '24 (edited)
Another perception from a different perspective: As Oracle is one of the "older" database vendor, companies often already have their data warehouse solution on it before Data Vault became an industrie-wide approved way of building a data platform. When it comes to the point that the whole solution does not scale anymore, they are looking for the state-of-the-art and plan an all-around refresh: New way of working (agile), new approach (Data Vault), new technology (mostly OLAP databases in the Cloud). I think as soon as it comes to these migration-projects where everything gets renewed and Data Vault is the way to go, the technology from Oracle is no longer the top favorite for a restart. The same is see for SQL-Server btw. . Not that much, but similar.
3
Definitely, Marc. I can see also reactions to the "predatory" licence policy of Oracle, what forces clients to move to another DB technology. So it is also the scale problem but not from technological point of view but financial.
BTW, did you try the Oracle Cloud Platform? I did. I rather would not have tried it again...
3
• Jul '24
Sharing about DV in Oracle. We have DV2 in Oracle since 2017. In general, raw data and data transformation pipelines are running well using database procs and packages. I can't comment on real-time data refresh as once a day refresh is sufficient for us atm. Our DW is growing but we can't scale our server anymore. We are moving to cloud and will be investigating if DV has a place in data lakehouse.
3
• Jul '24
I tried Oracle Autonomous Database. What didn't you like about the Oracle Cloud Platform?
2
• Jul '24 (edited)
It is already years ago. It was in 2018, I guess. But there were many weird features...
  • deployment of changes in backend was quicker than in UI -> It was unable to create new account in UI, only using REST API (UI thrown an exception "unknown parameter")
  • deployment of changes in backend was quicker than documentation -> e.g. renamed parameters in REST API call
  • the place, when You could read usage was elsewhere every month -> invoicing process was like a hide-and-seek game (sometimes, more like peek-a-boo...)
  • Cloud backup of on-premise database - superb feature... till the moment when they released new version of the server side without any notice and local database stopped with full archive logs. -> It was necessary to compile and deploy new backup driver. Really common task in production environment 🤪
  • Migrating on-premise database into cloud. Advertised as easy going, on-click task. -> To fine-tune the patch-set on both databases took me one week of core DBA work.
I must say that it could be much better today. Maybe. I hope... but I won't try it.
2
• Jul '24
Thank you for sharing you experience!
1
• Jul '24
Good Point!
1
User
Your comment
Daniel Fritzler
3
Do Oracle users like Data Vault?
Data Innovators Exchange
skool.com/data-innovators-exchange
Your source for Data Management Professionals in the age of AI and Big Data. Comprehensive Data Engineering reviews, resources, frameworks & news.
Leaderboard (30-day)
powered by