3 ms·
Diplomatic preface: I think Oracle is a pretty darn good database just so thats said. Opinion: Why would you say there is no open source analog to the Oracle
by olivermuty 4y ago
Diplomatic preface:
I think Oracle is a pretty darn good database just so thats said.
Opinion:
Why would you say there is no open source analog to the Oracle DWH setup? CitusDB has been able to replicate the mix and match of OLAP and OLTP for quite a while now. In my time as an architect in MSFT we were competing (and successfully too) with CitusDB and Postgres against bespoke complex Exadata setups already a few years ago, and CitusDB just keeps getting better as they integrate more and more options for working with columnar data.
Oracle just straight up ignores all the goodness that has come out of modern operating systems and still tries to peddle Exadata setups with custom hardware nodes and whatnot when a large swathe of those problems can be solved horizontally instead of vertically.
If your business is a thin layer around a finely tuned Oracle setup then ofc it becomes pretty stupid to suggest moving off that and into Postgres in any kind of less-than-five-years project. I would say though that for new projects it is most likely cheaper to either hire postgres experts to replace your oracle experts or just let your Oracle gurus forget all the vendor specific tuning you don't really focus that much on in Postgres than it is to pay for Oracle.
- ibejoeb 4y agoSorry for the late response. Citus certainly does keep getting better. Its parallelization is a little different but given a system designed to use it, I'm sure it'd be just as good as Oracle. Its tenant sharding is a killer feature. My argument never has been that it's purely a feature play; in fact, I think RDS made Oracle far more compelling, because I got to offload the majority of the day-to-day. Now, with citus on azure, yeah, it's pretty compelling on the operating cost side. > If your business is a thin layer around a finely tuned Oracle setup then ofc it becomes pretty stupid to suggest moving off that Right. It's really and end-to-end thing. Oracle serves pretty much every significant business problem. It has a giant API and huge function library that I can use to implement pretty much whatever I want. Then, I can turn it over to the auditors, who know it and understand its operations, so compliance is relatively easy when it comes to things like HIPAA/PCI/FERC or whatever. It's not just about tech. It make a lot of sense for a lot of businesses. Now that I'm not as heavy in regulatory environments and more in science, I think I'd be very happy with the offering. (In fact, I am actively using postrges, and not actively using oracle right now.) I might miss some of the in-built reporting functionality that Oracle has, but I'd have to have a look at the very latest offerings in that area from citus.
- olivermuty 4y agoJust a little addendum, rds is SE only and not EE, so almost no big business can use it regardless unless its for some small r&d etc.