Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to SafariWhen comparing Orchestrate vs Oracle Database, the Slant community recommends Orchestrate for most people. In the question“What are the best databases to use for Node.js applications?” Orchestrate is ranked 12th while Oracle Database is ranked 15th. The most important reason people chose Orchestrate is:
Orchestrate was built for scale. Orchestrate is a full-fledged distributed data system, provided as a multi-tenant service. There is no need to manage finite server resources like disk space, CPU, or memory
Question Ranking
Pros
Pro Effortless/Automatic Scaling
Orchestrate was built for scale. Orchestrate is a full-fledged distributed data system, provided as a multi-tenant service. There is no need to manage finite server resources like disk space, CPU, or memory
Pro Already set up for you
Orchestrate is a Database-as-a-Service, so there is no downloading, installation, or any other administration. It also makes configuration management and deployment easy.
Pro Great Node.js support
Orchestrate.js is a first class client for Node.js applications
Pro Fault Tolerance Baked In
As a DBaaS, Orchestrate manages replicas and sharding across multiple machines. Additionally, daily backups are managed by the company.
Pro Multiple Query types at Low Latencies
No other database provides Full-Text-Search, Time-Series, Graph, and Key/Value APIs. Moreover, as a DBaaS, the queries are pre-optimized for low latencies. Consistently under 10ms for any query.
Pro World wide technical support
Oracle is a large company with specialists in a lot of countries. It's very easy to find consultants and any kind of help with Oracle.
Pro Useful features for daily workflow
Some of the most important features are the partitioning option, active data guard, and security options. All of these are very useful for daily workflow.
Pro Stable
Pro Secure
Pro Scalable
Pro Reduced downtime during upgrades
Oracle Database has parallel upgrading for high available applications. Updates are made in parallel without keeping the database down.
Pro High performance parallel quesries
Oracle Database has introduced concurrent execution of union branches, which means that one set of parallel servers will execute one branch, a second set will execute another branch and so on. Instead of the old system where each branch executed one after the other.
Cons
Con Data are not on your server
Since it's a DBaaS, your data are completely on their server. It cannot be run on your server. Backup is handled by them as well, which may be good or not depending on your needs.
Con Not Open Source
Orchestrate is not an open source solution.
Con Proprietary
Con Terrible company reputation
Oracle is very (in)famous for being involved in a number of controversies. Some of them have ended up in lawsuits with other tech companies because of license disputes. The latest one is a lawsuit against Google for Google's implementation of JAVA in their Android ecosystem.
Con Ghost data
To work around ghost data you can after encrypting something, manually move everything out of the old table space and then shred those data files. To be able to get rid of ghost data automatically would be great.
