Teradata and Oracle Database In-Memory compete in the field of large-scale data management. Teradata appears to have the upper hand with its advanced parallel processing and workload management capabilities, making it highly suitable for large data environments.
Features: Teradata's parallel processing capabilities and MPP architecture allow efficient handling of large datasets and provide scalability and consistent performance. It integrates advanced analytics and offers a range of workload management options. Oracle Database In-Memory is noted for its rapid performance in analytic queries and real-time analytics due to its columnar format, which enhances data warehouse performance when combined with Exadata.
Room for Improvement: Teradata faces challenges in pricing and scalability, with users desiring better support for unstructured data and improved cloud integration. Enhancements in cloud services and third-party tool integration are also sought after. Oracle Database In-Memory users call for better ease of use, query optimization, and cost reduction, along with increased AI support and flexible design options.
Ease of Deployment and Customer Service: Teradata offers adaptable deployment across on-premises, private, hybrid, and public clouds, yet Oracle Database In-Memory is preferred slightly for hybrid cloud environments. Teradata's customer service receives praise, especially for technical support, despite some reporting delays. Oracle's customer service is similarly well-regarded with dependable technical support.
Pricing and ROI: Teradata is recognized for high costs, although its data warehousing capabilities and performance are seen to justify the expense, resulting in a positive ROI. Oracle Database In-Memory is also regarded as costly, particularly for smaller enterprises, yet recent price adjustments have improved its competitiveness, especially as a cost-efficient solution for real-time analytics.
At least fifteen to twenty percent of our time has been saved using Teradata, which has positively affected team productivity and business outcomes.
Independent research showed that Teradata VantageCloud users achieved an average ROI of 427% across three years with payback under a year, demonstrating the platform's ability to deliver a strong financial return.
We have realized a return on investment, with a reduction of staff from 27 to eight, and our current return on investment is approximately 14%.
Support quality varies across regions, with more advanced solutions from the U.S. and UK compared to Asian region support.
I rate the technical support of Oracle an eight or nine out of ten.
The technical support from Oracle is very good.
The customer support for Teradata has been great.
They are responsive and knowledgeable, and the documentation is very helpful.
Customer support is very good, rated eight out of ten under our essential agreement.
Whenever we need more resources, we can add that in Teradata, and when not needed, we can scale it down as well.
This flexibility allows organizations to scale according to their needs, balancing performance, cost, and compliance requirements.
This expansion can occur without incurring downtime or taking systems offline.
It was very difficult to move data from on-site to cloud in one attempt at the start, because we didn't have sufficient bandwidth to copy the data files to the cloud.
Oracle Database In-Memory is stable, which means there are no glitches or issues.
Its massively parallel process architecture allows the platform to distribute workload efficiently, enabling organizations to run heavy analytic queries without compromising speed or stability.
I find the stability to be almost a ten out of ten.
The workload management and software maturity provide a reliable system.
Enhancing features like CAG augmentation and cache augmentation could significantly optimize performance for large language models.
The area where improvement is required the most in the product is the UI.
I want to highlight two features for improvement: first, storing data in various formats without requiring a tabular structure, accommodating unstructured data; and second, adding AI ML features to better integrate Gen AI, LLM concepts, and user-friendly experiences such as text-to-SQL capabilities.
Unlike SQL and Oracle, which have in-built replication capabilities, we don't have similar functionality with Teradata.
The most challenging aspect is finding Teradata resources, so we are focusing on internal training and looking for more Teradata experts.
Recent reductions in cloud costs and learning opportunities, such as free portals for students, make the pricing reasonable without hindering access to powerful features and performance.
The pricing for Oracle Database In-Memory is more affordable.
Teradata is much more expensive than SQL, which is well-performed and cheaper.
Initially, it may seem expensive compared to similar cloud databases, however, it offers significant value in performance, stability, and overall output once in use.
Role-based access control (RBAC), strong audit and compliance features, high availability, fault tolerance, and encrypted data at rest and in-transit are key features.
The biggest benefit of Oracle Database In-Memory is dealing with a huge amount of information without any latency for our response time.
The valuable features of Oracle Database In-Memory include its capability to bypass disk storage for faster memory operations, which is critical for transactions and analytics.
Teradata's security helps our organization meet compliance requirements such as GDPR and IFRS, and it is particularly essential for revenue contracting or revenue recognition.
Its architecture allows information to be processed efficiently while maintaining stable performance, even in highly demanding environments.
It facilitates data integration, where we integrate and analyze data from various sources, making it a powerful and high-quality reliable solution for the company.
| Product | Market Share (%) |
|---|---|
| Teradata | 4.2% |
| Oracle Database In-Memory | 1.9% |
| Other | 93.9% |
| Company Size | Count |
|---|---|
| Small Business | 6 |
| Midsize Enterprise | 4 |
| Large Enterprise | 23 |
| Company Size | Count |
|---|---|
| Small Business | 28 |
| Midsize Enterprise | 13 |
| Large Enterprise | 52 |
Oracle Database In-Memory transparently accelerates analytics by orders of magnitude while simultaneously speeding up mixed-workload OLTP. With Oracle Database In-Memory, users get immediate answers to business questions that previously took hours.
Oracle Database In-Memory delivers leading-edge in-memory performance without the need to restrict functionality, or accept compromises, complexity and risk. Deploying Oracle Database In-Memory with any existing Oracle Database compatible application is as easy as flipping a switch - no application changes are required. Oracle Database In-Memory is fully integrated with the Oracle Database’s renowned scale-up, scale-out, storage tiering, availability, and security technologies making it the most industrialstrength offering on the market.
The ability to easily perform real-time data analysis together with real-time transaction processing on all existing applications enables organizations to transform into Real-Time Enterprises that quickly make data-driven decisions, respond instantly to customer demands, and continuously optimize all key processes.
For more information on Oracle Database In-Memory, visit Oracle.com
Teradata is a powerful tool for handling substantial data volumes with its parallel processing architecture, supporting both cloud and on-premise environments efficiently. It offers impressive capabilities for fast query processing, data integration, and real-time reporting, making it suitable for diverse industrial applications.
Known for its robust parallel processing capabilities, Teradata effectively manages large datasets and provides adaptable deployment across cloud and on-premise setups. It enhances performance and scalability with features like advanced query tuning, workload management, and strong security. Users appreciate its ease of use and automation features which support real-time data reporting. The optimizer and intelligent partitioning help improve query speed and efficiency, while multi-temperature data management optimizes data handling.
What are the key features of Teradata?
What benefits and ROI do users look for?
In the finance, retail, and government sectors, Teradata is employed for data warehousing, business intelligence, and analytical processing. It handles vast datasets for activities like customer behavior modeling and enterprise data integration. Supporting efficient reporting and analytics, Teradata enhances data storage and processing, whether deployed on-premise or on cloud platforms.
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.
