We performed a comparison between Oracle Multitenant and Teradata based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable features are the speed and ease of use."
"You can scale the solution as needed."
"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"
"Maintaining databases is a valuable feature for us."
"Multitenant has a container database with many pluggable databases."
"It's easy to use and works great."
"The best thing about Oracle Multitenant is its ability to consolidate multiple databases into one engine."
"The feature that I like on Multitenant is the ease - it is very easy for my team to run the database."
"Designing the database is easy."
"Auto-partitioning and indexing, and resource allocation on the fly are key features."
"Their extensive experience in data warehousing, the platform's performance, and their strong reputation in the market are the most valuable."
"We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server."
"Viewpoint, the detailed query logs and performance statistics are valuable features."
"I've never had any issues with scalability."
"The flexibility in design is very good."
"There are several features of Teradata that I like. One of the most basic is the indexes. I also like that it provides lower TCO. It also has the optimizer feature which is a good feature and isn't found in other legacy systems. Parallelism is also another feature I like in Teradata because when you are running or hosting on multiple systems, you have this shared-nothing architecture that helps. Loading and unloading in Teradata are also really helpful compared to other systems."
"The solution lacks a GUI for commands."
"While the product is overall excellent, it is quite expensive."
"It can be complicated to scale up the solution, but it's scalable."
"This solution is a bit complicated when collecting from containers - that feature should be a bit better."
"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 would be beneficial to include this solution with Oracle Enterprise, but Oracle charges additional fees for it."
"The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."
"Teradata can improve the way it handles big data and unstructured data."
"I would like to see more integration with many different types of data."
"Query language and its functionality are rather limited, compared to Oracle or even SQL Server. However, it is possible to perform any kind of logic in it (though some workarounds may be required)."
"The solution could improve by having a cloud version or a cloud component. We have to use other solutions, such as Amazon AWS, Microsoft Azure, or Snowflake for the cloud."
"Limited interest and success in some areas make us hesitate about upgrading."
"I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement."
"I would like to see an improved Knowledge Base on the web."
Oracle Multitenant is ranked 16th in Relational Databases Tools with 15 reviews while Teradata is ranked 7th in Relational Databases Tools with 54 reviews. Oracle Multitenant is rated 8.4, while Teradata is rated 8.2. 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 Teradata writes "Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities". Oracle Multitenant is most compared with SQL Server, Oracle Database, MySQL, IBM Db2 Database and SAP HANA, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and BigQuery. See our Oracle Multitenant vs. Teradata report.
See our list of best Relational Databases Tools vendors.
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.