What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
1062 Ratings
10 Ratings

Oracle Database

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
1062 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.6 out of 100
10 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 6.1 out of 100

Likelihood to Recommend

Oracle Database

I believe that Oracle Database can be used almost on any scenario, starting with small department solutions to actually any enterprise level system. It includes many features that allow a single database to work as an OLTP and Data Warehouse at the same time, reducing hardware requirements and the need to implement ETL or integration solutions between OLTP and DW.
Lisandro Fernigrini | TrustRadius Reviewer

Presto

Presto is for interactive simple queries, where Hive is for reliable processing. If you have a fact-dim join, presto is great..however for fact-fact joins presto is not the solution.. Presto is a great replacement for proprietary technology like Vertica
Praveen Murugesan | TrustRadius Reviewer

Pros

Oracle Database

  • Oracle database is battle tested and has been in the industry for a long time, meaning they have a good understanding of the markets demands.
  • Oracle database is secure and ensures that user data is not tampered with through prompt updates.
  • Peer to peer communities are available to help solve almost all problems that one may be facing.
Allison Mills | TrustRadius Reviewer

Presto

  • Linking, embedding links and adding images is easy enough.
  • Once you have become familiar with the interface, Presto becomes very quick & easy to use (but, you have to practice & repeat to know what you are doing - it is not as intuitive as one would hope).
  • Organizing & design is fairly simple with click & drag parameters.
Corinne Nacin-Martinez | TrustRadius Reviewer

Cons

Oracle Database

  • Oracle 12c SQL Developer is included with the product for no additional licensing cost, but it is much more limited compared to query tools such as TOAD.
  • Oracle 12c stumbles on certain queries with the optimizer not catching simple methods to return queries very quickly. Often a scalar subquery is required to reduce the time by up to 99%.
  • On occasion, the optimizer can miss simple changes such as IN ('1','2','3') working but BETWEEN '1' AND '3' being stuck in an infinite loop.
Bennett Walker | TrustRadius Reviewer

Presto

  • Presto was not designed for large fact fact joins. This is by design as presto does not leverage disk and used memory for processing which in turn makes it fast.. However, this is a tradeoff..in an ideal world, people would like to use one system for all their use cases, and presto should get exhaustive by solving this problem.
  • Resource allocation is not similar to YARN and presto has a priority queue based query resource allocation..so a query that takes long takes longer...this might be alleviated by giving some more control back to the user to define priority/override.
  • UDF Support is not available in presto. You will have to write your own functions..while this is good for performance, it comes at a huge overhead of building exclusively for presto and not being interoperable with other systems like Hive, SparkSQL etc.
Praveen Murugesan | TrustRadius Reviewer

Likelihood to Renew

Oracle Database

Oracle Database 8.6
Based on 5 answers
As a Oracle Database administrator,I do installation upgradation to oracle 12C and we can make use of the new features that are introduced in this version to secure data in better ways hence I highly recommend using this database software
Sukesh Nayak | TrustRadius Reviewer

Presto

No score
No answers yet
No answers on this topic

Usability

Oracle Database

Oracle Database 8.1
Based on 5 answers
Many of the powerful options can be auto-configured but there are still many things to take into account at the moment of installing and configuring an Oracle Database, compared with SQL Server or other databases. At the same time, that extra complexity allows for detailed configuration and guarantees performance, scalability, availability and security.
Lisandro Fernigrini | TrustRadius Reviewer

Presto

No score
No answers yet
No answers on this topic

Support Rating

Oracle Database

Oracle Database 8.7
Based on 3 answers
The product is very good but when you need help it's very difficult. Oracle must have a database with all the customers' configuration so we don't lose a lot of time answering questions.We finally contract with a premium DBA to solve all our issues.
Gonzalo Segarra | TrustRadius Reviewer

Presto

No score
No answers yet
No answers on this topic

Implementation Rating

Oracle Database

Oracle Database 9.6
Based on 3 answers
The implementation of Oracle Database 12C was smooth and upgradation can be performed in minimum time as oracle 12C gives option to perform metadata upgrade using parallel option
Sukesh Nayak | TrustRadius Reviewer

Presto

No score
No answers yet
No answers on this topic

Alternatives Considered

Oracle Database

Compared to other SQL type databases, Oracle can simply be described as a super-set or an extension of them.As Oracle has not only the features of SQL but also PL/SQL, it is much more feature rich compared to other databases technologies. However, there is no fair way to compared Oracle against MongoDB as their basic principles are on totally different terms.Any application that needs not only the power of storage but automatic manipulation of data dynamically during runtime is definitely a place where Oracle should be used.
venkat nitin panaganti | TrustRadius Reviewer

Presto

Presto is good for a templated design appeal. You cannot be too creative via this interface - but, the layout and options make the finalized visual product appealing to customers. The other design products I use are for different purposes and not really comparable to Presto.
Corinne Nacin-Martinez | TrustRadius Reviewer

Return on Investment

Oracle Database

  • Positive Impact - I have been serving as a DBA to a Aviation Industry customer since 2009. Aviation Industry User community believes that Oracle database product is best product in the world. The reason would be it has been in the market for many years, more reliable product and the customer has more confidence in Oracle than others, has good market reputation, so many oracle expertise easily available whenever and where ever needed in affordable cost.
  • Positive Impact - Oracle12c with - ODA, Exadata, Big data appliance, Super cluster, and Oracle12c cloud offering are becoming popular day by day.
  • Negative Impact - Oracle licensing cost has been one of the most debatable topics in business user community every year.
Sarju Patel | TrustRadius Reviewer

Presto

  • Presto has helped scale Uber's interactive data needs. We have migrated a lot out of proprietary tech like Vertica.
  • Presto has helped build data driven applications on its stack than maintain a separate online/offline stack.
  • Presto has helped us build data exploration tools by leveraging it's power of interactive and is immensely valuable for data scientists.
Praveen Murugesan | TrustRadius Reviewer

Pricing Details

Oracle Database

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Presto

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Add comparison