Oracle Database In-Memory vs Teradata comparison

Oracle Database In-Memory

Read 56 Teradata reviews

5,643 Views
4,699 Comparison Views

86% willing to recommend

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Oracle Database In-Memory 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.

To learn more, read our detailed Oracle Database In-Memory vs. Teradata Report (Updated: May 2024).

Oracle Database In-Memory vs. Teradata

May 2024

Download the complete report

Helped 787,226 peers since 2012

Categories and Ranking

Oracle Database In-Memory

Ranking in Relational Databases Tools

8th

Average Rating

8.8

Number of Reviews

Ranking in other categories

Embedded Database (2nd)

Teradata

Ranking in Relational Databases Tools

7th

Average Rating

8.2

Number of Reviews

Ranking in other categories

Data Warehouse (3rd)

Market share comparison

As of June 2024, in the Relational Databases Tools category, the market share of Oracle Database In-Memory is 0.8% and it increased by 11.4% compared to the previous year. The market share of Teradata is 5.9% and it increased by 10.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Relational Databases Tools

Unique Categories:

Embedded Database

38.9%

Data Warehouse

15.6%

Featured Reviews

Priyank Shrivastava

Sr Quality Engineer at Optum

Dec 14, 2022

User friendly with great scalability but needs to move toward intelligent AI

Our company uses the solution to create relational databases. We use both public and private clouds. The solution has a simplicity that makes it very easy to use. The scalability is very good. The solution should move to the new way of writing software code with AI that is intelligent and…

Read full review

SurjitChoudhury

Data engineer at Cocos pt

Feb 20, 2024

Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities

We created and constructed the warehouse. We used multiple loading processes like MultiLoad, FastLoad, and Teradata Pump. But those are loading processes, and Teradata is a powerful tool because if we consider older technologies, its architecture with nodes, virtual processes, and nodes is a unique concept. Later, other technologies like Informatica also adopted the concept of nodes from Informatica PowerCenter version 7.x. Previously, it was a client-server architecture, but later, it changed to the nodes concept. Like, we can have the database available 24/7, 365 days. If one node fails, other nodes can take care of it. Informatica adopted all those concepts when it changed its architecture. Even Oracle databases have since adapted their architecture to them. However, this particular Teradata company initially started with its own different type of architecture, which major companies later adopted. It has grown now, but initially, whatever query we sent it would be mapped into a particular component. After that, it goes to the virtual processor and down to the disk, where the actual physical data is loaded. So, in between, there's a map, which acts like a data dictionary. It also holds information about each piece of data, where it's loaded, and on which particular virtual processor or node the data resides. Because Teradata comes with a four-node architecture, or however many nodes we choose, the cost is determined by that initially. So, what type of data does each and every node hold? It's a shared-no architecture. So, whatever task is given to a virtual processor it will be processed. If there's a failure, then it will be taken care of by another virtual processor. Moreover, this solution has impacted the query time and data performance. In Teradata, there's a lot of joining, partitioning, and indexing of records. There are primary and secondary indexes, hash indexing, and other indexing processes. To improve query performance, we first analyze the query and tune it. If a join needs a secondary index, which plays a major role in filtering records, we might reconstruct that particular table with the secondary index. This tuning involves partitioning and indexing. We use these tools and technologies to fine-tune performance. When it comes to integration, tools like Informatica seamlessly connect with Teradata. We ensure the Teradata database is configured correctly in Informatica, including the proper hostname and properties for the load process. We didn't find any major complexity or issues with integration. But, these technologies are quite old now. With newer big data technologies, we've worked with a four-layer architecture, pulling data from Hadoop Lake to Teradata. We configure Teradata with the appropriate hostname and credentials, and use BTEQ queries to load data. Previously, we converted the data warehouse to a CLD model as per Teradata's standardized procedures, moving from an ETL to an EMT process. This allowed us to perform gap analysis on missing entities based on the model and retrieve them from the source system again. We found Teradata integration straightforward and compatible with other tools.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"The most valuable aspects of this solution are the fast caching and improved performance to the database"

"The on-premise version is stable. We have different teams and resources for the server side, for admin, and for development. We can easily take care of all the services and applications."

"Security is the most valuable feature."

"The most valuable feature is that Database-In-Memory is more consistent and faster than traditional databases as it requires fewer CPUs to process instructions."

"The product offers high scalability."

"The scalability is very good."

"It efficiently handles low-code data and supports read-and-write operations for clustering."

"The solution's ROI is excellent."

More Oracle Database In-Memory pros

"The initial setup was straightforward."

"It's a pre-configured appliance that requires very little in terms of setting-up."

"It has reduced a lot of reworking on maintaining indexes, partitions, etc."

