DuckDB vs Oracle Database In-Memory comparison

DuckDB and Oracle are both solutions in the Embedded Database category. DuckDB is ranked #6 with an average rating of 9.0, while Oracle is ranked #3 with an average rating of 9.1. DuckDB holds a 20.6% mindshare in EDS, compared to Oracle’s 26.2% mindshare. Additionally, 100% of DuckDB users are willing to recommend the solution, compared to 100% of Oracle users who would recommend it.

DuckDB

Read 1 DuckDB review

229 Views
191 Comparison Views

100% willing to recommend

Oracle Database In-Memory

Read 29 Oracle Database In-Memory reviews

628 Views
512 Comparison Views

100% willing to recommend

DuckDB

Oracle Database In-Memory

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between DuckDB and Oracle Database In-Memory based on real PeerSpot user reviews.

Find out what your peers are saying about Firebird, SQLite, Oracle and others in Embedded Database.

To learn more, read our detailed Embedded Database Report (Updated: November 2024).

Buyer's Guide

Embedded Database

November 2024

Download the complete report

Helped 824,067 peers since 2012

Categories and Ranking

DuckDB

Ranking in Embedded Database

6th

Average Rating

9.0

Number of Reviews

Ranking in other categories

No ranking in other categories

Oracle Database In-Memory

Ranking in Embedded Database

3rd

Average Rating

8.8

Reviews Sentiment

8.3

Number of Reviews

Ranking in other categories

Relational Databases Tools (8th)

Mindshare comparison

As of December 2024, in the Embedded Database category, the mindshare of DuckDB is 20.6%, up from 2.3% compared to the previous year. The mindshare of Oracle Database In-Memory is 26.2%, down from 37.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Embedded Database

Featured Reviews

Aleksandr Motuzov

Head of Data Science center of excellence at Ameriabank CJSC

Highly efficient data processing, optimizes infrastructure, and offers good integrations

DuckDB is very fast. If we don't have enough memory, we can use swap. For instance, if we use a fast storage space, the system volume in Kubernetes could be a fast swap for DuckDB if we have memory limits. In our framework, DuckDB is five times faster than Spark in some cases. It has an extensive SQL dialect, many SQL Windows functions, and good integration with Polars. We can easily use SQL and Pandas framework in Python to process data.

Read full review

Duy AnhMai

Product Owner at Heineken

Improved data processing speeds with enhanced security and processing efficiency

We use Oracle Database In-Memory to deploy applications for commercial purposes, store data securely, and ensure efficient data processing Oracle Database In-Memory has improved data storage and processing efficiency, which is crucial for handling large amounts of data in our products and…

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

"DuckDB is very fast."

"The scalability of the solution is very good. It's able to support large amounts of data."

"It accelerates query processing, which in turn speeds up operations and streamlines workflow, and ultimately enhancing productivity."

"The solution's most valuable feature is its performance optimization within our hardware environment."

"The product offers high scalability."

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

"The solution's ROI is excellent."

"We can integrate it with any data sources as well."

"We use the tool for real-time data transfer for risk management purposes. In a trading system, conversions happen fast. We use the product to handle fast transactions with low latency."

More Oracle Database In-Memory pros

Cons

"Sometimes we have memory issues that cause job failures, which we don't fully understand why, but we can rerun the jobs without problems."

"Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster."

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

"Oracle Database In-Memory is more expensive than Azure, and the support from the Oracle team is not very good, especially since they do not have a support team in our region."

"I would like Oracle Database In-Memory to include a data replication feature."

"We use some partitions in In-Memory. We have a very large table and a low dose. It is very expensive in data to load all of them into In-Memory. It takes up more memory slots in the server, as well as a lot of RAM. We use last partitions on the table. We always need to create a script and make a schedule that can load a last partition in In-Memory. Oracle doesn't have features to do this automatically. I would like them to allow us to load last partitions, as well as other table partitions, in In-Memory. I think a good feature would do that automatically, letting you see a table, load a large partition, and monitor loading memory. It's quite a good feature."

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

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

"Lacks sufficient integration with other tools."

More Oracle Database In-Memory cons

Pricing and Cost Advice

Information not available

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

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

"The solution's pricing is high."

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

"Oracle Database In-Memory is expensive."

"The platform's licensing cost needs improvement."

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

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

More Oracle Database In-Memory pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Embedded Database solutions are best for your needs.

See recommendations

824,067 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

No data available

Financial Services Firm

19%

Computer Software Company

11%

Manufacturing Company

10%

Government

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

What is your experience regarding pricing and costs for DuckDB?

We use the open-source version of DuckDB and don't have costs associated with it. There is a company that provides commercial software, but we use the open-source library, not the services.

See all answers

What needs improvement with DuckDB?

Sometimes we have memory issues that cause job failures, which we don't fully understand why, but we can rerun the jobs without problems. There were also problems with binary formats in the previou...

See all answers

What is your primary use case for DuckDB?

We use the concept of a feature store. We need the engine, and we use Feast as our feature store framework to build our feature store. We use the DuckDB engine as a data engine, which helps us move...

See all answers

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

We can integrate it with any data sources as well.

See all answers

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

Oracle Database In-Memory is very expensive. Additionally, there are extra costs for some features.

See all answers

What needs improvement with Oracle Database In-Memory?

Oracle Database In-Memory is more expensive than Azure, and the support from the Oracle team is not very good, especially since they do not have a support team in our region.

See all answers

Comparisons

Druid vs DuckDB

Compared 35% of the time

SQLite vs DuckDB

Compared 33% of the time

SAP HANA vs DuckDB

Compared 15% of the time

Oracle Berkeley DB vs DuckDB

Compared 8% of the time

More DuckDB Competitors

SAP HANA vs Oracle Database In-Memory

Compared 25% of the time

SQL Server vs Oracle Database In-Memory

Compared 16% 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

More Oracle Database In-Memory Competitors

Product Reports

Buyer's Guide

Embedded Database

November 2024

Download DuckDB product report

Buyer's Guide

Oracle Database In-Memory

December 2024

Download Oracle Database In-Memory product report

Learn More

Video not available

DuckDB

Oracle

Overview

DuckDB is an in-process SQL OLAP database management system. Processing and storing tabular datasets, e.g., from CSV or Parquet files. Interactive data analysis, e.g., join & aggregate multiple large tables. Concurrent large changes, to multiple large tables, e.g., appending rows, adding/removing/updating columns. Large result set transfer to client.

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

Sample Customers

Information Not Available

Shanghai Customs

Find out what your peers are saying about Firebird, SQLite, Oracle and others in Embedded Database. Updated: November 2024.

DOWNLOAD NOW

824,067 professionals have used our research since 2012.

See our list of best Embedded Database vendors.

We monitor all Embedded Database 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.