TrustRadius

Amazon Athena vs. IBM ILOG CPLEX Optimization Studio

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Amazon Athena
Score 7.9 out of 10
N/A
Amazon Athena is an interactive query service that makes it easy to analyze data directly in Amazon S3 using standard SQL. With a few clicks in the AWS Management Console, customers can point Athena at their data stored in S3 and begin using standard SQL to run ad-hoc queries and get results in seconds. Athena is serverless, so there is no infrastructure to setup or manage, and customers pay only for the queries they run. You can use Athena to process logs, perform ad-hoc analysis, and run…
$5
per TB of Data Scanned
IBM ILOG CPLEX Optimization Studio
Score 9.7 out of 10
N/A
IBM® ILOG® CPLEX® Optimization Studio is a prescriptive analytics solution that enables rapid development and deployment of decision optimization models using mathematical and constraint programming.
$285
per month per user
Pricing
Amazon AthenaIBM ILOG CPLEX Optimization Studio
Editions & Modules
Price per Query
$5.00
per TB of Data Scanned
No answers on this topic
Offerings
Pricing Offerings
Amazon AthenaIBM ILOG CPLEX Optimization Studio
Free Trial
NoYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details——
More Pricing Information
Community Pulse
Amazon AthenaIBM ILOG CPLEX Optimization Studio
Features
Amazon AthenaIBM ILOG CPLEX Optimization Studio
Database-as-a-Service
Comparison of Database-as-a-Service features of Product A and Product B
Amazon Athena
8.6
4 Ratings
1% above category average
IBM ILOG CPLEX Optimization Studio
-
Ratings
Automatic software patching8.22 Ratings00 Ratings
Database scalability9.03 Ratings00 Ratings
Automated backups7.73 Ratings00 Ratings
Database security provisions9.22 Ratings00 Ratings
Monitoring and metrics8.04 Ratings00 Ratings
Automatic host deployment9.22 Ratings00 Ratings
Platform Connectivity
Comparison of Platform Connectivity features of Product A and Product B
Amazon Athena
-
Ratings
IBM ILOG CPLEX Optimization Studio
8.0
2 Ratings
4% below category average
Connect to Multiple Data Sources00 Ratings9.02 Ratings
Extend Existing Data Sources00 Ratings7.02 Ratings
Automatic Data Format Detection00 Ratings8.02 Ratings
MDM Integration00 Ratings8.02 Ratings
Data Exploration
Comparison of Data Exploration features of Product A and Product B
Amazon Athena
-
Ratings
IBM ILOG CPLEX Optimization Studio
10.0
2 Ratings
17% above category average
Visualization00 Ratings10.02 Ratings
Interactive Data Analysis00 Ratings10.02 Ratings
Data Preparation
Comparison of Data Preparation features of Product A and Product B
Amazon Athena
-
Ratings
IBM ILOG CPLEX Optimization Studio
7.3
2 Ratings
11% below category average
Interactive Data Cleaning and Enrichment00 Ratings5.01 Ratings
Data Transformations00 Ratings7.01 Ratings
Data Encryption00 Ratings8.02 Ratings
Built-in Processors00 Ratings9.02 Ratings
Platform Data Modeling
Comparison of Platform Data Modeling features of Product A and Product B
Amazon Athena
-
Ratings
IBM ILOG CPLEX Optimization Studio
8.0
2 Ratings
5% below category average
Multiple Model Development Languages and Tools00 Ratings10.02 Ratings
Automated Machine Learning00 Ratings5.01 Ratings
Single platform for multiple model development00 Ratings8.02 Ratings
Self-Service Model Delivery00 Ratings9.01 Ratings
Model Deployment
Comparison of Model Deployment features of Product A and Product B
Amazon Athena
-
Ratings
IBM ILOG CPLEX Optimization Studio
10.0
2 Ratings
16% above category average
Flexible Model Publishing Options00 Ratings10.02 Ratings
Security, Governance, and Cost Controls00 Ratings10.02 Ratings
Best Alternatives
Amazon AthenaIBM ILOG CPLEX Optimization Studio
Small Businesses
IBM Cloudant
IBM Cloudant
Score 7.4 out of 10
Jupyter Notebook
Jupyter Notebook
Score 8.5 out of 10
Medium-sized Companies
IBM Cloudant
IBM Cloudant
Score 7.4 out of 10
Posit
Posit
Score 10.0 out of 10
Enterprises
IBM Cloudant
IBM Cloudant
Score 7.4 out of 10
Posit
Posit
Score 10.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Amazon AthenaIBM ILOG CPLEX Optimization Studio
Likelihood to Recommend
10.0
(4 ratings)
9.0
(2 ratings)
Usability
10.0
(1 ratings)
9.0
(1 ratings)
Support Rating
-
(0 ratings)
7.0
(1 ratings)
User Testimonials
Amazon AthenaIBM ILOG CPLEX Optimization Studio
Likelihood to Recommend
Amazon AWS
If you are looking to take a lot of the traditional "database administration" work off someone's plate, going with Amazon Athena certainly has "no code" options to optimize lots of database tasks. I would say this option is less appropriate if you have other Microsoft things at play, such as Power BI.
Scott Kennedy | TrustRadius Reviewer
Scott Kennedy
Sr Director, BI
Read full review
IBM
It is well suited for solving large-sized, mixed-integer, and integer programming problems. Now, the new version supports for Multi-Objective optimization along with some new algorithms such as Benders Decomposition. It is less appropriate for quadratic programming problems where the objective function is the product of multiple variables. However, it's very easy to code any problem.
Verified User
Anonymous
Read full review
Pros
Amazon AWS
  • Nested Schemas like JSON data structure
  • Ability to adapt the data model to fit your queries better
  • Performance Improvement