"A conventional and easily defined way to build a data warehouse or a layer of data marts."

"I've never had any issues with scalability."

"I like this solution's ease of design and the fact that its performance is quite good. It is stable as well."

"The solution scales well on the cloud."

"Their extensive experience in data warehousing, the platform's performance, and their strong reputation in the market are the most valuable."

More Teradata pros

Cons

"The high cost of the product is an area of concern where improvements are required."

"It would be good if Oracle could reduce downtime when transferring from non-In-Memory to In-Memory."

"The pricing could be improved. It would ideal if it was more reasonable."

"We often have to find solutions on our own through the support site, so there's room for improvement in this regard."

"The solution should move to the new way of writing software code with AI that is intelligent and learns."

"The solution is quite expensive."

"The product could be more economical."

"Oracle Database In-Memory appliance-based solutions can be restrictive for some applications, as they may require more flexibility in the database design to be tuned and sized to the customer's needs."

More Oracle Database In-Memory cons

"Azure Synapse SQL has evolved from a solely dedicated support tool to a data lake. It can store data from multiple systems, not just traditional database management systems. On the other hand, Teradata has limitations in loading flat files or unstructured data directly into its warehouse. In Azure Synapse SQL, we can implement machine learning using Python scripts. Additionally, Azure Synapse SQL offers advanced analytical capabilities compared to Teradata. Teradata is also expensive."

"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."

"I'm not sure about the unstructured data management capabilities. It could be improved."

"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."

"I would like to see an improved Knowledge Base on the web."

"Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect."

"The user interface needs to be improved."

"The scalability could be better. The on-premises solution is always more complicated to scale."

More Teradata cons

Pricing and Cost Advice

"The solution's pricing is high."

"Database In-Memory is priced a bit higher than its competitors like Microsoft."

"The pricing is pretty good so I rate it an eight out of ten."

"The product is expensive."

"It's quite costly and it comes with a fixed price."

"I rate the pricing a zero out of ten because Database In-Memory is too costly."

"There is a need to make a yearly payment towards the licensing costs, after which there is any to pay towards the support cost attached to the solution."

"Oracle Database In-Memory is expensive."

"The solution requires a license."

"We are looking for a more flexible cost model for the next version that we use, whether it be cloud or on-premise."

"The initial cost may seem high, but the TCO is low."

"Price is quite high, so if it is really possible to use other solutions (e.g. you do not have strict requirements for performance and huge data volumes), it might be better to look at alternatives from the RDBMS world."

"Teradata's licensing is on the expensive side."

"Teradata is a very expensive solution."

"Teradata is currently making improvements in this area."

"Teradata is expensive but gives value for money, especially if you don't want to move your data to the cloud."

More Teradata pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.

See recommendations

787,226 professionals have used our research since 2012.

Comparison Review

it_user232068

Senior Data Architect at a pharma/biotech company with 1,001-5,000 employees

Aug 5, 2015

Netezza vs. Teradata

Original published at https://www.linkedin.com/pulse/should-i-choose-net Two leading Massively Parallel Processing (MPP) architectures for Data Warehousing (DW) are IBM PureData System for Analytics (formerly Netezza) and Teradata. I thought talking about the similarities and differences…

Read full review

Top Industries

By visitors reading reviews

Financial Services Firm

20%

Computer Software Company

12%

Manufacturing Company

10%

Government

Financial Services Firm

25%

Computer Software Company

10%

Manufacturing Company

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about Oracle Database In-Memory?

We can integrate it with any data sources as well.

What is your experience regarding pricing and costs for Oracle Database In-Memory?

The cost of the product is high. There is a need to make a yearly payment towards the licensing costs, after which there is any to pay towards the support cost attached to the solution.

What needs improvement with Oracle Database In-Memory?

The platform’s pricing needs improvement.

Comparing Teradata and Oracle Database, which product do you think is better and why?

I have spoken to my colleagues about this comparison and in our collective opinion, the reason why some people may declare Teradata better than Oracle is the pricing. Both solutions are quite simi...

Which companies use Teradata and who is it most suitable for?

Before my organization implemented this solution, we researched which big brands were using Teradata, so we knew if it would be compatible with our field. According to the product's site, the comp...

Is Teradata a difficult solution to work with?

Teradata is not a difficult product to work with, especially since they offer you technical support at all levels if you just ask. There are some features that may cause difficulties - for example,...

SAP HANA vs Oracle Database In-Memory

Comparisons

Compared 29% of the time

IBM Db2 Database vs Oracle Database In-Memory

Compared 13% of the time

Progress OpenEdge RDBMS vs Oracle Database In-Memory

