We performed a comparison between Oracle Multitenant and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."Multitenant has a container database with many pluggable databases."
"The database becomes pluggable. Inside this container is called a pluggable database and each application contains this pluggable database inside Multitenant. We can then share resources like control files, memory, etc. This lets you stop and start each application without impacting the others. This resource sharing is the most valuable feature"
"The most valuable features are the speed and ease of use."
"It's easy to use and works great."
"The best thing about Oracle Multitenant is its ability to consolidate multiple databases into one engine."
"Maintaining databases is a valuable feature for us."
"You can scale the solution as needed."
"The feature that I like on Multitenant is the ease - it is very easy for my team to run the database."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"Allows us to take volumes and process them at a very high speed."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"Speed and resiliency are probably the best parts of this product."
"I have found the solution to be scalable."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"Eighty percent of the ETL operations have improved since implementing this solution."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"The solution lacks a GUI for commands."
"Technical support could be faster."
"The user interface for this solution can be made better."
"That said, Oracle in general doesn't invest in their UI for any of their applications. If we're talking about the dashboard or other user experience, there is room for improvement. I'm talking about on premises. The cloud version has started to improve."
"It can be complicated to scale up the solution, but it's scalable."
"It would be beneficial to include this solution with Oracle Enterprise, but Oracle charges additional fees for it."
"This solution is a bit complicated when collecting from containers - that feature should be a bit better."
"While the product is overall excellent, it is quite expensive."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"Limitations in group by projections is where I would like to see an improvement."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"It would be great if this were a managed service in AWS."
Oracle Multitenant is ranked 16th in Relational Databases Tools with 15 reviews while Vertica is ranked 4th in Data Warehouse with 82 reviews. Oracle Multitenant is rated 8.4, while Vertica is rated 8.4. The top reviewer of Oracle Multitenant writes "Databases are automatically upgraded and cloning of pluggable databases requires just one command ". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Oracle Multitenant is most compared with SQL Server, Oracle Database, MySQL, IBM Db2 Database and SAP HANA, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.