RK
Riyaz Khan
Data Engineer
Read full review
IBM
  • Linear Programming
  • Mixed-Integer Linear Programming
  • Non-Linear Convex-Optimization
  • Visualization
  • Shadow Price Analysis
  • Parameter Tuning
Verified User
Anonymous
Read full review
Cons
Amazon AWS
  • Response caching can be improved.
  • Data Partitioning is tricky and understanding of the same could be improved.
Alok Pabalkar | TrustRadius Reviewer
Alok Pabalkar
Co-Founder & CTO
Read full review
IBM
  • Data handling from different sources like Note Pad, etc.
  • Large size of MILP problems.
  • Various parameters to set.
Verified User
Anonymous
Read full review
Usability
Amazon AWS
Easy to use. Scalable. Gets the job of data warehousing setup done. Using the datalake on S3 has become super convenient.
Alok Pabalkar | TrustRadius Reviewer
Alok Pabalkar
Co-Founder & CTO
Read full review
IBM
It's nice to use and with good optimization.
Verified User
Anonymous
Read full review
Support Rating
Amazon AWS
No answers on this topic
IBM
Honestly, to say, I never contacted CPLEX but used its forum to know/clarify any issues I faced.
Verified User
Anonymous
Read full review
Alternatives Considered
Amazon AWS
Verified User
Anonymous
Read full review
IBM
IBM CPLEX Optimization Studio covers wide range of problems in comparison to Gurobi and also offers a number of visualization tools for results analysis. It has better customization and parameter tuning options in comparison to Gurobi. It offers various API integrations such as Python, Java and C++ which is not the case with Gurobi.
Verified User
Anonymous
Read full review
Return on Investment
Amazon AWS
  • The query speeds help us make more decisions in a day (speed).
  • If you need more horsepower for specific times in the day this option helps scale.
  • The security of your environment is well protected too.
Scott Kennedy | TrustRadius Reviewer
Scott Kennedy
Sr Director, BI
Read full review
IBM
  • Faster computation leading to better internal customer relations
  • Able to solve high variable problems with ease
  • Anomaly detection became easier within business
Verified User
Anonymous
Read full review
ScreenShots