Compared 11% of the time

SQL Server vs Oracle Database In-Memory

Compared 11% of the time

MariaDB vs Oracle Database In-Memory

Compared 7% of the time

More Oracle Database In-Memory Competitors

SQL Server vs Teradata

Compared 19% of the time

Snowflake vs Teradata

Compared 12% of the time

Oracle Exadata vs Teradata

Compared 11% of the time

MySQL vs Teradata

Compared 10% of the time

BigQuery vs Teradata

Compared 7% of the time

More Teradata Competitors

Product Reports

Oracle Database In-Memory

May 2024

Download Oracle Database In-Memory product report

Download Teradata product report

April 2024

Learn More

Oracle

Overview

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 multi-cloud data platform company that provides data warehouse and relational database tools. The brand has an extensive portfolio of big data analytic solutions, integrated marketing applications, and services. The products that Teradata offers can be categorized in the following ways:

Software: The products in this category include Teradata Vantage, an advanced SQL engine and Teradata database.
Cloud: The solutions can work with popular cloud services such as Amazon AWS, Microsoft Azure, Google Cloud Platform, and VMware. Teradata Cloud and customer cloud are also included in this product category.
Ecosystem management: The products in this section include IntelliSphere, business continuity manager, data lab, data mover, data stream, QueryGrid, and viewpoint.
Hardware: This category includes backup, archive, and restore (BAR) and IntelliFlex.
Applications: Master data management (MDM) and Teradata analytics for enterprise applications are the two products in this category.

One of the most popular and commonly used products by Teradata is Teradata Vantage. This is a connected multi-cloud data platform for enterprise analytics. The product unifies data lakes, analytics, and data warehouses, as well as data sources and types. The solution offers its customers scalability, which allows them to scale dimensions to handle massive workloads of data. Teradata Vantage utilizes artificial intelligence (AI) and machine learning (ML) to power more models and enhance quality.

Through Vantage Console, businesses can benefit from role-based, no-code software to organize and manage their data. The product offers deployment on many popular public clouds, on premises, and on commodity hardware. Teradata Vantage unifies and integrates all data types from sources and provides companies with a single source of information. It achieves this by supporting all common data types and formats. The product also provides organizations with tools for monitoring, analyzing, and connecting data throughout the organizations.

Part of this product is also VantageCloud, which offers a modern cloud-native architecture as well as hybrid and multi-cloud deployment options. This solution offers new ways for clients to deploy their platforms. These include the next-generation, cloud-native architecture of Teradata VantageCloud Lake.

Teradata Features

The different products that Teradata offers have various features which facilitate data management for customers. Some of the key capabilities of the solutions offered by Teradata include:

Connectivity: Users can benefit from connections to the mainframe or network-attached systems. The product provides its own extension for interaction with data stored in the tables. It also supports SQL.
Linear scalability: Teradata solutions are highly scalable and linear. The solution can handle large volumes of data effectively while also supporting the ability to scale up to 2048 nodes.
Load and unload utilities: The product offers features to move data in and out of the product's system effectively.
Mature optimizer: Part of this feature is Teradata Optimizer, which is an advanced product that can handle up to 64 joins in a single query.
Robust utilities: The solution includes multiple robust utilities in this category of features that facilitate data handling in and out of the product's systems. The tools include MultiLoad, FastLoad, and FastExport.
Shared nothing architecture: This set of features, connected to the architecture of Teradata, is known as “shared nothing architecture” because the nodes, processors, and disks all work independently. These capacities ensure better value for a given task.
Unlimited parallelism: These features divide large volumes of data into smaller processes that are executed in parallel. This contributes to the execution of complex tasks in a timely manner.

Teradata Benefits

Through its multiple solutions, Teradata offers various benefits for its clients. Some of these include:

The solution facilitates prototype creation and offers faster times for completion.
Through Teradata, users are able to use faster, simpler, and easier solutions for data-related tasks.
The product eliminates the need for unnecessary data movement, which contributes to performance improvements.
Teradata offers developers the ability to decide where in the architecture different parts of an application run.
Teradata allows database administrators to manage databases from a single point of control.
The solution provides the option to get the same data on multiple deployment options.
The product supports Online Analytical Programming (OLAP) functions, which allows it to perform a complex analytical process of data.
Teradata uses the Service Workstation to provide a single operation view for the multi-node system of the product.

Reviews from Real Users

Martin P., a services manager at Bytes Systems Integration, describes Teradata as a product that is very fast with good database control and excellent support.

Blaine V., principal at Insight Data Consulting, rates Teradata highly because of its excellent native features, highly stable, and impressive automation.

Sample Customers

Shanghai Customs

Netflix