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

MySQL

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

Attribute Ratings

  • MySQL is rated higher in 1 area: Likelihood to Recommend

Likelihood to Recommend

8.5

MySQL

85%
133 Ratings
8.0

Oracle Data Warehouse

80%
12 Ratings

Likelihood to Renew

9.9

MySQL

99%
4 Ratings

Oracle Data Warehouse

N/A
0 Ratings

Usability

10.0

MySQL

100%
6 Ratings

Oracle Data Warehouse

N/A
0 Ratings

Support Rating

8.6

MySQL

86%
4 Ratings

Oracle Data Warehouse

N/A
0 Ratings

Implementation Rating

8.0

MySQL

80%
2 Ratings

Oracle Data Warehouse

N/A
0 Ratings

Likelihood to Recommend

Oracle

For smaller database backends, this product works well. Our backend printer management software is using MySQL as its backend and we have not had any issues since it went live 2 years ago. It's also free so no licensing worries.
Read full review

Oracle

Including other products, Oracle is very specialized in business support. Choosing Oracle Data Warehouse would be a safe choice for an enterprise-level company (more than a thousand employees). Healthcare organizations may want to consider Oracle, as they are typically conservative with privacy and security issues with patient data. Although cloud-based systems are widely being adopted in the healthcare industry (such as population research or genomics), core data sets (such as patients' sensitive medical records) may be better stored with a home-grown data center and warehouse solution.
Read full review

Pros

Oracle

  • Security: is embedded at each level in MySQL. Authentication mechanisms are in place for configuring user access and even service account access to applications. MySQL is secure enough under the hood to store your sensitive information. Also, additional plugins are available that sit on top of MySQL for even tighter security.
  • Widely adopted: MySQL is used across the industry and is trusted the most. Therefore, if you face any problems, simply Google it and you shall land in plenty of forums. This is a great relief as when you are in a need of help, you can find it right in your browser.
  • Lightweight application: MySQL is not a heavy application. However, the data you store in the database can get heavy with time, but as in the configuration and MySql application files, those are not very heavy and can easily be installed on legacy systems as well.
Read full review

Oracle

  • Able to handle very large data sizes efficiently from a performance, high availability and manageability perspective. This is accomplished through the Oracle Partitioning functionality. Partitioning allows large segments (tables, IOT index-organized tables, indexes) to be broken into smaller segments at the physical layer but treated as a whole at the logical layer.
  • Provides support for dual-format architecture through Oracle In-Memory functionality. Without any change to application code one can obtain in-memory performance. This functionality enables us to have the tables represented in both the row format and the column format using in-memory format. This is a huge boost for BI/analytic queries since the Oracle optimizer is able to intelligently choose the appropriate format.
  • Provision to materialize a subset of table data or table joins. This is through materialized views and the optimizer will rewrite the query against the base tables to make use of this materialized view. This provides a huge performance boost and is critical in VLDBs as in a data warehouse. The query rewrite is fully transparent to users.
  • Provides multiple compression capabilities. This is very useful not only for deducing the storage foot print but as well as increase performance at different layers of the infrastructure including query performance. The compression functionality can be applied against both structured and unstructured data.
  • With the advent of Engineered Systems (Exadata, Database Machine, SuperCluster) there are specific features and functionalities that can further boost the Oracle data warehouse. These are related to consolidation, Smart Scan, Storage Indexes, EHCC (Exadata hybrid columnar compression) and much more.
  • RAC - Real Application Clusters (with 2 or more nodes) provides functionality for high availability, performance and scaling as the work load increases. The parallelism is provided both within a node and as well as across nodes. If for any reason a node goes down the data warehouse is still available through other nodes and the running queries are transparently failed over to the surviving nodes.
Read full review

Cons

Oracle

  • Although you can add the data you require as more and more data is added, the fixity of it becomes more critical.
  • As the demand, size, and use of the system increase, you may also need to change or acquire more equipment on your servers, although this is an internal inconvenience for the company.
Read full review

Oracle

  • Customer support isn't the best out there. We usually have to wait about an hour to get some form of assistance.
  • Pricing is a bit higher than many of its competitors such as AWS Redshift.
  • Tweaking features requires dedicated staff. Software is fairly advanced. Would be difficult to use for newcomers.
Read full review

Pricing Details

MySQL

Starting Price

Editions & Modules

MySQL editions and modules pricing
EditionModules

Footnotes

    Offerings

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services

    Entry-level set up fee?

    No setup fee

    Additional Details

    Oracle Data Warehouse

    Starting Price

    Editions & Modules

    Oracle Data Warehouse editions and modules pricing
    EditionModules

    Footnotes

      Offerings

      Free Trial
      Free/Freemium Version
      Premium Consulting/Integration Services

      Entry-level set up fee?

      No setup fee

      Additional Details

      Likelihood to Renew

      Oracle

      For teaching Databases and SQL, I would definitely continue to use MySQL. It provides a good, solid foundation to learn about databases. Also to learn about the SQL language and how it works with the creation, insertion, deletion, updating, and manipulation of data, tables, and databases. This SQL language is a foundation and can be used to learn many other database related concepts.
      Read full review

      Oracle

      No answers on this topic

      Usability

      Oracle

      I give MySQL a 9/10 overall because I really like it but I feel like there are a lot of tech people who would hate it if I gave it a 10/10. I've never had any problems with it or reached any of its limitations but I know a few people who have so I can't give it a 10/10 based on those complaints.
      Read full review

      Oracle

      No answers on this topic

      Support Rating

      Oracle

      The support staff is friendly, knowledgeable, and efficient. I only had to get part way through my explanations before they had a solution. They will walk you through a fix or actually connect in and fix the problem for you--or would if you can allow it. I've done it both ways with them. They are always forthcoming with 'how to do this if it happens again' information. I love working with MySQL support.
      Read full review

      Oracle

      No answers on this topic

      Implementation Rating

      Oracle

      1. Estimate your data size. 2. Test, test, and test.
      Read full review

      Oracle

      No answers on this topic

      Alternatives Considered

      Oracle

      MongoDB is an application oriented solution with unstructured data. Percona Server for MySQL is a good solution when looking for performance peaks and the amount of data grows continuously over time. MySQL is the ideal solution when we have a data schema defined and we do not have great requirements at the performance level.
      Read full review

      Oracle

      Oracle is, in my opinion, the top dog in this space. I feel like the other vendors are playing catch-up to where Oracle is right now. It is also likely the most expensive option out there.
      Read full review

      Return on Investment

      Oracle

      • It has made site management through a CMS like WordPress or Drupal infinitely easier to manage.
      • It is a critical part of the LAMP, WAMP and MAMP stack and has been a major driver of innovation in the content-management-system space, pushing site and web-application development toward greater democratization.
      • It has proved to be very reliable and easy to set up and administer and saves me tremendous time troubleshooting query and performance issues.
      Read full review

      Oracle

      • Very cost effective for large databases.
      • Very fast results on simple queries.
      • Analytical functionalities are of wide range, which makes it very cost effective.
      • For smaller businesses, it might be a great asset.
      • Some features are supposed to be bought separately, so one needs to consider this before licensing with Oracle DW.
      Read full review

      Add comparison